APPS.WIP_MOVE_VALIDATOR dependencies on WIP_PARAMETERS

Line 1000: FROM wip_parameters wp

996: wmti.source_code <> 'RCV' OR
997: (wmti.source_code = 'RCV' AND
998: NOT EXISTS
999: (SELECT 'X'
1000: FROM wip_parameters wp
1001: WHERE wp.organization_id = wmti.organization_id
1002: AND wp.osp_shop_floor_status =
1003: wsc.shop_floor_status_code))))
1004: RETURNING wmti.transaction_id BULK COLLECT INTO enums;

Line 2276: -- value setup in WIP_PARAMETERS. However it is always an optional info for

2272: END reason_id;
2273:
2274: -- validate scrap_account_id. This value can be either required or optional
2275: -- info for the discrete and repetitive scrap transaction. It depends on the
2276: -- value setup in WIP_PARAMETERS. However it is always an optional info for
2277: -- OSFM txns. If the caller provided this info, it must be valid account_id
2278: PROCEDURE scrap_account_id IS
2279: l_scrap_flag NUMBER;
2280: l_errMsg VARCHAR2(240);

Line 2314: wip_parameters wp

2310: wmti.program_application_id,
2311: wmti.program_id,
2312: wmti.program_update_date
2313: FROM wip_move_txn_interface wmti,
2314: wip_parameters wp
2315: WHERE wp.organization_id = wmti.organization_id
2316: AND wmti.group_id = g_group_id
2317: AND wmti.process_phase = WIP_CONSTANTS.MOVE_VAL
2318: AND wmti.process_status = WIP_CONSTANTS.RUNNING

Line 3232: FROM wip_parameters wp

3228: wmti.source_code <> 'RCV' OR
3229: (wmti.source_code = 'RCV' AND
3230: NOT EXISTS
3231: (SELECT 'X'
3232: FROM wip_parameters wp
3233: WHERE wp.organization_id = wmti.organization_id
3234: AND wp.osp_shop_floor_status =
3235: wsc.shop_floor_status_code))))
3236: RETURNING wmti.transaction_id BULK COLLECT INTO enums;