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 778: select okc_deliverable_id_s.nextval INTO delNewTab(q).deliverable_id from dual;

774: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
775: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'103: deliverable IDs table record = '||j);
776: END IF;
777:
778: select okc_deliverable_id_s.nextval INTO delNewTab(q).deliverable_id from dual;
779:
780: delNewTab(q).business_document_id := p_target_doc_id;
781: delNewTab(q).business_document_type := p_target_doc_type;
782: delNewTab(q).business_document_number := p_target_doc_number;

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

993: delIdTab.extend;
994:
995: delIdTab(j).orig_del_id := delRecTab(i).deliverable_id;
996:
997: select okc_deliverable_id_s.nextval INTO delNewTab(q).deliverable_id from dual;
998:
999: delNewTab(q).business_document_id := p_target_doc_id;
1000: delNewTab(q).business_document_type := p_target_doc_type;
1001: delNewTab(q).business_document_number := p_target_doc_number;

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

2088: -- extend table type
2089: delIdTab.extend;
2090: delIdTab(j).orig_del_id := delRecTab(i).deliverable_id;
2091: delNewTab(j) := delRecTab(i);
2092: select okc_deliverable_id_s.nextval INTO delNewTab(j).deliverable_id from dual;
2093: delIdTab(j).del_id := delNewTab(j).deliverable_id;
2094: delNewTab(j).original_deliverable_id := delNewTab(j).deliverable_id;
2095: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2096: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: New Deliverable Id :'||to_char(delNewTab(j).deliverable_id));

Line 2134: from dual;

2130: delIdTab.extend;
2131: delIdTab(j).orig_del_id := delRecTab(i).deliverable_id;
2132: delNewTab(j) := delRecTab(i);
2133: select okc_deliverable_id_s.nextval INTO delNewTab(j).deliverable_id
2134: from dual;
2135: delIdTab(j).del_id := delNewTab(j).deliverable_id;
2136: -- If party and contact info is null then assign the parameter values
2137: delNewTab(j).internal_party_id :=
2138: NVL(delNewTab(j).internal_party_id,p_internal_party_id);

Line 2160: from dual;

2156: delIdTab.extend;
2157: delIdTab(j).orig_del_id := delRecTab(i).deliverable_id;
2158: delNewTab(j) := delRecTab(i);
2159: select okc_deliverable_id_s.nextval INTO delNewTab(j).deliverable_id
2160: from dual;
2161: delIdTab(j).del_id := delNewTab(j).deliverable_id;
2162: -- If party and contact info is null then assign the parameter values
2163: delNewTab(j).internal_party_id :=
2164: NVL(delNewTab(j).internal_party_id,p_internal_party_id);

Line 2251: from dual;

2247: delIdTab.extend;
2248: delIdTab(j).orig_del_id := delRecTab(i).deliverable_id;
2249: delNewTab(j) := delRecTab(i);
2250: select okc_deliverable_id_s.nextval INTO delNewTab(j).deliverable_id
2251: from dual;
2252: -- If party and contact info is null then assign the parameter values
2253: delNewTab(j).internal_party_id :=
2254: NVL(delNewTab(j).internal_party_id,p_internal_party_id);
2255: delNewTab(j).external_party_id :=

Line 2286: from dual;

2282: delIdTab.extend;
2283: delIdTab(j).orig_del_id := delRecTab(i).deliverable_id;
2284: delNewTab(j) := delRecTab(i);
2285: select okc_deliverable_id_s.nextval INTO delNewTab(j).deliverable_id
2286: from dual;
2287: delIdTab(j).del_id := delNewTab(j).deliverable_id;
2288: -- If party and contact info is null then assign the parameter values
2289: delNewTab(j).internal_party_id :=
2290: NVL(delNewTab(j).internal_party_id,p_internal_party_id);

Line 2363: from dual;

2359: delIdTab.extend;
2360: delIdTab(j).orig_del_id := delRecTab(i).deliverable_id;
2361: delNewTab(j) := delRecTab(i);
2362: select okc_deliverable_id_s.nextval INTO delNewTab(j).deliverable_id
2363: from dual;
2364: -- 11.5.10+ bug#3670582 fix reset original del id
2365: delNewTab(j).original_deliverable_id := delNewTab(j).deliverable_id;
2366:
2367:

Line 2440: from dual;

2436: delIdTab.extend;
2437: delIdTab(j).orig_del_id := delRecTab(i).deliverable_id;
2438: delNewTab(j) := delRecTab(i);
2439: select okc_deliverable_id_s.nextval INTO delNewTab(j).deliverable_id
2440: from dual;
2441: -- 11.5.10+ bug#3670582 fix reset original del id
2442: delNewTab(j).original_deliverable_id := delNewTab(j).deliverable_id;
2443:
2444: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2508: from dual;

2504: delIdTab.extend;
2505: delIdTab(j).orig_del_id := delRecTab(i).deliverable_id;
2506: delNewTab(j) := delRecTab(i);
2507: select okc_deliverable_id_s.nextval INTO delNewTab(j).deliverable_id
2508: from dual;
2509: -- 11.5.10+ bug#3670582 fix reset original del id
2510: delNewTab(j).original_deliverable_id := delNewTab(j).deliverable_id;
2511:
2512: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2555: from dual;

2551: delIdTab.extend;
2552: delIdTab(j).orig_del_id := delRecTab(i).deliverable_id;
2553: delNewTab(j) := delRecTab(i);
2554: select okc_deliverable_id_s.nextval INTO delNewTab(j).deliverable_id
2555: from dual;
2556: -- 11.5.10+ bug#3670582 fix reset original del id
2557: delNewTab(j).original_deliverable_id := delNewTab(j).deliverable_id;
2558:
2559: delIdTab(j).del_id := delNewTab(j).deliverable_id;

Line 2631: from dual;

2627: delIdTab.extend;
2628: delIdTab(j).orig_del_id := delRecTab(i).deliverable_id;
2629: delNewTab(j) := delRecTab(i);
2630: select okc_deliverable_id_s.nextval INTO delNewTab(j).deliverable_id
2631: from dual;
2632: -- 11.5.10+ bug#3670582 fix reset original del id
2633: delNewTab(j).original_deliverable_id := delNewTab(j).deliverable_id;
2634:
2635: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2671: from dual;

2667: delIdTab.extend;
2668: delIdTab(j).orig_del_id := delRecTab(i).deliverable_id;
2669: delNewTab(j) := delRecTab(i);
2670: select okc_deliverable_id_s.nextval INTO delNewTab(j).deliverable_id
2671: from dual;
2672: -- 11.5.10+ bug#3670582 fix reset original del id
2673: delNewTab(j).original_deliverable_id := delNewTab(j).deliverable_id;
2674:
2675: delIdTab(j).del_id := delNewTab(j).deliverable_id;

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

3376: END IF;
3377: delNewTab(j).business_document_version := p_current_doc_version;
3378: delNewTab(j).recurring_del_parent_id := delRecTab(i).deliverable_id;
3379: select okc_deliverable_id_s.nextval
3380: INTO delNewTab(j).deliverable_id from dual;
3381: delIdTab(q).del_id := delNewTab(j).deliverable_id;
3382: -- reset end date definition to new definition
3383: delNewTab(j).RELATIVE_END_DATE_DURATION:=
3384: delRecTab(i).RELATIVE_END_DATE_DURATION;

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

3595: delIdTab(q).orig_del_id := delInsTab(k).deliverable_id;
3596: -- build new version deliverables table
3597: delNewTab(j):= delInsTab(k);
3598: select okc_deliverable_id_s.nextval
3599: INTO delNewTab(j).deliverable_id from dual;
3600: delNewTab(j).business_document_version := p_current_doc_version;
3601: delIdTab(q).del_id := delNewTab(j).deliverable_id;
3602: -- Resetting the amendment attributes to the definition values bug#3293314
3603: delNewTab(j).AMENDMENT_OPERATION := delRecTab(i).amendment_operation;

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

4283: IF delRecTab(i).amendment_operation IS NOT NULL THEN
4284: delNewTab(j).last_amendment_date := delRecTab(i).last_amendment_date;
4285: END IF;
4286: select okc_deliverable_id_s.nextval
4287: INTO delNewTab(j).deliverable_id from dual;
4288: delNewTab(j).business_document_version := p_doc_version;
4289: delIdTab(q).del_id := delNewTab(j).deliverable_id;
4290:
4291: END LOOP;-- delRecTab(i)

Line 5701: INTO l_notification_date from dual;

5697: ELSIF UPPER(delRecTab(i).NOTIFY_PRIOR_DUE_DATE_UOM) = 'WK' THEN
5698: l_notification_date :=trunc(delRecTab(i).actual_due_date)-7*delRecTab(i).NOTIFY_PRIOR_DUE_DATE_VALUE;
5699: ELSIF UPPER(delRecTab(i).NOTIFY_PRIOR_DUE_DATE_UOM) = 'MTH' THEN
5700: select add_months(delRecTab(i).actual_due_date,-delRecTab(i).NOTIFY_PRIOR_DUE_DATE_VALUE)
5701: INTO l_notification_date from dual;
5702: END IF;
5703:
5704: IF trunc(l_notification_date) = trunc(sysdate) OR
5705: trunc(l_notification_date) < trunc(sysdate) THEN -- call to notifier

Line 6061: INTO l_notification_date from dual;

6057: ELSIF UPPER(delRecTab(i).NOTIFY_ESCALATION_UOM) = 'WK' THEN
6058: l_notification_date :=trunc(delRecTab(i).actual_due_date)+7*delRecTab(i).NOTIFY_ESCALATION_VALUE;
6059: ELSIF UPPER(delRecTab(i).NOTIFY_ESCALATION_UOM) = 'MTH' THEN
6060: select add_months(delRecTab(i).actual_due_date,delRecTab(i).NOTIFY_ESCALATION_VALUE)
6061: INTO l_notification_date from dual;
6062: END IF;
6063:
6064: IF trunc(l_notification_date) = trunc(sysdate) OR
6065: trunc(l_notification_date) < trunc(sysdate) THEN -- call to notifier

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

10439: delIdTab.extend;
10440: delIdTab(j).orig_del_id := delRecTab(i).deliverable_id;
10441: delNewTab(j) := delRecTab(i);
10442: select okc_deliverable_id_s.nextval
10443: INTO delNewTab(j).deliverable_id from dual;
10444: delIdTab(j).del_id := delNewTab(j).deliverable_id;
10445: -- store current_del_parent_id in local variable
10446: --to assign it to the instances
10447: l_recur_del_parent_id := delNewTab(j).deliverable_id;

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

10567: delIdTab(j).orig_del_id := delInsTab(n).deliverable_id;
10568: -- build new version deliverables table
10569: delNewTab(j):= delInsTab(n);
10570: select okc_deliverable_id_s.nextval
10571: INTO delNewTab(j).deliverable_id from dual;
10572: delIdTab(j).del_id := delNewTab(j).deliverable_id;
10573: delNewTab(j).recurring_del_parent_id := l_recur_del_parent_id;
10574: -- assign common attributes
10575: delNewTab(j).business_document_id := p_target_doc_id;

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

11390: -- extend table type
11391: delIdTab.extend;
11392: delIdTab(j).orig_del_id := delRecTab(i).deliverable_id;
11393: delNewTab(j) := delRecTab(i);
11394: select okc_deliverable_id_s.nextval INTO delNewTab(j).deliverable_id from dual;
11395: delIdTab(j).del_id := delNewTab(j).deliverable_id;
11396: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
11397: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'100: New Deliverable Id :'||to_char(delNewTab(j).deliverable_id));
11398: END IF;