APPS.WMS_STRATEGY_UPGRADE_PVT dependencies on WMS_SELECTION_CRITERIA_TXN_S

Line 107: l_stg_assignment_id wms_selection_criteria_txn.stg_assignment_id%type;

103:
104: ---local variables
105:
106:
107: l_stg_assignment_id wms_selection_criteria_txn.stg_assignment_id%type;
108: l_sequence_number wms_selection_criteria_txn.sequence_number%type;
109: l_rule_type_code wms_selection_criteria_txn.rule_type_code%type;
110: l_return_type_code wms_selection_criteria_txn.return_type_code%type;
111: l_return_type_id wms_selection_criteria_txn.return_type_id%type;

Line 108: l_sequence_number wms_selection_criteria_txn.sequence_number%type;

104: ---local variables
105:
106:
107: l_stg_assignment_id wms_selection_criteria_txn.stg_assignment_id%type;
108: l_sequence_number wms_selection_criteria_txn.sequence_number%type;
109: l_rule_type_code wms_selection_criteria_txn.rule_type_code%type;
110: l_return_type_code wms_selection_criteria_txn.return_type_code%type;
111: l_return_type_id wms_selection_criteria_txn.return_type_id%type;
112: l_enabled_flag wms_selection_criteria_txn.enabled_flag%type;

Line 242: select wms_selection_criteria_txn_s.nextval

238: l_enabled_flag := 1;
239: l_sequence_number := l_seq;
240: l_from_organization_id := l_stg_rec.organization_id;
241:
242: select wms_selection_criteria_txn_s.nextval
243: into l_stg_assignment_id
244: from dual;
245:
246: --- Set the Pk1, Pk2, Pk3, Pk4 and Pk5 from the wms_strategy_assigenment table to the