APPS.CSTPSMCM dependencies on WSM_SPLIT_MERGE_TRANSACTIONS

Line 27: FROM WSM_SPLIT_MERGE_TRANSACTIONS

23: CST_CSTPSMCW_RUNNING EXCEPTION;
24:
25: CURSOR c_ORG_ID IS
26: SELECT DISTINCT organization_id
27: FROM WSM_SPLIT_MERGE_TRANSACTIONS
28: WHERE STATUS = WIP_CONSTANTS.COMPLETED
29: AND COSTED IN (WIP_CONSTANTS.PENDING,WIP_CONSTANTS.ERROR);
30: BEGIN
31: l_stmt_num := 5;

Line 72: SELECT wsm_split_merge_transactions_s.nextval

68: FETCH c_ORG_ID into l_org_id;
69: EXIT WHEN c_ORG_ID%NOTFOUND;
70:
71: l_stmt_num := 20;
72: SELECT wsm_split_merge_transactions_s.nextval
73: INTO l_group_id
74: FROM dual;
75:
76: l_stmt_num := 30;

Line 77: UPDATE wsm_split_merge_transactions

73: INTO l_group_id
74: FROM dual;
75:
76: l_stmt_num := 30;
77: UPDATE wsm_split_merge_transactions
78: SET group_id = l_group_id,
79: costed = WIP_CONSTANTS.PENDING
80: WHERE organization_id = l_org_id
81: AND status = WIP_CONSTANTS.COMPLETED