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.

[Home] [Help]

APPS.OKC_DELIVERABLE_PROCESS_PVT dependencies on OKC_DELIVERABLE_ID_S

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 2133: select okc_deliverable_id_s.nextval INTO delNewTab(j).deliverable_id

2129: -- extend table type
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 :=

Line 2159: select okc_deliverable_id_s.nextval INTO delNewTab(j).deliverable_id

2155: -- extend table type
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 :=

Line 2250: select okc_deliverable_id_s.nextval INTO delNewTab(j).deliverable_id

2246: -- extend table type
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);

Line 2285: select okc_deliverable_id_s.nextval INTO delNewTab(j).deliverable_id

2281: -- extend table type
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 :=

Line 2362: select okc_deliverable_id_s.nextval INTO delNewTab(j).deliverable_id

2358: -- extend table type
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:

Line 2439: select okc_deliverable_id_s.nextval INTO delNewTab(j).deliverable_id

2435: -- extend table type
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:

Line 2507: select okc_deliverable_id_s.nextval INTO delNewTab(j).deliverable_id

2503: -- extend table type
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:

Line 2554: select okc_deliverable_id_s.nextval INTO delNewTab(j).deliverable_id

2550: -- extend table type
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:

Line 2630: select okc_deliverable_id_s.nextval INTO delNewTab(j).deliverable_id

2626: -- extend table type
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:

Line 2670: select okc_deliverable_id_s.nextval INTO delNewTab(j).deliverable_id

2666: -- extend table type
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:

Line 3379: select okc_deliverable_id_s.nextval

3375: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'Recur Id'||l_recur_parent_id);
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:=

Line 3598: select okc_deliverable_id_s.nextval

3594: -- build the id table to copy attachments
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

Line 4286: select okc_deliverable_id_s.nextval

4282: --if they is an amendment on the deliverable
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:

Line 10442: select okc_deliverable_id_s.nextval

10438: -- extend table type
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

Line 10570: select okc_deliverable_id_s.nextval

10566: -- build the id table to copy attachments
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

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;