DBA Data[Home] [Help]

APPS.PO_VALIDATIONS dependencies on PO_VAL_SHIPMENTS

Line 3438: PO_VAL_SHIPMENTS.days_early_gte_zero(

3434: -- ECO 4503425: Removed the planned item null date check as this
3435: -- has been moved to submission checks
3436:
3437: WHEN c_days_early_gte_zero THEN
3438: PO_VAL_SHIPMENTS.days_early_gte_zero(
3439: p_line_loc_id_tbl => p_line_locations.line_location_id
3440: , p_days_early_rcpt_allowed_tbl => p_line_locations.days_early_receipt_allowed
3441: , x_results => x_results
3442: , x_result_type => l_result_type

Line 3446: PO_VAL_SHIPMENTS.days_late_gte_zero(

3442: , x_result_type => l_result_type
3443: );
3444:
3445: WHEN c_days_late_gte_zero THEN
3446: PO_VAL_SHIPMENTS.days_late_gte_zero(
3447: p_line_loc_id_tbl => p_line_locations.line_location_id
3448: , p_days_late_rcpt_allowed_tbl => p_line_locations.days_late_receipt_allowed
3449: , x_results => x_results
3450: , x_result_type => l_result_type

Line 3454: PO_VAL_SHIPMENTS.rcv_close_tol_within_range(

3450: , x_result_type => l_result_type
3451: );
3452:
3453: WHEN c_rcv_close_tol_within_range THEN
3454: PO_VAL_SHIPMENTS.rcv_close_tol_within_range(
3455: p_line_loc_id_tbl => p_line_locations.line_location_id
3456: , p_receive_close_tolerance_tbl => p_line_locations.receive_close_tolerance
3457: , x_results => x_results
3458: , x_result_type => l_result_type

Line 3462: PO_VAL_SHIPMENTS.over_rcpt_tol_within_range(

3458: , x_result_type => l_result_type
3459: );
3460:
3461: WHEN c_over_rcpt_tol_within_range THEN
3462: PO_VAL_SHIPMENTS.over_rcpt_tol_within_range(
3463: p_line_loc_id_tbl => p_line_locations.line_location_id
3464: , p_qty_rcv_tolerance_tbl => p_line_locations.qty_rcv_tolerance
3465: , x_results => x_results
3466: , x_result_type => l_result_type

Line 3470: PO_VAL_SHIPMENTS.match_4way_check(

3466: , x_result_type => l_result_type
3467: );
3468:
3469: WHEN c_match_4way_check THEN
3470: PO_VAL_SHIPMENTS.match_4way_check(
3471: p_line_loc_id_tbl => p_line_locations.line_location_id
3472: , p_value_basis_tbl => p_line_locations.value_basis --
3473: , p_receipt_required_flag_tbl => p_line_locations.receipt_required_flag
3474: , p_inspection_required_flag_tbl => p_line_locations.inspection_required_flag

Line 3482: PO_VAL_SHIPMENTS.inv_close_tol_range_check(

3478: , x_result_type => l_result_type
3479: );
3480:
3481: WHEN c_inv_close_tol_range_check THEN
3482: PO_VAL_SHIPMENTS.inv_close_tol_range_check(
3483: p_line_loc_id_tbl => p_line_locations.line_location_id
3484: , p_invoice_close_tolerance_tbl => p_line_locations.invoice_close_tolerance
3485: , x_results => x_results
3486: , x_result_type => l_result_type

Line 3490: PO_VAL_SHIPMENTS.need_by_date_open_period_check(

3486: , x_result_type => l_result_type
3487: );
3488:
3489: WHEN c_need_by_date_open_per_check THEN
3490: PO_VAL_SHIPMENTS.need_by_date_open_period_check(
3491: p_line_loc_id_tbl => p_line_locations.line_location_id
3492: --PBWC Message Change Impact: Adding a token
3493: , p_line_id_tbl => p_line_locations.po_line_id
3494: , p_need_by_date_tbl => p_line_locations.need_by_date

Line 3501: PO_VAL_SHIPMENTS.promise_date_open_period_check(

3497: , x_result_type => l_result_type
3498: );
3499:
3500: WHEN c_promise_date_open_per_check THEN
3501: PO_VAL_SHIPMENTS.promise_date_open_period_check(
3502: p_line_loc_id_tbl => p_line_locations.line_location_id
3503: --PBWC Message Change Impact: Adding a token
3504: , p_line_id_tbl => p_line_locations.po_line_id
3505: , p_promised_date_tbl => p_line_locations.promised_date

Line 3512: PO_VAL_SHIPMENTS.ship_to_org_null_check(

3508: , x_result_type => l_result_type
3509: );
3510:
3511: WHEN c_ship_to_org_null_check THEN
3512: PO_VAL_SHIPMENTS.ship_to_org_null_check(
3513: p_line_loc_id_tbl => p_line_locations.line_location_id
3514: , p_ship_to_org_id_tbl => p_line_locations.ship_to_organization_id
3515: , p_shipment_type_tbl => p_line_locations.shipment_type
3516: , x_results => x_results

Line 3521: PO_VAL_SHIPMENTS.ship_to_loc_null_check(

3517: , x_result_type => l_result_type
3518: );
3519:
3520: WHEN c_ship_to_loc_null_check THEN
3521: PO_VAL_SHIPMENTS.ship_to_loc_null_check(
3522: p_line_loc_id_tbl => p_line_locations.line_location_id
3523: , p_ship_to_loc_id_tbl => p_line_locations.ship_to_location_id
3524: , p_shipment_type_tbl => p_line_locations.shipment_type
3525: , x_results => x_results

Line 3530: PO_VAL_SHIPMENTS.ship_num_gt_zero(

3526: , x_result_type => l_result_type
3527: );
3528:
3529: WHEN c_ship_num_gt_zero THEN
3530: PO_VAL_SHIPMENTS.ship_num_gt_zero(
3531: p_line_loc_id_tbl => p_line_locations.line_location_id
3532: , p_shipment_num_tbl => p_line_locations.shipment_num
3533: -- : Pass payment_type
3534: , p_payment_type_tbl => p_line_locations.payment_type

Line 3540: PO_VAL_SHIPMENTS.ship_num_unique_check(

3536: , x_result_type => l_result_type
3537: );
3538:
3539: WHEN c_ship_num_unique_check THEN
3540: PO_VAL_SHIPMENTS.ship_num_unique_check(
3541: p_line_loc_id_tbl => p_line_locations.line_location_id
3542: , p_line_id_tbl => p_line_locations.po_line_id
3543: , p_shipment_num_tbl => p_line_locations.shipment_num
3544: -- : Pass in shipment_type

Line 3551: PO_VAL_SHIPMENTS.is_org_in_current_sob_check(

3547: , x_result_type => l_result_type
3548: );
3549:
3550: WHEN c_is_org_in_current_sob_check THEN
3551: PO_VAL_SHIPMENTS.is_org_in_current_sob_check(
3552: p_line_loc_id_tbl => p_line_locations.line_location_id
3553: --PBWC Message Change Impact: Adding a token
3554: , p_line_id_tbl => p_line_locations.po_line_id
3555: , p_org_id_tbl => p_line_locations.org_id

Line 3563: PO_VAL_SHIPMENTS.quantity_gt_zero(

3559: , x_result_type => l_result_type
3560: );
3561:
3562: WHEN c_ship_qty_gt_zero THEN
3563: PO_VAL_SHIPMENTS.quantity_gt_zero(
3564: p_line_loc_id_tbl => p_line_locations.line_location_id
3565: , p_quantity_tbl => p_line_locations.quantity
3566: , p_shipment_type_tbl => p_line_locations.shipment_type
3567: , p_value_basis_tbl => p_line_locations.value_basis --

Line 3574: PO_VAL_SHIPMENTS.quantity_ge_quantity_exec(

3570: );
3571:
3572: -- : Combine qty billed and rcvd into qty exec
3573: WHEN c_ship_qty_ge_qty_exec THEN
3574: PO_VAL_SHIPMENTS.quantity_ge_quantity_exec(
3575: p_line_loc_id_tbl => p_line_locations.line_location_id
3576: , p_quantity_tbl => p_line_locations.quantity
3577: , x_result_set_id => l_result_set_id
3578: , x_result_type => l_result_type

Line 3583: PO_VAL_SHIPMENTS.amount_gt_zero(

3579: );
3580: --
3581:
3582: WHEN c_ship_amt_gt_zero THEN
3583: PO_VAL_SHIPMENTS.amount_gt_zero(
3584: p_line_loc_id_tbl => p_line_locations.line_location_id
3585: , p_amount_tbl => p_line_locations.amount
3586: , p_shipment_type_tbl => p_line_locations.shipment_type
3587: , p_value_basis_tbl => p_line_locations.value_basis --

Line 3594: PO_VAL_SHIPMENTS.amount_ge_amount_exec(

3590: );
3591:
3592: -- : Combine amt billed and rcvd into amt exec
3593: WHEN c_ship_amt_ge_amt_exec THEN
3594: PO_VAL_SHIPMENTS.amount_ge_amount_exec(
3595: p_line_loc_id_tbl => p_line_locations.line_location_id
3596: , p_amount_tbl => p_line_locations.amount
3597: , x_result_set_id => l_result_set_id
3598: , x_result_type => l_result_type

Line 3604: PO_VAL_SHIPMENTS.ship_sec_quantity_gt_zero(

3600: --
3601:
3602: -- Opm related validation : OPM Integration R12 Start
3603: WHEN c_ship_sec_qty_gt_zero THEN
3604: PO_VAL_SHIPMENTS.ship_sec_quantity_gt_zero(
3605: p_line_loc_id_tbl => p_line_locations.line_location_id
3606: , p_item_id_tbl => p_line_locations.line_item_id
3607: , p_ship_to_org_id_tbl => p_line_locations.ship_to_organization_id
3608: , p_sec_quantity_tbl => p_line_locations.secondary_quantity

Line 3614: PO_VAL_SHIPMENTS.ship_qtys_within_deviation(

3610: , x_result_type => l_result_type
3611: );
3612:
3613: WHEN c_ship_qtys_within_deviation THEN
3614: PO_VAL_SHIPMENTS.ship_qtys_within_deviation(
3615: p_line_loc_id_tbl => p_line_locations.line_location_id
3616: , p_item_id_tbl => p_line_locations.line_item_id
3617: , p_ship_to_org_id_tbl => p_line_locations.ship_to_organization_id
3618: , p_quantity_tbl => p_line_locations.quantity

Line 3629: PO_VAL_SHIPMENTS.unit_of_measure_not_null(

3625: -- Opm related validation : OPM Integration R12 End
3626:
3627: -- Bug 5385686 : Enforce not null check on UOM
3628: WHEN c_unit_of_measure_not_null THEN
3629: PO_VAL_SHIPMENTS.unit_of_measure_not_null(
3630: p_line_loc_id_tbl => p_line_locations.line_location_id
3631: , p_value_basis_tbl => p_line_locations.value_basis
3632: , p_payment_type_tbl => p_line_locations.payment_type
3633: , p_unit_meas_lookup_code_tbl => p_line_locations.unit_meas_lookup_code

Line 3669: PO_VAL_SHIPMENTS2.need_by_date(p_id_tbl => p_line_locations.interface_id,

3665: -- PDOI Shipment Validation Subroutines
3666: --------------------------------------------------------------------------
3667: WHEN c_shipment_need_by_date THEN
3668: -- if purchase_basis is 'TEMP LABOR', the need_by_date column must be null
3669: PO_VAL_SHIPMENTS2.need_by_date(p_id_tbl => p_line_locations.interface_id,
3670: p_purchase_basis_tbl => p_line_locations.purchase_basis,
3671: p_need_by_date_tbl => p_line_locations.need_by_date,
3672: x_results => x_results,
3673: x_result_type => l_result_type);

Line 3676: PO_VAL_SHIPMENTS2.promised_date(p_id_tbl => p_line_locations.interface_id,

3672: x_results => x_results,
3673: x_result_type => l_result_type);
3674: WHEN c_shipment_promised_date THEN
3675: -- if purchase_basis is 'TEMP LABOR', the promised_date must be null
3676: PO_VAL_SHIPMENTS2.promised_date(p_id_tbl => p_line_locations.interface_id,
3677: p_purchase_basis_tbl => p_line_locations.purchase_basis,
3678: p_promised_date_tbl => p_line_locations.promised_date,
3679: x_results => x_results,
3680: x_result_type => l_result_type);

Line 3683: PO_VAL_SHIPMENTS2.shipment_type(p_id_tbl => p_line_locations.interface_id,

3679: x_results => x_results,
3680: x_result_type => l_result_type);
3681: WHEN c_shipment_type_blanket THEN
3682: -- validate shipment type
3683: PO_VAL_SHIPMENTS2.shipment_type(p_id_tbl => p_line_locations.interface_id,
3684: p_shipment_type_tbl => p_line_locations.shipment_type,
3685: p_doc_type => c_doc_type_blanket,
3686: x_results => x_results,
3687: x_result_type => l_result_type);

Line 3690: PO_VAL_SHIPMENTS2.shipment_type(p_id_tbl => p_line_locations.interface_id,

3686: x_results => x_results,
3687: x_result_type => l_result_type);
3688: WHEN c_shipment_type_standard THEN
3689: -- validate shipment type
3690: PO_VAL_SHIPMENTS2.shipment_type(p_id_tbl => p_line_locations.interface_id,
3691: p_shipment_type_tbl => p_line_locations.shipment_type,
3692: p_doc_type => c_doc_type_standard,
3693: x_results => x_results,
3694: x_result_type => l_result_type);

Line 3697: PO_VAL_SHIPMENTS2.shipment_type(p_id_tbl => p_line_locations.interface_id,

3693: x_results => x_results,
3694: x_result_type => l_result_type);
3695: WHEN c_shipment_type_quotation THEN
3696: -- validate shipment type
3697: PO_VAL_SHIPMENTS2.shipment_type(p_id_tbl => p_line_locations.interface_id,
3698: p_shipment_type_tbl => p_line_locations.shipment_type,
3699: p_doc_type => c_doc_type_quotation,
3700: x_results => x_results,
3701: x_result_type => l_result_type);

Line 3705: PO_VAL_SHIPMENTS2.shipment_num(p_id_tbl => p_line_locations.interface_id,

3701: x_result_type => l_result_type);
3702: WHEN c_shipment_num THEN
3703: -- validate shipment num is not null, greater than zero and unique
3704: -- bug 4642348: add two parameters - p_draft_id_tbl, p_doc_type
3705: PO_VAL_SHIPMENTS2.shipment_num(p_id_tbl => p_line_locations.interface_id,
3706: p_shipment_num_tbl => p_line_locations.shipment_num,
3707: p_shipment_type_tbl => p_line_locations.shipment_type,
3708: p_po_header_id_tbl => p_line_locations.po_header_id,
3709: p_po_line_id_tbl => p_line_locations.po_line_id,

Line 3725: PO_VAL_SHIPMENTS2.quantity(p_id_tbl => p_line_locations.interface_id,

3721: x_result_set_id => l_result_set_id,
3722: x_result_type => l_result_type);
3723: WHEN c_shipment_quantity THEN
3724: -- If order_type_lookup_code is RATE or FIXED PRICE, validate quantity is not null
3725: PO_VAL_SHIPMENTS2.quantity(p_id_tbl => p_line_locations.interface_id,
3726: p_quantity_tbl => p_line_locations.quantity,
3727: p_order_type_lookup_code_tbl => p_line_locations.order_type_lookup_code,
3728: x_results => x_results,
3729: x_result_type => l_result_type);

Line 3732: PO_VAL_SHIPMENTS2.price_override(p_id_tbl => p_line_locations.interface_id,

3728: x_results => x_results,
3729: x_result_type => l_result_type);
3730: WHEN c_shipment_price_override THEN
3731: -- If order_type_lookup_code is not FIXED PRICE, price_override cannot be null
3732: PO_VAL_SHIPMENTS2.price_override(p_id_tbl => p_line_locations.interface_id,
3733: p_price_override_tbl => p_line_locations.price_override,
3734: p_order_type_lookup_code_tbl => p_line_locations.order_type_lookup_code,
3735: x_results => x_results,
3736: x_result_type => l_result_type);

Line 3740: PO_VAL_SHIPMENTS2.price_discount(p_id_tbl => p_line_locations.interface_id,

3736: x_result_type => l_result_type);
3737: WHEN c_shipment_price_discount THEN
3738: -- If order_type_lookup_code is not FIXED PRICE, price_discount/price_override cannot both be null
3739: -- and price discount cannot be less than zero or greater than 100
3740: PO_VAL_SHIPMENTS2.price_discount(p_id_tbl => p_line_locations.interface_id,
3741: p_price_discount_tbl => p_line_locations.price_discount,
3742: p_price_override_tbl => p_line_locations.price_override,
3743: p_order_type_lookup_code_tbl => p_line_locations.order_type_lookup_code,
3744: x_results => x_results,

Line 3748: PO_VAL_SHIPMENTS2.ship_to_organization_id(p_id_tbl => p_line_locations.interface_id,

3744: x_results => x_results,
3745: x_result_type => l_result_type);
3746: WHEN c_ship_to_organization_id THEN
3747: -- validate ship_to_organization_id
3748: PO_VAL_SHIPMENTS2.ship_to_organization_id(p_id_tbl => p_line_locations.interface_id,
3749: p_ship_to_organization_id_tbl => p_line_locations.ship_to_organization_id,
3750: p_item_id_tbl => p_line_locations.item_id,
3751: p_item_revision_tbl => p_line_locations.item_revision,
3752: p_ship_to_location_id_tbl => p_line_locations.ship_to_location_id,

Line 3759: PO_VAL_SHIPMENTS2.effective_dates(p_id_tbl => p_line_locations.interface_id,

3755: WHEN c_shipment_effective_dates THEN
3756: -- validate_effective_dates
3757: -- bug5016163
3758: -- Added price break look up code as parameter
3759: PO_VAL_SHIPMENTS2.effective_dates(p_id_tbl => p_line_locations.interface_id,
3760: p_line_expiration_date_tbl => p_line_locations.line_expiration_date,
3761: p_to_date_tbl => p_line_locations.to_date,
3762: p_from_date_tbl => p_line_locations.from_date,
3763: p_header_start_date_tbl => p_line_locations.hdr_start_date,

Line 3770: PO_VAL_SHIPMENTS2.qty_rcv_exception_code(p_id_tbl => p_line_locations.interface_id,

3766: x_results => x_results,
3767: x_result_type => l_result_type);
3768: WHEN c_qty_rcv_exception_code THEN
3769: -- validate qty_rcv_exception_code against PO_LOOKUP_CODES
3770: PO_VAL_SHIPMENTS2.qty_rcv_exception_code(p_id_tbl => p_line_locations.interface_id,
3771: p_qty_rcv_exception_code_tbl => p_line_locations.qty_rcv_exception_code,
3772: x_result_set_id => l_result_set_id,
3773: x_result_type => l_result_type);
3774: WHEN c_enforce_ship_to_loc_code THEN

Line 3777: PO_VAL_SHIPMENTS2.enforce_ship_to_loc_code(p_id_tbl => p_line_locations.interface_id,

3773: x_result_type => l_result_type);
3774: WHEN c_enforce_ship_to_loc_code THEN
3775: -- If shipment_type is STANDARD and enforce_ship_to_loc_code is not equal
3776: -- to NONE, REJECT or WARNING
3777: PO_VAL_SHIPMENTS2.enforce_ship_to_loc_code(p_id_tbl => p_line_locations.interface_id,
3778: p_enforce_ship_to_loc_code_tbl => p_line_locations.enforce_ship_to_location_code,
3779: p_shipment_type_tbl => p_line_locations.shipment_type,
3780: x_results => x_results,
3781: x_result_type => l_result_type);

Line 3785: PO_VAL_SHIPMENTS2.allow_sub_receipts_flag(p_id_tbl => p_line_locations.interface_id,

3781: x_result_type => l_result_type);
3782: WHEN c_allow_sub_receipts_flag THEN
3783: -- If shipment_type is STANDARD and allow_sub_receipts_flag is not equal
3784: -- to NONE, REJECT or WARNING
3785: PO_VAL_SHIPMENTS2.allow_sub_receipts_flag(p_id_tbl => p_line_locations.interface_id,
3786: p_shipment_type_tbl => p_line_locations.shipment_type,
3787: p_allow_sub_receipts_flag_tbl => p_line_locations.allow_substitute_receipts_flag,
3788: x_results => x_results,
3789: x_result_type => l_result_type);

Line 3793: PO_VAL_SHIPMENTS2.days_early_receipt_allowed(p_id_tbl => p_line_locations.interface_id,

3789: x_result_type => l_result_type);
3790: WHEN c_days_early_receipt_allowed THEN
3791: -- If shipment_type is STANDARD and days_early_receipt_allowed is not null
3792: -- and less than zero.
3793: PO_VAL_SHIPMENTS2.days_early_receipt_allowed(p_id_tbl => p_line_locations.interface_id,
3794: p_shipment_type_tbl => p_line_locations.shipment_type,
3795: p_days_early_rcpt_allowed_tbl => p_line_locations.days_early_receipt_allowed,
3796: x_results => x_results,
3797: x_result_type => l_result_type);

Line 3801: PO_VAL_SHIPMENTS2.receipt_days_exception_code(p_id_tbl => p_line_locations.interface_id,

3797: x_result_type => l_result_type);
3798: WHEN c_receipt_days_exception_code THEN
3799: -- If shipment_type is STANDARD and receipt_days_expection_code is not null
3800: -- and not 'NONE', 'REJECT' not 'WARNING'
3801: PO_VAL_SHIPMENTS2.receipt_days_exception_code(p_id_tbl => p_line_locations.interface_id,
3802: p_shipment_type_tbl => p_line_locations.shipment_type,
3803: p_rcpt_days_exception_code_tbl => p_line_locations.receipt_days_exception_code,
3804: x_results => x_results,
3805: x_result_type => l_result_type);

Line 3809: PO_VAL_SHIPMENTS2.invoice_close_tolerance(p_id_tbl => p_line_locations.interface_id,

3805: x_result_type => l_result_type);
3806: WHEN c_invoice_close_tolerance THEN
3807: -- If shipment_type is STANDARD and invoice_close_tolerance is not null
3808: -- and less than or equal to zero or greater than or equal to 100.
3809: PO_VAL_SHIPMENTS2.invoice_close_tolerance(p_id_tbl => p_line_locations.interface_id,
3810: p_shipment_type_tbl => p_line_locations.shipment_type,
3811: p_invoice_close_tolerance_tbl => p_line_locations.invoice_close_tolerance,
3812: x_results => x_results,
3813: x_result_type => l_result_type);

Line 3817: PO_VAL_SHIPMENTS2.receive_close_tolerance(p_id_tbl => p_line_locations.interface_id,

3813: x_result_type => l_result_type);
3814: WHEN c_receive_close_tolerance THEN
3815: -- If shipment_type is STANDARD and receive_close_tolerance is not null
3816: -- and less than or equal to zero or greater than or equal to 100.
3817: PO_VAL_SHIPMENTS2.receive_close_tolerance(p_id_tbl => p_line_locations.interface_id,
3818: p_shipment_type_tbl => p_line_locations.shipment_type,
3819: p_receive_close_tolerance_tbl => p_line_locations.receive_close_tolerance,
3820: x_results => x_results,
3821: x_result_type => l_result_type);

Line 3824: PO_VAL_SHIPMENTS2.receiving_routing_id(p_id_tbl => p_line_locations.interface_id,

3820: x_results => x_results,
3821: x_result_type => l_result_type);
3822: WHEN c_receiving_routing_id THEN
3823: -- Validate that receiving routing id exists in rcv_routing_headers
3824: PO_VAL_SHIPMENTS2.receiving_routing_id(p_id_tbl => p_line_locations.interface_id,
3825: p_shipment_type_tbl => p_line_locations.shipment_type,
3826: p_receiving_routing_id_tbl => p_line_locations.receiving_routing_id,
3827: x_result_set_id => l_result_set_id,
3828: x_result_type => l_result_type);

Line 3831: PO_VAL_SHIPMENTS2.accrue_on_receipt_flag(p_id_tbl => p_line_locations.interface_id,

3827: x_result_set_id => l_result_set_id,
3828: x_result_type => l_result_type);
3829: WHEN c_accrue_on_receipt_flag THEN
3830: -- Validate accrue_on_receipt_flag is Y or N, if not null.
3831: PO_VAL_SHIPMENTS2.accrue_on_receipt_flag(p_id_tbl => p_line_locations.interface_id,
3832: p_accrue_on_receipt_flag_tbl => p_line_locations.accrue_on_receipt_flag,
3833: x_results => x_results,
3834: x_result_type => l_result_type);
3835: WHEN c_fob_lookup_code_line_loc THEN

Line 3836: PO_VAL_SHIPMENTS2.fob_lookup_code(p_id_tbl => p_line_locations.interface_id,

3832: p_accrue_on_receipt_flag_tbl => p_line_locations.accrue_on_receipt_flag,
3833: x_results => x_results,
3834: x_result_type => l_result_type);
3835: WHEN c_fob_lookup_code_line_loc THEN
3836: PO_VAL_SHIPMENTS2.fob_lookup_code(p_id_tbl => p_line_locations.interface_id,
3837: p_fob_lookup_code_tbl => p_line_locations.fob_lookup_code,
3838: x_result_set_id => l_result_set_id,
3839: x_result_type => l_result_type);
3840: WHEN c_freight_terms_line_loc THEN

Line 3841: PO_VAL_SHIPMENTS2.freight_terms(p_id_tbl => p_line_locations.interface_id,

3837: p_fob_lookup_code_tbl => p_line_locations.fob_lookup_code,
3838: x_result_set_id => l_result_set_id,
3839: x_result_type => l_result_type);
3840: WHEN c_freight_terms_line_loc THEN
3841: PO_VAL_SHIPMENTS2.freight_terms(p_id_tbl => p_line_locations.interface_id,
3842: p_freight_terms_tbl => p_line_locations.freight_terms_lookup_code,
3843: x_result_set_id => l_result_set_id,
3844: x_result_type => l_result_type);
3845: WHEN c_freight_carrier_line_loc THEN

Line 3846: PO_VAL_SHIPMENTS2.freight_carrier(p_id_tbl => p_line_locations.interface_id,

3842: p_freight_terms_tbl => p_line_locations.freight_terms_lookup_code,
3843: x_result_set_id => l_result_set_id,
3844: x_result_type => l_result_type);
3845: WHEN c_freight_carrier_line_loc THEN
3846: PO_VAL_SHIPMENTS2.freight_carrier(p_id_tbl => p_line_locations.interface_id,
3847: p_freight_carrier_tbl => p_line_locations.freight_carrier,
3848: p_inventory_org_id => l_inventory_org_id,
3849: x_result_set_id => l_result_set_id,
3850: x_result_type => l_result_type);

Line 3852: PO_VAL_SHIPMENTS2.style_related_info(p_id_tbl => p_line_locations.interface_id,

3848: p_inventory_org_id => l_inventory_org_id,
3849: x_result_set_id => l_result_set_id,
3850: x_result_type => l_result_type);
3851: WHEN c_line_loc_style_related_info THEN
3852: PO_VAL_SHIPMENTS2.style_related_info(p_id_tbl => p_line_locations.interface_id,
3853: p_style_id_tbl => p_line_locations.hdr_style_id,
3854: x_result_set_id => l_result_set_id,
3855: x_result_type => l_result_type);
3856: WHEN c_price_break THEN

Line 3859: PO_VAL_SHIPMENTS2.price_break(p_id_tbl => p_line_locations.interface_id,

3855: x_result_type => l_result_type);
3856: WHEN c_price_break THEN
3857: -- Cannot create price breaks for Amount-Based or Fixed Price lines in a Blanket
3858: -- Purchase Agreement.
3859: PO_VAL_SHIPMENTS2.price_break(p_id_tbl => p_line_locations.interface_id,
3860: p_order_type_lookup_code_tbl => p_line_locations.order_type_lookup_code,
3861: x_results => x_results,
3862: x_result_type => l_result_type);
3863: WHEN c_tax_name THEN

Line 3864: PO_VAL_SHIPMENTS2.tax_name(p_id_tbl => p_line_locations.interface_id,

3860: p_order_type_lookup_code_tbl => p_line_locations.order_type_lookup_code,
3861: x_results => x_results,
3862: x_result_type => l_result_type);
3863: WHEN c_tax_name THEN
3864: PO_VAL_SHIPMENTS2.tax_name(p_id_tbl => p_line_locations.interface_id,
3865: p_tax_name_tbl => p_line_locations.tax_name,
3866: p_tax_code_id_tbl => p_line_locations.tax_code_id,
3867: p_need_by_date_tbl => p_line_locations.need_by_date,
3868: p_allow_tax_code_override => l_allow_tax_code_override,