APPS.WIP_MOVE_VALIDATOR dependencies on WIP_PARAMETERS

Line 999: FROM wip_parameters wp

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

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

2204: END reason_id;
2205:
2206: -- validate scrap_account_id. This value can be either required or optional
2207: -- info for the discrete and repetitive scrap transaction. It depends on the
2208: -- value setup in WIP_PARAMETERS. However it is always an optional info for
2209: -- OSFM txns. If the caller provided this info, it must be valid account_id
2210: PROCEDURE scrap_account_id IS
2211: l_scrap_flag NUMBER;
2212: l_errMsg VARCHAR2(240);

Line 2246: wip_parameters wp

2242: wmti.program_application_id,
2243: wmti.program_id,
2244: wmti.program_update_date
2245: FROM wip_move_txn_interface wmti,
2246: wip_parameters wp
2247: WHERE wp.organization_id = wmti.organization_id
2248: AND wmti.group_id = g_group_id
2249: AND wmti.process_phase = WIP_CONSTANTS.MOVE_VAL
2250: AND wmti.process_status = WIP_CONSTANTS.RUNNING

Line 3163: FROM wip_parameters wp

3159: wmti.source_code <> 'RCV' OR
3160: (wmti.source_code = 'RCV' AND
3161: NOT EXISTS
3162: (SELECT 'X'
3163: FROM wip_parameters wp
3164: WHERE wp.organization_id = wmti.organization_id
3165: AND wp.osp_shop_floor_status =
3166: wsc.shop_floor_status_code))))
3167: RETURNING wmti.transaction_id BULK COLLECT INTO enums;