APPS.INV_PICK_RELEASE_PUB dependencies on STANDARD

Line 981: AND wutta.user_task_type_id = mmtt.standard_operation_id

977: AND EXISTS
978: ( SELECT 'x'
979: FROM wms_user_task_type_attributes wutta
980: WHERE wutta.organization_id = mmtt.organization_id
981: AND wutta.user_task_type_id = mmtt.standard_operation_id
982: AND wutta.honor_case_pick_flag = 'Y'
983: )
984: UNION ALL
985: -- Bulk pick parent tasks

Line 999: AND wutta.user_task_type_id = mmtt.standard_operation_id

995: AND EXISTS
996: ( SELECT 'x'
997: FROM wms_user_task_type_attributes wutta
998: WHERE wutta.organization_id = mmtt.organization_id
999: AND wutta.user_task_type_id = mmtt.standard_operation_id
1000: AND wutta.honor_case_pick_flag = 'Y'
1001: );
1002:
1003:

Line 1027: -- Standard Call to check for call compatibility

1023: inv_log_util.g_maintain_log_profile := TRUE; -- Bug 5558315 - duplication so no dependency btw inv_cache and inv_log
1024:
1025: SAVEPOINT Pick_Release_PUB;
1026:
1027: -- Standard Call to check for call compatibility
1028: IF NOT fnd_api.Compatible_API_Call(l_api_version , p_api_version , l_api_name , G_PKG_NAME) THEN
1029: If is_debug then
1030: print_debug('Fnd_APi not compatible','INV_Pick_Release_Pub.Pick_Release');
1031: End If;

Line 3472: -- Standard call to commit

3468: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3469: END IF;
3470: END IF;
3471:
3472: -- Standard call to commit
3473: IF p_commit = fnd_api.g_true THEN
3474: COMMIT;
3475: END IF;
3476:

Line 3477: -- Standard call to get message count and if count is 1, get message info

3473: IF p_commit = fnd_api.g_true THEN
3474: COMMIT;
3475: END IF;
3476:
3477: -- Standard call to get message count and if count is 1, get message info
3478: IF is_debug THEN
3479: print_Debug('x_return_status is ' || x_return_status,
3480: 'Inv_Pick_Release_Pub.Pick_Release');
3481: END IF;

Line 3637: -- Standard Call to check for call compatibility

3633: BEGIN
3634: -- Set savepoint for this API
3635: SAVEPOINT Reserve_Unconfirmed_Qty_PUB;
3636:
3637: -- Standard Call to check for call compatibility
3638: IF NOT fnd_api.Compatible_API_Call(l_api_version
3639: , p_api_version
3640: , l_api_name
3641: , G_PKG_NAME) THEN

Line 3822: -- Standard call to commit

3818: -- Commit if necessary
3819: IF x_return_status <> fnd_api.g_ret_sts_success THEN
3820: ROLLBACK TO Reserve_Unconfirmed_Qty_PUB;
3821: ELSE
3822: -- Standard call to commit
3823: IF p_commit = fnd_api.g_true THEN
3824: COMMIT;
3825: END IF;
3826: END IF;

Line 4084: -- Standard Call to check for call compatibility

4080: BEGIN
4081: -- Set savepoint for this API
4082: SAVEPOINT Reserve_Unconfirmed_Qty_PUB;
4083:
4084: -- Standard Call to check for call compatibility
4085: IF NOT fnd_api.Compatible_API_Call(l_api_version
4086: , p_api_version
4087: , l_api_name
4088: , G_PKG_NAME) THEN

Line 4270: -- Standard call to commit

4266: -- Commit if necessary
4267: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4268: ROLLBACK TO Reserve_Unconfirmed_Qty_PUB;
4269: ELSE
4270: -- Standard call to commit
4271: IF p_commit = fnd_api.g_true THEN
4272: COMMIT;
4273: END IF;
4274: END IF;