DBA Data[Home] [Help]

APPS.CSP_MTL_TRANSACTIONS_PKG dependencies on STANDARD

Line 201: p_STANDARD_OPERATION_ID NUMBER,

197: p_TASK_GROUP_ID NUMBER,
198: p_PICK_SLIP_NUMBER NUMBER,
199: p_RESERVATION_ID NUMBER,
200: p_TRANSACTION_STATUS NUMBER,
201: p_STANDARD_OPERATION_ID NUMBER,
202: p_TASK_PRIORITY NUMBER,
203: p_WMS_TASK_TYPE NUMBER,
204: p_PARENT_LINE_ID NUMBER)
205: -- P_SOURCE_LOT_NUMBER NUMBER)

Line 402: STANDARD_OPERATION_ID,

398: TASK_GROUP_ID,
399: PICK_SLIP_NUMBER,
400: RESERVATION_ID,
401: TRANSACTION_STATUS,
402: STANDARD_OPERATION_ID,
403: TASK_PRIORITY,
404: WMS_TASK_TYPE,
405: PARENT_LINE_ID
406: --SOURCE_LOT_NUMBER

Line 594: decode( p_STANDARD_OPERATION_ID, FND_API.G_MISS_NUM, NULL, p_STANDARD_OPERATION_ID),

590: decode( p_TASK_GROUP_ID, FND_API.G_MISS_NUM, NULL, p_TASK_GROUP_ID),
591: decode( p_PICK_SLIP_NUMBER, FND_API.G_MISS_NUM, NULL, p_PICK_SLIP_NUMBER),
592: decode( p_RESERVATION_ID, FND_API.G_MISS_NUM, NULL, p_RESERVATION_ID),
593: decode( p_TRANSACTION_STATUS, FND_API.G_MISS_NUM, NULL, p_TRANSACTION_STATUS),
594: decode( p_STANDARD_OPERATION_ID, FND_API.G_MISS_NUM, NULL, p_STANDARD_OPERATION_ID),
595: decode( p_TASK_PRIORITY, FND_API.G_MISS_NUM, NULL, p_TASK_PRIORITY),
596: decode( p_WMS_TASK_TYPE, FND_API.G_MISS_NUM, NULL, p_WMS_TASK_TYPE),
597: decode( p_PARENT_LINE_ID, FND_API.G_MISS_NUM, NULL, p_PARENT_LINE_ID)
598: -- decode( P_SOURCE_LOT_NUMBER, FND_API.G_MISS_NUM, NULL, p_SOURCE_LOT_NUMBER)

Line 789: p_STANDARD_OPERATION_ID NUMBER,

785: p_TASK_GROUP_ID NUMBER,
786: p_PICK_SLIP_NUMBER NUMBER,
787: p_RESERVATION_ID NUMBER,
788: p_TRANSACTION_STATUS NUMBER,
789: p_STANDARD_OPERATION_ID NUMBER,
790: P_TASK_PRIORITY NUMBER,
791: p_WMS_TASK_TYPE NUMBER,
792: p_PARENT_LINE_ID NUMBER)
793: -- P_SOURCE_LOT_NUMBER NUMBER)

Line 984: STANDARD_OPERATION_ID = decode( p_STANDARD_OPERATION_ID, FND_API.G_MISS_NUM, STANDARD_OPERATION_ID, p_STANDARD_OPERATION_ID),

980: TASK_GROUP_ID = decode( p_TASK_GROUP_ID, FND_API.G_MISS_NUM, TASK_GROUP_ID, p_TASK_GROUP_ID),
981: PICK_SLIP_NUMBER = decode( p_PICK_SLIP_NUMBER, FND_API.G_MISS_NUM, PICK_SLIP_NUMBER, p_PICK_SLIP_NUMBER),
982: RESERVATION_ID = decode( p_RESERVATION_ID, FND_API.G_MISS_NUM, RESERVATION_ID, p_RESERVATION_ID),
983: TRANSACTION_STATUS = decode( p_TRANSACTION_STATUS, FND_API.G_MISS_NUM, TRANSACTION_STATUS, p_TRANSACTION_STATUS),
984: STANDARD_OPERATION_ID = decode( p_STANDARD_OPERATION_ID, FND_API.G_MISS_NUM, STANDARD_OPERATION_ID, p_STANDARD_OPERATION_ID),
985: TASK_PRIORITY = decode( p_TASK_PRIORITY, FND_API.G_MISS_NUM, TASK_PRIORITY, p_TASK_PRIORITY),
986: WMS_TASK_TYPE = decode( p_WMS_TASK_TYPE, FND_API.G_MISS_NUM, WMS_TASK_TYPE, p_WMS_TASK_TYPE),
987: PARENT_LINE_ID = decode( p_PARENT_LINE_ID, FND_API.G_MISS_NUM, PARENT_LINE_ID, p_PARENT_LINE_ID)
988: -- SOURCE_LOT_NUMBER = decode( P_SOURCE_LOT_NUMBER, FND_API.G_MISS_NUM, SOURCE_LOT_NUMBER, p_SOURCE_LOT_NUMBER)

Line 1194: P_STANDARD_OPERATION_ID NUMBER,

1190: p_TASK_GROUP_ID NUMBER,
1191: p_PICK_SLIP_NUMBER NUMBER,
1192: p_RESERVATION_ID NUMBER,
1193: p_TRANSACTION_STATUS NUMBER,
1194: P_STANDARD_OPERATION_ID NUMBER,
1195: P_TASK_PRIORITY NUMBER,
1196: p_WMS_TASK_TYPE NUMBER,
1197: p_PARENT_LINE_ID NUMBER)
1198: -- P_SOURCE_LOT_NUMBER NUMBER)

Line 1777: AND ( ( Recinfo.STANDARD_OPERATION_ID = p_STANDARD_OPERATION_ID)

1773: AND ( p_RESERVATION_ID IS NULL )))
1774: AND ( ( Recinfo.TRANSACTION_STATUS = p_TRANSACTION_STATUS)
1775: OR ( ( Recinfo.TRANSACTION_STATUS IS NULL )
1776: AND ( p_TRANSACTION_STATUS IS NULL )))
1777: AND ( ( Recinfo.STANDARD_OPERATION_ID = p_STANDARD_OPERATION_ID)
1778: OR ( ( Recinfo.STANDARD_OPERATION_ID IS NULL )
1779: AND ( p_STANDARD_OPERATION_ID IS NULL )))
1780: AND ( ( Recinfo.TASK_PRIORITY = p_TASK_PRIORITY)
1781: OR ( ( Recinfo.TASK_PRIORITY IS NULL )

Line 1778: OR ( ( Recinfo.STANDARD_OPERATION_ID IS NULL )

1774: AND ( ( Recinfo.TRANSACTION_STATUS = p_TRANSACTION_STATUS)
1775: OR ( ( Recinfo.TRANSACTION_STATUS IS NULL )
1776: AND ( p_TRANSACTION_STATUS IS NULL )))
1777: AND ( ( Recinfo.STANDARD_OPERATION_ID = p_STANDARD_OPERATION_ID)
1778: OR ( ( Recinfo.STANDARD_OPERATION_ID IS NULL )
1779: AND ( p_STANDARD_OPERATION_ID IS NULL )))
1780: AND ( ( Recinfo.TASK_PRIORITY = p_TASK_PRIORITY)
1781: OR ( ( Recinfo.TASK_PRIORITY IS NULL )
1782: AND ( p_TASK_PRIORITY IS NULL )))

Line 1779: AND ( p_STANDARD_OPERATION_ID IS NULL )))

1775: OR ( ( Recinfo.TRANSACTION_STATUS IS NULL )
1776: AND ( p_TRANSACTION_STATUS IS NULL )))
1777: AND ( ( Recinfo.STANDARD_OPERATION_ID = p_STANDARD_OPERATION_ID)
1778: OR ( ( Recinfo.STANDARD_OPERATION_ID IS NULL )
1779: AND ( p_STANDARD_OPERATION_ID IS NULL )))
1780: AND ( ( Recinfo.TASK_PRIORITY = p_TASK_PRIORITY)
1781: OR ( ( Recinfo.TASK_PRIORITY IS NULL )
1782: AND ( p_TASK_PRIORITY IS NULL )))
1783: AND ( ( Recinfo.WMS_TASK_TYPE = p_WMS_TASK_TYPE)