eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FII_AP_INV_B_C dependencies on FII_AP_INV_B

Line 1: PACKAGE BODY FII_AP_INV_B_C AS

1: PACKAGE BODY FII_AP_INV_B_C AS
2: /* $Header: FIIAP17B.pls 120.76 2007/11/27 06:53:40 hsoorea ship $ */
3:
4: g_fii_schema VARCHAR2(30);
5: -- g_tablespace VARCHAR2(50) := NULL;

Line 59: g_table_name VARCHAR2(50) := 'FII_AP_INV_B';

55:
56: g_program_type VARCHAR2(1);
57:
58: g_usage_code CONSTANT VARCHAR2(10) := 'DBI'; --CHAR will fail join
59: g_table_name VARCHAR2(50) := 'FII_AP_INV_B';
60: g_ind_exp_classes VARCHAR2(1000);
61: g_xla_ret_code VARCHAR2(1) := NULL;
62: g_apps_schema_name VARCHAR2(50) := NVL(FII_UTIL.get_apps_schema_name, 'APPS');
63:

Line 244: FROM fii_ap_inv_b

240:
241: BEGIN
242: SELECT 1
243: INTO l_count1
244: FROM fii_ap_inv_b
245: WHERE ROWNUM = 1;
246: EXCEPTION
247: WHEN NO_DATA_FOUND THEN l_count1 := 0;
248: END;

Line 330: FROM FII_AP_Inv_B

326: sysdate CREATION_DATE,
327: g_fii_user_id CREATED_BY,
328: g_fii_login_id LAST_UPDATE_LOGIN
329: FROM (SELECT AE_Header_ID, Ref_AE_Header_ID, Temp_Line_Num
330: FROM FII_AP_Inv_B
331: WHERE GL_SL_Link_ID IS NULL);
332:
333: l_count := SQL%ROWCOUNT;
334:

Line 656: SELECT MAX(NVL(AE_Header_ID, -1)) + 1 INTO l_start_number2 FROM FII_AP_INV_B;

652: FROM FII_AP_Unpost_Headers_T;
653:
654:
655: --Find start and end re for Phase 2 jobs.
656: SELECT MAX(NVL(AE_Header_ID, -1)) + 1 INTO l_start_number2 FROM FII_AP_INV_B;
657: SELECT MAX(AE_Header_ID) INTO l_max_number2 FROM XLA_AE_HEADERS;
658:
659: IF l_max_number1 = -1 AND l_start_number1 = -1 AND l_max_number2 <= l_start_number2 THEN
660: RETURN -1;

Line 740: 'FII_AP_INV_B_C_SUBWORKER',

736:
737:
738: l_request_id := FND_REQUEST.SUBMIT_REQUEST(
739: 'FII',
740: 'FII_AP_INV_B_C_SUBWORKER',
741: NULL,
742: NULL,
743: FALSE,
744: p_worker_no);

Line 936: SELECT FII_AP_INV_B_S.nextval INTO seq_id FROM dual;

932: PROCEDURE POPULATE_AP_BASE_SUM IS
933: l_stmt VARCHAR2(1000);
934: seq_id NUMBER :=0;
935: BEGIN
936: SELECT FII_AP_INV_B_S.nextval INTO seq_id FROM dual;
937:
938: if g_debug_flag = 'Y' then
939: FII_UTIL.put_line('');
940: FII_UTIL.put_line('-------------------------------------------------');

Line 941: FII_UTIL.put_line('Populating FII_AP_INV_B FROM FII_AP_INV_STG table');

937:
938: if g_debug_flag = 'Y' then
939: FII_UTIL.put_line('');
940: FII_UTIL.put_line('-------------------------------------------------');
941: FII_UTIL.put_line('Populating FII_AP_INV_B FROM FII_AP_INV_STG table');
942: end if;
943:
944: g_state := 'Populating FII_AP_INV_B FROM FII_AP_INV_STG table';
945:

Line 944: g_state := 'Populating FII_AP_INV_B FROM FII_AP_INV_STG table';

940: FII_UTIL.put_line('-------------------------------------------------');
941: FII_UTIL.put_line('Populating FII_AP_INV_B FROM FII_AP_INV_STG table');
942: end if;
943:
944: g_state := 'Populating FII_AP_INV_B FROM FII_AP_INV_STG table';
945:
946: -- haritha.
947: -- Removed the where condition to check for invoice_id and other attributes
948: -- of a distribution. Instead added the invoice_distribution_id condition.

Line 951: MERGE /+ use_nl(bsum) / INTO FII_AP_INV_B BSUM

947: -- Removed the where condition to check for invoice_id and other attributes
948: -- of a distribution. Instead added the invoice_distribution_id condition.
949: -- Also added the additional columns for insertion.
950:
951: MERGE /*+ use_nl(bsum) */ INTO FII_AP_INV_B BSUM
952: USING (SELECT *
953: FROM FII_AP_INV_STG
954: WHERE (nvl(prim_conversion_rate,1) > 0 OR nvl(sec_conversion_rate,1) > 0)
955: ) STG

Line 1078: FII_UTIL.put_line('Merged ' || SQL%ROWCOUNT || ' records into FII_AP_INV_B');

1074: STG.Purchasing_Category_ID,
1075: STG.Item_Description);
1076:
1077: if g_debug_flag = 'Y' then
1078: FII_UTIL.put_line('Merged ' || SQL%ROWCOUNT || ' records into FII_AP_INV_B');
1079: FII_UTIL.put_line('');
1080: end if;
1081:
1082: COMMIT;

Line 1118: FII_UTIL.initialize(p_object_name||'.log',p_object_name||'.out',l_dir,'FII_AP_INV_B_Worker');

1114: -- fii_util.initialize will get profile options FII_DEBUG_MODE
1115: -- and BIS_DEBUG_LOG_DIRECTORY and set up the directory where
1116: -- the log files and output files are written to
1117: ----------------------------------------------------------------
1118: FII_UTIL.initialize(p_object_name||'.log',p_object_name||'.out',l_dir,'FII_AP_INV_B_Worker');
1119:
1120:
1121: g_fii_user_id := FND_GLOBAL.User_Id;
1122: g_fii_login_id := FND_GLOBAL.Login_Id;

Line 1145: -- FII_AP_INV_B is using

1141: g_state := 'Initializing the global variables';
1142:
1143: -- --------------------------------------------------------
1144: -- Find the schema owner and tablespace
1145: -- FII_AP_INV_B is using
1146: -- --------------------------------------------------------
1147: g_section := 'Section 20';
1148: if g_debug_flag = 'Y' then
1149: FII_UTIL.put_line('Section 20');

Line 1632: SELECT FII_AP_INV_B_S.nextval INTO seq_id FROM dual;

1628: fii_util.start_timer;
1629: fii_util.put_line('');
1630: end if;
1631:
1632: SELECT FII_AP_INV_B_S.nextval INTO seq_id FROM dual;
1633:
1634: -- haritha.
1635: -- Added additional columns for insertion.
1636:

Line 1637: INSERT /+ APPEND PARALLEL(F) / INTO FII_AP_INV_B F (

1633:
1634: -- haritha.
1635: -- Added additional columns for insertion.
1636:
1637: INSERT /*+ APPEND PARALLEL(F) */ INTO FII_AP_INV_B F (
1638: LEDGER_ID,
1639: ACCOUNT_DATE,
1640: ACCOUNT_DATE_ID,
1641: INV_CURRENCY_CODE,

Line 1837: FII_UTIL.initialize('FII_AP_INV_B.log','FII_AP_INV_B.out',l_dir,'FII_AP_INV_B_L');

1833: -- and BIS_DEBUG_LOG_DIRECTORY and set up the directory where
1834: -- the log files and output files are written to
1835: ----------------------------------------------------------------
1836: IF g_program_type = 'L' THEN
1837: FII_UTIL.initialize('FII_AP_INV_B.log','FII_AP_INV_B.out',l_dir,'FII_AP_INV_B_L');
1838: ELSE
1839: FII_UTIL.initialize('FII_AP_INV_B.log','FII_AP_INV_B.out',l_dir, 'FII_AP_INV_B_I');
1840: END IF;
1841:

Line 1839: FII_UTIL.initialize('FII_AP_INV_B.log','FII_AP_INV_B.out',l_dir, 'FII_AP_INV_B_I');

1835: ----------------------------------------------------------------
1836: IF g_program_type = 'L' THEN
1837: FII_UTIL.initialize('FII_AP_INV_B.log','FII_AP_INV_B.out',l_dir,'FII_AP_INV_B_L');
1838: ELSE
1839: FII_UTIL.initialize('FII_AP_INV_B.log','FII_AP_INV_B.out',l_dir, 'FII_AP_INV_B_I');
1840: END IF;
1841:
1842: -------------------------------------------------------------
1843: -- Check if FII: DBI Payables Invoice Distributions Implementation profile

Line 1894: TRUNCATE_TABLE('FII_AP_INV_B');

1890: IF g_debug_flag = 'Y' then
1891: FII_UTIL.put_line('Running Initial Load, truncate staging and base summary table.');
1892: END IF;
1893: TRUNCATE_TABLE('FII_AP_INV_STG');
1894: TRUNCATE_TABLE('FII_AP_INV_B');
1895: COMMIT;
1896: END IF;
1897:
1898: -- Load and Increment programs should record the dates seperately

Line 1902: IF (NOT BIS_COLLECTION_UTILITIES.setup('FII_AP_INV_B_L')) THEN

1898: -- Load and Increment programs should record the dates seperately
1899: -- so that the dates are derived correctly for incremental mode.
1900: g_state := 'Calling BIS_COLLECTION_UTILITIES.setup';
1901: IF p_program_type = 'L' THEN
1902: IF (NOT BIS_COLLECTION_UTILITIES.setup('FII_AP_INV_B_L')) THEN
1903: raise_application_error(-20000,errbuf);
1904: return;
1905: END IF;
1906: ELSE

Line 1907: IF (NOT BIS_COLLECTION_UTILITIES.setup('FII_AP_INV_B_I')) THEN

1903: raise_application_error(-20000,errbuf);
1904: return;
1905: END IF;
1906: ELSE
1907: IF (NOT BIS_COLLECTION_UTILITIES.setup('FII_AP_INV_B_I')) THEN
1908: raise_application_error(-20000,errbuf);
1909: return;
1910: END IF;
1911: END IF;

Line 2366: BIS_COLLECTION_UTILITIES.get_last_refresh_dates('FII_AP_INV_B_L', l_last_start_date,

2362: SELECT MAX(Last_Update_Date) INTO l_last_sup_merge
2363: FROM AP_Duplicate_Vendors_All
2364: WHERE Process_Flag = 'Y';
2365:
2366: BIS_COLLECTION_UTILITIES.get_last_refresh_dates('FII_AP_INV_B_L', l_last_start_date,
2367: l_last_end_date, l_last_period_from,
2368: l_last_period_to);
2369: l_timestamp := nvl(l_last_start_date, bis_common_parameters.get_global_start_date);
2370:

Line 2371: BIS_COLLECTION_UTILITIES.get_last_refresh_dates('FII_AP_INV_B_I', l_last_start_date,

2367: l_last_end_date, l_last_period_from,
2368: l_last_period_to);
2369: l_timestamp := nvl(l_last_start_date, bis_common_parameters.get_global_start_date);
2370:
2371: BIS_COLLECTION_UTILITIES.get_last_refresh_dates('FII_AP_INV_B_I', l_last_start_date,
2372: l_last_end_date, l_last_period_from,
2373: l_last_period_to);
2374: l_timestamp := greatest(l_timestamp, nvl(l_last_start_date, bis_common_parameters.get_global_start_date));
2375:

Line 2379: UPDATE FII_AP_Inv_B BSUM

2375:
2376: IF trunc(l_last_sup_merge) >= trunc(l_timestamp) THEN
2377: g_state := 'Updating Supplier_ID and Supplier_Site_ID from AP_Duplicate_Vendors_All.';
2378:
2379: UPDATE FII_AP_Inv_B BSUM
2380: SET (Supplier_ID, Supplier_Site_ID) =
2381: (SELECT Vendor_ID, NVL(Vendor_Site_ID, Duplicate_Vendor_Site_ID)
2382: FROM AP_Duplicate_Vendors_All DV1
2383: WHERE DV1.Duplicate_Vendor_ID = BSUM.Supplier_ID

Line 2527: CHILD_SETUP('FII_AP_INV_B_C_SUBWORKER'||p_worker_no);

2523: -- Set up directory structure for child process
2524: -- because child process do not call setup routine
2525: -- from EDWCORE
2526: -- -----------------------------------------------
2527: CHILD_SETUP('FII_AP_INV_B_C_SUBWORKER'||p_worker_no);
2528:
2529: BIS_COLLECTION_UTILITIES.get_last_refresh_dates('FII_AP_INV_B_L', l_last_start_date,
2530: l_last_end_date, l_last_period_from,
2531: l_last_period_to);

Line 2529: BIS_COLLECTION_UTILITIES.get_last_refresh_dates('FII_AP_INV_B_L', l_last_start_date,

2525: -- from EDWCORE
2526: -- -----------------------------------------------
2527: CHILD_SETUP('FII_AP_INV_B_C_SUBWORKER'||p_worker_no);
2528:
2529: BIS_COLLECTION_UTILITIES.get_last_refresh_dates('FII_AP_INV_B_L', l_last_start_date,
2530: l_last_end_date, l_last_period_from,
2531: l_last_period_to);
2532: g_start_date := nvl(l_last_period_from, bis_common_parameters.get_global_start_date);
2533:

Line 2678: END FII_AP_INV_B_C;

2674: COMMIT;
2675:
2676:
2677: END WORKER;
2678: END FII_AP_INV_B_C;