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_OTM_INTEGRATION_PVT dependencies on PO_OTM_ORDER_TYPE

Line 24: , x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE

20:
21: -- Private procedures
22: PROCEDURE populate_otm_info (
23: p_action IN VARCHAR2
24: , x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE
25: );
26:
27: PROCEDURE populate_address_info (
28: x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE

Line 28: x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE

24: , x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE
25: );
26:
27: PROCEDURE populate_address_info (
28: x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE
29: );
30:
31: PROCEDURE populate_address_info (
32: x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE

Line 32: x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE

28: x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE
29: );
30:
31: PROCEDURE populate_address_info (
32: x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE
33: , x_otm_sched_line IN OUT NOCOPY PO_OTM_SCHEDULE_LINE_TYPE
34: );
35:
36: PROCEDURE populate_drop_ship_info (

Line 43: , x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE

39:
40: PROCEDURE get_approved_po (
41: p_doc_id IN NUMBER
42: , p_doc_revision IN NUMBER
43: , x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE
44: );
45:
46: PROCEDURE get_canceled_po (
47: p_doc_id IN NUMBER

Line 51: , x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE

47: p_doc_id IN NUMBER
48: , p_doc_revision IN NUMBER
49: , p_line_id IN NUMBER
50: , p_line_loc_id IN NUMBER
51: , x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE
52: );
53:
54: PROCEDURE get_closed_po (
55: p_doc_id IN NUMBER

Line 59: , x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE

55: p_doc_id IN NUMBER
56: , p_doc_revision IN NUMBER
57: , p_line_id IN NUMBER
58: , p_line_loc_id IN NUMBER
59: , x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE
60: );
61:
62: PROCEDURE get_opened_po (
63: p_doc_id IN NUMBER

Line 67: , x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE

63: p_doc_id IN NUMBER
64: , p_doc_revision IN NUMBER
65: , p_line_id IN NUMBER
66: , p_line_loc_id IN NUMBER
67: , x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE
68: );
69:
70: PROCEDURE get_held_po (
71: p_doc_id IN NUMBER

Line 73: , x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE

69:
70: PROCEDURE get_held_po (
71: p_doc_id IN NUMBER
72: , p_doc_revision IN NUMBER
73: , x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE
74: );
75:
76: PROCEDURE get_po_for_status_change (
77: p_doc_id IN NUMBER

Line 81: , x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE

77: p_doc_id IN NUMBER
78: , p_doc_revision IN NUMBER
79: , p_line_id IN NUMBER
80: , p_line_loc_id IN NUMBER
81: , x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE
82: );
83:
84: PROCEDURE get_approved_release (
85: p_doc_id IN NUMBER

Line 88: , x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE

84: PROCEDURE get_approved_release (
85: p_doc_id IN NUMBER
86: , p_doc_revision IN NUMBER
87: , p_blanket_revision IN NUMBER
88: , x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE
89: );
90:
91: PROCEDURE get_canceled_release (
92: p_doc_id IN NUMBER

Line 96: , x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE

92: p_doc_id IN NUMBER
93: , p_doc_revision IN NUMBER
94: , p_blanket_revision IN NUMBER
95: , p_line_loc_id IN NUMBER
96: , x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE
97: );
98:
99: PROCEDURE get_closed_release (
100: p_doc_id IN NUMBER

Line 104: , x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE

100: p_doc_id IN NUMBER
101: , p_doc_revision IN NUMBER
102: , p_blanket_revision IN NUMBER
103: , p_line_loc_id IN NUMBER
104: , x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE
105: );
106:
107: PROCEDURE get_opened_release (
108: p_doc_id IN NUMBER

Line 112: , x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE

108: p_doc_id IN NUMBER
109: , p_doc_revision IN NUMBER
110: , p_blanket_revision IN NUMBER
111: , p_line_loc_id IN NUMBER
112: , x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE
113: );
114:
115: PROCEDURE get_held_release (
116: p_doc_id IN NUMBER

Line 119: , x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE

115: PROCEDURE get_held_release (
116: p_doc_id IN NUMBER
117: , p_doc_revision IN NUMBER
118: , p_blanket_revision IN NUMBER
119: , x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE
120: );
121:
122: PROCEDURE get_release_for_status_change (
123: p_doc_id IN NUMBER

Line 127: , x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE

123: p_doc_id IN NUMBER
124: , p_doc_revision IN NUMBER
125: , p_blanket_revision IN NUMBER
126: , p_line_loc_id IN NUMBER
127: , x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE
128: );
129:
130: -- 7449918 OTM Recovery START
131: PROCEDURE get_recovering_order

Line 133: x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE

129:
130: -- 7449918 OTM Recovery START
131: PROCEDURE get_recovering_order
132: ( p_doc_id IN NUMBER,
133: x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE
134: );
135:
136: PROCEDURE get_recovering_release
137: ( p_doc_id IN NUMBER,

Line 138: x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE

134: );
135:
136: PROCEDURE get_recovering_release
137: ( p_doc_id IN NUMBER,
138: x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE
139: );
140: -- OTM Recovery END
141:
142: FUNCTION is_otm_installed

Line 565: , x_otm_doc OUT NOCOPY PO_OTM_ORDER_TYPE

561: , p_blanket_revision IN NUMBER DEFAULT NULL
562: , p_action IN VARCHAR2
563: , p_line_id IN NUMBER DEFAULT NULL
564: , p_line_loc_id IN NUMBER DEFAULT NULL
565: , x_otm_doc OUT NOCOPY PO_OTM_ORDER_TYPE
566: )
567: IS
568:
569: d_progress VARCHAR2(3);

Line 601: x_otm_doc := PO_OTM_ORDER_TYPE.new_instance();

597: );
598:
599: -- initialize the OTM document object and
600: -- get domain info
601: x_otm_doc := PO_OTM_ORDER_TYPE.new_instance();
602: populate_otm_info(
603: p_action => p_action
604: , x_otm_doc => x_otm_doc);
605:

Line 741: , x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE

737: END get_otm_document;
738:
739: PROCEDURE populate_otm_info (
740: p_action IN VARCHAR2
741: , x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE
742: )
743: IS
744:
745: d_progress VARCHAR2(3);

Line 787: , x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE

783:
784: PROCEDURE get_approved_po (
785: p_doc_id IN NUMBER
786: , p_doc_revision IN NUMBER
787: , x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE
788: )
789: IS
790:
791: CURSOR get_shipment_line_info (

Line 1185: , x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE

1181: p_doc_id IN NUMBER
1182: , p_doc_revision IN NUMBER
1183: , p_line_id IN NUMBER
1184: , p_line_loc_id IN NUMBER
1185: , x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE
1186: )
1187: IS
1188:
1189: d_progress VARCHAR2(3);

Line 1232: , x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE

1228: p_doc_id IN NUMBER
1229: , p_doc_revision IN NUMBER
1230: , p_line_id IN NUMBER
1231: , p_line_loc_id IN NUMBER
1232: , x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE
1233: )
1234: IS
1235:
1236: d_progress VARCHAR2(3);

Line 1279: , x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE

1275: p_doc_id IN NUMBER
1276: , p_doc_revision IN NUMBER
1277: , p_line_id IN NUMBER
1278: , p_line_loc_id IN NUMBER
1279: , x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE
1280: )
1281: IS
1282:
1283: d_progress VARCHAR2(3);

Line 1326: , x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE

1322: p_doc_id IN NUMBER
1323: , p_doc_revision IN NUMBER
1324: , p_line_id IN NUMBER
1325: , p_line_loc_id IN NUMBER
1326: , x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE
1327: )
1328: IS
1329:
1330: CURSOR get_shipment_line_info (

Line 1481: , x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE

1477:
1478: PROCEDURE get_held_po (
1479: p_doc_id IN NUMBER
1480: , p_doc_revision IN NUMBER
1481: , x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE
1482: )
1483: IS
1484:
1485: d_progress VARCHAR2(3);

Line 1541: , x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE

1537: PROCEDURE get_approved_release (
1538: p_doc_id IN NUMBER
1539: , p_doc_revision IN NUMBER
1540: , p_blanket_revision IN NUMBER
1541: , x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE
1542: )
1543: IS
1544:
1545: CURSOR get_shipment_line_info (

Line 1951: , x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE

1947: p_doc_id IN NUMBER
1948: , p_doc_revision IN NUMBER
1949: , p_blanket_revision IN NUMBER
1950: , p_line_loc_id IN NUMBER
1951: , x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE
1952: )
1953: IS
1954:
1955: d_progress VARCHAR2(3);

Line 1998: , x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE

1994: p_doc_id IN NUMBER
1995: , p_doc_revision IN NUMBER
1996: , p_blanket_revision IN NUMBER
1997: , p_line_loc_id IN NUMBER
1998: , x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE
1999: )
2000: IS
2001:
2002: d_progress VARCHAR2(3);

Line 2045: , x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE

2041: p_doc_id IN NUMBER
2042: , p_doc_revision IN NUMBER
2043: , p_blanket_revision IN NUMBER
2044: , p_line_loc_id IN NUMBER
2045: , x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE
2046: )
2047: IS
2048:
2049: d_progress VARCHAR2(3);

Line 2093: , x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE

2089: p_doc_id IN NUMBER
2090: , p_doc_revision IN NUMBER
2091: , p_blanket_revision IN NUMBER
2092: , p_line_loc_id IN NUMBER
2093: , x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE
2094: )
2095: IS
2096:
2097: CURSOR get_shipment_line_info (

Line 2256: , x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE

2252: PROCEDURE get_held_release (
2253: p_doc_id IN NUMBER
2254: , p_doc_revision IN NUMBER
2255: , p_blanket_revision IN NUMBER
2256: , x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE
2257: )
2258: IS
2259:
2260: d_progress VARCHAR2(3);

Line 2319: x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE

2315:
2316: END get_held_release;
2317:
2318: PROCEDURE populate_address_info (
2319: x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE
2320: )
2321: IS
2322:
2323: l_territory_short_name FND_TERRITORIES_TL.territory_short_name%TYPE;

Line 2404: x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE

2400:
2401: END populate_address_info;
2402:
2403: PROCEDURE populate_address_info (
2404: x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE
2405: , x_otm_sched_line IN OUT NOCOPY PO_OTM_SCHEDULE_LINE_TYPE
2406: )
2407: IS
2408:

Line 2736: x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE

2732: END recover_failed_docs;
2733:
2734: PROCEDURE get_recovering_order
2735: ( p_doc_id IN NUMBER,
2736: x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE
2737: ) IS
2738:
2739: d_module CONSTANT VARCHAR2(100) := g_module_prefix || 'get_recovering_order';
2740: d_progress VARCHAR2(3);

Line 2891: x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE

2887: END get_recovering_order;
2888:
2889: PROCEDURE get_recovering_release
2890: ( p_doc_id IN NUMBER,
2891: x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE
2892: ) IS
2893:
2894: d_module CONSTANT VARCHAR2(100) := g_module_prefix || 'get_recovering_release';
2895: d_progress VARCHAR2(3);