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_CLM_UPG_PVT dependencies on PO_TBL_VARCHAR240

Line 9: -- IN :l_entity_pk_tbl IN PO_TBL_VARCHAR240

5: -- Pre-reqs : None.
6: -- Modifiers : none
7: -- Function : this api returns the UNION ALL of the input tables.
8: -- Parameters :
9: -- IN :l_entity_pk_tbl IN PO_TBL_VARCHAR240
10: -- l_temp_entity_pk_tbl IN PO_TBL_VARCHAR240
11: -- OUT :
12: -- IN OUT :
13: FUNCTION merge_tbl_varchar240(l_entity_pk_tbl IN PO_TBL_VARCHAR240,

Line 10: -- l_temp_entity_pk_tbl IN PO_TBL_VARCHAR240

6: -- Modifiers : none
7: -- Function : this api returns the UNION ALL of the input tables.
8: -- Parameters :
9: -- IN :l_entity_pk_tbl IN PO_TBL_VARCHAR240
10: -- l_temp_entity_pk_tbl IN PO_TBL_VARCHAR240
11: -- OUT :
12: -- IN OUT :
13: FUNCTION merge_tbl_varchar240(l_entity_pk_tbl IN PO_TBL_VARCHAR240,
14: l_temp_entity_pk_tbl IN PO_TBL_VARCHAR240)

Line 13: FUNCTION merge_tbl_varchar240(l_entity_pk_tbl IN PO_TBL_VARCHAR240,

9: -- IN :l_entity_pk_tbl IN PO_TBL_VARCHAR240
10: -- l_temp_entity_pk_tbl IN PO_TBL_VARCHAR240
11: -- OUT :
12: -- IN OUT :
13: FUNCTION merge_tbl_varchar240(l_entity_pk_tbl IN PO_TBL_VARCHAR240,
14: l_temp_entity_pk_tbl IN PO_TBL_VARCHAR240)
15: RETURN PO_TBL_VARCHAR240
16: IS
17: l_entity_pk1_tbl PO_TBL_VARCHAR240;

Line 14: l_temp_entity_pk_tbl IN PO_TBL_VARCHAR240)

10: -- l_temp_entity_pk_tbl IN PO_TBL_VARCHAR240
11: -- OUT :
12: -- IN OUT :
13: FUNCTION merge_tbl_varchar240(l_entity_pk_tbl IN PO_TBL_VARCHAR240,
14: l_temp_entity_pk_tbl IN PO_TBL_VARCHAR240)
15: RETURN PO_TBL_VARCHAR240
16: IS
17: l_entity_pk1_tbl PO_TBL_VARCHAR240;
18: BEGIN

Line 15: RETURN PO_TBL_VARCHAR240

11: -- OUT :
12: -- IN OUT :
13: FUNCTION merge_tbl_varchar240(l_entity_pk_tbl IN PO_TBL_VARCHAR240,
14: l_temp_entity_pk_tbl IN PO_TBL_VARCHAR240)
15: RETURN PO_TBL_VARCHAR240
16: IS
17: l_entity_pk1_tbl PO_TBL_VARCHAR240;
18: BEGIN
19: l_entity_pk1_tbl := PO_TBL_VARCHAR240();

Line 17: l_entity_pk1_tbl PO_TBL_VARCHAR240;

13: FUNCTION merge_tbl_varchar240(l_entity_pk_tbl IN PO_TBL_VARCHAR240,
14: l_temp_entity_pk_tbl IN PO_TBL_VARCHAR240)
15: RETURN PO_TBL_VARCHAR240
16: IS
17: l_entity_pk1_tbl PO_TBL_VARCHAR240;
18: BEGIN
19: l_entity_pk1_tbl := PO_TBL_VARCHAR240();
20: SELECT *
21: BULK COLLECT INTO l_entity_pk1_tbl

Line 19: l_entity_pk1_tbl := PO_TBL_VARCHAR240();

15: RETURN PO_TBL_VARCHAR240
16: IS
17: l_entity_pk1_tbl PO_TBL_VARCHAR240;
18: BEGIN
19: l_entity_pk1_tbl := PO_TBL_VARCHAR240();
20: SELECT *
21: BULK COLLECT INTO l_entity_pk1_tbl
22: FROM (SELECT * FROM TABLE(l_entity_pk_tbl)
23: UNION ALL

Line 60: p_pk1_tbl PO_TBL_VARCHAR240 ,

56: /* Bug 13938456 -Procedure to create attachment level locks*/
57: PROCEDURE lock_attachments(
58: p_entity_name_tbl PO_TBL_VARCHAR30,
59: p_draft_id NUMBER ,
60: p_pk1_tbl PO_TBL_VARCHAR240 ,
61: p_pk2_tbl PO_TBL_VARCHAR240 ,
62: p_pk3_tbl PO_TBL_VARCHAR240 ,
63: p_pk4_tbl PO_TBL_VARCHAR240
64: );

Line 61: p_pk2_tbl PO_TBL_VARCHAR240 ,

57: PROCEDURE lock_attachments(
58: p_entity_name_tbl PO_TBL_VARCHAR30,
59: p_draft_id NUMBER ,
60: p_pk1_tbl PO_TBL_VARCHAR240 ,
61: p_pk2_tbl PO_TBL_VARCHAR240 ,
62: p_pk3_tbl PO_TBL_VARCHAR240 ,
63: p_pk4_tbl PO_TBL_VARCHAR240
64: );
65:

Line 62: p_pk3_tbl PO_TBL_VARCHAR240 ,

58: p_entity_name_tbl PO_TBL_VARCHAR30,
59: p_draft_id NUMBER ,
60: p_pk1_tbl PO_TBL_VARCHAR240 ,
61: p_pk2_tbl PO_TBL_VARCHAR240 ,
62: p_pk3_tbl PO_TBL_VARCHAR240 ,
63: p_pk4_tbl PO_TBL_VARCHAR240
64: );
65:
66:

Line 63: p_pk4_tbl PO_TBL_VARCHAR240

59: p_draft_id NUMBER ,
60: p_pk1_tbl PO_TBL_VARCHAR240 ,
61: p_pk2_tbl PO_TBL_VARCHAR240 ,
62: p_pk3_tbl PO_TBL_VARCHAR240 ,
63: p_pk4_tbl PO_TBL_VARCHAR240
64: );
65:
66:
67: -- Start of comments

Line 137: l_entity_pk1_tbl PO_TBL_VARCHAR240;

133: -- End of comments
134: PROCEDURE enable_conc_mod_for_styleId( p_style_id IN NUMBER)
135: IS
136: l_draft_id_tbl PO_TBL_NUMBER;
137: l_entity_pk1_tbl PO_TBL_VARCHAR240;
138: l_entity_name_tbl PO_TBL_VARCHAR30;
139: l_entity_pk2_tbl PO_TBL_VARCHAR240;
140: l_entity_pk3_tbl PO_TBL_VARCHAR240;
141: l_entity_pk4_tbl PO_TBL_VARCHAR240;

Line 139: l_entity_pk2_tbl PO_TBL_VARCHAR240;

135: IS
136: l_draft_id_tbl PO_TBL_NUMBER;
137: l_entity_pk1_tbl PO_TBL_VARCHAR240;
138: l_entity_name_tbl PO_TBL_VARCHAR30;
139: l_entity_pk2_tbl PO_TBL_VARCHAR240;
140: l_entity_pk3_tbl PO_TBL_VARCHAR240;
141: l_entity_pk4_tbl PO_TBL_VARCHAR240;
142: l_temp_entity_pk1_tbl PO_TBL_VARCHAR240;
143: l_temp_entity_name_tbl PO_TBL_VARCHAR30;

Line 140: l_entity_pk3_tbl PO_TBL_VARCHAR240;

136: l_draft_id_tbl PO_TBL_NUMBER;
137: l_entity_pk1_tbl PO_TBL_VARCHAR240;
138: l_entity_name_tbl PO_TBL_VARCHAR30;
139: l_entity_pk2_tbl PO_TBL_VARCHAR240;
140: l_entity_pk3_tbl PO_TBL_VARCHAR240;
141: l_entity_pk4_tbl PO_TBL_VARCHAR240;
142: l_temp_entity_pk1_tbl PO_TBL_VARCHAR240;
143: l_temp_entity_name_tbl PO_TBL_VARCHAR30;
144: l_temp_entity_pk2_tbl PO_TBL_VARCHAR240;

Line 141: l_entity_pk4_tbl PO_TBL_VARCHAR240;

137: l_entity_pk1_tbl PO_TBL_VARCHAR240;
138: l_entity_name_tbl PO_TBL_VARCHAR30;
139: l_entity_pk2_tbl PO_TBL_VARCHAR240;
140: l_entity_pk3_tbl PO_TBL_VARCHAR240;
141: l_entity_pk4_tbl PO_TBL_VARCHAR240;
142: l_temp_entity_pk1_tbl PO_TBL_VARCHAR240;
143: l_temp_entity_name_tbl PO_TBL_VARCHAR30;
144: l_temp_entity_pk2_tbl PO_TBL_VARCHAR240;
145: l_temp_entity_pk3_tbl PO_TBL_VARCHAR240;

Line 142: l_temp_entity_pk1_tbl PO_TBL_VARCHAR240;

138: l_entity_name_tbl PO_TBL_VARCHAR30;
139: l_entity_pk2_tbl PO_TBL_VARCHAR240;
140: l_entity_pk3_tbl PO_TBL_VARCHAR240;
141: l_entity_pk4_tbl PO_TBL_VARCHAR240;
142: l_temp_entity_pk1_tbl PO_TBL_VARCHAR240;
143: l_temp_entity_name_tbl PO_TBL_VARCHAR30;
144: l_temp_entity_pk2_tbl PO_TBL_VARCHAR240;
145: l_temp_entity_pk3_tbl PO_TBL_VARCHAR240;
146: l_temp_entity_pk4_tbl PO_TBL_VARCHAR240;

Line 144: l_temp_entity_pk2_tbl PO_TBL_VARCHAR240;

140: l_entity_pk3_tbl PO_TBL_VARCHAR240;
141: l_entity_pk4_tbl PO_TBL_VARCHAR240;
142: l_temp_entity_pk1_tbl PO_TBL_VARCHAR240;
143: l_temp_entity_name_tbl PO_TBL_VARCHAR30;
144: l_temp_entity_pk2_tbl PO_TBL_VARCHAR240;
145: l_temp_entity_pk3_tbl PO_TBL_VARCHAR240;
146: l_temp_entity_pk4_tbl PO_TBL_VARCHAR240;
147: x_return_status VARCHAR2(10);
148: x_results PO_VALIDATION_RESULTS_TYPE;

Line 145: l_temp_entity_pk3_tbl PO_TBL_VARCHAR240;

141: l_entity_pk4_tbl PO_TBL_VARCHAR240;
142: l_temp_entity_pk1_tbl PO_TBL_VARCHAR240;
143: l_temp_entity_name_tbl PO_TBL_VARCHAR30;
144: l_temp_entity_pk2_tbl PO_TBL_VARCHAR240;
145: l_temp_entity_pk3_tbl PO_TBL_VARCHAR240;
146: l_temp_entity_pk4_tbl PO_TBL_VARCHAR240;
147: x_return_status VARCHAR2(10);
148: x_results PO_VALIDATION_RESULTS_TYPE;
149:

Line 146: l_temp_entity_pk4_tbl PO_TBL_VARCHAR240;

142: l_temp_entity_pk1_tbl PO_TBL_VARCHAR240;
143: l_temp_entity_name_tbl PO_TBL_VARCHAR30;
144: l_temp_entity_pk2_tbl PO_TBL_VARCHAR240;
145: l_temp_entity_pk3_tbl PO_TBL_VARCHAR240;
146: l_temp_entity_pk4_tbl PO_TBL_VARCHAR240;
147: x_return_status VARCHAR2(10);
148: x_results PO_VALIDATION_RESULTS_TYPE;
149:
150: BEGIN

Line 152: l_entity_pk1_tbl := PO_TBL_VARCHAR240();

148: x_results PO_VALIDATION_RESULTS_TYPE;
149:
150: BEGIN
151: l_draft_id_tbl := po_tbl_number();
152: l_entity_pk1_tbl := PO_TBL_VARCHAR240();
153: l_entity_name_tbl := PO_TBL_VARCHAR30();
154: l_entity_pk2_tbl :=PO_TBL_VARCHAR240();
155: l_entity_pk3_tbl :=PO_TBL_VARCHAR240();
156: l_entity_pk4_tbl :=PO_TBL_VARCHAR240();

Line 154: l_entity_pk2_tbl :=PO_TBL_VARCHAR240();

150: BEGIN
151: l_draft_id_tbl := po_tbl_number();
152: l_entity_pk1_tbl := PO_TBL_VARCHAR240();
153: l_entity_name_tbl := PO_TBL_VARCHAR30();
154: l_entity_pk2_tbl :=PO_TBL_VARCHAR240();
155: l_entity_pk3_tbl :=PO_TBL_VARCHAR240();
156: l_entity_pk4_tbl :=PO_TBL_VARCHAR240();
157: l_temp_entity_pk1_tbl :=PO_TBL_VARCHAR240();
158: l_temp_entity_name_tbl :=PO_TBL_VARCHAR30();

Line 155: l_entity_pk3_tbl :=PO_TBL_VARCHAR240();

151: l_draft_id_tbl := po_tbl_number();
152: l_entity_pk1_tbl := PO_TBL_VARCHAR240();
153: l_entity_name_tbl := PO_TBL_VARCHAR30();
154: l_entity_pk2_tbl :=PO_TBL_VARCHAR240();
155: l_entity_pk3_tbl :=PO_TBL_VARCHAR240();
156: l_entity_pk4_tbl :=PO_TBL_VARCHAR240();
157: l_temp_entity_pk1_tbl :=PO_TBL_VARCHAR240();
158: l_temp_entity_name_tbl :=PO_TBL_VARCHAR30();
159: l_temp_entity_pk2_tbl :=PO_TBL_VARCHAR240();

Line 156: l_entity_pk4_tbl :=PO_TBL_VARCHAR240();

152: l_entity_pk1_tbl := PO_TBL_VARCHAR240();
153: l_entity_name_tbl := PO_TBL_VARCHAR30();
154: l_entity_pk2_tbl :=PO_TBL_VARCHAR240();
155: l_entity_pk3_tbl :=PO_TBL_VARCHAR240();
156: l_entity_pk4_tbl :=PO_TBL_VARCHAR240();
157: l_temp_entity_pk1_tbl :=PO_TBL_VARCHAR240();
158: l_temp_entity_name_tbl :=PO_TBL_VARCHAR30();
159: l_temp_entity_pk2_tbl :=PO_TBL_VARCHAR240();
160: l_temp_entity_pk3_tbl :=PO_TBL_VARCHAR240();

Line 157: l_temp_entity_pk1_tbl :=PO_TBL_VARCHAR240();

153: l_entity_name_tbl := PO_TBL_VARCHAR30();
154: l_entity_pk2_tbl :=PO_TBL_VARCHAR240();
155: l_entity_pk3_tbl :=PO_TBL_VARCHAR240();
156: l_entity_pk4_tbl :=PO_TBL_VARCHAR240();
157: l_temp_entity_pk1_tbl :=PO_TBL_VARCHAR240();
158: l_temp_entity_name_tbl :=PO_TBL_VARCHAR30();
159: l_temp_entity_pk2_tbl :=PO_TBL_VARCHAR240();
160: l_temp_entity_pk3_tbl :=PO_TBL_VARCHAR240();
161: l_temp_entity_pk4_tbl :=PO_TBL_VARCHAR240();

Line 159: l_temp_entity_pk2_tbl :=PO_TBL_VARCHAR240();

155: l_entity_pk3_tbl :=PO_TBL_VARCHAR240();
156: l_entity_pk4_tbl :=PO_TBL_VARCHAR240();
157: l_temp_entity_pk1_tbl :=PO_TBL_VARCHAR240();
158: l_temp_entity_name_tbl :=PO_TBL_VARCHAR30();
159: l_temp_entity_pk2_tbl :=PO_TBL_VARCHAR240();
160: l_temp_entity_pk3_tbl :=PO_TBL_VARCHAR240();
161: l_temp_entity_pk4_tbl :=PO_TBL_VARCHAR240();
162: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod_for_styleId:p_style_id: '||p_style_id);
163: --commit or rollback to savepoint and exit

Line 160: l_temp_entity_pk3_tbl :=PO_TBL_VARCHAR240();

156: l_entity_pk4_tbl :=PO_TBL_VARCHAR240();
157: l_temp_entity_pk1_tbl :=PO_TBL_VARCHAR240();
158: l_temp_entity_name_tbl :=PO_TBL_VARCHAR30();
159: l_temp_entity_pk2_tbl :=PO_TBL_VARCHAR240();
160: l_temp_entity_pk3_tbl :=PO_TBL_VARCHAR240();
161: l_temp_entity_pk4_tbl :=PO_TBL_VARCHAR240();
162: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod_for_styleId:p_style_id: '||p_style_id);
163: --commit or rollback to savepoint and exit
164: SAVEPOINT update_sp;

Line 161: l_temp_entity_pk4_tbl :=PO_TBL_VARCHAR240();

157: l_temp_entity_pk1_tbl :=PO_TBL_VARCHAR240();
158: l_temp_entity_name_tbl :=PO_TBL_VARCHAR30();
159: l_temp_entity_pk2_tbl :=PO_TBL_VARCHAR240();
160: l_temp_entity_pk3_tbl :=PO_TBL_VARCHAR240();
161: l_temp_entity_pk4_tbl :=PO_TBL_VARCHAR240();
162: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod_for_styleId:p_style_id: '||p_style_id);
163: --commit or rollback to savepoint and exit
164: SAVEPOINT update_sp;
165: -- collect draft_id for all open modifications having the given style_id

Line 420: p_pk1_tbl PO_TBL_VARCHAR240 ,

416: -------------------------------------------------------------------------------
417: PROCEDURE lock_attachments(
418: p_entity_name_tbl PO_TBL_VARCHAR30,
419: p_draft_id NUMBER ,
420: p_pk1_tbl PO_TBL_VARCHAR240 ,
421: p_pk2_tbl PO_TBL_VARCHAR240 ,
422: p_pk3_tbl PO_TBL_VARCHAR240 ,
423: p_pk4_tbl PO_TBL_VARCHAR240
424: ) AS

Line 421: p_pk2_tbl PO_TBL_VARCHAR240 ,

417: PROCEDURE lock_attachments(
418: p_entity_name_tbl PO_TBL_VARCHAR30,
419: p_draft_id NUMBER ,
420: p_pk1_tbl PO_TBL_VARCHAR240 ,
421: p_pk2_tbl PO_TBL_VARCHAR240 ,
422: p_pk3_tbl PO_TBL_VARCHAR240 ,
423: p_pk4_tbl PO_TBL_VARCHAR240
424: ) AS
425:

Line 422: p_pk3_tbl PO_TBL_VARCHAR240 ,

418: p_entity_name_tbl PO_TBL_VARCHAR30,
419: p_draft_id NUMBER ,
420: p_pk1_tbl PO_TBL_VARCHAR240 ,
421: p_pk2_tbl PO_TBL_VARCHAR240 ,
422: p_pk3_tbl PO_TBL_VARCHAR240 ,
423: p_pk4_tbl PO_TBL_VARCHAR240
424: ) AS
425:
426: --Cursor to fetch the attachment level details for the mod at different entity levels

Line 423: p_pk4_tbl PO_TBL_VARCHAR240

419: p_draft_id NUMBER ,
420: p_pk1_tbl PO_TBL_VARCHAR240 ,
421: p_pk2_tbl PO_TBL_VARCHAR240 ,
422: p_pk3_tbl PO_TBL_VARCHAR240 ,
423: p_pk4_tbl PO_TBL_VARCHAR240
424: ) AS
425:
426: --Cursor to fetch the attachment level details for the mod at different entity levels
427: