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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 3578: select okc_deliverable_id_s.nextval

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

Line 3811: select okc_deliverable_id_s.nextval

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

Line 4545: select okc_deliverable_id_s.nextval

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

Line 11414: select okc_deliverable_id_s.nextval

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

Line 11556: select okc_deliverable_id_s.nextval

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

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 ;