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.PO_PDOI_HEADER_PROCESS_PVT dependencies on PO_SESSION_GT

Line 13: p_key IN po_session_gt.key%TYPE,

9: ---------------------- PRIVATE PROCEDURES PROTOTYPE ----------------------
10: --------------------------------------------------------------------------
11: PROCEDURE derive_rate_type_code
12: (
13: p_key IN po_session_gt.key%TYPE,
14: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
15: p_rate_type_tbl IN PO_TBL_VARCHAR30,
16: x_rate_type_code_tbl IN OUT NOCOPY PO_TBL_VARCHAR30
17: );

Line 21: p_key IN po_session_gt.key%TYPE,

17: );
18:
19: PROCEDURE derive_agent_id
20: (
21: p_key IN po_session_gt.key%TYPE,
22: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
23: p_agent_name_tbl IN PO_TBL_VARCHAR2000,
24: x_agent_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
25: );

Line 29: p_key IN po_session_gt.key%TYPE,

25: );
26:
27: PROCEDURE derive_vendor_site_id
28: (
29: p_key IN po_session_gt.key%TYPE,
30: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
31: p_vendor_id_tbl IN PO_TBL_NUMBER,
32: p_vendor_site_code_tbl IN PO_TBL_VARCHAR30,
33: x_vendor_site_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

Line 38: p_key IN po_session_gt.key%TYPE,

34: );
35:
36: PROCEDURE derive_vendor_contact_id
37: (
38: p_key IN po_session_gt.key%TYPE,
39: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
40: p_vendor_site_id_tbl IN PO_TBL_NUMBER,
41: p_vendor_contact_tbl IN PO_TBL_VARCHAR2000,
42: x_vendor_contact_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

Line 47: p_key IN po_session_gt.key%TYPE,

43: );
44:
45: PROCEDURE derive_from_header_id
46: (
47: p_key IN po_session_gt.key%TYPE,
48: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
49: p_from_rfq_num_tbl IN PO_TBL_VARCHAR30,
50: x_from_header_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
51: );

Line 55: p_key IN po_session_gt.key%TYPE,

51: );
52:
53: PROCEDURE derive_style_id
54: (
55: p_key IN po_session_gt.key%TYPE,
56: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
57: p_style_display_name_tbl IN PO_TBL_VARCHAR2000,
58: x_style_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
59: );

Line 63: p_key IN po_session_gt.key%TYPE,

59: );
60:
61: PROCEDURE default_info_from_vendor
62: (
63: p_key IN po_session_gt.key%TYPE,
64: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
65: p_vendor_id_tbl IN PO_TBL_NUMBER,
66: x_invoice_currency_code_tbl OUT NOCOPY PO_TBL_VARCHAR30,
67: x_terms_id_tbl OUT NOCOPY PO_TBL_NUMBER

Line 72: p_key IN po_session_gt.key%TYPE,

68: );
69:
70: PROCEDURE default_info_from_vendor_site
71: (
72: p_key IN po_session_gt.key%TYPE,
73: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
74: p_vendor_id_tbl IN PO_TBL_NUMBER,
75: x_vendor_site_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,
76: x_fob_tbl OUT NOCOPY PO_TBL_VARCHAR30,

Line 89: p_key IN po_session_gt.key%TYPE,

85: );
86:
87: PROCEDURE default_vendor_contact
88: (
89: p_key IN po_session_gt.key%TYPE,
90: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
91: p_vendor_site_id_tbl IN PO_TBL_NUMBER,
92: x_vendor_contact_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
93: );

Line 109: p_key IN po_session_gt.key%TYPE,

105:
106: --PDOI CLM Integration Starts
107: PROCEDURE default_clm_standard_format
108: (
109: p_key IN po_session_gt.key%TYPE,
110: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
111: p_style_id_tbl IN PO_TBL_NUMBER,
112: p_clm_award_type IN PO_TBL_VARCHAR30,
113: x_clm_standard_form_tbl IN OUT NOCOPY PO_TBL_VARCHAR2000,

Line 119: p_key IN po_session_gt.key%TYPE,

115: );
116:
117: PROCEDURE derive_clm_award_type
118: (
119: p_key IN po_session_gt.key%TYPE,
120: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
121: p_clm_award_type_disp_tbl IN PO_TBL_VARCHAR240,
122: x_clm_award_type_tbl IN OUT NOCOPY PO_TBL_VARCHAR30
123: );

Line 127: p_key IN po_session_gt.key%TYPE,

123: );
124:
125: PROCEDURE derive_clm_award_admin
126: (
127: p_key IN po_session_gt.key%TYPE,
128: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
129: p_clm_award_admin_disp_tbl IN PO_TBL_VARCHAR240,
130: x_clm_award_administrator_tbl IN OUT NOCOPY PO_TBL_VARCHAR2000
131: );

Line 135: p_key IN po_session_gt.key%TYPE,

131: );
132:
133: PROCEDURE derive_clm_contract_officer
134: (
135: p_key IN po_session_gt.key%TYPE,
136: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
137: p_clm_contract_oficer_disp_tbl IN PO_TBL_VARCHAR240,
138: x_clm_contract_officer_tbl IN OUT NOCOPY PO_TBL_NUMBER
139: );

Line 143: p_key IN po_session_gt.key%TYPE,

139: );
140:
141: PROCEDURE derive_vendor_site_id_from_idv
142: (
143: p_key IN po_session_gt.key%TYPE,
144: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
145: p_clm_source_document_id_tbl IN PO_TBL_NUMBER,
146: p_doc_type_tbl IN PO_TBL_VARCHAR30,
147: x_vendor_site_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

Line 824: l_key po_session_gt.key%TYPE;

820: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
821: d_position NUMBER;
822:
823: -- key used when operating on temp table
824: l_key po_session_gt.key%TYPE;
825:
826: -- table used to save the index of the each row
827: l_index_tbl DBMS_SQL.NUMBER_TABLE;
828:

Line 1440: l_key po_session_gt.key%TYPE;

1436: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
1437: d_position NUMBER;
1438:
1439: -- key used when operating on temp table
1440: l_key po_session_gt.key%TYPE;
1441:
1442: -- table used to save the index of the each row
1443: l_index_tbl DBMS_SQL.NUMBER_TABLE;
1444:

Line 2213: p_key IN po_session_gt.key%TYPE,

2209: --End of Comments
2210: ------------------------------------------------------------------------
2211: PROCEDURE derive_location_id
2212: (
2213: p_key IN po_session_gt.key%TYPE,
2214: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2215: p_location_type IN VARCHAR2,
2216: p_location_tbl IN PO_TBL_VARCHAR100,
2217: x_location_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

Line 2238: INSERT INTO po_session_gt(key, num1, num2)

2234: END IF;
2235:
2236: IF (p_location_type = 'SHIP_TO') THEN
2237: FORALL i IN 1..p_index_tbl.COUNT
2238: INSERT INTO po_session_gt(key, num1, num2)
2239: SELECT p_key,
2240: p_index_tbl(i),
2241: location_id
2242: FROM po_locations_val_v

Line 2249: INSERT INTO po_session_gt(key, num1, num2)

2245: AND location_code = p_location_tbl(i)
2246: AND nvl(ship_to_site_flag, 'N') = 'Y';
2247: ELSE -- p_location_type = 'BILL_TO'
2248: FORALL i IN 1..p_index_tbl.COUNT
2249: INSERT INTO po_session_gt(key, num1, num2)
2250: SELECT p_key,
2251: p_index_tbl(i),
2252: location_id
2253: FROM po_locations_val_v

Line 2262: DELETE FROM po_session_gt

2258: END IF;
2259:
2260: d_position := 10;
2261:
2262: DELETE FROM po_session_gt
2263: WHERE key = p_key
2264: RETURNING num1, num2 BULK COLLECT INTO l_index_tbl, l_result_tbl;
2265:
2266: d_position := 20;

Line 2320: p_key IN po_session_gt.key%TYPE,

2316: --End of Comments
2317: ------------------------------------------------------------------------
2318: PROCEDURE derive_terms_id
2319: (
2320: p_key IN po_session_gt.key%TYPE,
2321: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2322: p_payment_terms_tbl IN PO_TBL_VARCHAR100,
2323: x_terms_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
2324: ) IS

Line 2342: INSERT INTO po_session_gt(key, num1, num2)

2338: PO_LOG.proc_begin(d_module, 'terms ids', x_terms_id_tbl);
2339: END IF;
2340:
2341: FORALL i IN 1..p_index_tbl.COUNT
2342: INSERT INTO po_session_gt(key, num1, num2)
2343: SELECT p_key,
2344: p_index_tbl(i),
2345: term_id
2346: FROM ap_terms

Line 2356: DELETE FROM po_session_gt

2352: AND TRUNC(nvl(end_date_active, sysdate));
2353:
2354: d_position := 10;
2355:
2356: DELETE FROM po_session_gt
2357: WHERE key = p_key
2358: RETURNING num1, num2 BULK COLLECT INTO l_index_tbl, l_result_tbl;
2359:
2360: d_position := 20;

Line 2417: p_key IN po_session_gt.key%TYPE,

2413: --End of Comments
2414: ------------------------------------------------------------------------
2415: PROCEDURE derive_vendor_id
2416: (
2417: p_key IN po_session_gt.key%TYPE,
2418: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2419: p_vendor_name_tbl IN PO_TBL_VARCHAR2000,
2420: p_vendor_num_tbl IN PO_TBL_VARCHAR30,
2421: x_vendor_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

Line 2444: INSERT INTO po_session_gt(key, num1, num2)

2440: PO_LOG.proc_begin(d_module, 'vendor ids', x_vendor_id_tbl);
2441: END IF;
2442:
2443: FORALL i IN 1..p_index_tbl.COUNT
2444: INSERT INTO po_session_gt(key, num1, num2)
2445: SELECT p_key,
2446: p_index_tbl(i),
2447: vendor_id
2448: FROM po_vendors

Line 2456: DELETE FROM po_session_gt

2452: segment1 = p_vendor_num_tbl(i));
2453:
2454: d_position := 10;
2455:
2456: DELETE FROM po_session_gt
2457: WHERE key = p_key
2458: RETURNING num1, num2 BULK COLLECT INTO l_index_tbl, l_result_tbl;
2459:
2460: d_position := 20;

Line 2529: p_key IN po_session_gt.key%TYPE,

2525: --End of Comments
2526: ------------------------------------------------------------------------
2527: PROCEDURE derive_rate_type_code
2528: (
2529: p_key IN po_session_gt.key%TYPE,
2530: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2531: p_rate_type_tbl IN PO_TBL_VARCHAR30,
2532: x_rate_type_code_tbl IN OUT NOCOPY PO_TBL_VARCHAR30
2533: ) IS

Line 2551: INSERT INTO po_session_gt(key, num1, char1)

2547: PO_LOG.proc_begin(d_module, 'rate type code', x_rate_type_code_tbl);
2548: END IF;
2549:
2550: FORALL i IN 1..p_index_tbl.COUNT
2551: INSERT INTO po_session_gt(key, num1, char1)
2552: SELECT p_key,
2553: p_index_tbl(i),
2554: conversion_type
2555: FROM gl_daily_conversion_types

Line 2562: DELETE FROM po_session_gt

2558: AND user_conversion_type = p_rate_type_tbl(i);
2559:
2560: d_position := 10;
2561:
2562: DELETE FROM po_session_gt
2563: WHERE key = p_key
2564: RETURNING num1, char1 BULK COLLECT INTO l_index_tbl, l_result_tbl;
2565:
2566: d_position := 20;

Line 2620: p_key IN po_session_gt.key%TYPE,

2616: --End of Comments
2617: ------------------------------------------------------------------------
2618: PROCEDURE derive_agent_id
2619: (
2620: p_key IN po_session_gt.key%TYPE,
2621: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2622: p_agent_name_tbl IN PO_TBL_VARCHAR2000,
2623: x_agent_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
2624: ) IS

Line 2642: INSERT INTO po_session_gt(key, num1, num2)

2638: PO_LOG.proc_begin(d_module, 'agent id', x_agent_id_tbl);
2639: END IF;
2640:
2641: FORALL i IN 1..p_index_tbl.COUNT
2642: INSERT INTO po_session_gt(key, num1, num2)
2643: SELECT p_key,
2644: p_index_tbl(i),
2645: employee_id
2646: FROM po_buyers_val_v

Line 2653: DELETE FROM po_session_gt

2649: AND full_name = p_agent_name_tbl(i);
2650:
2651: d_position := 10;
2652:
2653: DELETE FROM po_session_gt
2654: WHERE key = p_key
2655: RETURNING num1, num2 BULK COLLECT INTO l_index_tbl, l_result_tbl;
2656:
2657: d_position := 20;

Line 2713: p_key IN po_session_gt.key%TYPE,

2709: --End of Comments
2710: ------------------------------------------------------------------------
2711: PROCEDURE derive_vendor_site_id
2712: (
2713: p_key IN po_session_gt.key%TYPE,
2714: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2715: p_vendor_id_tbl IN PO_TBL_NUMBER,
2716: p_vendor_site_code_tbl IN PO_TBL_VARCHAR30,
2717: x_vendor_site_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

Line 2737: INSERT INTO po_session_gt(key, num1, num2)

2733: PO_LOG.proc_begin(d_module, 'site id', x_vendor_site_id_tbl);
2734: END IF;
2735:
2736: FORALL i IN 1..p_index_tbl.COUNT
2737: INSERT INTO po_session_gt(key, num1, num2)
2738: SELECT p_key,
2739: p_index_tbl(i),
2740: vendor_site_id
2741: FROM po_supplier_sites_val_v

Line 2750: DELETE FROM po_session_gt

2746: AND vendor_site_code = p_vendor_site_code_tbl(i);
2747:
2748: d_position := 10;
2749:
2750: DELETE FROM po_session_gt
2751: WHERE key = p_key
2752: RETURNING num1, num2 BULK COLLECT INTO l_index_tbl, l_result_tbl;
2753:
2754: d_position := 20;

Line 2811: p_key IN po_session_gt.key%TYPE,

2807: --End of Comments
2808: ------------------------------------------------------------------------
2809: PROCEDURE derive_vendor_contact_id
2810: (
2811: p_key IN po_session_gt.key%TYPE,
2812: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2813: p_vendor_site_id_tbl IN PO_TBL_NUMBER,
2814: p_vendor_contact_tbl IN PO_TBL_VARCHAR2000,
2815: x_vendor_contact_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

Line 2835: INSERT INTO po_session_gt(key, num1, num2)

2831: PO_LOG.proc_begin(d_module, 'contact id', x_vendor_contact_id_tbl);
2832: END IF;
2833:
2834: FORALL i IN 1..p_index_tbl.COUNT
2835: INSERT INTO po_session_gt(key, num1, num2)
2836: SELECT p_key,
2837: p_index_tbl(i),
2838: vendor_contact_id
2839: FROM po_vendor_contacts

Line 2848: DELETE FROM po_session_gt

2844: AND vendor_site_id = p_vendor_site_id_tbl(i);
2845:
2846: d_position := 10;
2847:
2848: DELETE FROM po_session_gt
2849: WHERE key = p_key
2850: RETURNING num1, num2 BULK COLLECT INTO l_index_tbl, l_result_tbl;
2851:
2852: d_position := 20;

Line 2910: p_key IN po_session_gt.key%TYPE,

2906: --End of Comments
2907: ------------------------------------------------------------------------
2908: PROCEDURE derive_style_id
2909: (
2910: p_key IN po_session_gt.key%TYPE,
2911: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2912: p_style_display_name_tbl IN PO_TBL_VARCHAR2000,
2913: x_style_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
2914: ) IS

Line 2932: INSERT INTO po_session_gt(key, num1, num2)

2928: PO_LOG.proc_begin(d_module, 'p_style_display_name_tbl', p_style_display_name_tbl);
2929: END IF;
2930:
2931: FORALL i IN 1..p_index_tbl.COUNT
2932: INSERT INTO po_session_gt(key, num1, num2)
2933: SELECT p_key,
2934: p_index_tbl(i),
2935: style_id
2936: FROM po_doc_style_lines_tl pds

Line 2943: DELETE FROM po_session_gt

2939: pds.LANGUAGE = USERENV('LANG');
2940:
2941: d_position := 10;
2942:
2943: DELETE FROM po_session_gt
2944: WHERE key = p_key
2945: RETURNING num1, num2 BULK COLLECT INTO l_index_tbl, l_result_tbl;
2946:
2947: d_position := 20;

Line 3002: p_key IN po_session_gt.key%TYPE,

2998: --End of Comments
2999: ------------------------------------------------------------------------
3000: PROCEDURE derive_from_header_id
3001: (
3002: p_key IN po_session_gt.key%TYPE,
3003: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
3004: p_from_rfq_num_tbl IN PO_TBL_VARCHAR30,
3005: x_from_header_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
3006: ) IS

Line 3024: INSERT INTO po_session_gt(key, num1, num2)

3020: PO_LOG.proc_begin(d_module, 'from header id', x_from_header_id_tbl);
3021: END IF;
3022:
3023: FORALL i IN 1..p_index_tbl.COUNT
3024: INSERT INTO po_session_gt(key, num1, num2)
3025: SELECT p_key,
3026: p_index_tbl(i),
3027: po_header_id
3028: FROM po_headers

Line 3036: DELETE FROM po_session_gt

3032: AND type_lookup_code = 'RFQ'; -- PO_PDOI_CONSTANTS.g_DOC_TYPE_RFQ;
3033:
3034: d_position := 10;
3035:
3036: DELETE FROM po_session_gt
3037: WHERE key = p_key
3038: RETURNING num1, num2 BULK COLLECT INTO l_index_tbl, l_result_tbl;
3039:
3040: d_position := 20;

Line 3097: p_key IN po_session_gt.key%TYPE,

3093: --End of Comments
3094: ------------------------------------------------------------------------
3095: PROCEDURE default_info_from_vendor
3096: (
3097: p_key IN po_session_gt.key%TYPE,
3098: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
3099: p_vendor_id_tbl IN PO_TBL_NUMBER,
3100: x_invoice_currency_code_tbl OUT NOCOPY PO_TBL_VARCHAR30,
3101: x_terms_id_tbl OUT NOCOPY PO_TBL_NUMBER

Line 3140: INSERT INTO po_session_gt(

3136: x_invoice_currency_code_tbl.EXTEND(p_index_tbl.COUNT);
3137: x_terms_id_tbl.EXTEND(p_index_tbl.COUNT);
3138:
3139: FORALL i IN 1..p_index_tbl.COUNT
3140: INSERT INTO po_session_gt(
3141: key, num1, char1, num2)
3142: SELECT p_key,
3143: p_index_tbl(i),
3144: invoice_currency_code,

Line 3151: DELETE FROM po_session_gt

3147: WHERE vendor_id = p_vendor_id_tbl(i);
3148:
3149: d_position := 10;
3150:
3151: DELETE FROM po_session_gt
3152: WHERE key = p_key
3153: RETURNING num1, char1, num2
3154: BULK COLLECT INTO
3155: l_index_tbl,

Line 3244: p_key IN po_session_gt.key%TYPE,

3240: --End of Comments
3241: ------------------------------------------------------------------------
3242: PROCEDURE default_info_from_vendor_site
3243: (
3244: p_key IN po_session_gt.key%TYPE,
3245: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
3246: p_vendor_id_tbl IN PO_TBL_NUMBER,
3247: x_vendor_site_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,
3248: x_fob_tbl OUT NOCOPY PO_TBL_VARCHAR30,

Line 3311: INSERT INTO po_session_gt(key, num1, num2, num3)

3307: d_position := 10;
3308:
3309: -- default vendor_site_id if it is empty
3310: FORALL i IN 1..p_index_tbl.COUNT
3311: INSERT INTO po_session_gt(key, num1, num2, num3)
3312: SELECT p_key,
3313: p_index_tbl(i),
3314: min(vendor_site_id),
3315: vendor_id

Line 3330: DELETE FROM po_session_gt

3326: HAVING count(vendor_site_id) = 1;
3327:
3328: d_position := 20;
3329:
3330: DELETE FROM po_session_gt
3331: WHERE key = p_key
3332: RETURNING num1, num2 BULK COLLECT INTO l_index_tbl, l_vendor_site_id_tbl;
3333:
3334: FOR i IN 1..l_index_tbl.COUNT

Line 3349: INSERT INTO po_session_gt(

3345:
3346: -- default other attributes from site definition
3347: -- to do (add char6 to gt table?)
3348: FORALL i IN 1..p_index_tbl.COUNT
3349: INSERT INTO po_session_gt(
3350: key, num1, char1, char2, char3, num2, num3, char4, num4, char5, char6)
3351: SELECT p_key,
3352: p_index_tbl(i),
3353: fob_lookup_code,

Line 3370: DELETE FROM po_session_gt

3366: WHERE vendor_site_id = x_vendor_site_id_tbl(i);
3367:
3368: d_position := 40;
3369:
3370: DELETE FROM po_session_gt
3371: WHERE key = p_key
3372: RETURNING num1, char1, char2, char3, num2, num3, char4, num4, char5, char6
3373: BULK COLLECT INTO
3374: l_index_tbl,

Line 3460: p_key IN po_session_gt.key%TYPE,

3456: --End of Comments
3457: ------------------------------------------------------------------------
3458: PROCEDURE default_vendor_contact
3459: (
3460: p_key IN po_session_gt.key%TYPE,
3461: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
3462: p_vendor_site_id_tbl IN PO_TBL_NUMBER,
3463: x_vendor_contact_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
3464: ) IS

Line 3485: INSERT INTO po_session_gt(key, num1, num2, num3)

3481:
3482: -- select contact id from vendor_site table if there is only
3483: -- one contact defined on that site
3484: FORALL i IN 1..p_index_tbl.COUNT
3485: INSERT INTO po_session_gt(key, num1, num2, num3)
3486: SELECT p_key,
3487: p_index_tbl(i),
3488: max(vendor_contact_id),
3489: vendor_site_id

Line 3500: DELETE FROM po_session_gt

3496: HAVING count(vendor_contact_id) = 1;
3497:
3498: d_position := 10;
3499:
3500: DELETE FROM po_session_gt
3501: WHERE key = p_key
3502: RETURNING num1, num2 BULK COLLECT INTO l_index_tbl, l_result_tbl;
3503:
3504: d_position := 20;

Line 3731: p_key IN po_session_gt.key%TYPE,

3727:
3728: --PDOI CLM Integration Starts
3729: PROCEDURE default_clm_standard_format
3730: (
3731: p_key IN po_session_gt.key%TYPE,
3732: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
3733: p_style_id_tbl IN PO_TBL_NUMBER,
3734: p_clm_award_type IN PO_TBL_VARCHAR30,
3735: x_clm_standard_form_tbl IN OUT NOCOPY PO_TBL_VARCHAR2000,

Line 3758: INSERT INTO po_session_gt(key, num1, char1, char2, char3, num2)

3754: PO_LOG.proc_begin(d_module, 'clm_document_format_tbl', x_clm_document_format_tbl);
3755: END IF;
3756:
3757: FORALL i IN 1..p_index_tbl.COUNT
3758: INSERT INTO po_session_gt(key, num1, char1, char2, char3, num2)
3759: SELECT p_key,
3760: p_index_tbl(i),
3761: x_clm_standard_form_tbl(i),
3762: x_clm_document_format_tbl(i),

Line 3771: UPDATE po_session_gt

3767: AND nvl(clm_flag, 'N') ='Y';
3768:
3769: --Try to deafult both standard_from & document_format if there exists an entry of default type
3770: FORALL i IN 1..p_index_tbl.COUNT
3771: UPDATE po_session_gt
3772: SET char1 = ( SELECT standard_form
3773: FROM PO_PRINT_FORM_FORMATS
3774: WHERE document_type = decode(PO_PDOI_PARAMS.g_request.document_type, PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD,
3775: decode(char3,

Line 3805: UPDATE po_session_gt

3801:
3802:
3803: --Try to default only the document_format from standard_form
3804: FORALL i IN 1..p_index_tbl.COUNT
3805: UPDATE po_session_gt
3806: SET char2 = ( SELECT document_format
3807: FROM PO_PRINT_FORM_FORMATS
3808: WHERE document_type = decode(PO_PDOI_PARAMS.g_request.document_type, PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD,
3809: decode(char3,

Line 3838: DELETE FROM po_session_gt

3834:
3835:
3836: d_position := 10;
3837:
3838: DELETE FROM po_session_gt
3839: WHERE key = p_key
3840: RETURNING num1, char1, char2 BULK COLLECT INTO l_index_tbl, l_standard_form_tbl, l_document_format_tbl ;
3841:
3842: d_position := 20;

Line 3875: p_key IN po_session_gt.key%TYPE,

3871:
3872:
3873: PROCEDURE derive_clm_award_type
3874: (
3875: p_key IN po_session_gt.key%TYPE,
3876: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
3877: p_clm_award_type_disp_tbl IN PO_TBL_VARCHAR240,
3878: x_clm_award_type_tbl IN OUT NOCOPY PO_TBL_VARCHAR30
3879: ) IS

Line 3897: INSERT INTO po_session_gt(key, num1, char1)

3893: --PO_LOG.proc_begin(d_module, 'p_clm_award_type_disp_tbl', p_clm_award_type_disp_tbl);
3894: END IF;
3895:
3896: FORALL i IN 1..p_index_tbl.COUNT
3897: INSERT INTO po_session_gt(key, num1, char1)
3898: SELECT p_key,
3899: p_index_tbl(i),
3900: lookup_code
3901: FROM PO_LOOKUP_CODES

Line 3910: DELETE FROM po_session_gt

3906: AND displayed_field = p_clm_award_type_disp_tbl(i);
3907:
3908: d_position := 10;
3909:
3910: DELETE FROM po_session_gt
3911: WHERE key = p_key
3912: RETURNING num1, char1 BULK COLLECT INTO l_index_tbl, l_result_tbl;
3913:
3914: d_position := 20;

Line 3946: p_key IN po_session_gt.key%TYPE,

3942:
3943:
3944: PROCEDURE derive_clm_award_admin
3945: (
3946: p_key IN po_session_gt.key%TYPE,
3947: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
3948: p_clm_award_admin_disp_tbl IN PO_TBL_VARCHAR240,
3949: x_clm_award_administrator_tbl IN OUT NOCOPY PO_TBL_VARCHAR2000
3950: ) IS

Line 3968: INSERT INTO po_session_gt(key, num1, char1)

3964: --PO_LOG.proc_begin(d_module, 'p_clm_award_type_disp_tbl', p_clm_award_type_disp_tbl);
3965: END IF;
3966:
3967: FORALL i IN 1..p_index_tbl.COUNT
3968: INSERT INTO po_session_gt(key, num1, char1)
3969: SELECT p_key,
3970: p_index_tbl(i),
3971: To_Char(employee_id)
3972: FROM PO_BUYERS_VAL_V

Line 3980: DELETE FROM po_session_gt

3976: AND full_name = p_clm_award_admin_disp_tbl(i);
3977:
3978: d_position := 10;
3979:
3980: DELETE FROM po_session_gt
3981: WHERE key = p_key
3982: RETURNING num1, char1 BULK COLLECT INTO l_index_tbl, l_result_tbl;
3983:
3984: d_position := 20;

Line 4015: p_key IN po_session_gt.key%TYPE,

4011:
4012:
4013: PROCEDURE derive_clm_contract_officer
4014: (
4015: p_key IN po_session_gt.key%TYPE,
4016: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
4017: p_clm_contract_oficer_disp_tbl IN PO_TBL_VARCHAR240,
4018: x_clm_contract_officer_tbl IN OUT NOCOPY PO_TBL_NUMBER
4019: ) IS

Line 4037: INSERT INTO po_session_gt(key, num1, num2)

4033: --PO_LOG.proc_begin(d_module, 'p_clm_award_type_disp_tbl', p_clm_award_type_disp_tbl);
4034: END IF;
4035:
4036: FORALL i IN 1..p_index_tbl.COUNT
4037: INSERT INTO po_session_gt(key, num1, num2)
4038: SELECT p_key,
4039: p_index_tbl(i),
4040: employee_id
4041: FROM PO_BUYERS_VAL_V

Line 4050: DELETE FROM po_session_gt

4046: AND Nvl(contract_officer,'N') = 'Y';
4047:
4048: d_position := 10;
4049:
4050: DELETE FROM po_session_gt
4051: WHERE key = p_key
4052: RETURNING num1, num2 BULK COLLECT INTO l_index_tbl, l_result_tbl;
4053:
4054: d_position := 20;

Line 4085: p_key IN po_session_gt.key%TYPE,

4081:
4082:
4083: PROCEDURE derive_clm_source_document_id
4084: (
4085: p_key IN po_session_gt.key%TYPE,
4086: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
4087: p_clm_source_document_disp_tbl IN PO_TBL_VARCHAR240,
4088: x_clm_source_document_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
4089: ) IS

Line 4107: INSERT INTO po_session_gt(key, num1, num2)

4103: --PO_LOG.proc_begin(d_module, 'p_clm_award_type_disp_tbl', p_clm_award_type_disp_tbl);
4104: END IF;
4105:
4106: FORALL i IN 1..p_index_tbl.COUNT
4107: INSERT INTO po_session_gt(key, num1, num2)
4108: SELECT p_key,
4109: p_index_tbl(i),
4110: po_header_id
4111: FROM po_headers_all

Line 4118: DELETE FROM po_session_gt

4114: AND clm_document_number = p_clm_source_document_disp_tbl(i);
4115:
4116: d_position := 10;
4117:
4118: DELETE FROM po_session_gt
4119: WHERE key = p_key
4120: RETURNING num1, num2 BULK COLLECT INTO l_index_tbl, l_result_tbl;
4121:
4122: d_position := 20;

Line 4152: p_key IN po_session_gt.key%TYPE,

4148:
4149:
4150: PROCEDURE derive_vendor_id_from_idv
4151: (
4152: p_key IN po_session_gt.key%TYPE,
4153: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
4154: p_clm_source_document_id_tbl IN PO_TBL_NUMBER,
4155: p_doc_type_tbl IN PO_TBL_VARCHAR30,
4156: x_vendor_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

Line 4175: INSERT INTO po_session_gt(key, num1, num2)

4171: PO_LOG.proc_begin(d_module, 'vendor_id_tbl', x_vendor_id_tbl);
4172: END IF;
4173:
4174: FORALL i IN 1..p_index_tbl.Count
4175: INSERT INTO po_session_gt(key, num1, num2)
4176: SELECT p_key,
4177: p_index_tbl(i),
4178: vendor_id
4179: FROM po_headers_all

Line 4187: DELETE FROM po_session_gt

4183: AND p_doc_type_tbl(i) = PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD;
4184:
4185: d_position := 10;
4186:
4187: DELETE FROM po_session_gt
4188: WHERE key = p_key
4189: RETURNING num1, num2 BULK COLLECT INTO l_index_tbl, l_result_tbl;
4190:
4191: d_position := 20;

Line 4220: p_key IN po_session_gt.key%TYPE,

4216:
4217:
4218: PROCEDURE derive_vendor_site_id_from_idv
4219: (
4220: p_key IN po_session_gt.key%TYPE,
4221: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
4222: p_clm_source_document_id_tbl IN PO_TBL_NUMBER,
4223: p_doc_type_tbl IN PO_TBL_VARCHAR30,
4224: x_vendor_site_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

Line 4243: INSERT INTO po_session_gt(key, num1, num2)

4239: --PO_LOG.proc_begin(d_module, 'p_clm_award_type_disp_tbl', p_clm_award_type_disp_tbl);
4240: END IF;
4241:
4242: FORALL i IN 1..p_index_tbl.Count
4243: INSERT INTO po_session_gt(key, num1, num2)
4244: SELECT p_key,
4245: p_index_tbl(i),
4246: vendor_site_id
4247: FROM po_headers_all

Line 4255: DELETE FROM po_session_gt

4251: AND p_doc_type_tbl(i) = PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD;
4252:
4253: d_position := 10;
4254:
4255: DELETE FROM po_session_gt
4256: WHERE key = p_key
4257: RETURNING num1, num2 BULK COLLECT INTO l_index_tbl, l_result_tbl;
4258:
4259: d_position := 20;