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_VARCHAR30

Line 35: -- IN :l_entity_pk_tbl IN PO_TBL_VARCHAR30

31: -- Pre-reqs : None.
32: -- Modifiers : none
33: -- Function : this api returns the UNION ALL of the input tables.
34: -- Parameters :
35: -- IN :l_entity_pk_tbl IN PO_TBL_VARCHAR30
36: -- l_temp_entity_pk_tbl IN PO_TBL_VARCHAR30
37: -- OUT :
38: -- IN OUT :
39: FUNCTION merge_tbl_varchar30(l_entity_pk_tbl IN PO_TBL_VARCHAR30,

Line 36: -- l_temp_entity_pk_tbl IN PO_TBL_VARCHAR30

32: -- Modifiers : none
33: -- Function : this api returns the UNION ALL of the input tables.
34: -- Parameters :
35: -- IN :l_entity_pk_tbl IN PO_TBL_VARCHAR30
36: -- l_temp_entity_pk_tbl IN PO_TBL_VARCHAR30
37: -- OUT :
38: -- IN OUT :
39: FUNCTION merge_tbl_varchar30(l_entity_pk_tbl IN PO_TBL_VARCHAR30,
40: l_temp_entity_pk_tbl IN PO_TBL_VARCHAR30)

Line 39: FUNCTION merge_tbl_varchar30(l_entity_pk_tbl IN PO_TBL_VARCHAR30,

35: -- IN :l_entity_pk_tbl IN PO_TBL_VARCHAR30
36: -- l_temp_entity_pk_tbl IN PO_TBL_VARCHAR30
37: -- OUT :
38: -- IN OUT :
39: FUNCTION merge_tbl_varchar30(l_entity_pk_tbl IN PO_TBL_VARCHAR30,
40: l_temp_entity_pk_tbl IN PO_TBL_VARCHAR30)
41: RETURN PO_TBL_VARCHAR30
42: IS
43: l_entity_pk1_tbl PO_TBL_VARCHAR30;

Line 40: l_temp_entity_pk_tbl IN PO_TBL_VARCHAR30)

36: -- l_temp_entity_pk_tbl IN PO_TBL_VARCHAR30
37: -- OUT :
38: -- IN OUT :
39: FUNCTION merge_tbl_varchar30(l_entity_pk_tbl IN PO_TBL_VARCHAR30,
40: l_temp_entity_pk_tbl IN PO_TBL_VARCHAR30)
41: RETURN PO_TBL_VARCHAR30
42: IS
43: l_entity_pk1_tbl PO_TBL_VARCHAR30;
44: BEGIN

Line 41: RETURN PO_TBL_VARCHAR30

37: -- OUT :
38: -- IN OUT :
39: FUNCTION merge_tbl_varchar30(l_entity_pk_tbl IN PO_TBL_VARCHAR30,
40: l_temp_entity_pk_tbl IN PO_TBL_VARCHAR30)
41: RETURN PO_TBL_VARCHAR30
42: IS
43: l_entity_pk1_tbl PO_TBL_VARCHAR30;
44: BEGIN
45: l_entity_pk1_tbl := PO_TBL_VARCHAR30();

Line 43: l_entity_pk1_tbl PO_TBL_VARCHAR30;

39: FUNCTION merge_tbl_varchar30(l_entity_pk_tbl IN PO_TBL_VARCHAR30,
40: l_temp_entity_pk_tbl IN PO_TBL_VARCHAR30)
41: RETURN PO_TBL_VARCHAR30
42: IS
43: l_entity_pk1_tbl PO_TBL_VARCHAR30;
44: BEGIN
45: l_entity_pk1_tbl := PO_TBL_VARCHAR30();
46: SELECT *
47: BULK COLLECT INTO l_entity_pk1_tbl

Line 45: l_entity_pk1_tbl := PO_TBL_VARCHAR30();

41: RETURN PO_TBL_VARCHAR30
42: IS
43: l_entity_pk1_tbl PO_TBL_VARCHAR30;
44: BEGIN
45: l_entity_pk1_tbl := PO_TBL_VARCHAR30();
46: SELECT *
47: BULK COLLECT INTO l_entity_pk1_tbl
48: FROM (SELECT * FROM TABLE(l_entity_pk_tbl)
49: UNION ALL

Line 58: p_entity_name_tbl PO_TBL_VARCHAR30,

54:
55: PROCEDURE enable_conc_mod_for_styleId( p_style_id IN NUMBER);
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 ,

Line 138: l_entity_name_tbl PO_TBL_VARCHAR30;

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;
142: l_temp_entity_pk1_tbl PO_TBL_VARCHAR240;

Line 143: l_temp_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;
147: x_return_status VARCHAR2(10);

Line 153: l_entity_name_tbl := PO_TBL_VARCHAR30();

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();
157: l_temp_entity_pk1_tbl :=PO_TBL_VARCHAR240();

Line 158: l_temp_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();
162: FND_FILE.put_line(FND_FILE.log,'enable_conc_mod_for_styleId:p_style_id: '||p_style_id);

Line 418: p_entity_name_tbl PO_TBL_VARCHAR30,

414: --Procedure to create attachment level locks
415: --End of Comments
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 ,