APPS.CSTPSMCM dependencies on WIP_CONSTANTS

Line 28: WHERE STATUS = WIP_CONSTANTS.COMPLETED

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;
32:

Line 29: AND COSTED IN (WIP_CONSTANTS.PENDING,WIP_CONSTANTS.ERROR);

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;
32:
33: l_user_id := FND_GLOBAL.USER_ID;

Line 79: costed = WIP_CONSTANTS.PENDING

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
82: AND COSTED IN (WIP_CONSTANTS.PENDING, WIP_CONSTANTS.ERROR);
83:

Line 81: AND status = WIP_CONSTANTS.COMPLETED

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
82: AND COSTED IN (WIP_CONSTANTS.PENDING, WIP_CONSTANTS.ERROR);
83:
84: l_submit_req_id := FND_REQUEST.SUBMIT_REQUEST('BOM',
85: 'CSTPSMCW',

Line 82: AND COSTED IN (WIP_CONSTANTS.PENDING, WIP_CONSTANTS.ERROR);

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
82: AND COSTED IN (WIP_CONSTANTS.PENDING, WIP_CONSTANTS.ERROR);
83:
84: l_submit_req_id := FND_REQUEST.SUBMIT_REQUEST('BOM',
85: 'CSTPSMCW',
86: NULL,