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 19: , x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE

15:
16: -- Private procedures
17: PROCEDURE populate_otm_info (
18: p_action IN VARCHAR2
19: , x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE
20: );
21:
22: PROCEDURE populate_address_info (
23: x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE

Line 23: x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE

19: , x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE
20: );
21:
22: PROCEDURE populate_address_info (
23: x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE
24: );
25:
26: PROCEDURE populate_address_info (
27: x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE

Line 27: x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE

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

Line 38: , x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE

34:
35: PROCEDURE get_approved_po (
36: p_doc_id IN NUMBER
37: , p_doc_revision IN NUMBER
38: , x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE
39: );
40:
41: PROCEDURE get_canceled_po (
42: p_doc_id IN NUMBER

Line 46: , x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE

42: p_doc_id IN NUMBER
43: , p_doc_revision IN NUMBER
44: , p_line_id IN NUMBER
45: , p_line_loc_id IN NUMBER
46: , x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE
47: );
48:
49: PROCEDURE get_closed_po (
50: p_doc_id IN NUMBER

Line 54: , x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE

50: p_doc_id IN NUMBER
51: , p_doc_revision IN NUMBER
52: , p_line_id IN NUMBER
53: , p_line_loc_id IN NUMBER
54: , x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE
55: );
56:
57: PROCEDURE get_opened_po (
58: p_doc_id IN NUMBER

Line 62: , x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE

58: p_doc_id IN NUMBER
59: , p_doc_revision IN NUMBER
60: , p_line_id IN NUMBER
61: , p_line_loc_id IN NUMBER
62: , x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE
63: );
64:
65: PROCEDURE get_held_po (
66: p_doc_id IN NUMBER

Line 68: , x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE

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

Line 76: , x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE

72: p_doc_id IN NUMBER
73: , p_doc_revision IN NUMBER
74: , p_line_id IN NUMBER
75: , p_line_loc_id IN NUMBER
76: , x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE
77: );
78:
79: PROCEDURE get_approved_release (
80: p_doc_id IN NUMBER

Line 83: , x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE

79: PROCEDURE get_approved_release (
80: p_doc_id IN NUMBER
81: , p_doc_revision IN NUMBER
82: , p_blanket_revision IN NUMBER
83: , x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE
84: );
85:
86: PROCEDURE get_canceled_release (
87: p_doc_id IN NUMBER

Line 91: , x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE

87: p_doc_id IN NUMBER
88: , p_doc_revision IN NUMBER
89: , p_blanket_revision IN NUMBER
90: , p_line_loc_id IN NUMBER
91: , x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE
92: );
93:
94: PROCEDURE get_closed_release (
95: p_doc_id IN NUMBER

Line 99: , x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE

95: p_doc_id IN NUMBER
96: , p_doc_revision IN NUMBER
97: , p_blanket_revision IN NUMBER
98: , p_line_loc_id IN NUMBER
99: , x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE
100: );
101:
102: PROCEDURE get_opened_release (
103: p_doc_id IN NUMBER

Line 107: , x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE

103: p_doc_id IN NUMBER
104: , p_doc_revision IN NUMBER
105: , p_blanket_revision IN NUMBER
106: , p_line_loc_id IN NUMBER
107: , x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE
108: );
109:
110: PROCEDURE get_held_release (
111: p_doc_id IN NUMBER

Line 114: , x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE

110: PROCEDURE get_held_release (
111: p_doc_id IN NUMBER
112: , p_doc_revision IN NUMBER
113: , p_blanket_revision IN NUMBER
114: , x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE
115: );
116:
117: PROCEDURE get_release_for_status_change (
118: p_doc_id IN NUMBER

Line 122: , x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE

118: p_doc_id IN NUMBER
119: , p_doc_revision IN NUMBER
120: , p_blanket_revision IN NUMBER
121: , p_line_loc_id IN NUMBER
122: , x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE
123: );
124:
125:
126: FUNCTION is_otm_installed

Line 519: , x_otm_doc OUT NOCOPY PO_OTM_ORDER_TYPE

515: , p_blanket_revision IN NUMBER DEFAULT NULL
516: , p_action IN VARCHAR2
517: , p_line_id IN NUMBER DEFAULT NULL
518: , p_line_loc_id IN NUMBER DEFAULT NULL
519: , x_otm_doc OUT NOCOPY PO_OTM_ORDER_TYPE
520: )
521: IS
522:
523: d_progress VARCHAR2(3);

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

542: d_progress := '100';
543:
544: -- initialize the OTM document object and
545: -- get domain info
546: x_otm_doc := PO_OTM_ORDER_TYPE.new_instance();
547: populate_otm_info(
548: p_action => p_action
549: , x_otm_doc => x_otm_doc);
550:

Line 671: , x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE

667: END get_otm_document;
668:
669: PROCEDURE populate_otm_info (
670: p_action IN VARCHAR2
671: , x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE
672: )
673: IS
674:
675: d_progress VARCHAR2(3);

Line 717: , x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE

713:
714: PROCEDURE get_approved_po (
715: p_doc_id IN NUMBER
716: , p_doc_revision IN NUMBER
717: , x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE
718: )
719: IS
720:
721: CURSOR get_shipment_line_info (

Line 1113: , x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE

1109: p_doc_id IN NUMBER
1110: , p_doc_revision IN NUMBER
1111: , p_line_id IN NUMBER
1112: , p_line_loc_id IN NUMBER
1113: , x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE
1114: )
1115: IS
1116:
1117: d_progress VARCHAR2(3);

Line 1160: , x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE

1156: p_doc_id IN NUMBER
1157: , p_doc_revision IN NUMBER
1158: , p_line_id IN NUMBER
1159: , p_line_loc_id IN NUMBER
1160: , x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE
1161: )
1162: IS
1163:
1164: d_progress VARCHAR2(3);

Line 1207: , x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE

1203: p_doc_id IN NUMBER
1204: , p_doc_revision IN NUMBER
1205: , p_line_id IN NUMBER
1206: , p_line_loc_id IN NUMBER
1207: , x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE
1208: )
1209: IS
1210:
1211: d_progress VARCHAR2(3);

Line 1254: , x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE

1250: p_doc_id IN NUMBER
1251: , p_doc_revision IN NUMBER
1252: , p_line_id IN NUMBER
1253: , p_line_loc_id IN NUMBER
1254: , x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE
1255: )
1256: IS
1257:
1258: CURSOR get_shipment_line_info (

Line 1409: , x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE

1405:
1406: PROCEDURE get_held_po (
1407: p_doc_id IN NUMBER
1408: , p_doc_revision IN NUMBER
1409: , x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE
1410: )
1411: IS
1412:
1413: d_progress VARCHAR2(3);

Line 1469: , x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE

1465: PROCEDURE get_approved_release (
1466: p_doc_id IN NUMBER
1467: , p_doc_revision IN NUMBER
1468: , p_blanket_revision IN NUMBER
1469: , x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE
1470: )
1471: IS
1472:
1473: CURSOR get_shipment_line_info (

Line 1879: , x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE

1875: p_doc_id IN NUMBER
1876: , p_doc_revision IN NUMBER
1877: , p_blanket_revision IN NUMBER
1878: , p_line_loc_id IN NUMBER
1879: , x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE
1880: )
1881: IS
1882:
1883: d_progress VARCHAR2(3);

Line 1926: , x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE

1922: p_doc_id IN NUMBER
1923: , p_doc_revision IN NUMBER
1924: , p_blanket_revision IN NUMBER
1925: , p_line_loc_id IN NUMBER
1926: , x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE
1927: )
1928: IS
1929:
1930: d_progress VARCHAR2(3);

Line 1973: , x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE

1969: p_doc_id IN NUMBER
1970: , p_doc_revision IN NUMBER
1971: , p_blanket_revision IN NUMBER
1972: , p_line_loc_id IN NUMBER
1973: , x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE
1974: )
1975: IS
1976:
1977: d_progress VARCHAR2(3);

Line 2021: , x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE

2017: p_doc_id IN NUMBER
2018: , p_doc_revision IN NUMBER
2019: , p_blanket_revision IN NUMBER
2020: , p_line_loc_id IN NUMBER
2021: , x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE
2022: )
2023: IS
2024:
2025: CURSOR get_shipment_line_info (

Line 2184: , x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE

2180: PROCEDURE get_held_release (
2181: p_doc_id IN NUMBER
2182: , p_doc_revision IN NUMBER
2183: , p_blanket_revision IN NUMBER
2184: , x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE
2185: )
2186: IS
2187:
2188: d_progress VARCHAR2(3);

Line 2247: x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE

2243:
2244: END get_held_release;
2245:
2246: PROCEDURE populate_address_info (
2247: x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE
2248: )
2249: IS
2250:
2251: l_territory_short_name FND_TERRITORIES_TL.territory_short_name%TYPE;

Line 2332: x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE

2328:
2329: END populate_address_info;
2330:
2331: PROCEDURE populate_address_info (
2332: x_otm_doc IN OUT NOCOPY PO_OTM_ORDER_TYPE
2333: , x_otm_sched_line IN OUT NOCOPY PO_OTM_SCHEDULE_LINE_TYPE
2334: )
2335: IS
2336: