DBA Data[Home] [Help]

APPS.INV_TRANSACTION_FLOW_PVT dependencies on INV_TRANSACTION_FLOW_PVT

Line 1: PACKAGE BODY INV_TRANSACTION_FLOW_PVT AS

1: PACKAGE BODY INV_TRANSACTION_FLOW_PVT AS
2: /* $Header: INVICTFB.pls 120.2 2006/08/14 12:02:01 anthiyag noship $ */
3: -- global variables
4: g_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
5: g_version_printed BOOLEAN := FALSE;

Line 6: g_pkg_name VARCHAR2(30):='INV_TRANSACTION_FLOW_PVT';

2: /* $Header: INVICTFB.pls 120.2 2006/08/14 12:02:01 anthiyag noship $ */
3: -- global variables
4: g_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
5: g_version_printed BOOLEAN := FALSE;
6: g_pkg_name VARCHAR2(30):='INV_TRANSACTION_FLOW_PVT';
7: g_miss_date DATE:=to_date(to_char(FND_API.G_MISS_DATE,'DD-MM-YYYY HH24:MI:SS'),'DD-MM-YYYY HH24:MI:SS');
8:
9: --procedures
10:

Line 1184: P_LINES_TAB IN INV_TRANSACTION_FLOW_PVT.TRX_FLOW_LINES_TAB,

1180:
1181: /*=======================================================================================================*/
1182:
1183: FUNCTION Validate_Trx_Flow_Lines(
1184: P_LINES_TAB IN INV_TRANSACTION_FLOW_PVT.TRX_FLOW_LINES_TAB,
1185: P_SHIP_FROM_TO_ORGANIZATION_ID IN NUMBER,
1186: P_FLOW_TYPE IN NUMBER,
1187: P_START_ORG_ID IN NUMBER,
1188: P_END_ORG_ID IN NUMBER,

Line 1892: P_LINES_TAB IN INV_TRANSACTION_FLOW_PVT.TRX_FLOW_LINES_TAB

1888: P_ATTRIBUTE13 IN VARCHAR2,
1889: P_ATTRIBUTE14 IN VARCHAR2,
1890: P_ATTRIBUTE15 IN VARCHAR2,
1891: P_REF_DATE IN DATE,
1892: P_LINES_TAB IN INV_TRANSACTION_FLOW_PVT.TRX_FLOW_LINES_TAB
1893: ) IS
1894: l_row_id NUMBER;
1895: l_header_id NUMBER;
1896: inv_j_installed BOOLEAN;

Line 2112: /*IF NOT INV_TRANSACTION_FLOW_PVT.Validate_Header(

2108: end if;
2109: --
2110: -- Validate Header
2111: --
2112: /*IF NOT INV_TRANSACTION_FLOW_PVT.Validate_Header(
2113: P_HEADER_ID => p_header_id,
2114: P_START_ORG_ID => p_start_org_id,
2115: P_END_ORG_ID => p_end_org_id,
2116: P_FLOW_TYPE => p_flow_type,

Line 2132: IF NOT INV_TRANSACTION_FLOW_PVT.Validate_Start_Date(

2128: end if;
2129: --
2130: -- Validate Start Date*/
2131: --
2132: IF NOT INV_TRANSACTION_FLOW_PVT.Validate_Start_Date(
2133: P_HEADER_ID => p_header_id,
2134: P_START_ORG_ID => p_start_org_id,
2135: P_END_ORG_ID => p_end_org_id,
2136: P_FLOW_TYPE => p_flow_type,

Line 2152: IF NOT INV_TRANSACTION_FLOW_PVT.Validate_End_Date(

2148: end if;
2149: --
2150: -- Validate End Date
2151: --
2152: IF NOT INV_TRANSACTION_FLOW_PVT.Validate_End_Date(
2153: P_HEADER_ID => p_header_id,
2154: P_START_ORG_ID => p_start_org_id,
2155: P_END_ORG_ID => p_end_org_id,
2156: P_FLOW_TYPE => p_flow_type,

Line 2261: INV_TRANSACTION_FLOW_PVT.INSERT_TRX_FLOW_HEADER(

2257: END IF;
2258: --
2259: -- All data is validated can be inserted to tables now
2260: --
2261: INV_TRANSACTION_FLOW_PVT.INSERT_TRX_FLOW_HEADER(
2262: P_HEADER_ID => p_header_id,
2263: P_START_ORG_ID => P_START_ORG_ID,
2264: P_END_ORG_ID => P_END_ORG_ID,
2265: P_FLOW_TYPE => P_FLOW_TYPE,

Line 2302: INV_TRANSACTION_FLOW_PVT.INSERT_TRX_FLOW_LINES(

2298: end if;
2299: -- insert all the lines
2300: FOR l_index IN 1..p_lines_tab.count
2301: LOOP
2302: INV_TRANSACTION_FLOW_PVT.INSERT_TRX_FLOW_LINES(
2303: P_Header_Id => p_header_id,
2304: P_Line_Number => p_lines_tab(l_index).line_number,
2305: P_From_Org_Id => p_lines_tab(l_index).from_org_id,
2306: P_From_Organization_Id => p_lines_tab(l_index).from_organization_id,

Line 2384: P_LINES_TAB IN INV_TRANSACTION_FLOW_PVT.TRX_FLOW_LINES_TAB

2380: P_ATTRIBUTE12 IN VARCHAR2,
2381: P_ATTRIBUTE13 IN VARCHAR2,
2382: P_ATTRIBUTE14 IN VARCHAR2,
2383: P_ATTRIBUTE15 IN VARCHAR2,
2384: P_LINES_TAB IN INV_TRANSACTION_FLOW_PVT.TRX_FLOW_LINES_TAB
2385: ) IS
2386:
2387:
2388:

Line 2461: IF NOT INV_TRANSACTION_FLOW_PVT.Validate_Start_Date(

2457: RAISE FND_API.G_EXC_ERROR;
2458: END;
2459: IF p_start_date <> l_start_date THEN
2460: -- do the validation
2461: IF NOT INV_TRANSACTION_FLOW_PVT.Validate_Start_Date(
2462: P_HEADER_ID => p_header_id,
2463: P_START_ORG_ID => l_start_org_id,
2464: P_END_ORG_ID => l_end_org_id,
2465: P_FLOW_TYPE => l_flow_type,

Line 2479: IF NOT INV_TRANSACTION_FLOW_PVT.Validate_End_Date(

2475: END IF;
2476:
2477: IF nvl(p_end_date,sysdate) <> nvl(l_end_date,sysdate) THEN
2478: -- do the validations
2479: IF NOT INV_TRANSACTION_FLOW_PVT.Validate_End_Date(
2480: P_HEADER_ID => p_header_id,
2481: P_START_ORG_ID => l_start_org_id,
2482: P_END_ORG_ID => l_end_org_id,
2483: P_FLOW_TYPE => l_flow_type,

Line 2558: INV_TRANSACTION_FLOW_PVT.UPDATE_TRX_FLOW_HEADER(

2554:
2555: --
2556: -- All data is validated can be updated to tables now
2557: --
2558: INV_TRANSACTION_FLOW_PVT.UPDATE_TRX_FLOW_HEADER(
2559: P_HEADER_ID => p_header_id,
2560: P_START_DATE => P_START_DATE,
2561: P_END_DATE => P_END_DATE,
2562: P_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,

Line 2588: INV_TRANSACTION_FLOW_PVT.UPDATE_TRX_FLOW_LINES(

2584: end if;
2585: -- update all the lines
2586: FOR l_index IN 1..p_lines_tab.count
2587: LOOP
2588: INV_TRANSACTION_FLOW_PVT.UPDATE_TRX_FLOW_LINES(
2589: P_Header_Id => p_header_id,
2590: P_Line_Number => p_lines_tab(l_index).line_number,
2591: P_Last_Updated_By => FND_GLOBAL.USER_ID,
2592: P_Last_Update_Date => SYSDATE,

Line 2719: IF NOT INV_TRANSACTION_FLOW_PVT.Validate_Start_Date(

2715: END;
2716:
2717: IF p_start_date <> l_start_date THEN
2718: -- do the validation
2719: IF NOT INV_TRANSACTION_FLOW_PVT.Validate_Start_Date(
2720: P_HEADER_ID => p_header_id,
2721: P_START_ORG_ID => l_start_org_id,
2722: P_END_ORG_ID => l_end_org_id,
2723: P_FLOW_TYPE => l_flow_type,

Line 2737: IF NOT INV_TRANSACTION_FLOW_PVT.Validate_End_Date(

2733: END IF;
2734:
2735: IF nvl(p_end_date,sysdate) <> nvl(l_end_date,sysdate) THEN
2736: -- do the validations
2737: IF NOT INV_TRANSACTION_FLOW_PVT.Validate_End_Date(
2738: P_HEADER_ID => p_header_id,
2739: P_START_ORG_ID => l_start_org_id,
2740: P_END_ORG_ID => l_end_org_id,
2741: P_FLOW_TYPE => l_flow_type,

Line 2783: INV_TRANSACTION_FLOW_PVT.update_trx_flow_header

2779:
2780: --
2781: -- All data is validated can be updated to tables now
2782: --
2783: INV_TRANSACTION_FLOW_PVT.update_trx_flow_header
2784: (P_HEADER_ID => p_header_id,
2785: P_START_DATE => P_START_DATE,
2786: P_END_DATE => P_END_DATE,
2787: P_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,

Line 2920: INV_TRANSACTION_FLOW_PVT.UPDATE_TRX_FLOW_LINES(

2916: if g_debug=1 then
2917: debug('attribute columns for lines validated','Update_IC_Txn_Flow_line');
2918: end if;
2919:
2920: INV_TRANSACTION_FLOW_PVT.UPDATE_TRX_FLOW_LINES(
2921: P_Header_Id => p_header_id,
2922: P_Line_Number => p_line_number,
2923: P_Last_Updated_By => FND_GLOBAL.USER_ID,
2924: P_Last_Update_Date => SYSDATE,

Line 3582: END;-- INV_TRANSACTION_FLOW_PVT

3578:
3579: /*=======================================================================================================*/
3580:
3581:
3582: END;-- INV_TRANSACTION_FLOW_PVT
3583: