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_DIST_PROCESS_PVT dependencies on PO_SESSION_GT

Line 16: p_key IN po_session_gt.key%TYPE,

12: ---------------------- PRIVATE PROCEDURES PROTOTYPE ----------------------
13: --------------------------------------------------------------------------
14: PROCEDURE derive_ship_to_ou_id
15: (
16: p_key IN po_session_gt.key%TYPE,
17: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
18: p_ship_to_org_id_tbl IN PO_TBL_NUMBER,
19: x_ship_to_ou_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
20: );

Line 24: p_key IN po_session_gt.key%TYPE,

20: );
21:
22: PROCEDURE derive_deliver_to_loc_id
23: (
24: p_key IN po_session_gt.key%TYPE,
25: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
26: p_deliver_to_loc_tbl IN PO_TBL_VARCHAR100,
27: x_deliver_to_loc_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
28: );

Line 32: p_key IN po_session_gt.key%TYPE,

28: );
29:
30: PROCEDURE derive_deliver_to_person_id
31: (
32: p_key IN po_session_gt.key%TYPE,
33: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
34: p_person_name_tbl IN PO_TBL_VARCHAR2000,
35: x_person_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
36: );

Line 40: p_key IN po_session_gt.key%TYPE,

36: );
37:
38: PROCEDURE derive_dest_type_code
39: (
40: p_key IN po_session_gt.key%TYPE,
41: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
42: p_dest_type_tbl IN PO_TBL_VARCHAR30,
43: x_dest_type_code_tbl IN OUT NOCOPY PO_TBL_VARCHAR30
44: );

Line 48: p_key IN po_session_gt.key%TYPE,

44: );
45:
46: PROCEDURE derive_dest_org_id
47: (
48: p_key IN po_session_gt.key%TYPE,
49: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
50: p_dest_org_tbl IN PO_TBL_VARCHAR100,
51: p_ship_to_org_id_tbl IN PO_TBL_NUMBER,
52: x_dest_org_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

Line 57: p_key IN po_session_gt.key%TYPE,

53: );
54:
55: PROCEDURE derive_wip_entity_id
56: (
57: p_key IN po_session_gt.key%TYPE,
58: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
59: p_wip_entity_tbl IN PO_TBL_VARCHAR2000,
60: p_dest_org_id_tbl IN PO_TBL_NUMBER,
61: p_dest_type_code_tbl IN PO_TBL_VARCHAR30,

Line 67: p_key IN po_session_gt.key%TYPE,

63: );
64:
65: PROCEDURE derive_wip_line_id
66: (
67: p_key IN po_session_gt.key%TYPE,
68: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
69: p_wip_line_code_tbl IN PO_TBL_VARCHAR30,
70: p_dest_org_id_tbl IN PO_TBL_NUMBER,
71: p_dest_type_code_tbl IN PO_TBL_VARCHAR30,

Line 77: p_key IN po_session_gt.key%TYPE,

73: );
74:
75: PROCEDURE derive_ship_to_ou_coa_id
76: (
77: p_key IN po_session_gt.key%TYPE,
78: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
79: p_dest_org_id_tbl IN PO_TBL_NUMBER,
80: p_txn_flow_header_id_tbl IN PO_TBL_NUMBER,
81: p_dest_charge_account_id_tbl IN PO_TBL_NUMBER,

Line 87: p_key IN po_session_gt.key%TYPE,

83: );
84:
85: PROCEDURE derive_bom_resource_id
86: (
87: p_key IN po_session_gt.key%TYPE,
88: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
89: p_bom_resource_code_tbl IN PO_TBL_VARCHAR30,
90: p_dest_org_id_tbl IN PO_TBL_NUMBER,
91: x_bom_resource_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

Line 102: p_key IN po_session_gt.key%TYPE,

98: );
99:
100: PROCEDURE derive_project_info
101: (
102: p_key IN po_session_gt.key%TYPE,
103: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
104: p_derive_row_tbl IN DBMS_SQL.NUMBER_TABLE,
105: x_dists IN OUT NOCOPY PO_PDOI_TYPES.distributions_rec_type
106: );

Line 110: p_key IN po_session_gt.key%TYPE,

106: );
107:
108: PROCEDURE derive_project_id
109: (
110: p_key IN po_session_gt.key%TYPE,
111: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
112: p_project_tbl IN PO_TBL_VARCHAR30,
113: p_dest_type_code_tbl IN PO_TBL_VARCHAR30,
114: p_ship_to_org_id_tbl IN PO_TBL_NUMBER,

Line 122: p_key IN po_session_gt.key%TYPE,

118: );
119:
120: PROCEDURE derive_task_id
121: (
122: p_key IN po_session_gt.key%TYPE,
123: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
124: p_task_tbl IN PO_TBL_VARCHAR2000, --- Bug#16505809
125: p_dest_type_code_tbl IN PO_TBL_VARCHAR30,
126: p_project_id_tbl IN PO_TBL_NUMBER,

Line 134: p_key IN po_session_gt.key%TYPE,

130: );
131:
132: PROCEDURE derive_expenditure_type
133: (
134: p_key IN po_session_gt.key%TYPE,
135: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
136: p_expenditure_tbl IN PO_TBL_VARCHAR100,
137: p_project_id_tbl IN PO_TBL_NUMBER,
138: p_derive_row_tbl IN DBMS_SQL.NUMBER_TABLE,

Line 144: p_key IN po_session_gt.key%TYPE,

140: );
141:
142: PROCEDURE derive_expenditure_org_id
143: (
144: p_key IN po_session_gt.key%TYPE,
145: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
146: p_expenditure_org_tbl IN PO_TBL_VARCHAR100,
147: p_project_id_tbl IN PO_TBL_NUMBER,
148: p_derive_row_tbl IN DBMS_SQL.NUMBER_TABLE,

Line 161: p_key IN po_session_gt.key%TYPE,

157:
158:
159: PROCEDURE get_item_status
160: (
161: p_key IN po_session_gt.key%TYPE,
162: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
163: p_item_id_tbl IN PO_TBL_NUMBER,
164: p_ship_to_org_id_tbl IN PO_TBL_NUMBER,
165: x_item_status_tbl OUT NOCOPY PO_TBL_VARCHAR1

Line 773: l_key po_session_gt.key%TYPE;

769: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
770: d_position NUMBER;
771:
772: -- key value used to identify rows in temp table
773: l_key po_session_gt.key%TYPE;
774:
775: -- table to hold index
776: l_index_tbl DBMS_SQL.NUMBER_TABLE;
777:

Line 1542: l_key po_session_gt.key%TYPE;

1538: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
1539: d_position NUMBER;
1540:
1541: -- key value used to identify row in temp table
1542: l_key po_session_gt.key%TYPE;
1543:
1544: -- table to hold index
1545: l_index_tbl DBMS_SQL.NUMBER_TABLE;
1546:

Line 2426: p_key IN po_session_gt.key%TYPE,

2422: --End of Comments
2423: ------------------------------------------------------------------------
2424: PROCEDURE derive_ship_to_ou_id
2425: (
2426: p_key IN po_session_gt.key%TYPE,
2427: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2428: p_ship_to_org_id_tbl IN PO_TBL_NUMBER,
2429: x_ship_to_ou_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
2430: ) IS

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

2448: x_ship_to_ou_id_tbl.EXTEND(p_index_tbl.COUNT);
2449:
2450: -- query database to get derived result in batch mode
2451: FORALL i IN 1..p_index_tbl.COUNT
2452: INSERT INTO po_session_gt(key, num1, num2)
2453: SELECT p_key,
2454: p_index_tbl(i),
2455: TO_NUMBER(org_info.org_information3)
2456: FROM hr_organization_information org_info,

Line 2466: DELETE FROM po_session_gt

2462: d_position := 10;
2463:
2464: -- retrieve values from temp table and delete the records at the
2465: -- same time
2466: DELETE FROM po_session_gt
2467: WHERE key = p_key
2468: RETURNING num1, num2 BULK COLLECT INTO l_index_tbl, l_result_tbl;
2469:
2470: d_position := 20;

Line 2521: p_key IN po_session_gt.key%TYPE,

2517: --End of Comments
2518: ------------------------------------------------------------------------
2519: PROCEDURE derive_deliver_to_loc_id
2520: (
2521: p_key IN po_session_gt.key%TYPE,
2522: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2523: p_deliver_to_loc_tbl IN PO_TBL_VARCHAR100,
2524: x_deliver_to_loc_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
2525: ) IS

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

2542: END IF;
2543:
2544: -- query database to get derived result in batch mode
2545: FORALL i IN 1..p_index_tbl.COUNT
2546: INSERT INTO po_session_gt(key, num1, num2)
2547: SELECT p_key,
2548: p_index_tbl(i),
2549: location_id
2550: FROM hr_locations

Line 2559: DELETE FROM po_session_gt

2555: d_position := 10;
2556:
2557: -- retrieve values from temp table and delete the records at the
2558: -- same time
2559: DELETE FROM po_session_gt
2560: WHERE key = p_key
2561: RETURNING num1, num2 BULK COLLECT INTO l_index_tbl, l_result_tbl;
2562:
2563: d_position := 20;

Line 2614: p_key IN po_session_gt.key%TYPE,

2610: --End of Comments
2611: ------------------------------------------------------------------------
2612: PROCEDURE derive_deliver_to_person_id
2613: (
2614: p_key IN po_session_gt.key%TYPE,
2615: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2616: p_person_name_tbl IN PO_TBL_VARCHAR2000,
2617: x_person_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
2618: ) IS

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

2633: END IF;
2634:
2635: -- query database to get derived result in batch mode
2636: FORALL i IN 1..p_index_tbl.COUNT
2637: INSERT INTO po_session_gt(key, num1, num2)
2638: SELECT p_key,
2639: p_index_tbl(i),
2640: employee_id
2641: FROM hr_employees_all_v

Line 2650: DELETE FROM po_session_gt

2646: d_position := 10;
2647:
2648: -- retrieve values from temp table and delete the records at the
2649: -- same time
2650: DELETE FROM po_session_gt
2651: WHERE key = p_key
2652: RETURNING num1, num2 BULK COLLECT INTO l_index_tbl, l_result_tbl;
2653:
2654: d_position := 20;

Line 2705: p_key IN po_session_gt.key%TYPE,

2701: --End of Comments
2702: ------------------------------------------------------------------------
2703: PROCEDURE derive_dest_type_code
2704: (
2705: p_key IN po_session_gt.key%TYPE,
2706: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2707: p_dest_type_tbl IN PO_TBL_VARCHAR30,
2708: x_dest_type_code_tbl IN OUT NOCOPY PO_TBL_VARCHAR30
2709: ) IS

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

2724: END IF;
2725:
2726: -- query database to get derived result in batch mode
2727: FORALL i IN 1..p_index_tbl.COUNT
2728: INSERT INTO po_session_gt(key, num1, char1)
2729: SELECT p_key,
2730: p_index_tbl(i),
2731: lookup_code
2732: FROM po_destination_types_all_v

Line 2741: DELETE FROM po_session_gt

2737: d_position := 10;
2738:
2739: -- retrieve values from temp table and delete the records at the
2740: -- same time
2741: DELETE FROM po_session_gt
2742: WHERE key = p_key
2743: RETURNING num1, char1 BULK COLLECT INTO l_index_tbl, l_result_tbl;
2744:
2745: d_position := 20;

Line 2798: p_key IN po_session_gt.key%TYPE,

2794: --End of Comments
2795: ------------------------------------------------------------------------
2796: PROCEDURE derive_dest_org_id
2797: (
2798: p_key IN po_session_gt.key%TYPE,
2799: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2800: p_dest_org_tbl IN PO_TBL_VARCHAR100,
2801: p_ship_to_org_id_tbl IN PO_TBL_NUMBER,
2802: x_dest_org_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

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

2819: END IF;
2820:
2821: -- query database to get derived result in batch mode
2822: FORALL i IN 1..p_index_tbl.COUNT
2823: INSERT INTO po_session_gt(key, num1, num2)
2824: SELECT p_key,
2825: p_index_tbl(i),
2826: organization_id
2827: FROM org_organization_definitions

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

2835:
2836: -- set destination_organization_id as ship_to_organization
2837: -- if destination_organization is null
2838: FORALL i IN 1..p_index_tbl.COUNT
2839: INSERT INTO po_session_gt(key, num1, num2)
2840: SELECT p_key,
2841: p_index_tbl(i),
2842: p_ship_to_org_id_tbl(i)
2843: FROM dual

Line 2851: DELETE FROM po_session_gt

2847: d_position := 20;
2848:
2849: -- retrieve values from temp table and delete the records at the
2850: -- same time
2851: DELETE FROM po_session_gt
2852: WHERE key = p_key
2853: RETURNING num1, num2 BULK COLLECT INTO l_index_tbl, l_result_tbl;
2854:
2855: d_position := 30;

Line 2910: p_key IN po_session_gt.key%TYPE,

2906: --End of Comments
2907: ------------------------------------------------------------------------
2908: PROCEDURE derive_wip_entity_id
2909: (
2910: p_key IN po_session_gt.key%TYPE,
2911: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2912: p_wip_entity_tbl IN PO_TBL_VARCHAR2000,
2913: p_dest_org_id_tbl IN PO_TBL_NUMBER,
2914: p_dest_type_code_tbl IN PO_TBL_VARCHAR30,

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

2933: END IF;
2934:
2935: -- query database to get derived result in batch mode
2936: FORALL i IN 1..p_index_tbl.COUNT
2937: INSERT INTO po_session_gt(key, num1, num2)
2938: SELECT p_key,
2939: p_index_tbl(i),
2940: wip_entity_id
2941: FROM wip_entities

Line 2952: DELETE FROM po_session_gt

2948: d_position := 10;
2949:
2950: -- retrieve values from temp table and delete the records at the
2951: -- same time
2952: DELETE FROM po_session_gt
2953: WHERE key = p_key
2954: RETURNING num1, num2 BULK COLLECT INTO l_index_tbl, l_result_tbl;
2955:
2956: d_position := 20;

Line 3011: p_key IN po_session_gt.key%TYPE,

3007: --End of Comments
3008: ------------------------------------------------------------------------
3009: PROCEDURE derive_wip_line_id
3010: (
3011: p_key IN po_session_gt.key%TYPE,
3012: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
3013: p_wip_line_code_tbl IN PO_TBL_VARCHAR30,
3014: p_dest_org_id_tbl IN PO_TBL_NUMBER,
3015: p_dest_type_code_tbl IN PO_TBL_VARCHAR30,

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

3034: END IF;
3035:
3036: -- query database to get derived result in batch mode
3037: FORALL i IN 1..p_index_tbl.COUNT
3038: INSERT INTO po_session_gt(key, num1, num2)
3039: SELECT p_key,
3040: p_index_tbl(i),
3041: line_id
3042: FROM wip_lines

Line 3053: DELETE FROM po_session_gt

3049: d_position := 10;
3050:
3051: -- retrieve values from temp table and delete the records at the
3052: -- same time
3053: DELETE FROM po_session_gt
3054: WHERE key = p_key
3055: RETURNING num1, num2 BULK COLLECT INTO l_index_tbl, l_result_tbl;
3056:
3057: d_position := 20;

Line 3111: p_key IN po_session_gt.key%TYPE,

3107: --End of Comments
3108: ------------------------------------------------------------------------
3109: PROCEDURE derive_ship_to_ou_coa_id
3110: (
3111: p_key IN po_session_gt.key%TYPE,
3112: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
3113: p_dest_org_id_tbl IN PO_TBL_NUMBER,
3114: p_txn_flow_header_id_tbl IN PO_TBL_NUMBER,
3115: p_dest_charge_account_id_tbl IN PO_TBL_NUMBER,

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

3137: END IF;
3138:
3139: -- query database to get derived result in batch mode
3140: FORALL i IN 1..p_index_tbl.COUNT
3141: INSERT INTO po_session_gt(key, num1, num2)
3142: SELECT p_key,
3143: p_index_tbl(i),
3144: sob.chart_of_accounts_id
3145: FROM gl_sets_of_books sob,

Line 3159: DELETE FROM po_session_gt

3155: d_position := 10;
3156:
3157: -- retrieve values from temp table and delete the records at the
3158: -- same time
3159: DELETE FROM po_session_gt
3160: WHERE key = p_key
3161: RETURNING num1, num2 BULK COLLECT INTO l_index_tbl, l_result_tbl;
3162:
3163: d_position := 20;

Line 3216: p_key IN po_session_gt.key%TYPE,

3212: --End of Comments
3213: ------------------------------------------------------------------------
3214: PROCEDURE derive_bom_resource_id
3215: (
3216: p_key IN po_session_gt.key%TYPE,
3217: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
3218: p_bom_resource_code_tbl IN PO_TBL_VARCHAR30,
3219: p_dest_org_id_tbl IN PO_TBL_NUMBER,
3220: x_bom_resource_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

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

3239: END IF;
3240:
3241: -- query database to get derived result in batch mode
3242: FORALL i IN 1..p_index_tbl.COUNT
3243: INSERT INTO po_session_gt(key, num1, num2)
3244: SELECT p_key,
3245: p_index_tbl(i),
3246: resource_id
3247: FROM bom_resources

Line 3257: DELETE FROM po_session_gt

3253: d_position := 10;
3254:
3255: -- retrieve values from temp table and delete the records at the
3256: -- same time
3257: DELETE FROM po_session_gt
3258: WHERE key = p_key
3259: RETURNING num1, num2 BULK COLLECT INTO l_index_tbl, l_result_tbl;
3260:
3261: d_position := 20;

Line 3657: p_key IN po_session_gt.key%TYPE,

3653: --End of Comments
3654: ------------------------------------------------------------------------
3655: PROCEDURE derive_project_info
3656: (
3657: p_key IN po_session_gt.key%TYPE,
3658: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
3659: p_derive_row_tbl IN DBMS_SQL.NUMBER_TABLE,
3660: x_dists IN OUT NOCOPY PO_PDOI_TYPES.distributions_rec_type
3661: ) IS

Line 3782: p_key IN po_session_gt.key%TYPE,

3778: --End of Comments
3779: ------------------------------------------------------------------------
3780: PROCEDURE derive_project_id
3781: (
3782: p_key IN po_session_gt.key%TYPE,
3783: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
3784: p_project_tbl IN PO_TBL_VARCHAR30,
3785: p_dest_type_code_tbl IN PO_TBL_VARCHAR30,
3786: p_ship_to_org_id_tbl IN PO_TBL_NUMBER,

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

3809:
3810: -- query database to get derived result in batch mode
3811: -- query different views based on value of destination_type_code
3812: FORALL i IN INDICES OF p_derive_row_tbl
3813: INSERT INTO po_session_gt(key, num1, num2)
3814: SELECT p_key,
3815: p_index_tbl(i),
3816: project_id
3817: FROM pa_projects_expend_v

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

3822:
3823: d_position := 10;
3824:
3825: FORALL i IN INDICES OF p_derive_row_tbl
3826: INSERT INTO po_session_gt(key, num1, num2)
3827: SELECT p_key,
3828: p_index_tbl(i),
3829: project_id
3830: FROM pjm_projects_org_ou_v

Line 3842: DELETE FROM po_session_gt

3838: d_position := 20;
3839:
3840: -- retrieve values from temp table and delete the records at the
3841: -- same time
3842: DELETE FROM po_session_gt
3843: WHERE key = p_key
3844: RETURNING num1, num2 BULK COLLECT INTO l_index_tbl, l_result_tbl;
3845:
3846: d_position := 30;

Line 3905: p_key IN po_session_gt.key%TYPE,

3901: --End of Comments
3902: ------------------------------------------------------------------------
3903: PROCEDURE derive_task_id
3904: (
3905: p_key IN po_session_gt.key%TYPE,
3906: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
3907: p_task_tbl IN PO_TBL_VARCHAR2000, --- Bug#16505809
3908: p_dest_type_code_tbl IN PO_TBL_VARCHAR30,
3909: p_project_id_tbl IN PO_TBL_NUMBER,

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

3932:
3933: -- query database to get derived result in batch mode
3934: -- query different views based on value of destination_type_code
3935: FORALL i IN INDICES OF p_derive_row_tbl
3936: INSERT INTO po_session_gt(key, num1, num2)
3937: SELECT p_key,
3938: p_index_tbl(i),
3939: task_id
3940: FROM pa_tasks_expend_v

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

3946:
3947: d_position := 10;
3948:
3949: FORALL i IN INDICES OF p_derive_row_tbl
3950: INSERT INTO po_session_gt(key, num1, num2)
3951: SELECT p_key,
3952: p_index_tbl(i),
3953: task_id
3954: FROM pa_tasks_all_expend_v

Line 3966: DELETE FROM po_session_gt

3962: d_position := 20;
3963:
3964: -- retrieve values from temp table and delete the records at the
3965: -- same time
3966: DELETE FROM po_session_gt
3967: WHERE key = p_key
3968: RETURNING num1, num2 BULK COLLECT INTO l_index_tbl, l_result_tbl;
3969:
3970: d_position := 30;

Line 4025: p_key IN po_session_gt.key%TYPE,

4021: --End of Comments
4022: ------------------------------------------------------------------------
4023: PROCEDURE derive_expenditure_type
4024: (
4025: p_key IN po_session_gt.key%TYPE,
4026: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
4027: p_expenditure_tbl IN PO_TBL_VARCHAR100,
4028: p_project_id_tbl IN PO_TBL_NUMBER,
4029: p_derive_row_tbl IN DBMS_SQL.NUMBER_TABLE,

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

4047: END IF;
4048:
4049: -- query database to get derived result in batch mode
4050: FORALL i IN INDICES OF p_derive_row_tbl
4051: INSERT INTO po_session_gt(key, num1, char1)
4052: SELECT p_key,
4053: p_index_tbl(i),
4054: expenditure_type
4055: FROM pa_expenditure_types_v

Line 4065: DELETE FROM po_session_gt

4061: d_position := 10;
4062:
4063: -- retrieve values from temp table and delete the records at the
4064: -- same time
4065: DELETE FROM po_session_gt
4066: WHERE key = p_key
4067: RETURNING num1, char1 BULK COLLECT INTO l_index_tbl, l_result_tbl;
4068:
4069: d_position := 20;

Line 4125: p_key IN po_session_gt.key%TYPE,

4121: --End of Comments
4122: ------------------------------------------------------------------------
4123: PROCEDURE derive_expenditure_org_id
4124: (
4125: p_key IN po_session_gt.key%TYPE,
4126: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
4127: p_expenditure_org_tbl IN PO_TBL_VARCHAR100,
4128: p_project_id_tbl IN PO_TBL_NUMBER,
4129: p_derive_row_tbl IN DBMS_SQL.NUMBER_TABLE,

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

4148: END IF;
4149:
4150: -- query database to get derived result in batch mode
4151: FORALL i IN INDICES OF p_derive_row_tbl
4152: INSERT INTO po_session_gt(key, num1, num2)
4153: SELECT p_key,
4154: p_index_tbl(i),
4155: organization_id
4156: FROM pa_organizations_expend_v

Line 4167: DELETE FROM po_session_gt

4163: d_position := 10;
4164:
4165: -- retrieve values from temp table and delete the records at the
4166: -- same time
4167: DELETE FROM po_session_gt
4168: WHERE key = p_key
4169: RETURNING num1, num2 BULK COLLECT INTO l_index_tbl, l_result_tbl;
4170:
4171: d_position := 20;

Line 4222: p_key IN po_session_gt.key%TYPE,

4218: --End of Comments
4219: ------------------------------------------------------------------------
4220: PROCEDURE get_item_status
4221: (
4222: p_key IN po_session_gt.key%TYPE,
4223: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
4224: p_item_id_tbl IN PO_TBL_NUMBER,
4225: p_ship_to_org_id_tbl IN PO_TBL_NUMBER,
4226: x_item_status_tbl OUT NOCOPY PO_TBL_VARCHAR1

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

4245: x_item_status_tbl := PO_TBL_VARCHAR1();
4246: x_item_status_tbl.EXTEND(p_index_tbl.COUNT);
4247:
4248: FORALL i IN 1..p_index_tbl.COUNT
4249: INSERT INTO po_session_gt(key, num1, char1)
4250: SELECT p_key,
4251: p_index_tbl(i),
4252: DECODE(outside_operation_flag,'Y','O',
4253: DECODE(stock_enabled_flag,'Y','E','D'))

Line 4262: DELETE FROM po_session_gt

4258: d_position := 10;
4259:
4260: -- retrieve values from temp table and delete the records at the
4261: -- same time
4262: DELETE FROM po_session_gt
4263: WHERE key = p_key
4264: RETURNING num1, char1 BULK COLLECT INTO l_index_tbl, l_result_tbl;
4265:
4266: d_position := 20;