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.MSC_SCE_LOADS_PKG dependencies on MSC_SUP_DEM_ENTRIES

Line 64: TYPE pubaddrList IS TABLE OF msc_sup_dem_entries.publisher_address%TYPE;

60: TYPE publisherList IS TABLE OF msc_companies.company_name%TYPE;
61: TYPE publishidList IS TABLE OF msc_companies.company_id%TYPE;
62: TYPE pubsiteList IS TABLE OF msc_company_sites.company_site_name%TYPE;
63: TYPE pubsiteidList IS TABLE OF msc_company_sites.company_site_id%TYPE;
64: TYPE pubaddrList IS TABLE OF msc_sup_dem_entries.publisher_address%TYPE;
65: TYPE customerList IS TABLE OF msc_companies.company_name%TYPE;
66: TYPE custidList IS TABLE OF msc_companies.company_id%TYPE;
67: TYPE custsiteList IS TABLE OF msc_company_sites.company_site_name%TYPE;
68: TYPE custsiteidList IS TABLE OF msc_company_sites.company_site_id%TYPE;

Line 69: TYPE custaddrList IS TABLE OF msc_sup_dem_entries.customer_address%TYPE;

65: TYPE customerList IS TABLE OF msc_companies.company_name%TYPE;
66: TYPE custidList IS TABLE OF msc_companies.company_id%TYPE;
67: TYPE custsiteList IS TABLE OF msc_company_sites.company_site_name%TYPE;
68: TYPE custsiteidList IS TABLE OF msc_company_sites.company_site_id%TYPE;
69: TYPE custaddrList IS TABLE OF msc_sup_dem_entries.customer_address%TYPE;
70: TYPE supplierList IS TABLE OF msc_companies.company_name%TYPE;
71: TYPE suppidList IS TABLE OF msc_companies.company_id%TYPE;
72: TYPE suppsiteList IS TABLE OF msc_company_sites.company_site_name%TYPE;
73: TYPE suppsiteidList IS TABLE OF msc_company_sites.company_site_id%TYPE;

Line 74: TYPE suppaddrList IS TABLE OF msc_sup_dem_entries.supplier_address%TYPE;

70: TYPE supplierList IS TABLE OF msc_companies.company_name%TYPE;
71: TYPE suppidList IS TABLE OF msc_companies.company_id%TYPE;
72: TYPE suppsiteList IS TABLE OF msc_company_sites.company_site_name%TYPE;
73: TYPE suppsiteidList IS TABLE OF msc_company_sites.company_site_id%TYPE;
74: TYPE suppaddrList IS TABLE OF msc_sup_dem_entries.supplier_address%TYPE;
75: TYPE shipfromList IS TABLE OF msc_companies.company_name%TYPE;
76: TYPE shipfromidList IS TABLE OF msc_companies.company_id%TYPE;
77: TYPE shipfromsiteList IS TABLE OF msc_company_sites.company_site_name%TYPE;
78: TYPE shipfromsidList IS TABLE OF msc_company_sites.company_site_id%TYPE;

Line 79: TYPE shipfromaddrList IS TABLE OF msc_sup_dem_entries.ship_from_address%TYPE;

75: TYPE shipfromList IS TABLE OF msc_companies.company_name%TYPE;
76: TYPE shipfromidList IS TABLE OF msc_companies.company_id%TYPE;
77: TYPE shipfromsiteList IS TABLE OF msc_company_sites.company_site_name%TYPE;
78: TYPE shipfromsidList IS TABLE OF msc_company_sites.company_site_id%TYPE;
79: TYPE shipfromaddrList IS TABLE OF msc_sup_dem_entries.ship_from_address%TYPE;
80: TYPE shiptoList IS TABLE OF msc_companies.company_name%TYPE;
81: TYPE shiptoidList IS TABLE OF msc_companies.company_id%TYPE;
82: TYPE shiptositeList IS TABLE OF msc_company_sites.company_site_name%TYPE;
83: TYPE shiptosidList IS TABLE OF msc_company_sites.company_site_id%TYPE;

Line 84: TYPE shiptopaddrList IS TABLE OF msc_sup_dem_entries.ship_to_address%TYPE;

80: TYPE shiptoList IS TABLE OF msc_companies.company_name%TYPE;
81: TYPE shiptoidList IS TABLE OF msc_companies.company_id%TYPE;
82: TYPE shiptositeList IS TABLE OF msc_company_sites.company_site_name%TYPE;
83: TYPE shiptosidList IS TABLE OF msc_company_sites.company_site_id%TYPE;
84: TYPE shiptopaddrList IS TABLE OF msc_sup_dem_entries.ship_to_address%TYPE;
85: TYPE shiptoaddrList IS TABLE OF msc_supdem_lines_interface.ship_to_address%TYPE;
86: TYPE endordpubList IS TABLE OF msc_companies.company_name%TYPE;
87: TYPE endordpubidList IS TABLE OF msc_companies.company_id%TYPE;
88: TYPE endordpubsiteList IS TABLE OF msc_company_sites.company_site_name%TYPE;

Line 106: TYPE keydateList IS TABLE OF msc_sup_dem_entries.key_date%TYPE;

102: TYPE relnumList IS TABLE OF msc_supdem_lines_interface.release_number%TYPE;
103: TYPE endordList IS TABLE OF msc_supdem_lines_interface.pegging_order_identifier%TYPE;
104: TYPE endlineList IS TABLE OF msc_supdem_lines_interface.ref_line_number%TYPE;
105: TYPE endrelList IS TABLE OF msc_supdem_lines_interface.ref_release_number%TYPE;
106: TYPE keydateList IS TABLE OF msc_sup_dem_entries.key_date%TYPE;
107: TYPE newschedList IS TABLE OF msc_sup_dem_entries.new_schedule_date%TYPE;
108: TYPE shipdateList IS TABLE OF msc_sup_dem_entries.ship_date%TYPE;
109: TYPE receiptdateList IS TABLE OF msc_sup_dem_entries.receipt_date%TYPE;
110: TYPE newordplaceList IS TABLE OF msc_sup_dem_entries.new_order_placement_date%TYPE;

Line 107: TYPE newschedList IS TABLE OF msc_sup_dem_entries.new_schedule_date%TYPE;

103: TYPE endordList IS TABLE OF msc_supdem_lines_interface.pegging_order_identifier%TYPE;
104: TYPE endlineList IS TABLE OF msc_supdem_lines_interface.ref_line_number%TYPE;
105: TYPE endrelList IS TABLE OF msc_supdem_lines_interface.ref_release_number%TYPE;
106: TYPE keydateList IS TABLE OF msc_sup_dem_entries.key_date%TYPE;
107: TYPE newschedList IS TABLE OF msc_sup_dem_entries.new_schedule_date%TYPE;
108: TYPE shipdateList IS TABLE OF msc_sup_dem_entries.ship_date%TYPE;
109: TYPE receiptdateList IS TABLE OF msc_sup_dem_entries.receipt_date%TYPE;
110: TYPE newordplaceList IS TABLE OF msc_sup_dem_entries.new_order_placement_date%TYPE;
111: TYPE origpromList IS TABLE OF msc_sup_dem_entries.original_promised_date%TYPE;

Line 108: TYPE shipdateList IS TABLE OF msc_sup_dem_entries.ship_date%TYPE;

104: TYPE endlineList IS TABLE OF msc_supdem_lines_interface.ref_line_number%TYPE;
105: TYPE endrelList IS TABLE OF msc_supdem_lines_interface.ref_release_number%TYPE;
106: TYPE keydateList IS TABLE OF msc_sup_dem_entries.key_date%TYPE;
107: TYPE newschedList IS TABLE OF msc_sup_dem_entries.new_schedule_date%TYPE;
108: TYPE shipdateList IS TABLE OF msc_sup_dem_entries.ship_date%TYPE;
109: TYPE receiptdateList IS TABLE OF msc_sup_dem_entries.receipt_date%TYPE;
110: TYPE newordplaceList IS TABLE OF msc_sup_dem_entries.new_order_placement_date%TYPE;
111: TYPE origpromList IS TABLE OF msc_sup_dem_entries.original_promised_date%TYPE;
112: TYPE reqdateList IS TABLE OF msc_sup_dem_entries.request_date%TYPE;

Line 109: TYPE receiptdateList IS TABLE OF msc_sup_dem_entries.receipt_date%TYPE;

105: TYPE endrelList IS TABLE OF msc_supdem_lines_interface.ref_release_number%TYPE;
106: TYPE keydateList IS TABLE OF msc_sup_dem_entries.key_date%TYPE;
107: TYPE newschedList IS TABLE OF msc_sup_dem_entries.new_schedule_date%TYPE;
108: TYPE shipdateList IS TABLE OF msc_sup_dem_entries.ship_date%TYPE;
109: TYPE receiptdateList IS TABLE OF msc_sup_dem_entries.receipt_date%TYPE;
110: TYPE newordplaceList IS TABLE OF msc_sup_dem_entries.new_order_placement_date%TYPE;
111: TYPE origpromList IS TABLE OF msc_sup_dem_entries.original_promised_date%TYPE;
112: TYPE reqdateList IS TABLE OF msc_sup_dem_entries.request_date%TYPE;
113: TYPE wipstdatelist IS TABLE OF msc_sup_dem_entries.wip_start_date%TYPE;

Line 110: TYPE newordplaceList IS TABLE OF msc_sup_dem_entries.new_order_placement_date%TYPE;

106: TYPE keydateList IS TABLE OF msc_sup_dem_entries.key_date%TYPE;
107: TYPE newschedList IS TABLE OF msc_sup_dem_entries.new_schedule_date%TYPE;
108: TYPE shipdateList IS TABLE OF msc_sup_dem_entries.ship_date%TYPE;
109: TYPE receiptdateList IS TABLE OF msc_sup_dem_entries.receipt_date%TYPE;
110: TYPE newordplaceList IS TABLE OF msc_sup_dem_entries.new_order_placement_date%TYPE;
111: TYPE origpromList IS TABLE OF msc_sup_dem_entries.original_promised_date%TYPE;
112: TYPE reqdateList IS TABLE OF msc_sup_dem_entries.request_date%TYPE;
113: TYPE wipstdatelist IS TABLE OF msc_sup_dem_entries.wip_start_date%TYPE;
114: TYPE wipenddatelist IS TABLE OF msc_sup_dem_entries.wip_end_date%TYPE;

Line 111: TYPE origpromList IS TABLE OF msc_sup_dem_entries.original_promised_date%TYPE;

107: TYPE newschedList IS TABLE OF msc_sup_dem_entries.new_schedule_date%TYPE;
108: TYPE shipdateList IS TABLE OF msc_sup_dem_entries.ship_date%TYPE;
109: TYPE receiptdateList IS TABLE OF msc_sup_dem_entries.receipt_date%TYPE;
110: TYPE newordplaceList IS TABLE OF msc_sup_dem_entries.new_order_placement_date%TYPE;
111: TYPE origpromList IS TABLE OF msc_sup_dem_entries.original_promised_date%TYPE;
112: TYPE reqdateList IS TABLE OF msc_sup_dem_entries.request_date%TYPE;
113: TYPE wipstdatelist IS TABLE OF msc_sup_dem_entries.wip_start_date%TYPE;
114: TYPE wipenddatelist IS TABLE OF msc_sup_dem_entries.wip_end_date%TYPE;
115: TYPE qtyList IS TABLE OF msc_supdem_lines_interface.quantity%TYPE;

Line 112: TYPE reqdateList IS TABLE OF msc_sup_dem_entries.request_date%TYPE;

108: TYPE shipdateList IS TABLE OF msc_sup_dem_entries.ship_date%TYPE;
109: TYPE receiptdateList IS TABLE OF msc_sup_dem_entries.receipt_date%TYPE;
110: TYPE newordplaceList IS TABLE OF msc_sup_dem_entries.new_order_placement_date%TYPE;
111: TYPE origpromList IS TABLE OF msc_sup_dem_entries.original_promised_date%TYPE;
112: TYPE reqdateList IS TABLE OF msc_sup_dem_entries.request_date%TYPE;
113: TYPE wipstdatelist IS TABLE OF msc_sup_dem_entries.wip_start_date%TYPE;
114: TYPE wipenddatelist IS TABLE OF msc_sup_dem_entries.wip_end_date%TYPE;
115: TYPE qtyList IS TABLE OF msc_supdem_lines_interface.quantity%TYPE;
116: TYPE uomList IS TABLE OF msc_sup_dem_entries.uom_code%TYPE;

Line 113: TYPE wipstdatelist IS TABLE OF msc_sup_dem_entries.wip_start_date%TYPE;

109: TYPE receiptdateList IS TABLE OF msc_sup_dem_entries.receipt_date%TYPE;
110: TYPE newordplaceList IS TABLE OF msc_sup_dem_entries.new_order_placement_date%TYPE;
111: TYPE origpromList IS TABLE OF msc_sup_dem_entries.original_promised_date%TYPE;
112: TYPE reqdateList IS TABLE OF msc_sup_dem_entries.request_date%TYPE;
113: TYPE wipstdatelist IS TABLE OF msc_sup_dem_entries.wip_start_date%TYPE;
114: TYPE wipenddatelist IS TABLE OF msc_sup_dem_entries.wip_end_date%TYPE;
115: TYPE qtyList IS TABLE OF msc_supdem_lines_interface.quantity%TYPE;
116: TYPE uomList IS TABLE OF msc_sup_dem_entries.uom_code%TYPE;
117: TYPE commentList IS TABLE OF msc_supdem_lines_interface.comments%TYPE;

Line 114: TYPE wipenddatelist IS TABLE OF msc_sup_dem_entries.wip_end_date%TYPE;

110: TYPE newordplaceList IS TABLE OF msc_sup_dem_entries.new_order_placement_date%TYPE;
111: TYPE origpromList IS TABLE OF msc_sup_dem_entries.original_promised_date%TYPE;
112: TYPE reqdateList IS TABLE OF msc_sup_dem_entries.request_date%TYPE;
113: TYPE wipstdatelist IS TABLE OF msc_sup_dem_entries.wip_start_date%TYPE;
114: TYPE wipenddatelist IS TABLE OF msc_sup_dem_entries.wip_end_date%TYPE;
115: TYPE qtyList IS TABLE OF msc_supdem_lines_interface.quantity%TYPE;
116: TYPE uomList IS TABLE OF msc_sup_dem_entries.uom_code%TYPE;
117: TYPE commentList IS TABLE OF msc_supdem_lines_interface.comments%TYPE;
118: TYPE carrierList IS TABLE OF msc_supdem_lines_interface.carrier_code%TYPE;

Line 116: TYPE uomList IS TABLE OF msc_sup_dem_entries.uom_code%TYPE;

112: TYPE reqdateList IS TABLE OF msc_sup_dem_entries.request_date%TYPE;
113: TYPE wipstdatelist IS TABLE OF msc_sup_dem_entries.wip_start_date%TYPE;
114: TYPE wipenddatelist IS TABLE OF msc_sup_dem_entries.wip_end_date%TYPE;
115: TYPE qtyList IS TABLE OF msc_supdem_lines_interface.quantity%TYPE;
116: TYPE uomList IS TABLE OF msc_sup_dem_entries.uom_code%TYPE;
117: TYPE commentList IS TABLE OF msc_supdem_lines_interface.comments%TYPE;
118: TYPE carrierList IS TABLE OF msc_supdem_lines_interface.carrier_code%TYPE;
119: TYPE billofladList IS TABLE OF msc_supdem_lines_interface.bill_of_lading_number%TYPE;
120: TYPE trackingList IS TABLE OF msc_supdem_lines_interface.tracking_number%TYPE;

Line 159: TYPE transactionIdList IS TABLE OF msc_sup_dem_entries.transaction_id%TYPE;

155: TYPE rowidList IS TABLE OF ROWID INDEX BY BINARY_INTEGER;
156: TYPE serialLineId IS TABLE OF msc_st_serial_numbers.line_id%TYPE;
157: TYPE serialErrMsg IS TABLE OF msc_st_serial_numbers.err_msg%TYPE;
158: TYPE serialOrderType IS TABLE OF msc_st_serial_numbers.order_type%TYPE;
159: TYPE transactionIdList IS TABLE OF msc_sup_dem_entries.transaction_id%TYPE;
160: TYPE shipCtrlList IS TABLE OF msc_sup_dem_entries.shipping_control%TYPE;
161: TYPE plannerCode IS TABLE OF msc_sup_dem_entries.planner_code%TYPE;--Bug 4424426
162:
163:

Line 160: TYPE shipCtrlList IS TABLE OF msc_sup_dem_entries.shipping_control%TYPE;

156: TYPE serialLineId IS TABLE OF msc_st_serial_numbers.line_id%TYPE;
157: TYPE serialErrMsg IS TABLE OF msc_st_serial_numbers.err_msg%TYPE;
158: TYPE serialOrderType IS TABLE OF msc_st_serial_numbers.order_type%TYPE;
159: TYPE transactionIdList IS TABLE OF msc_sup_dem_entries.transaction_id%TYPE;
160: TYPE shipCtrlList IS TABLE OF msc_sup_dem_entries.shipping_control%TYPE;
161: TYPE plannerCode IS TABLE OF msc_sup_dem_entries.planner_code%TYPE;--Bug 4424426
162:
163:
164: PROCEDURE get_user_id(

Line 161: TYPE plannerCode IS TABLE OF msc_sup_dem_entries.planner_code%TYPE;--Bug 4424426

157: TYPE serialErrMsg IS TABLE OF msc_st_serial_numbers.err_msg%TYPE;
158: TYPE serialOrderType IS TABLE OF msc_st_serial_numbers.order_type%TYPE;
159: TYPE transactionIdList IS TABLE OF msc_sup_dem_entries.transaction_id%TYPE;
160: TYPE shipCtrlList IS TABLE OF msc_sup_dem_entries.shipping_control%TYPE;
161: TYPE plannerCode IS TABLE OF msc_sup_dem_entries.planner_code%TYPE;--Bug 4424426
162:
163:
164: PROCEDURE get_user_id(
165: p_int_control_number IN NUMBER,