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_AR_REVENUE_B_C dependencies on FII_AR_REVENUE_JOBS

Line 238: -- FII_UTIL.put_line('Truncating table FII_AR_REVENUE_JOBS');

234: -- return;
235: if g_debug_flag = 'Y' then
236: FII_UTIL.put_line('Running procedure CLEAN_UP');
237: FII_UTIL.put_line('');
238: -- FII_UTIL.put_line('Truncating table FII_AR_REVENUE_JOBS');
239: end if;
240: truncate_table('fii_ar_revenue_jobs');
241:
242: IF (g_truncate_id = 'Y') THEN

Line 240: truncate_table('fii_ar_revenue_jobs');

236: FII_UTIL.put_line('Running procedure CLEAN_UP');
237: FII_UTIL.put_line('');
238: -- FII_UTIL.put_line('Truncating table FII_AR_REVENUE_JOBS');
239: end if;
240: truncate_table('fii_ar_revenue_jobs');
241:
242: IF (g_truncate_id = 'Y') THEN
243: -- if g_debug_flag = 'Y' then
244: -- FII_UTIL.put_line('Truncating table FII_AR_REVENUE_ID');

Line 2383: INSERT INTO FII_AR_REVENUE_JOBS (

2379:
2380: -- haritha
2381: /* Register jobs to get future-dated transactions for 'AR INV' and
2382: 'AR ADJ' */
2383: INSERT INTO FII_AR_REVENUE_JOBS (
2384: function,
2385: phase,
2386: priority,
2387: date_parameter1,

Line 2429: INSERT INTO FII_AR_REVENUE_JOBS (

2425:
2426: WHILE (l_from_temp <= sysdate )
2427: LOOP
2428:
2429: INSERT INTO FII_AR_REVENUE_JOBS (
2430: function,
2431: phase,
2432: priority,
2433: date_parameter1,

Line 2460: INSERT INTO FII_AR_REVENUE_JOBS (

2456:
2457: -- haritha
2458: /* Register jobs to get future-dated transactions for AR DL*/
2459:
2460: INSERT INTO FII_AR_REVENUE_JOBS (
2461: function,
2462: phase,
2463: priority,
2464: date_parameter1,

Line 2501: INSERT INTO FII_AR_REVENUE_JOBS (

2497: fii_util.put_line('');
2498: fii_util.put_line('Registering remaining misc jobs ');
2499: end if;
2500:
2501: INSERT INTO FII_AR_REVENUE_JOBS (
2502: function,
2503: phase,
2504: priority,
2505: date_parameter1,

Line 2634: insert into FII_AR_REVENUE_JOBS (

2630: ELSE
2631: l_priority := 2;
2632: END IF;
2633:
2634: insert into FII_AR_REVENUE_JOBS (
2635: function,
2636: phase,
2637: priority,
2638: number_parameter1,

Line 4409: FROM FII_AR_REVENUE_JOBS;

4405: l_completed_cnt,
4406: l_wip_cnt,
4407: l_failed_cnt,
4408: l_tot_cnt
4409: FROM FII_AR_REVENUE_JOBS;
4410:
4411: if g_debug_flag = 'Y' then
4412: fii_util.put_line('Job status - Unassigned:'||l_unassigned_cnt||
4413: ' In Process:'||l_wip_cnt||

Line 4688: FROM fii_ar_revenue_jobs

4684:
4685: IF (p_program_type = 'I') THEN
4686: SELECT sum(rows_processed)
4687: INTO l_count
4688: FROM fii_ar_revenue_jobs
4689: WHERE function = 'POPULATE_STG';
4690:
4691: if g_debug_flag = 'Y' then
4692: fii_util.put_line(' ');

Line 4699: FROM fii_ar_revenue_jobs

4695: END IF;
4696:
4697: /* SELECT sum(rows_processed)
4698: INTO l_count
4699: FROM fii_ar_revenue_jobs
4700: WHERE function = 'DETECT_DELETED_INV';
4701: if g_debug_flag = 'Y' then
4702: fii_util.put_line('Found '||l_count||' invoice(s) deleted');
4703: end if;

Line 4766: UPDATE FII_AR_REVENUE_JOBS

4762:
4763: --------------------------------
4764: -- Terminate the child processes
4765: --------------------------------
4766: UPDATE FII_AR_REVENUE_JOBS
4767: SET status = 'FAILED'
4768: WHERE rownum < 2;
4769:
4770: COMMIT;

Line 4786: UPDATE FII_AR_REVENUE_JOBS

4782:
4783: --------------------------------
4784: -- Terminate the child processes
4785: --------------------------------
4786: UPDATE FII_AR_REVENUE_JOBS
4787: SET status = 'FAILED'
4788: WHERE rownum < 2;
4789:
4790: COMMIT;

Line 4815: l_function FII_AR_REVENUE_JOBS.function%TYPE;

4811: l_curr_comp_cnt NUMBER := 0;
4812: l_curr_tot_cnt NUMBER := 0;
4813: l_count NUMBER;
4814: l_curr_phase NUMBER;
4815: l_function FII_AR_REVENUE_JOBS.function%TYPE;
4816: l_num_parameter1 FII_AR_REVENUE_JOBS.number_parameter1%TYPE;
4817: l_num_parameter2 FII_AR_REVENUE_JOBS.number_parameter2%TYPE;
4818: l_char_parameter1 FII_AR_REVENUE_JOBS.char_parameter1%TYPE;
4819: l_char_parameter2 FII_AR_REVENUE_JOBS.char_parameter2%TYPE;

Line 4816: l_num_parameter1 FII_AR_REVENUE_JOBS.number_parameter1%TYPE;

4812: l_curr_tot_cnt NUMBER := 0;
4813: l_count NUMBER;
4814: l_curr_phase NUMBER;
4815: l_function FII_AR_REVENUE_JOBS.function%TYPE;
4816: l_num_parameter1 FII_AR_REVENUE_JOBS.number_parameter1%TYPE;
4817: l_num_parameter2 FII_AR_REVENUE_JOBS.number_parameter2%TYPE;
4818: l_char_parameter1 FII_AR_REVENUE_JOBS.char_parameter1%TYPE;
4819: l_char_parameter2 FII_AR_REVENUE_JOBS.char_parameter2%TYPE;
4820: l_section VARCHAR2(20) := NULL;

Line 4817: l_num_parameter2 FII_AR_REVENUE_JOBS.number_parameter2%TYPE;

4813: l_count NUMBER;
4814: l_curr_phase NUMBER;
4815: l_function FII_AR_REVENUE_JOBS.function%TYPE;
4816: l_num_parameter1 FII_AR_REVENUE_JOBS.number_parameter1%TYPE;
4817: l_num_parameter2 FII_AR_REVENUE_JOBS.number_parameter2%TYPE;
4818: l_char_parameter1 FII_AR_REVENUE_JOBS.char_parameter1%TYPE;
4819: l_char_parameter2 FII_AR_REVENUE_JOBS.char_parameter2%TYPE;
4820: l_section VARCHAR2(20) := NULL;
4821:

Line 4818: l_char_parameter1 FII_AR_REVENUE_JOBS.char_parameter1%TYPE;

4814: l_curr_phase NUMBER;
4815: l_function FII_AR_REVENUE_JOBS.function%TYPE;
4816: l_num_parameter1 FII_AR_REVENUE_JOBS.number_parameter1%TYPE;
4817: l_num_parameter2 FII_AR_REVENUE_JOBS.number_parameter2%TYPE;
4818: l_char_parameter1 FII_AR_REVENUE_JOBS.char_parameter1%TYPE;
4819: l_char_parameter2 FII_AR_REVENUE_JOBS.char_parameter2%TYPE;
4820: l_section VARCHAR2(20) := NULL;
4821:
4822: BEGIN

Line 4819: l_char_parameter2 FII_AR_REVENUE_JOBS.char_parameter2%TYPE;

4815: l_function FII_AR_REVENUE_JOBS.function%TYPE;
4816: l_num_parameter1 FII_AR_REVENUE_JOBS.number_parameter1%TYPE;
4817: l_num_parameter2 FII_AR_REVENUE_JOBS.number_parameter2%TYPE;
4818: l_char_parameter1 FII_AR_REVENUE_JOBS.char_parameter1%TYPE;
4819: l_char_parameter2 FII_AR_REVENUE_JOBS.char_parameter2%TYPE;
4820: l_section VARCHAR2(20) := NULL;
4821:
4822: BEGIN
4823: Errbuf :=NULL;

Line 4871: FROM FII_AR_REVENUE_JOBS;

4867: l_failed_cnt,
4868: l_curr_unasgn_cnt,
4869: l_curr_comp_cnt,
4870: l_curr_tot_cnt
4871: FROM FII_AR_REVENUE_JOBS;
4872:
4873:
4874: l_section := 'W-Section 40';
4875: IF (l_failed_cnt > 0) THEN

Line 4896: UPDATE FII_AR_REVENUE_JOBS

4892:
4893: IF (l_curr_unasgn_cnt > 0) THEN
4894:
4895: l_section := 'W-Section 50';
4896: UPDATE FII_AR_REVENUE_JOBS
4897: SET status = 'IN PROCESS',
4898: start_time = sysdate,
4899: worker = g_worker_num
4900: WHERE status = 'UNASSIGNED'

Line 4904: FROM fii_ar_revenue_jobs

4900: WHERE status = 'UNASSIGNED'
4901: AND phase = l_curr_phase
4902: AND priority = (
4903: SELECT min(priority)
4904: FROM fii_ar_revenue_jobs
4905: WHERE status = 'UNASSIGNED'
4906: AND phase = l_curr_phase)
4907: AND rownum < 2;
4908:

Line 4945: FROM FII_AR_REVENUE_JOBS

4941: l_num_parameter1,
4942: l_num_parameter2,
4943: l_char_parameter1,
4944: l_char_parameter2
4945: FROM FII_AR_REVENUE_JOBS
4946: WHERE worker = p_worker_no
4947: AND status = 'IN PROCESS';
4948:
4949:

Line 5013: UPDATE FII_AR_REVENUE_JOBS

5009:
5010: COMMIT;
5011:
5012: l_section := 'W-Section 80';
5013: UPDATE FII_AR_REVENUE_JOBS
5014: SET status = 'COMPLETED',
5015: end_time = sysdate,
5016: rows_processed = l_count
5017: WHERE worker = p_worker_no

Line 5025: UPDATE FII_AR_REVENUE_JOBS

5021: EXCEPTION
5022: WHEN OTHERS THEN
5023:
5024: g_retcode := -2;
5025: UPDATE FII_AR_REVENUE_JOBS
5026: SET status = 'FAILED',
5027: end_time = sysdate
5028: WHERE worker = p_worker_no
5029: AND status = 'IN PROCESS';