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.OKC_DELIVERABLE_PROCESS_PVT dependencies on DUAL

Line 798: select okc_deliverable_id_s.nextval INTO delNewTab(q).deliverable_id from dual;

794: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
795: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'103: deliverable IDs table record = '||j);
796: END IF;
797:
798: select okc_deliverable_id_s.nextval INTO delNewTab(q).deliverable_id from dual;
799:
800: delNewTab(q).business_document_id := p_target_doc_id;
801: delNewTab(q).business_document_type := p_target_doc_type;
802: delNewTab(q).business_document_number := p_target_doc_number;

Line 1051: select okc_deliverable_id_s.nextval INTO delNewTab(q).deliverable_id from dual;

1047: delIdTab.extend;
1048:
1049: delIdTab(j).orig_del_id := delRecTab(i).deliverable_id;
1050:
1051: select okc_deliverable_id_s.nextval INTO delNewTab(q).deliverable_id from dual;
1052:
1053: delNewTab(q).business_document_id := p_target_doc_id;
1054: delNewTab(q).business_document_type := p_target_doc_type;
1055: delNewTab(q).business_document_number := p_target_doc_number;

Line 2224: select okc_deliverable_id_s.nextval INTO delNewTab(j).deliverable_id from dual;

2220: -- extend table type
2221: delIdTab.extend;
2222: delIdTab(j).orig_del_id := delRecTab(i).deliverable_id;
2223: delNewTab(j) := delRecTab(i);
2224: select okc_deliverable_id_s.nextval INTO delNewTab(j).deliverable_id from dual;
2225: delIdTab(j).del_id := delNewTab(j).deliverable_id;
2226: delNewTab(j).original_deliverable_id := delNewTab(j).deliverable_id;
2227: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2228: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: New Deliverable Id :'||to_char(delNewTab(j).deliverable_id));

Line 2266: from dual;

2262: delIdTab.extend;
2263: delIdTab(j).orig_del_id := delRecTab(i).deliverable_id;
2264: delNewTab(j) := delRecTab(i);
2265: select okc_deliverable_id_s.nextval INTO delNewTab(j).deliverable_id
2266: from dual;
2267: delIdTab(j).del_id := delNewTab(j).deliverable_id;
2268: -- If party and contact info is null then assign the parameter values
2269: delNewTab(j).internal_party_id :=
2270: NVL(delNewTab(j).internal_party_id,p_internal_party_id);

Line 2292: from dual;

2288: delIdTab.extend;
2289: delIdTab(j).orig_del_id := delRecTab(i).deliverable_id;
2290: delNewTab(j) := delRecTab(i);
2291: select okc_deliverable_id_s.nextval INTO delNewTab(j).deliverable_id
2292: from dual;
2293: delIdTab(j).del_id := delNewTab(j).deliverable_id;
2294: -- If party and contact info is null then assign the parameter values
2295: delNewTab(j).internal_party_id :=
2296: NVL(delNewTab(j).internal_party_id,p_internal_party_id);

Line 2383: from dual;

2379: delIdTab.extend;
2380: delIdTab(j).orig_del_id := delRecTab(i).deliverable_id;
2381: delNewTab(j) := delRecTab(i);
2382: select okc_deliverable_id_s.nextval INTO delNewTab(j).deliverable_id
2383: from dual;
2384: -- If party and contact info is null then assign the parameter values
2385: delNewTab(j).internal_party_id :=
2386: NVL(delNewTab(j).internal_party_id,p_internal_party_id);
2387: delNewTab(j).external_party_id :=

Line 2418: from dual;

2414: delIdTab.extend;
2415: delIdTab(j).orig_del_id := delRecTab(i).deliverable_id;
2416: delNewTab(j) := delRecTab(i);
2417: select okc_deliverable_id_s.nextval INTO delNewTab(j).deliverable_id
2418: from dual;
2419: delIdTab(j).del_id := delNewTab(j).deliverable_id;
2420: -- If party and contact info is null then assign the parameter values
2421: delNewTab(j).internal_party_id :=
2422: NVL(delNewTab(j).internal_party_id,p_internal_party_id);

Line 2495: from dual;

2491: delIdTab.extend;
2492: delIdTab(j).orig_del_id := delRecTab(i).deliverable_id;
2493: delNewTab(j) := delRecTab(i);
2494: select okc_deliverable_id_s.nextval INTO delNewTab(j).deliverable_id
2495: from dual;
2496: -- 11.5.10+ bug#3670582 fix reset original del id
2497: delNewTab(j).original_deliverable_id := delNewTab(j).deliverable_id;
2498:
2499:

Line 2579: from dual;

2575: delIdTab.extend;
2576: delIdTab(j).orig_del_id := delRecTab(i).deliverable_id;
2577: delNewTab(j) := delRecTab(i);
2578: select okc_deliverable_id_s.nextval INTO delNewTab(j).deliverable_id
2579: from dual;
2580: -- 11.5.10+ bug#3670582 fix reset original del id
2581: delNewTab(j).original_deliverable_id := delNewTab(j).deliverable_id;
2582:
2583: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2657: from dual;

2653: delIdTab.extend;
2654: delIdTab(j).orig_del_id := delRecTab(i).deliverable_id;
2655: delNewTab(j) := delRecTab(i);
2656: select okc_deliverable_id_s.nextval INTO delNewTab(j).deliverable_id
2657: from dual;
2658: -- 11.5.10+ bug#3670582 fix reset original del id
2659: delNewTab(j).original_deliverable_id := delNewTab(j).deliverable_id;
2660:
2661: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2704: from dual;

2700: delIdTab.extend;
2701: delIdTab(j).orig_del_id := delRecTab(i).deliverable_id;
2702: delNewTab(j) := delRecTab(i);
2703: select okc_deliverable_id_s.nextval INTO delNewTab(j).deliverable_id
2704: from dual;
2705: -- 11.5.10+ bug#3670582 fix reset original del id
2706: delNewTab(j).original_deliverable_id := delNewTab(j).deliverable_id;
2707:
2708: delIdTab(j).del_id := delNewTab(j).deliverable_id;

Line 2780: from dual;

2776: delIdTab.extend;
2777: delIdTab(j).orig_del_id := delRecTab(i).deliverable_id;
2778: delNewTab(j) := delRecTab(i);
2779: select okc_deliverable_id_s.nextval INTO delNewTab(j).deliverable_id
2780: from dual;
2781: -- 11.5.10+ bug#3670582 fix reset original del id
2782: delNewTab(j).original_deliverable_id := delNewTab(j).deliverable_id;
2783:
2784: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2820: from dual;

2816: delIdTab.extend;
2817: delIdTab(j).orig_del_id := delRecTab(i).deliverable_id;
2818: delNewTab(j) := delRecTab(i);
2819: select okc_deliverable_id_s.nextval INTO delNewTab(j).deliverable_id
2820: from dual;
2821: -- 11.5.10+ bug#3670582 fix reset original del id
2822: delNewTab(j).original_deliverable_id := delNewTab(j).deliverable_id;
2823:
2824: delIdTab(j).del_id := delNewTab(j).deliverable_id;

Line 3579: INTO delNewTab(j).deliverable_id from dual;

3575: END IF;
3576: delNewTab(j).business_document_version := p_current_doc_version;
3577: delNewTab(j).recurring_del_parent_id := delRecTab(i).deliverable_id;
3578: select okc_deliverable_id_s.nextval
3579: INTO delNewTab(j).deliverable_id from dual;
3580: delIdTab(q).del_id := delNewTab(j).deliverable_id;
3581: -- reset end date definition to new definition
3582: delNewTab(j).RELATIVE_END_DATE_DURATION:=
3583: delRecTab(i).RELATIVE_END_DATE_DURATION;

Line 3812: INTO delNewTab(j).deliverable_id from dual;

3808: delIdTab(q).orig_del_id := delInsTab(k).deliverable_id;
3809: -- build new version deliverables table
3810: delNewTab(j):= delInsTab(k);
3811: select okc_deliverable_id_s.nextval
3812: INTO delNewTab(j).deliverable_id from dual;
3813: delNewTab(j).business_document_version := p_current_doc_version;
3814: delIdTab(q).del_id := delNewTab(j).deliverable_id;
3815: -- Resetting the amendment attributes to the definition values bug#3293314
3816: delNewTab(j).AMENDMENT_OPERATION := delRecTab(i).amendment_operation;

Line 4546: INTO delNewTab(j).deliverable_id from dual;

4542: IF delRecTab(i).amendment_operation IS NOT NULL THEN
4543: delNewTab(j).last_amendment_date := delRecTab(i).last_amendment_date;
4544: END IF;
4545: select okc_deliverable_id_s.nextval
4546: INTO delNewTab(j).deliverable_id from dual;
4547: delNewTab(j).business_document_version := p_doc_version;
4548: delIdTab(q).del_id := delNewTab(j).deliverable_id;
4549:
4550: END LOOP;-- delRecTab(i)

Line 6009: INTO l_notification_date from dual;

6005: ELSIF UPPER(delRecTab(i).NOTIFY_PRIOR_DUE_DATE_UOM) = 'WK' THEN
6006: l_notification_date :=trunc(delRecTab(i).actual_due_date)-7*delRecTab(i).NOTIFY_PRIOR_DUE_DATE_VALUE;
6007: ELSIF UPPER(delRecTab(i).NOTIFY_PRIOR_DUE_DATE_UOM) = 'MTH' THEN
6008: select add_months(delRecTab(i).actual_due_date,-delRecTab(i).NOTIFY_PRIOR_DUE_DATE_VALUE)
6009: INTO l_notification_date from dual;
6010: END IF;
6011:
6012: IF trunc(l_notification_date) = trunc(sysdate) OR
6013: trunc(l_notification_date) < trunc(sysdate) THEN -- call to notifier

Line 6377: INTO l_notification_date from dual;

6373: ELSIF UPPER(delRecTab(i).NOTIFY_ESCALATION_UOM) = 'WK' THEN
6374: l_notification_date :=trunc(delRecTab(i).actual_due_date)+7*delRecTab(i).NOTIFY_ESCALATION_VALUE;
6375: ELSIF UPPER(delRecTab(i).NOTIFY_ESCALATION_UOM) = 'MTH' THEN
6376: select add_months(delRecTab(i).actual_due_date,delRecTab(i).NOTIFY_ESCALATION_VALUE)
6377: INTO l_notification_date from dual;
6378: END IF;
6379:
6380: IF trunc(l_notification_date) = trunc(sysdate) OR
6381: trunc(l_notification_date) < trunc(sysdate) THEN -- call to notifier

Line 11415: INTO delNewTab(j).deliverable_id from dual;

11411: delIdTab.extend;
11412: delIdTab(j).orig_del_id := delRecTab(i).deliverable_id;
11413: delNewTab(j) := delRecTab(i);
11414: select okc_deliverable_id_s.nextval
11415: INTO delNewTab(j).deliverable_id from dual;
11416: delIdTab(j).del_id := delNewTab(j).deliverable_id;
11417: -- store current_del_parent_id in local variable
11418: --to assign it to the instances
11419: l_recur_del_parent_id := delNewTab(j).deliverable_id;

Line 11557: INTO delNewTab(j).deliverable_id from dual;

11553: delIdTab(j).orig_del_id := delInsTab(n).deliverable_id;
11554: -- build new version deliverables table
11555: delNewTab(j):= delInsTab(n);
11556: select okc_deliverable_id_s.nextval
11557: INTO delNewTab(j).deliverable_id from dual;
11558: delIdTab(j).del_id := delNewTab(j).deliverable_id;
11559: delNewTab(j).recurring_del_parent_id := l_recur_del_parent_id;
11560: -- assign common attributes
11561: delNewTab(j).business_document_id := p_target_doc_id;

Line 12421: select okc_deliverable_id_s.nextval INTO delNewTab(j).deliverable_id from dual;

12417: -- extend table type
12418: delIdTab.extend;
12419: delIdTab(j).orig_del_id := delRecTab(i).deliverable_id;
12420: delNewTab(j) := delRecTab(i);
12421: select okc_deliverable_id_s.nextval INTO delNewTab(j).deliverable_id from dual;
12422: delIdTab(j).del_id := delNewTab(j).deliverable_id;
12423: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
12424: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: New Deliverable Id :'||to_char(delNewTab(j).deliverable_id));
12425: END IF;

Line 13044: select okc_deliverable_id_s.nextval INTO l_deliverable_id from dual;

13040: OPEN cur_del_doc_type(prev_vers_del(i).original_deliverable_id);
13041: FETCH cur_del_doc_type INTO l_business_document_type;
13042: CLOSE cur_del_doc_type;
13043: IF(l_business_document_type='TEMPLATE') THEN
13044: select okc_deliverable_id_s.nextval INTO l_deliverable_id from dual;
13045: ELSE
13046: l_deliverable_id:=prev_vers_del(i).original_deliverable_id;
13047: END IF;
13048: END IF ;