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_ST_SERIAL_NUMBERS

Line 139: TYPE serialTxnId IS TABLE OF msc_st_serial_numbers.serial_txn_id%TYPE;

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;
140: TYPE serialNumber IS TABLE OF msc_st_serial_numbers.serial_number%TYPE;
141: TYPE attachmentUrl IS TABLE OF msc_st_serial_numbers.attachment_url%TYPE;
142: TYPE userDefined IS TABLE OF msc_st_serial_numbers.user_defined1%TYPE;
143: TYPE creationDate IS TABLE OF msc_st_serial_numbers.creation_date%TYPE;

Line 140: TYPE serialNumber IS TABLE OF msc_st_serial_numbers.serial_number%TYPE;

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;
140: TYPE serialNumber IS TABLE OF msc_st_serial_numbers.serial_number%TYPE;
141: TYPE attachmentUrl IS TABLE OF msc_st_serial_numbers.attachment_url%TYPE;
142: TYPE userDefined IS TABLE OF msc_st_serial_numbers.user_defined1%TYPE;
143: TYPE creationDate IS TABLE OF msc_st_serial_numbers.creation_date%TYPE;
144: TYPE createdBy IS TABLE OF msc_st_serial_numbers.created_by%TYPE;

Line 141: TYPE attachmentUrl IS TABLE OF msc_st_serial_numbers.attachment_url%TYPE;

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;
140: TYPE serialNumber IS TABLE OF msc_st_serial_numbers.serial_number%TYPE;
141: TYPE attachmentUrl IS TABLE OF msc_st_serial_numbers.attachment_url%TYPE;
142: TYPE userDefined IS TABLE OF msc_st_serial_numbers.user_defined1%TYPE;
143: TYPE creationDate IS TABLE OF msc_st_serial_numbers.creation_date%TYPE;
144: TYPE createdBy IS TABLE OF msc_st_serial_numbers.created_by%TYPE;
145: TYPE lastUpdateDate IS TABLE OF msc_st_serial_numbers.last_update_date%TYPE;

Line 142: TYPE userDefined IS TABLE OF msc_st_serial_numbers.user_defined1%TYPE;

138: TYPE eventkeyList IS TABLE OF VARCHAR2(30);
139: TYPE serialTxnId IS TABLE OF msc_st_serial_numbers.serial_txn_id%TYPE;
140: TYPE serialNumber IS TABLE OF msc_st_serial_numbers.serial_number%TYPE;
141: TYPE attachmentUrl IS TABLE OF msc_st_serial_numbers.attachment_url%TYPE;
142: TYPE userDefined IS TABLE OF msc_st_serial_numbers.user_defined1%TYPE;
143: TYPE creationDate IS TABLE OF msc_st_serial_numbers.creation_date%TYPE;
144: TYPE createdBy IS TABLE OF msc_st_serial_numbers.created_by%TYPE;
145: TYPE lastUpdateDate IS TABLE OF msc_st_serial_numbers.last_update_date%TYPE;
146: TYPE lastUpdatedBy IS TABLE OF msc_st_serial_numbers.last_updated_by%TYPE;

Line 143: TYPE creationDate IS TABLE OF msc_st_serial_numbers.creation_date%TYPE;

139: TYPE serialTxnId IS TABLE OF msc_st_serial_numbers.serial_txn_id%TYPE;
140: TYPE serialNumber IS TABLE OF msc_st_serial_numbers.serial_number%TYPE;
141: TYPE attachmentUrl IS TABLE OF msc_st_serial_numbers.attachment_url%TYPE;
142: TYPE userDefined IS TABLE OF msc_st_serial_numbers.user_defined1%TYPE;
143: TYPE creationDate IS TABLE OF msc_st_serial_numbers.creation_date%TYPE;
144: TYPE createdBy IS TABLE OF msc_st_serial_numbers.created_by%TYPE;
145: TYPE lastUpdateDate IS TABLE OF msc_st_serial_numbers.last_update_date%TYPE;
146: TYPE lastUpdatedBy IS TABLE OF msc_st_serial_numbers.last_updated_by%TYPE;
147: TYPE lastUpdateLogin IS TABLE OF msc_st_serial_numbers.last_update_login%TYPE;

Line 144: TYPE createdBy IS TABLE OF msc_st_serial_numbers.created_by%TYPE;

140: TYPE serialNumber IS TABLE OF msc_st_serial_numbers.serial_number%TYPE;
141: TYPE attachmentUrl IS TABLE OF msc_st_serial_numbers.attachment_url%TYPE;
142: TYPE userDefined IS TABLE OF msc_st_serial_numbers.user_defined1%TYPE;
143: TYPE creationDate IS TABLE OF msc_st_serial_numbers.creation_date%TYPE;
144: TYPE createdBy IS TABLE OF msc_st_serial_numbers.created_by%TYPE;
145: TYPE lastUpdateDate IS TABLE OF msc_st_serial_numbers.last_update_date%TYPE;
146: TYPE lastUpdatedBy IS TABLE OF msc_st_serial_numbers.last_updated_by%TYPE;
147: TYPE lastUpdateLogin IS TABLE OF msc_st_serial_numbers.last_update_login%TYPE;
148: TYPE context IS TABLE OF msc_st_serial_numbers.context%TYPE;

Line 145: TYPE lastUpdateDate IS TABLE OF msc_st_serial_numbers.last_update_date%TYPE;

141: TYPE attachmentUrl IS TABLE OF msc_st_serial_numbers.attachment_url%TYPE;
142: TYPE userDefined IS TABLE OF msc_st_serial_numbers.user_defined1%TYPE;
143: TYPE creationDate IS TABLE OF msc_st_serial_numbers.creation_date%TYPE;
144: TYPE createdBy IS TABLE OF msc_st_serial_numbers.created_by%TYPE;
145: TYPE lastUpdateDate IS TABLE OF msc_st_serial_numbers.last_update_date%TYPE;
146: TYPE lastUpdatedBy IS TABLE OF msc_st_serial_numbers.last_updated_by%TYPE;
147: TYPE lastUpdateLogin IS TABLE OF msc_st_serial_numbers.last_update_login%TYPE;
148: TYPE context IS TABLE OF msc_st_serial_numbers.context%TYPE;
149: TYPE attribute IS TABLE OF msc_st_serial_numbers.attribute1%TYPE;

Line 146: TYPE lastUpdatedBy IS TABLE OF msc_st_serial_numbers.last_updated_by%TYPE;

142: TYPE userDefined IS TABLE OF msc_st_serial_numbers.user_defined1%TYPE;
143: TYPE creationDate IS TABLE OF msc_st_serial_numbers.creation_date%TYPE;
144: TYPE createdBy IS TABLE OF msc_st_serial_numbers.created_by%TYPE;
145: TYPE lastUpdateDate IS TABLE OF msc_st_serial_numbers.last_update_date%TYPE;
146: TYPE lastUpdatedBy IS TABLE OF msc_st_serial_numbers.last_updated_by%TYPE;
147: TYPE lastUpdateLogin IS TABLE OF msc_st_serial_numbers.last_update_login%TYPE;
148: TYPE context IS TABLE OF msc_st_serial_numbers.context%TYPE;
149: TYPE attribute IS TABLE OF msc_st_serial_numbers.attribute1%TYPE;
150: TYPE syncIndicator IS TABLE OF msc_st_serial_numbers.sync_indicator%TYPE;

Line 147: TYPE lastUpdateLogin IS TABLE OF msc_st_serial_numbers.last_update_login%TYPE;

143: TYPE creationDate IS TABLE OF msc_st_serial_numbers.creation_date%TYPE;
144: TYPE createdBy IS TABLE OF msc_st_serial_numbers.created_by%TYPE;
145: TYPE lastUpdateDate IS TABLE OF msc_st_serial_numbers.last_update_date%TYPE;
146: TYPE lastUpdatedBy IS TABLE OF msc_st_serial_numbers.last_updated_by%TYPE;
147: TYPE lastUpdateLogin IS TABLE OF msc_st_serial_numbers.last_update_login%TYPE;
148: TYPE context IS TABLE OF msc_st_serial_numbers.context%TYPE;
149: TYPE attribute IS TABLE OF msc_st_serial_numbers.attribute1%TYPE;
150: TYPE syncIndicator IS TABLE OF msc_st_serial_numbers.sync_indicator%TYPE;
151: TYPE rowStatus IS TABLE OF msc_st_serial_numbers.row_status%TYPE;

Line 148: TYPE context IS TABLE OF msc_st_serial_numbers.context%TYPE;

144: TYPE createdBy IS TABLE OF msc_st_serial_numbers.created_by%TYPE;
145: TYPE lastUpdateDate IS TABLE OF msc_st_serial_numbers.last_update_date%TYPE;
146: TYPE lastUpdatedBy IS TABLE OF msc_st_serial_numbers.last_updated_by%TYPE;
147: TYPE lastUpdateLogin IS TABLE OF msc_st_serial_numbers.last_update_login%TYPE;
148: TYPE context IS TABLE OF msc_st_serial_numbers.context%TYPE;
149: TYPE attribute IS TABLE OF msc_st_serial_numbers.attribute1%TYPE;
150: TYPE syncIndicator IS TABLE OF msc_st_serial_numbers.sync_indicator%TYPE;
151: TYPE rowStatus IS TABLE OF msc_st_serial_numbers.row_status%TYPE;
152: TYPE errMsg IS TABLE OF msc_st_serial_numbers.err_msg%TYPE;

Line 149: TYPE attribute IS TABLE OF msc_st_serial_numbers.attribute1%TYPE;

145: TYPE lastUpdateDate IS TABLE OF msc_st_serial_numbers.last_update_date%TYPE;
146: TYPE lastUpdatedBy IS TABLE OF msc_st_serial_numbers.last_updated_by%TYPE;
147: TYPE lastUpdateLogin IS TABLE OF msc_st_serial_numbers.last_update_login%TYPE;
148: TYPE context IS TABLE OF msc_st_serial_numbers.context%TYPE;
149: TYPE attribute IS TABLE OF msc_st_serial_numbers.attribute1%TYPE;
150: TYPE syncIndicator IS TABLE OF msc_st_serial_numbers.sync_indicator%TYPE;
151: TYPE rowStatus IS TABLE OF msc_st_serial_numbers.row_status%TYPE;
152: TYPE errMsg IS TABLE OF msc_st_serial_numbers.err_msg%TYPE;
153: TYPE planId IS TABLE OF msc_serial_numbers.plan_id%TYPE;

Line 150: TYPE syncIndicator IS TABLE OF msc_st_serial_numbers.sync_indicator%TYPE;

146: TYPE lastUpdatedBy IS TABLE OF msc_st_serial_numbers.last_updated_by%TYPE;
147: TYPE lastUpdateLogin IS TABLE OF msc_st_serial_numbers.last_update_login%TYPE;
148: TYPE context IS TABLE OF msc_st_serial_numbers.context%TYPE;
149: TYPE attribute IS TABLE OF msc_st_serial_numbers.attribute1%TYPE;
150: TYPE syncIndicator IS TABLE OF msc_st_serial_numbers.sync_indicator%TYPE;
151: TYPE rowStatus IS TABLE OF msc_st_serial_numbers.row_status%TYPE;
152: TYPE errMsg IS TABLE OF msc_st_serial_numbers.err_msg%TYPE;
153: TYPE planId IS TABLE OF msc_serial_numbers.plan_id%TYPE;
154: TYPE disableDate IS TABLE OF msc_serial_numbers.disable_date%TYPE;

Line 151: TYPE rowStatus IS TABLE OF msc_st_serial_numbers.row_status%TYPE;

147: TYPE lastUpdateLogin IS TABLE OF msc_st_serial_numbers.last_update_login%TYPE;
148: TYPE context IS TABLE OF msc_st_serial_numbers.context%TYPE;
149: TYPE attribute IS TABLE OF msc_st_serial_numbers.attribute1%TYPE;
150: TYPE syncIndicator IS TABLE OF msc_st_serial_numbers.sync_indicator%TYPE;
151: TYPE rowStatus IS TABLE OF msc_st_serial_numbers.row_status%TYPE;
152: TYPE errMsg IS TABLE OF msc_st_serial_numbers.err_msg%TYPE;
153: TYPE planId IS TABLE OF msc_serial_numbers.plan_id%TYPE;
154: TYPE disableDate IS TABLE OF msc_serial_numbers.disable_date%TYPE;
155: TYPE rowidList IS TABLE OF ROWID INDEX BY BINARY_INTEGER;

Line 152: TYPE errMsg IS TABLE OF msc_st_serial_numbers.err_msg%TYPE;

148: TYPE context IS TABLE OF msc_st_serial_numbers.context%TYPE;
149: TYPE attribute IS TABLE OF msc_st_serial_numbers.attribute1%TYPE;
150: TYPE syncIndicator IS TABLE OF msc_st_serial_numbers.sync_indicator%TYPE;
151: TYPE rowStatus IS TABLE OF msc_st_serial_numbers.row_status%TYPE;
152: TYPE errMsg IS TABLE OF msc_st_serial_numbers.err_msg%TYPE;
153: TYPE planId IS TABLE OF msc_serial_numbers.plan_id%TYPE;
154: TYPE disableDate IS TABLE OF msc_serial_numbers.disable_date%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;

Line 156: TYPE serialLineId IS TABLE OF msc_st_serial_numbers.line_id%TYPE;

152: TYPE errMsg IS TABLE OF msc_st_serial_numbers.err_msg%TYPE;
153: TYPE planId IS TABLE OF msc_serial_numbers.plan_id%TYPE;
154: TYPE disableDate IS TABLE OF msc_serial_numbers.disable_date%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;

Line 157: TYPE serialErrMsg IS TABLE OF msc_st_serial_numbers.err_msg%TYPE;

153: TYPE planId IS TABLE OF msc_serial_numbers.plan_id%TYPE;
154: TYPE disableDate IS TABLE OF msc_serial_numbers.disable_date%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

Line 158: TYPE serialOrderType IS TABLE OF msc_st_serial_numbers.order_type%TYPE;

154: TYPE disableDate IS TABLE OF msc_serial_numbers.disable_date%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:

Line 393: -- To improve the perfomance it creates indexes on MSC_ST_SERIAL_NUMBERS

389: ) RETURN NUMBER;
390:
391: --=======================================================================
392: -- These procedure are used to verify and load serial Number information
393: -- To improve the perfomance it creates indexes on MSC_ST_SERIAL_NUMBERS
394: -- abd drops it at the before exiting from the code
395: --====================================================================
396:
397: PROCEDURE serial_validation(