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:
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;
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:
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',
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,