54: /* Serial_Number_Control_code */
55: G_SERIAL_ITEM CONSTANT NUMBER := 1;
56:
57: /* PL/SQL table types */
58: TYPE headeridList IS TABLE OF msc_supdem_lines_interface.parent_header_id%TYPE;
59: TYPE lineidList IS TABLE OF msc_supdem_lines_interface.line_id%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;
55: G_SERIAL_ITEM CONSTANT NUMBER := 1;
56:
57: /* PL/SQL table types */
58: TYPE headeridList IS TABLE OF msc_supdem_lines_interface.parent_header_id%TYPE;
59: TYPE lineidList IS TABLE OF msc_supdem_lines_interface.line_id%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;
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;
89: TYPE endordpubsidList IS TABLE OF msc_company_sites.company_site_id%TYPE;
96: TYPE itemList IS TABLE OF msc_system_items.item_name%TYPE;
97: TYPE itemidList IS TABLE OF msc_system_items.inventory_item_id%TYPE;
98: TYPE itemdescList IS TABLE OF msc_system_items.description%TYPE;
99: TYPE categoryList IS TABLE OF msc_system_items.category_name%TYPE;
100: TYPE ordernumList IS TABLE OF msc_supdem_lines_interface.order_identifier%TYPE;
101: TYPE linenumList IS TABLE OF msc_supdem_lines_interface.line_number%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;
97: TYPE itemidList IS TABLE OF msc_system_items.inventory_item_id%TYPE;
98: TYPE itemdescList IS TABLE OF msc_system_items.description%TYPE;
99: TYPE categoryList IS TABLE OF msc_system_items.category_name%TYPE;
100: TYPE ordernumList IS TABLE OF msc_supdem_lines_interface.order_identifier%TYPE;
101: TYPE linenumList IS TABLE OF msc_supdem_lines_interface.line_number%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;
98: TYPE itemdescList IS TABLE OF msc_system_items.description%TYPE;
99: TYPE categoryList IS TABLE OF msc_system_items.category_name%TYPE;
100: TYPE ordernumList IS TABLE OF msc_supdem_lines_interface.order_identifier%TYPE;
101: TYPE linenumList IS TABLE OF msc_supdem_lines_interface.line_number%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;
99: TYPE categoryList IS TABLE OF msc_system_items.category_name%TYPE;
100: TYPE ordernumList IS TABLE OF msc_supdem_lines_interface.order_identifier%TYPE;
101: TYPE linenumList IS TABLE OF msc_supdem_lines_interface.line_number%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;
100: TYPE ordernumList IS TABLE OF msc_supdem_lines_interface.order_identifier%TYPE;
101: TYPE linenumList IS TABLE OF msc_supdem_lines_interface.line_number%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;
101: TYPE linenumList IS TABLE OF msc_supdem_lines_interface.line_number%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;
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;
119: TYPE billofladList IS TABLE OF msc_supdem_lines_interface.bill_of_lading_number%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;
121: TYPE vehicleList IS TABLE OF msc_supdem_lines_interface.vehicle_number%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;
121: TYPE vehicleList IS TABLE OF msc_supdem_lines_interface.vehicle_number%TYPE;
122: TYPE containerList IS TABLE OF msc_supdem_lines_interface.container_type%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;
121: TYPE vehicleList IS TABLE OF msc_supdem_lines_interface.vehicle_number%TYPE;
122: TYPE containerList IS TABLE OF msc_supdem_lines_interface.container_type%TYPE;
123: TYPE contqtyList IS TABLE OF msc_supdem_lines_interface.container_qty%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;
121: TYPE vehicleList IS TABLE OF msc_supdem_lines_interface.vehicle_number%TYPE;
122: TYPE containerList IS TABLE OF msc_supdem_lines_interface.container_type%TYPE;
123: TYPE contqtyList IS TABLE OF msc_supdem_lines_interface.container_qty%TYPE;
124: TYPE serialnumList IS TABLE OF msc_supdem_lines_interface.serial_number%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;
121: TYPE vehicleList IS TABLE OF msc_supdem_lines_interface.vehicle_number%TYPE;
122: TYPE containerList IS TABLE OF msc_supdem_lines_interface.container_type%TYPE;
123: TYPE contqtyList IS TABLE OF msc_supdem_lines_interface.container_qty%TYPE;
124: TYPE serialnumList IS TABLE OF msc_supdem_lines_interface.serial_number%TYPE;
125: TYPE attachurlList IS TABLE OF msc_supdem_lines_interface.attachment_url%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;
121: TYPE vehicleList IS TABLE OF msc_supdem_lines_interface.vehicle_number%TYPE;
122: TYPE containerList IS TABLE OF msc_supdem_lines_interface.container_type%TYPE;
123: TYPE contqtyList IS TABLE OF msc_supdem_lines_interface.container_qty%TYPE;
124: TYPE serialnumList IS TABLE OF msc_supdem_lines_interface.serial_number%TYPE;
125: TYPE attachurlList IS TABLE OF msc_supdem_lines_interface.attachment_url%TYPE;
126: TYPE errmsgList IS TABLE OF msc_supdem_lines_interface.err_msg%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;
121: TYPE vehicleList IS TABLE OF msc_supdem_lines_interface.vehicle_number%TYPE;
122: TYPE containerList IS TABLE OF msc_supdem_lines_interface.container_type%TYPE;
123: TYPE contqtyList IS TABLE OF msc_supdem_lines_interface.container_qty%TYPE;
124: TYPE serialnumList IS TABLE OF msc_supdem_lines_interface.serial_number%TYPE;
125: TYPE attachurlList IS TABLE OF msc_supdem_lines_interface.attachment_url%TYPE;
126: TYPE errmsgList IS TABLE OF msc_supdem_lines_interface.err_msg%TYPE;
127: TYPE versionList IS TABLE OF msc_supdem_lines_interface.version%TYPE;
120: TYPE trackingList IS TABLE OF msc_supdem_lines_interface.tracking_number%TYPE;
121: TYPE vehicleList IS TABLE OF msc_supdem_lines_interface.vehicle_number%TYPE;
122: TYPE containerList IS TABLE OF msc_supdem_lines_interface.container_type%TYPE;
123: TYPE contqtyList IS TABLE OF msc_supdem_lines_interface.container_qty%TYPE;
124: TYPE serialnumList IS TABLE OF msc_supdem_lines_interface.serial_number%TYPE;
125: TYPE attachurlList IS TABLE OF msc_supdem_lines_interface.attachment_url%TYPE;
126: TYPE errmsgList IS TABLE OF msc_supdem_lines_interface.err_msg%TYPE;
127: TYPE versionList IS TABLE OF msc_supdem_lines_interface.version%TYPE;
128: TYPE designatorList IS TABLE OF msc_supdem_lines_interface.designator%TYPE;
121: TYPE vehicleList IS TABLE OF msc_supdem_lines_interface.vehicle_number%TYPE;
122: TYPE containerList IS TABLE OF msc_supdem_lines_interface.container_type%TYPE;
123: TYPE contqtyList IS TABLE OF msc_supdem_lines_interface.container_qty%TYPE;
124: TYPE serialnumList IS TABLE OF msc_supdem_lines_interface.serial_number%TYPE;
125: TYPE attachurlList IS TABLE OF msc_supdem_lines_interface.attachment_url%TYPE;
126: TYPE errmsgList IS TABLE OF msc_supdem_lines_interface.err_msg%TYPE;
127: TYPE versionList IS TABLE OF msc_supdem_lines_interface.version%TYPE;
128: TYPE designatorList IS TABLE OF msc_supdem_lines_interface.designator%TYPE;
129: TYPE contextList IS TABLE OF msc_supdem_lines_interface.context%TYPE;
122: TYPE containerList IS TABLE OF msc_supdem_lines_interface.container_type%TYPE;
123: TYPE contqtyList IS TABLE OF msc_supdem_lines_interface.container_qty%TYPE;
124: TYPE serialnumList IS TABLE OF msc_supdem_lines_interface.serial_number%TYPE;
125: TYPE attachurlList IS TABLE OF msc_supdem_lines_interface.attachment_url%TYPE;
126: TYPE errmsgList IS TABLE OF msc_supdem_lines_interface.err_msg%TYPE;
127: TYPE versionList IS TABLE OF msc_supdem_lines_interface.version%TYPE;
128: TYPE designatorList IS TABLE OF msc_supdem_lines_interface.designator%TYPE;
129: TYPE contextList IS TABLE OF msc_supdem_lines_interface.context%TYPE;
130: TYPE attributeList IS TABLE OF msc_supdem_lines_interface.attribute1%TYPE;
123: TYPE contqtyList IS TABLE OF msc_supdem_lines_interface.container_qty%TYPE;
124: TYPE serialnumList IS TABLE OF msc_supdem_lines_interface.serial_number%TYPE;
125: TYPE attachurlList IS TABLE OF msc_supdem_lines_interface.attachment_url%TYPE;
126: TYPE errmsgList IS TABLE OF msc_supdem_lines_interface.err_msg%TYPE;
127: TYPE versionList IS TABLE OF msc_supdem_lines_interface.version%TYPE;
128: TYPE designatorList IS TABLE OF msc_supdem_lines_interface.designator%TYPE;
129: TYPE contextList IS TABLE OF msc_supdem_lines_interface.context%TYPE;
130: TYPE attributeList IS TABLE OF msc_supdem_lines_interface.attribute1%TYPE;
131: TYPE postingpartyList IS TABLE OF msc_supdem_lines_interface.posting_party_name%TYPE;
124: TYPE serialnumList IS TABLE OF msc_supdem_lines_interface.serial_number%TYPE;
125: TYPE attachurlList IS TABLE OF msc_supdem_lines_interface.attachment_url%TYPE;
126: TYPE errmsgList IS TABLE OF msc_supdem_lines_interface.err_msg%TYPE;
127: TYPE versionList IS TABLE OF msc_supdem_lines_interface.version%TYPE;
128: TYPE designatorList IS TABLE OF msc_supdem_lines_interface.designator%TYPE;
129: TYPE contextList IS TABLE OF msc_supdem_lines_interface.context%TYPE;
130: TYPE attributeList IS TABLE OF msc_supdem_lines_interface.attribute1%TYPE;
131: TYPE postingpartyList IS TABLE OF msc_supdem_lines_interface.posting_party_name%TYPE;
132: TYPE lastupdatedateList IS TABLE OF msc_supdem_lines_interface.last_update_date%TYPE; -- Bug # 5599903
125: TYPE attachurlList IS TABLE OF msc_supdem_lines_interface.attachment_url%TYPE;
126: TYPE errmsgList IS TABLE OF msc_supdem_lines_interface.err_msg%TYPE;
127: TYPE versionList IS TABLE OF msc_supdem_lines_interface.version%TYPE;
128: TYPE designatorList IS TABLE OF msc_supdem_lines_interface.designator%TYPE;
129: TYPE contextList IS TABLE OF msc_supdem_lines_interface.context%TYPE;
130: TYPE attributeList IS TABLE OF msc_supdem_lines_interface.attribute1%TYPE;
131: TYPE postingpartyList IS TABLE OF msc_supdem_lines_interface.posting_party_name%TYPE;
132: TYPE lastupdatedateList IS TABLE OF msc_supdem_lines_interface.last_update_date%TYPE; -- Bug # 5599903
133: TYPE lastupdatedbyList IS TABLE OF msc_supdem_lines_interface.last_updated_by%TYPE;
126: TYPE errmsgList IS TABLE OF msc_supdem_lines_interface.err_msg%TYPE;
127: TYPE versionList IS TABLE OF msc_supdem_lines_interface.version%TYPE;
128: TYPE designatorList IS TABLE OF msc_supdem_lines_interface.designator%TYPE;
129: TYPE contextList IS TABLE OF msc_supdem_lines_interface.context%TYPE;
130: TYPE attributeList IS TABLE OF msc_supdem_lines_interface.attribute1%TYPE;
131: TYPE postingpartyList IS TABLE OF msc_supdem_lines_interface.posting_party_name%TYPE;
132: TYPE lastupdatedateList IS TABLE OF msc_supdem_lines_interface.last_update_date%TYPE; -- Bug # 5599903
133: TYPE lastupdatedbyList IS TABLE OF msc_supdem_lines_interface.last_updated_by%TYPE;
134: TYPE syncList IS TABLE OF msc_supdem_lines_interface.sync_indicator%TYPE; --Fix for bug 6147298
127: TYPE versionList IS TABLE OF msc_supdem_lines_interface.version%TYPE;
128: TYPE designatorList IS TABLE OF msc_supdem_lines_interface.designator%TYPE;
129: TYPE contextList IS TABLE OF msc_supdem_lines_interface.context%TYPE;
130: TYPE attributeList IS TABLE OF msc_supdem_lines_interface.attribute1%TYPE;
131: TYPE postingpartyList IS TABLE OF msc_supdem_lines_interface.posting_party_name%TYPE;
132: TYPE lastupdatedateList IS TABLE OF msc_supdem_lines_interface.last_update_date%TYPE; -- Bug # 5599903
133: TYPE lastupdatedbyList IS TABLE OF msc_supdem_lines_interface.last_updated_by%TYPE;
134: TYPE syncList IS TABLE OF msc_supdem_lines_interface.sync_indicator%TYPE; --Fix for bug 6147298
135: TYPE delqtyList IS TABLE OF msc_supdem_lines_interface.quantity%TYPE; --Fix for bug 6147298
128: TYPE designatorList IS TABLE OF msc_supdem_lines_interface.designator%TYPE;
129: TYPE contextList IS TABLE OF msc_supdem_lines_interface.context%TYPE;
130: TYPE attributeList IS TABLE OF msc_supdem_lines_interface.attribute1%TYPE;
131: TYPE postingpartyList IS TABLE OF msc_supdem_lines_interface.posting_party_name%TYPE;
132: TYPE lastupdatedateList IS TABLE OF msc_supdem_lines_interface.last_update_date%TYPE; -- Bug # 5599903
133: TYPE lastupdatedbyList IS TABLE OF msc_supdem_lines_interface.last_updated_by%TYPE;
134: TYPE syncList IS TABLE OF msc_supdem_lines_interface.sync_indicator%TYPE; --Fix for bug 6147298
135: TYPE delqtyList IS TABLE OF msc_supdem_lines_interface.quantity%TYPE; --Fix for bug 6147298
136: TYPE numList IS TABLE OF NUMBER;
129: TYPE contextList IS TABLE OF msc_supdem_lines_interface.context%TYPE;
130: TYPE attributeList IS TABLE OF msc_supdem_lines_interface.attribute1%TYPE;
131: TYPE postingpartyList IS TABLE OF msc_supdem_lines_interface.posting_party_name%TYPE;
132: TYPE lastupdatedateList IS TABLE OF msc_supdem_lines_interface.last_update_date%TYPE; -- Bug # 5599903
133: TYPE lastupdatedbyList IS TABLE OF msc_supdem_lines_interface.last_updated_by%TYPE;
134: TYPE syncList IS TABLE OF msc_supdem_lines_interface.sync_indicator%TYPE; --Fix for bug 6147298
135: TYPE delqtyList IS TABLE OF msc_supdem_lines_interface.quantity%TYPE; --Fix for bug 6147298
136: TYPE numList IS TABLE OF NUMBER;
137: TYPE usernameList IS TABLE OF fnd_user.user_name%TYPE;
130: TYPE attributeList IS TABLE OF msc_supdem_lines_interface.attribute1%TYPE;
131: TYPE postingpartyList IS TABLE OF msc_supdem_lines_interface.posting_party_name%TYPE;
132: TYPE lastupdatedateList IS TABLE OF msc_supdem_lines_interface.last_update_date%TYPE; -- Bug # 5599903
133: TYPE lastupdatedbyList IS TABLE OF msc_supdem_lines_interface.last_updated_by%TYPE;
134: TYPE syncList IS TABLE OF msc_supdem_lines_interface.sync_indicator%TYPE; --Fix for bug 6147298
135: TYPE delqtyList IS TABLE OF msc_supdem_lines_interface.quantity%TYPE; --Fix for bug 6147298
136: TYPE numList IS TABLE OF NUMBER;
137: TYPE usernameList IS TABLE OF fnd_user.user_name%TYPE;
138: TYPE eventkeyList IS TABLE OF VARCHAR2(30);
131: TYPE postingpartyList IS TABLE OF msc_supdem_lines_interface.posting_party_name%TYPE;
132: TYPE lastupdatedateList IS TABLE OF msc_supdem_lines_interface.last_update_date%TYPE; -- Bug # 5599903
133: TYPE lastupdatedbyList IS TABLE OF msc_supdem_lines_interface.last_updated_by%TYPE;
134: TYPE syncList IS TABLE OF msc_supdem_lines_interface.sync_indicator%TYPE; --Fix for bug 6147298
135: TYPE delqtyList IS TABLE OF msc_supdem_lines_interface.quantity%TYPE; --Fix for bug 6147298
136: TYPE numList IS TABLE OF NUMBER;
137: TYPE usernameList IS TABLE OF fnd_user.user_name%TYPE;
138: TYPE eventkeyList IS TABLE OF VARCHAR2(30);
139: TYPE serialTxnId IS TABLE OF msc_st_serial_numbers.serial_txn_id%TYPE;