APPS.PO_VAL_DISTRIBUTIONS dependencies on PO_TBL_NUMBER

Line 126: p_dist_id_tbl IN PO_TBL_NUMBER

122: -- Assumption:
123: -- All of the unposted distribution data will be passed in
124: -- to this routine in order to get accurate results.
125: PROCEDURE dist_num_unique(
126: p_dist_id_tbl IN PO_TBL_NUMBER
127: , p_line_loc_id_tbl IN PO_TBL_NUMBER
128: , p_dist_num_tbl IN PO_TBL_NUMBER
129: , p_par_draft_id_tbl IN PO_TBL_VARCHAR4000 DEFAULT NULL --
130: , p_draft_id_tbl IN PO_TBL_NUMBER --

Line 127: , p_line_loc_id_tbl IN PO_TBL_NUMBER

123: -- All of the unposted distribution data will be passed in
124: -- to this routine in order to get accurate results.
125: PROCEDURE dist_num_unique(
126: p_dist_id_tbl IN PO_TBL_NUMBER
127: , p_line_loc_id_tbl IN PO_TBL_NUMBER
128: , p_dist_num_tbl IN PO_TBL_NUMBER
129: , p_par_draft_id_tbl IN PO_TBL_VARCHAR4000 DEFAULT NULL --
130: , p_draft_id_tbl IN PO_TBL_NUMBER --
131: , x_result_set_id IN OUT NOCOPY NUMBER

Line 128: , p_dist_num_tbl IN PO_TBL_NUMBER

124: -- to this routine in order to get accurate results.
125: PROCEDURE dist_num_unique(
126: p_dist_id_tbl IN PO_TBL_NUMBER
127: , p_line_loc_id_tbl IN PO_TBL_NUMBER
128: , p_dist_num_tbl IN PO_TBL_NUMBER
129: , p_par_draft_id_tbl IN PO_TBL_VARCHAR4000 DEFAULT NULL --
130: , p_draft_id_tbl IN PO_TBL_NUMBER --
131: , x_result_set_id IN OUT NOCOPY NUMBER
132: , x_result_type OUT NOCOPY VARCHAR2

Line 130: , p_draft_id_tbl IN PO_TBL_NUMBER --

126: p_dist_id_tbl IN PO_TBL_NUMBER
127: , p_line_loc_id_tbl IN PO_TBL_NUMBER
128: , p_dist_num_tbl IN PO_TBL_NUMBER
129: , p_par_draft_id_tbl IN PO_TBL_VARCHAR4000 DEFAULT NULL --
130: , p_draft_id_tbl IN PO_TBL_NUMBER --
131: , x_result_set_id IN OUT NOCOPY NUMBER
132: , x_result_type OUT NOCOPY VARCHAR2
133: )
134: IS

Line 155: p_dist_id_tbl IN PO_TBL_NUMBER

151: -----------------------------------------------------------------------------
152: -- Checks for null or non-positive distribution numbers.
153: -----------------------------------------------------------------------------
154: PROCEDURE dist_num_gt_zero(
155: p_dist_id_tbl IN PO_TBL_NUMBER
156: , p_dist_num_tbl IN PO_TBL_NUMBER
157: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
158: , x_result_type OUT NOCOPY VARCHAR2
159: )

Line 156: , p_dist_num_tbl IN PO_TBL_NUMBER

152: -- Checks for null or non-positive distribution numbers.
153: -----------------------------------------------------------------------------
154: PROCEDURE dist_num_gt_zero(
155: p_dist_id_tbl IN PO_TBL_NUMBER
156: , p_dist_num_tbl IN PO_TBL_NUMBER
157: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
158: , x_result_type OUT NOCOPY VARCHAR2
159: )
160: IS

Line 183: p_dist_id_tbl IN PO_TBL_NUMBER

179: -- Validates that quantity is not null and greater than zero if it is not
180: -- a Rate or Fixed Price line.
181: -----------------------------------------------------------------------------
182: PROCEDURE quantity_gt_zero(
183: p_dist_id_tbl IN PO_TBL_NUMBER
184: , p_qty_ordered_tbl IN PO_TBL_NUMBER
185: , p_value_basis_tbl IN PO_TBL_VARCHAR30 --
186: , p_cost_constraint_tbl IN PO_TBL_VARCHAR30
187: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

Line 184: , p_qty_ordered_tbl IN PO_TBL_NUMBER

180: -- a Rate or Fixed Price line.
181: -----------------------------------------------------------------------------
182: PROCEDURE quantity_gt_zero(
183: p_dist_id_tbl IN PO_TBL_NUMBER
184: , p_qty_ordered_tbl IN PO_TBL_NUMBER
185: , p_value_basis_tbl IN PO_TBL_VARCHAR30 --
186: , p_cost_constraint_tbl IN PO_TBL_VARCHAR30
187: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
188: , x_result_type OUT NOCOPY VARCHAR2

Line 189: , p_header_id_tbl IN PO_TBL_NUMBER --

185: , p_value_basis_tbl IN PO_TBL_VARCHAR30 --
186: , p_cost_constraint_tbl IN PO_TBL_VARCHAR30
187: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
188: , x_result_type OUT NOCOPY VARCHAR2
189: , p_header_id_tbl IN PO_TBL_NUMBER --
190: )
191: IS
192: l_input_size NUMBER;
193: l_clm_info_flag_tbl PO_TBL_VARCHAR1;

Line 234: p_dist_id_tbl IN PO_TBL_NUMBER

230: -- This check is only performed if quantity is being reduced below the
231: -- current transaction quantity, since over-billing/delivery is allowed.
232: -----------------------------------------------------------------------------
233: PROCEDURE quantity_ge_quantity_exec(
234: p_dist_id_tbl IN PO_TBL_NUMBER
235: , p_dist_type_tbl IN PO_TBL_VARCHAR30
236: , p_qty_ordered_tbl IN PO_TBL_NUMBER
237: , x_result_set_id IN OUT NOCOPY NUMBER
238: , x_result_type OUT NOCOPY VARCHAR2

Line 236: , p_qty_ordered_tbl IN PO_TBL_NUMBER

232: -----------------------------------------------------------------------------
233: PROCEDURE quantity_ge_quantity_exec(
234: p_dist_id_tbl IN PO_TBL_NUMBER
235: , p_dist_type_tbl IN PO_TBL_VARCHAR30
236: , p_qty_ordered_tbl IN PO_TBL_NUMBER
237: , x_result_set_id IN OUT NOCOPY NUMBER
238: , x_result_type OUT NOCOPY VARCHAR2
239: )
240: IS

Line 336: p_dist_id_tbl IN PO_TBL_NUMBER

332: -- Validates that amount is not null and greater than zero if the line is
333: -- Rate or Fixed Price.
334: -----------------------------------------------------------------------------
335: PROCEDURE amount_gt_zero(
336: p_dist_id_tbl IN PO_TBL_NUMBER
337: , p_amt_ordered_tbl IN PO_TBL_NUMBER
338: , p_value_basis_tbl IN PO_TBL_VARCHAR30 --
339: , p_cost_constraint_tbl IN PO_TBL_VARCHAR30
340: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

Line 337: , p_amt_ordered_tbl IN PO_TBL_NUMBER

333: -- Rate or Fixed Price.
334: -----------------------------------------------------------------------------
335: PROCEDURE amount_gt_zero(
336: p_dist_id_tbl IN PO_TBL_NUMBER
337: , p_amt_ordered_tbl IN PO_TBL_NUMBER
338: , p_value_basis_tbl IN PO_TBL_VARCHAR30 --
339: , p_cost_constraint_tbl IN PO_TBL_VARCHAR30
340: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
341: , x_result_type OUT NOCOPY VARCHAR2

Line 342: , p_header_id_tbl IN PO_TBL_NUMBER --

338: , p_value_basis_tbl IN PO_TBL_VARCHAR30 --
339: , p_cost_constraint_tbl IN PO_TBL_VARCHAR30
340: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
341: , x_result_type OUT NOCOPY VARCHAR2
342: , p_header_id_tbl IN PO_TBL_NUMBER --
343: )
344: IS
345: l_input_size NUMBER;
346: l_clm_info_flag_tbl PO_TBL_VARCHAR1;

Line 386: p_dist_id_tbl IN PO_TBL_NUMBER

382: -- This check is only performed if amount is being reduced below the
383: -- current transaction amount, since over-delivery/billing is allowed.
384: -----------------------------------------------------------------------------
385: PROCEDURE amount_ge_amount_exec(
386: p_dist_id_tbl IN PO_TBL_NUMBER
387: , p_dist_type_tbl IN PO_TBL_VARCHAR30
388: , p_amt_ordered_tbl IN PO_TBL_NUMBER
389: , x_result_set_id IN OUT NOCOPY NUMBER
390: , x_result_type OUT NOCOPY VARCHAR2

Line 388: , p_amt_ordered_tbl IN PO_TBL_NUMBER

384: -----------------------------------------------------------------------------
385: PROCEDURE amount_ge_amount_exec(
386: p_dist_id_tbl IN PO_TBL_NUMBER
387: , p_dist_type_tbl IN PO_TBL_VARCHAR30
388: , p_amt_ordered_tbl IN PO_TBL_NUMBER
389: , x_result_set_id IN OUT NOCOPY NUMBER
390: , x_result_type OUT NOCOPY VARCHAR2
391: )
392: IS

Line 493: p_dist_id_tbl IN PO_TBL_NUMBER

489: --
490: -- Where clauses derived from PJM_UNIT_EFF.UNIT_EFFECTIVE_ITEM
491: ------------------------------------------------------------------------
492: PROCEDURE pjm_unit_number_effective(
493: p_dist_id_tbl IN PO_TBL_NUMBER
494: , p_end_item_unit_number_tbl IN PO_TBL_VARCHAR30
495: , p_item_id_tbl IN PO_TBL_NUMBER
496: , p_ship_to_org_id_tbl IN PO_TBL_NUMBER
497: -- Bug# 4338241: Checking if it is inventory and PJM is installed

Line 495: , p_item_id_tbl IN PO_TBL_NUMBER

491: ------------------------------------------------------------------------
492: PROCEDURE pjm_unit_number_effective(
493: p_dist_id_tbl IN PO_TBL_NUMBER
494: , p_end_item_unit_number_tbl IN PO_TBL_VARCHAR30
495: , p_item_id_tbl IN PO_TBL_NUMBER
496: , p_ship_to_org_id_tbl IN PO_TBL_NUMBER
497: -- Bug# 4338241: Checking if it is inventory and PJM is installed
498: , p_destination_type_code_tbl IN PO_TBL_VARCHAR30
499: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

Line 496: , p_ship_to_org_id_tbl IN PO_TBL_NUMBER

492: PROCEDURE pjm_unit_number_effective(
493: p_dist_id_tbl IN PO_TBL_NUMBER
494: , p_end_item_unit_number_tbl IN PO_TBL_VARCHAR30
495: , p_item_id_tbl IN PO_TBL_NUMBER
496: , p_ship_to_org_id_tbl IN PO_TBL_NUMBER
497: -- Bug# 4338241: Checking if it is inventory and PJM is installed
498: , p_destination_type_code_tbl IN PO_TBL_VARCHAR30
499: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
500: , x_result_type OUT NOCOPY VARCHAR2

Line 577: p_dist_id_tbl IN PO_TBL_NUMBER

573:
574: END pjm_unit_number_effective;
575:
576: PROCEDURE oop_enter_all_fields(
577: p_dist_id_tbl IN PO_TBL_NUMBER
578: , p_line_line_type_id_tbl IN PO_TBL_NUMBER
579: , p_wip_entity_id_tbl IN PO_TBL_NUMBER
580: , p_wip_line_id_tbl IN PO_TBL_NUMBER
581: , p_wip_operation_seq_num_tbl IN PO_TBL_NUMBER

Line 578: , p_line_line_type_id_tbl IN PO_TBL_NUMBER

574: END pjm_unit_number_effective;
575:
576: PROCEDURE oop_enter_all_fields(
577: p_dist_id_tbl IN PO_TBL_NUMBER
578: , p_line_line_type_id_tbl IN PO_TBL_NUMBER
579: , p_wip_entity_id_tbl IN PO_TBL_NUMBER
580: , p_wip_line_id_tbl IN PO_TBL_NUMBER
581: , p_wip_operation_seq_num_tbl IN PO_TBL_NUMBER
582: , p_destination_type_code_tbl IN PO_TBL_VARCHAR30

Line 579: , p_wip_entity_id_tbl IN PO_TBL_NUMBER

575:
576: PROCEDURE oop_enter_all_fields(
577: p_dist_id_tbl IN PO_TBL_NUMBER
578: , p_line_line_type_id_tbl IN PO_TBL_NUMBER
579: , p_wip_entity_id_tbl IN PO_TBL_NUMBER
580: , p_wip_line_id_tbl IN PO_TBL_NUMBER
581: , p_wip_operation_seq_num_tbl IN PO_TBL_NUMBER
582: , p_destination_type_code_tbl IN PO_TBL_VARCHAR30
583: , p_wip_resource_seq_num_tbl IN PO_TBL_NUMBER

Line 580: , p_wip_line_id_tbl IN PO_TBL_NUMBER

576: PROCEDURE oop_enter_all_fields(
577: p_dist_id_tbl IN PO_TBL_NUMBER
578: , p_line_line_type_id_tbl IN PO_TBL_NUMBER
579: , p_wip_entity_id_tbl IN PO_TBL_NUMBER
580: , p_wip_line_id_tbl IN PO_TBL_NUMBER
581: , p_wip_operation_seq_num_tbl IN PO_TBL_NUMBER
582: , p_destination_type_code_tbl IN PO_TBL_VARCHAR30
583: , p_wip_resource_seq_num_tbl IN PO_TBL_NUMBER
584: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

Line 581: , p_wip_operation_seq_num_tbl IN PO_TBL_NUMBER

577: p_dist_id_tbl IN PO_TBL_NUMBER
578: , p_line_line_type_id_tbl IN PO_TBL_NUMBER
579: , p_wip_entity_id_tbl IN PO_TBL_NUMBER
580: , p_wip_line_id_tbl IN PO_TBL_NUMBER
581: , p_wip_operation_seq_num_tbl IN PO_TBL_NUMBER
582: , p_destination_type_code_tbl IN PO_TBL_VARCHAR30
583: , p_wip_resource_seq_num_tbl IN PO_TBL_NUMBER
584: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
585: , x_result_type OUT NOCOPY VARCHAR2

Line 583: , p_wip_resource_seq_num_tbl IN PO_TBL_NUMBER

579: , p_wip_entity_id_tbl IN PO_TBL_NUMBER
580: , p_wip_line_id_tbl IN PO_TBL_NUMBER
581: , p_wip_operation_seq_num_tbl IN PO_TBL_NUMBER
582: , p_destination_type_code_tbl IN PO_TBL_VARCHAR30
583: , p_wip_resource_seq_num_tbl IN PO_TBL_NUMBER
584: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
585: , x_result_type OUT NOCOPY VARCHAR2
586: )
587: IS

Line 701: p_dist_id_tbl IN PO_TBL_NUMBER

697: -- encumber.
698: -- Agreements only.
699: -------------------------------------------------------------------------
700: PROCEDURE unencum_amt_le_amt_to_encum(
701: p_dist_id_tbl IN PO_TBL_NUMBER
702: , p_amount_to_encumber_tbl IN PO_TBL_NUMBER
703: , p_unencumbered_amount_tbl IN PO_TBL_NUMBER
704: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
705: , x_result_type OUT NOCOPY VARCHAR2

Line 702: , p_amount_to_encumber_tbl IN PO_TBL_NUMBER

698: -- Agreements only.
699: -------------------------------------------------------------------------
700: PROCEDURE unencum_amt_le_amt_to_encum(
701: p_dist_id_tbl IN PO_TBL_NUMBER
702: , p_amount_to_encumber_tbl IN PO_TBL_NUMBER
703: , p_unencumbered_amount_tbl IN PO_TBL_NUMBER
704: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
705: , x_result_type OUT NOCOPY VARCHAR2
706: )

Line 703: , p_unencumbered_amount_tbl IN PO_TBL_NUMBER

699: -------------------------------------------------------------------------
700: PROCEDURE unencum_amt_le_amt_to_encum(
701: p_dist_id_tbl IN PO_TBL_NUMBER
702: , p_amount_to_encumber_tbl IN PO_TBL_NUMBER
703: , p_unencumbered_amount_tbl IN PO_TBL_NUMBER
704: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
705: , x_result_type OUT NOCOPY VARCHAR2
706: )
707: IS

Line 729: p_dist_id_tbl IN PO_TBL_NUMBER

725: -- Checks that the Amount To Encumber is not null and >= 0.
726: -- Agreements only.
727: -----------------------------------------------------------------------------
728: PROCEDURE amount_to_encumber_ge_zero(
729: p_dist_id_tbl IN PO_TBL_NUMBER
730: , p_amount_to_encumber_tbl IN PO_TBL_NUMBER
731: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
732: , x_result_type OUT NOCOPY VARCHAR2
733: )

Line 730: , p_amount_to_encumber_tbl IN PO_TBL_NUMBER

726: -- Agreements only.
727: -----------------------------------------------------------------------------
728: PROCEDURE amount_to_encumber_ge_zero(
729: p_dist_id_tbl IN PO_TBL_NUMBER
730: , p_amount_to_encumber_tbl IN PO_TBL_NUMBER
731: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
732: , x_result_type OUT NOCOPY VARCHAR2
733: )
734: IS

Line 757: p_dist_id_tbl IN PO_TBL_NUMBER

753: -- Ensures that the Budget Account is not null.
754: -- Agreements only.
755: -------------------------------------------------------------------------------
756: PROCEDURE budget_account_id_not_null(
757: p_dist_id_tbl IN PO_TBL_NUMBER
758: , p_budget_account_id_tbl IN PO_TBL_NUMBER
759: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
760: , x_result_type OUT NOCOPY VARCHAR2
761: )

Line 758: , p_budget_account_id_tbl IN PO_TBL_NUMBER

754: -- Agreements only.
755: -------------------------------------------------------------------------------
756: PROCEDURE budget_account_id_not_null(
757: p_dist_id_tbl IN PO_TBL_NUMBER
758: , p_budget_account_id_tbl IN PO_TBL_NUMBER
759: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
760: , x_result_type OUT NOCOPY VARCHAR2
761: )
762: IS

Line 784: p_dist_id_tbl IN PO_TBL_NUMBER

780: -- Ensures that the GL Encumbered Date is not null.
781: -- Agreements only.
782: -------------------------------------------------------------------------------
783: PROCEDURE gl_encumbered_date_not_null(
784: p_dist_id_tbl IN PO_TBL_NUMBER
785: , p_gl_encumbered_date_tbl IN PO_TBL_DATE
786: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
787: , x_result_type OUT NOCOPY VARCHAR2
788: )

Line 811: p_dist_id_tbl IN PO_TBL_NUMBER

807: -- is in an open period.
808: -- For both SPOs and BPAs.
809: ------------------------------------------------------------------------
810: PROCEDURE gl_enc_date_not_null_open(
811: p_dist_id_tbl IN PO_TBL_NUMBER
812: , p_org_id_tbl IN PO_TBL_NUMBER
813: , p_gl_encumbered_date_tbl IN PO_TBL_DATE
814: , p_dist_type_tbl IN PO_TBL_VARCHAR30 --Bug 14664343
815: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

Line 812: , p_org_id_tbl IN PO_TBL_NUMBER

808: -- For both SPOs and BPAs.
809: ------------------------------------------------------------------------
810: PROCEDURE gl_enc_date_not_null_open(
811: p_dist_id_tbl IN PO_TBL_NUMBER
812: , p_org_id_tbl IN PO_TBL_NUMBER
813: , p_gl_encumbered_date_tbl IN PO_TBL_DATE
814: , p_dist_type_tbl IN PO_TBL_VARCHAR30 --Bug 14664343
815: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
816: , x_result_type OUT NOCOPY VARCHAR2

Line 901: p_dist_id_tbl IN PO_TBL_NUMBER

897: -- award data on a distribution is valid.
898: --
899: ------------------------------------------------------------------------
900: PROCEDURE gms_data_valid(
901: p_dist_id_tbl IN PO_TBL_NUMBER
902: , p_project_id_tbl IN PO_TBL_NUMBER
903: , p_task_id_tbl IN PO_TBL_NUMBER
904: , p_award_number_tbl IN PO_TBL_VARCHAR2000
905: , p_expenditure_type_tbl IN PO_TBL_VARCHAR30

Line 902: , p_project_id_tbl IN PO_TBL_NUMBER

898: --
899: ------------------------------------------------------------------------
900: PROCEDURE gms_data_valid(
901: p_dist_id_tbl IN PO_TBL_NUMBER
902: , p_project_id_tbl IN PO_TBL_NUMBER
903: , p_task_id_tbl IN PO_TBL_NUMBER
904: , p_award_number_tbl IN PO_TBL_VARCHAR2000
905: , p_expenditure_type_tbl IN PO_TBL_VARCHAR30
906: , p_expenditure_item_date_tbl IN PO_TBL_DATE

Line 903: , p_task_id_tbl IN PO_TBL_NUMBER

899: ------------------------------------------------------------------------
900: PROCEDURE gms_data_valid(
901: p_dist_id_tbl IN PO_TBL_NUMBER
902: , p_project_id_tbl IN PO_TBL_NUMBER
903: , p_task_id_tbl IN PO_TBL_NUMBER
904: , p_award_number_tbl IN PO_TBL_VARCHAR2000
905: , p_expenditure_type_tbl IN PO_TBL_VARCHAR30
906: , p_expenditure_item_date_tbl IN PO_TBL_DATE
907: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

Line 911: l_failure_dist_id_tbl PO_TBL_NUMBER;

907: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
908: , x_result_type OUT NOCOPY VARCHAR2
909: )
910: IS
911: l_failure_dist_id_tbl PO_TBL_NUMBER;
912: l_failure_message_tbl PO_TBL_VARCHAR4000;
913: l_results_count NUMBER;
914:
915: BEGIN

Line 965: p_dist_id_tbl IN PO_TBL_NUMBER

961: -- Performs the federal financial validations for distributions
962: -- For Standard POs only.
963: ------------------------------------------------------------------------
964: PROCEDURE check_fv_validations(
965: p_dist_id_tbl IN PO_TBL_NUMBER
966: , p_ccid_tbl IN PO_TBL_NUMBER
967: , p_org_id_tbl IN PO_TBL_NUMBER
968: , p_attribute1_tbl IN PO_TBL_VARCHAR2000
969: , p_attribute2_tbl IN PO_TBL_VARCHAR2000

Line 966: , p_ccid_tbl IN PO_TBL_NUMBER

962: -- For Standard POs only.
963: ------------------------------------------------------------------------
964: PROCEDURE check_fv_validations(
965: p_dist_id_tbl IN PO_TBL_NUMBER
966: , p_ccid_tbl IN PO_TBL_NUMBER
967: , p_org_id_tbl IN PO_TBL_NUMBER
968: , p_attribute1_tbl IN PO_TBL_VARCHAR2000
969: , p_attribute2_tbl IN PO_TBL_VARCHAR2000
970: , p_attribute3_tbl IN PO_TBL_VARCHAR2000

Line 967: , p_org_id_tbl IN PO_TBL_NUMBER

963: ------------------------------------------------------------------------
964: PROCEDURE check_fv_validations(
965: p_dist_id_tbl IN PO_TBL_NUMBER
966: , p_ccid_tbl IN PO_TBL_NUMBER
967: , p_org_id_tbl IN PO_TBL_NUMBER
968: , p_attribute1_tbl IN PO_TBL_VARCHAR2000
969: , p_attribute2_tbl IN PO_TBL_VARCHAR2000
970: , p_attribute3_tbl IN PO_TBL_VARCHAR2000
971: , p_attribute4_tbl IN PO_TBL_VARCHAR2000

Line 1099: p_dist_id_tbl IN PO_TBL_NUMBER

1095: -- 1. Encumbrance is enabled and
1096: -- 2. Document is of CLM style.
1097: ------------------------------------------------------------------------
1098: PROCEDURE funded_value_ge_zero(
1099: p_dist_id_tbl IN PO_TBL_NUMBER
1100: , p_org_id_tbl IN PO_TBL_NUMBER
1101: , p_style_id_tbl IN PO_TBL_NUMBER
1102: , p_partial_funded_flag_tbl IN PO_TBL_VARCHAR1
1103: , p_funded_value_tbl IN PO_TBL_NUMBER

Line 1100: , p_org_id_tbl IN PO_TBL_NUMBER

1096: -- 2. Document is of CLM style.
1097: ------------------------------------------------------------------------
1098: PROCEDURE funded_value_ge_zero(
1099: p_dist_id_tbl IN PO_TBL_NUMBER
1100: , p_org_id_tbl IN PO_TBL_NUMBER
1101: , p_style_id_tbl IN PO_TBL_NUMBER
1102: , p_partial_funded_flag_tbl IN PO_TBL_VARCHAR1
1103: , p_funded_value_tbl IN PO_TBL_NUMBER
1104: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

Line 1101: , p_style_id_tbl IN PO_TBL_NUMBER

1097: ------------------------------------------------------------------------
1098: PROCEDURE funded_value_ge_zero(
1099: p_dist_id_tbl IN PO_TBL_NUMBER
1100: , p_org_id_tbl IN PO_TBL_NUMBER
1101: , p_style_id_tbl IN PO_TBL_NUMBER
1102: , p_partial_funded_flag_tbl IN PO_TBL_VARCHAR1
1103: , p_funded_value_tbl IN PO_TBL_NUMBER
1104: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1105: , x_result_type OUT NOCOPY VARCHAR2

Line 1103: , p_funded_value_tbl IN PO_TBL_NUMBER

1099: p_dist_id_tbl IN PO_TBL_NUMBER
1100: , p_org_id_tbl IN PO_TBL_NUMBER
1101: , p_style_id_tbl IN PO_TBL_NUMBER
1102: , p_partial_funded_flag_tbl IN PO_TBL_VARCHAR1
1103: , p_funded_value_tbl IN PO_TBL_NUMBER
1104: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1105: , x_result_type OUT NOCOPY VARCHAR2
1106: )
1107: IS

Line 1178: p_dist_id_tbl IN PO_TBL_NUMBER

1174: -- 1. Encumbrance is enabled and
1175: -- 2. Document is of CLM style.
1176: ------------------------------------------------------------------------
1177: PROCEDURE funded_val_le_tot_order_val(
1178: p_dist_id_tbl IN PO_TBL_NUMBER
1179: , p_org_id_tbl IN PO_TBL_NUMBER
1180: , p_style_id_tbl IN PO_TBL_NUMBER
1181: , p_partial_funded_flag_tbl IN PO_TBL_VARCHAR1
1182: , p_funded_value_tbl IN PO_TBL_NUMBER

Line 1179: , p_org_id_tbl IN PO_TBL_NUMBER

1175: -- 2. Document is of CLM style.
1176: ------------------------------------------------------------------------
1177: PROCEDURE funded_val_le_tot_order_val(
1178: p_dist_id_tbl IN PO_TBL_NUMBER
1179: , p_org_id_tbl IN PO_TBL_NUMBER
1180: , p_style_id_tbl IN PO_TBL_NUMBER
1181: , p_partial_funded_flag_tbl IN PO_TBL_VARCHAR1
1182: , p_funded_value_tbl IN PO_TBL_NUMBER
1183: , p_quantity_ordered_tbl IN PO_TBL_NUMBER

Line 1180: , p_style_id_tbl IN PO_TBL_NUMBER

1176: ------------------------------------------------------------------------
1177: PROCEDURE funded_val_le_tot_order_val(
1178: p_dist_id_tbl IN PO_TBL_NUMBER
1179: , p_org_id_tbl IN PO_TBL_NUMBER
1180: , p_style_id_tbl IN PO_TBL_NUMBER
1181: , p_partial_funded_flag_tbl IN PO_TBL_VARCHAR1
1182: , p_funded_value_tbl IN PO_TBL_NUMBER
1183: , p_quantity_ordered_tbl IN PO_TBL_NUMBER
1184: , p_amount_ordered_tbl IN PO_TBL_NUMBER

Line 1182: , p_funded_value_tbl IN PO_TBL_NUMBER

1178: p_dist_id_tbl IN PO_TBL_NUMBER
1179: , p_org_id_tbl IN PO_TBL_NUMBER
1180: , p_style_id_tbl IN PO_TBL_NUMBER
1181: , p_partial_funded_flag_tbl IN PO_TBL_VARCHAR1
1182: , p_funded_value_tbl IN PO_TBL_NUMBER
1183: , p_quantity_ordered_tbl IN PO_TBL_NUMBER
1184: , p_amount_ordered_tbl IN PO_TBL_NUMBER
1185: , p_price_override_tbl IN PO_TBL_NUMBER
1186: , p_nonrecoverable_tax_tbl IN PO_TBL_NUMBER

Line 1183: , p_quantity_ordered_tbl IN PO_TBL_NUMBER

1179: , p_org_id_tbl IN PO_TBL_NUMBER
1180: , p_style_id_tbl IN PO_TBL_NUMBER
1181: , p_partial_funded_flag_tbl IN PO_TBL_VARCHAR1
1182: , p_funded_value_tbl IN PO_TBL_NUMBER
1183: , p_quantity_ordered_tbl IN PO_TBL_NUMBER
1184: , p_amount_ordered_tbl IN PO_TBL_NUMBER
1185: , p_price_override_tbl IN PO_TBL_NUMBER
1186: , p_nonrecoverable_tax_tbl IN PO_TBL_NUMBER
1187: , p_rate_tbl IN PO_TBL_NUMBER

Line 1184: , p_amount_ordered_tbl IN PO_TBL_NUMBER

1180: , p_style_id_tbl IN PO_TBL_NUMBER
1181: , p_partial_funded_flag_tbl IN PO_TBL_VARCHAR1
1182: , p_funded_value_tbl IN PO_TBL_NUMBER
1183: , p_quantity_ordered_tbl IN PO_TBL_NUMBER
1184: , p_amount_ordered_tbl IN PO_TBL_NUMBER
1185: , p_price_override_tbl IN PO_TBL_NUMBER
1186: , p_nonrecoverable_tax_tbl IN PO_TBL_NUMBER
1187: , p_rate_tbl IN PO_TBL_NUMBER
1188: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

Line 1185: , p_price_override_tbl IN PO_TBL_NUMBER

1181: , p_partial_funded_flag_tbl IN PO_TBL_VARCHAR1
1182: , p_funded_value_tbl IN PO_TBL_NUMBER
1183: , p_quantity_ordered_tbl IN PO_TBL_NUMBER
1184: , p_amount_ordered_tbl IN PO_TBL_NUMBER
1185: , p_price_override_tbl IN PO_TBL_NUMBER
1186: , p_nonrecoverable_tax_tbl IN PO_TBL_NUMBER
1187: , p_rate_tbl IN PO_TBL_NUMBER
1188: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1189: , x_result_type OUT NOCOPY VARCHAR2

Line 1186: , p_nonrecoverable_tax_tbl IN PO_TBL_NUMBER

1182: , p_funded_value_tbl IN PO_TBL_NUMBER
1183: , p_quantity_ordered_tbl IN PO_TBL_NUMBER
1184: , p_amount_ordered_tbl IN PO_TBL_NUMBER
1185: , p_price_override_tbl IN PO_TBL_NUMBER
1186: , p_nonrecoverable_tax_tbl IN PO_TBL_NUMBER
1187: , p_rate_tbl IN PO_TBL_NUMBER
1188: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1189: , x_result_type OUT NOCOPY VARCHAR2
1190: )

Line 1187: , p_rate_tbl IN PO_TBL_NUMBER

1183: , p_quantity_ordered_tbl IN PO_TBL_NUMBER
1184: , p_amount_ordered_tbl IN PO_TBL_NUMBER
1185: , p_price_override_tbl IN PO_TBL_NUMBER
1186: , p_nonrecoverable_tax_tbl IN PO_TBL_NUMBER
1187: , p_rate_tbl IN PO_TBL_NUMBER
1188: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1189: , x_result_type OUT NOCOPY VARCHAR2
1190: )
1191: IS

Line 1315: p_dist_id_tbl IN PO_TBL_NUMBER

1311: -- 1. Encumbrance is enabled and
1312: -- 2. Document is of CLM style.
1313: ------------------------------------------------------------------------
1314: PROCEDURE qty_funded_ge_exc_qty(
1315: p_dist_id_tbl IN PO_TBL_NUMBER
1316: , p_org_id_tbl IN PO_TBL_NUMBER
1317: , p_style_id_tbl IN PO_TBL_NUMBER
1318: , p_quantity_funded_tbl IN PO_TBL_NUMBER
1319: , p_quantity_billed_tbl IN PO_TBL_NUMBER

Line 1316: , p_org_id_tbl IN PO_TBL_NUMBER

1312: -- 2. Document is of CLM style.
1313: ------------------------------------------------------------------------
1314: PROCEDURE qty_funded_ge_exc_qty(
1315: p_dist_id_tbl IN PO_TBL_NUMBER
1316: , p_org_id_tbl IN PO_TBL_NUMBER
1317: , p_style_id_tbl IN PO_TBL_NUMBER
1318: , p_quantity_funded_tbl IN PO_TBL_NUMBER
1319: , p_quantity_billed_tbl IN PO_TBL_NUMBER
1320: , p_quantity_delivered_tbl IN PO_TBL_NUMBER

Line 1317: , p_style_id_tbl IN PO_TBL_NUMBER

1313: ------------------------------------------------------------------------
1314: PROCEDURE qty_funded_ge_exc_qty(
1315: p_dist_id_tbl IN PO_TBL_NUMBER
1316: , p_org_id_tbl IN PO_TBL_NUMBER
1317: , p_style_id_tbl IN PO_TBL_NUMBER
1318: , p_quantity_funded_tbl IN PO_TBL_NUMBER
1319: , p_quantity_billed_tbl IN PO_TBL_NUMBER
1320: , p_quantity_delivered_tbl IN PO_TBL_NUMBER
1321: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

Line 1318: , p_quantity_funded_tbl IN PO_TBL_NUMBER

1314: PROCEDURE qty_funded_ge_exc_qty(
1315: p_dist_id_tbl IN PO_TBL_NUMBER
1316: , p_org_id_tbl IN PO_TBL_NUMBER
1317: , p_style_id_tbl IN PO_TBL_NUMBER
1318: , p_quantity_funded_tbl IN PO_TBL_NUMBER
1319: , p_quantity_billed_tbl IN PO_TBL_NUMBER
1320: , p_quantity_delivered_tbl IN PO_TBL_NUMBER
1321: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1322: , x_result_type OUT NOCOPY VARCHAR2

Line 1319: , p_quantity_billed_tbl IN PO_TBL_NUMBER

1315: p_dist_id_tbl IN PO_TBL_NUMBER
1316: , p_org_id_tbl IN PO_TBL_NUMBER
1317: , p_style_id_tbl IN PO_TBL_NUMBER
1318: , p_quantity_funded_tbl IN PO_TBL_NUMBER
1319: , p_quantity_billed_tbl IN PO_TBL_NUMBER
1320: , p_quantity_delivered_tbl IN PO_TBL_NUMBER
1321: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1322: , x_result_type OUT NOCOPY VARCHAR2
1323: )

Line 1320: , p_quantity_delivered_tbl IN PO_TBL_NUMBER

1316: , p_org_id_tbl IN PO_TBL_NUMBER
1317: , p_style_id_tbl IN PO_TBL_NUMBER
1318: , p_quantity_funded_tbl IN PO_TBL_NUMBER
1319: , p_quantity_billed_tbl IN PO_TBL_NUMBER
1320: , p_quantity_delivered_tbl IN PO_TBL_NUMBER
1321: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1322: , x_result_type OUT NOCOPY VARCHAR2
1323: )
1324: IS

Line 1409: p_dist_id_tbl IN PO_TBL_NUMBER

1405: -- 1. Encumbrance is enabled and
1406: -- 2. Document is of CLM style.
1407: ------------------------------------------------------------------------
1408: PROCEDURE amount_funded_ge_exc_amount(
1409: p_dist_id_tbl IN PO_TBL_NUMBER
1410: , p_org_id_tbl IN PO_TBL_NUMBER
1411: , p_style_id_tbl IN PO_TBL_NUMBER
1412: , p_amount_funded_tbl IN PO_TBL_NUMBER
1413: , p_amount_billed_tbl IN PO_TBL_NUMBER

Line 1410: , p_org_id_tbl IN PO_TBL_NUMBER

1406: -- 2. Document is of CLM style.
1407: ------------------------------------------------------------------------
1408: PROCEDURE amount_funded_ge_exc_amount(
1409: p_dist_id_tbl IN PO_TBL_NUMBER
1410: , p_org_id_tbl IN PO_TBL_NUMBER
1411: , p_style_id_tbl IN PO_TBL_NUMBER
1412: , p_amount_funded_tbl IN PO_TBL_NUMBER
1413: , p_amount_billed_tbl IN PO_TBL_NUMBER
1414: , p_amount_delivered_tbl IN PO_TBL_NUMBER

Line 1411: , p_style_id_tbl IN PO_TBL_NUMBER

1407: ------------------------------------------------------------------------
1408: PROCEDURE amount_funded_ge_exc_amount(
1409: p_dist_id_tbl IN PO_TBL_NUMBER
1410: , p_org_id_tbl IN PO_TBL_NUMBER
1411: , p_style_id_tbl IN PO_TBL_NUMBER
1412: , p_amount_funded_tbl IN PO_TBL_NUMBER
1413: , p_amount_billed_tbl IN PO_TBL_NUMBER
1414: , p_amount_delivered_tbl IN PO_TBL_NUMBER
1415: , p_line_matching_basis_tbl IN PO_TBL_VARCHAR30 --bug 13773450

Line 1412: , p_amount_funded_tbl IN PO_TBL_NUMBER

1408: PROCEDURE amount_funded_ge_exc_amount(
1409: p_dist_id_tbl IN PO_TBL_NUMBER
1410: , p_org_id_tbl IN PO_TBL_NUMBER
1411: , p_style_id_tbl IN PO_TBL_NUMBER
1412: , p_amount_funded_tbl IN PO_TBL_NUMBER
1413: , p_amount_billed_tbl IN PO_TBL_NUMBER
1414: , p_amount_delivered_tbl IN PO_TBL_NUMBER
1415: , p_line_matching_basis_tbl IN PO_TBL_VARCHAR30 --bug 13773450
1416: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

Line 1413: , p_amount_billed_tbl IN PO_TBL_NUMBER

1409: p_dist_id_tbl IN PO_TBL_NUMBER
1410: , p_org_id_tbl IN PO_TBL_NUMBER
1411: , p_style_id_tbl IN PO_TBL_NUMBER
1412: , p_amount_funded_tbl IN PO_TBL_NUMBER
1413: , p_amount_billed_tbl IN PO_TBL_NUMBER
1414: , p_amount_delivered_tbl IN PO_TBL_NUMBER
1415: , p_line_matching_basis_tbl IN PO_TBL_VARCHAR30 --bug 13773450
1416: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1417: , x_result_type OUT NOCOPY VARCHAR2

Line 1414: , p_amount_delivered_tbl IN PO_TBL_NUMBER

1410: , p_org_id_tbl IN PO_TBL_NUMBER
1411: , p_style_id_tbl IN PO_TBL_NUMBER
1412: , p_amount_funded_tbl IN PO_TBL_NUMBER
1413: , p_amount_billed_tbl IN PO_TBL_NUMBER
1414: , p_amount_delivered_tbl IN PO_TBL_NUMBER
1415: , p_line_matching_basis_tbl IN PO_TBL_VARCHAR30 --bug 13773450
1416: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1417: , x_result_type OUT NOCOPY VARCHAR2
1418: )

Line 1506: p_dist_id_tbl IN PO_TBL_NUMBER

1502: -- 1. Encumbrance is enabled and
1503: -- 2. Document is of CLM style.
1504: ------------------------------------------------------------------------
1505: PROCEDURE funded_value_gt_backing_req(
1506: p_dist_id_tbl IN PO_TBL_NUMBER
1507: , p_org_id_tbl IN PO_TBL_NUMBER
1508: , p_style_id_tbl IN PO_TBL_NUMBER
1509: , p_funded_value_tbl IN PO_TBL_NUMBER
1510: , p_req_distribution_id_tbl IN PO_TBL_NUMBER

Line 1507: , p_org_id_tbl IN PO_TBL_NUMBER

1503: -- 2. Document is of CLM style.
1504: ------------------------------------------------------------------------
1505: PROCEDURE funded_value_gt_backing_req(
1506: p_dist_id_tbl IN PO_TBL_NUMBER
1507: , p_org_id_tbl IN PO_TBL_NUMBER
1508: , p_style_id_tbl IN PO_TBL_NUMBER
1509: , p_funded_value_tbl IN PO_TBL_NUMBER
1510: , p_req_distribution_id_tbl IN PO_TBL_NUMBER
1511: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

Line 1508: , p_style_id_tbl IN PO_TBL_NUMBER

1504: ------------------------------------------------------------------------
1505: PROCEDURE funded_value_gt_backing_req(
1506: p_dist_id_tbl IN PO_TBL_NUMBER
1507: , p_org_id_tbl IN PO_TBL_NUMBER
1508: , p_style_id_tbl IN PO_TBL_NUMBER
1509: , p_funded_value_tbl IN PO_TBL_NUMBER
1510: , p_req_distribution_id_tbl IN PO_TBL_NUMBER
1511: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1512: , x_result_type OUT NOCOPY VARCHAR2

Line 1509: , p_funded_value_tbl IN PO_TBL_NUMBER

1505: PROCEDURE funded_value_gt_backing_req(
1506: p_dist_id_tbl IN PO_TBL_NUMBER
1507: , p_org_id_tbl IN PO_TBL_NUMBER
1508: , p_style_id_tbl IN PO_TBL_NUMBER
1509: , p_funded_value_tbl IN PO_TBL_NUMBER
1510: , p_req_distribution_id_tbl IN PO_TBL_NUMBER
1511: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1512: , x_result_type OUT NOCOPY VARCHAR2
1513: )

Line 1510: , p_req_distribution_id_tbl IN PO_TBL_NUMBER

1506: p_dist_id_tbl IN PO_TBL_NUMBER
1507: , p_org_id_tbl IN PO_TBL_NUMBER
1508: , p_style_id_tbl IN PO_TBL_NUMBER
1509: , p_funded_value_tbl IN PO_TBL_NUMBER
1510: , p_req_distribution_id_tbl IN PO_TBL_NUMBER
1511: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1512: , x_result_type OUT NOCOPY VARCHAR2
1513: )
1514: IS

Line 1602: p_dist_id_tbl IN PO_TBL_NUMBER

1598: -- 4. If gms is not installed or if award is not required,
1599: -- expenditure item type is required.
1600: ------------------------------------------------------------------------
1601: PROCEDURE check_proj_related_validations(
1602: p_dist_id_tbl IN PO_TBL_NUMBER
1603: , p_dest_type_code_tbl IN PO_TBL_VARCHAR30
1604: , p_project_id_tbl IN PO_TBL_NUMBER
1605: , p_task_id_tbl IN PO_TBL_NUMBER
1606: , p_award_id_tbl IN PO_TBL_NUMBER

Line 1604: , p_project_id_tbl IN PO_TBL_NUMBER

1600: ------------------------------------------------------------------------
1601: PROCEDURE check_proj_related_validations(
1602: p_dist_id_tbl IN PO_TBL_NUMBER
1603: , p_dest_type_code_tbl IN PO_TBL_VARCHAR30
1604: , p_project_id_tbl IN PO_TBL_NUMBER
1605: , p_task_id_tbl IN PO_TBL_NUMBER
1606: , p_award_id_tbl IN PO_TBL_NUMBER
1607: , p_expenditure_type_tbl IN PO_TBL_VARCHAR30
1608: , p_expenditure_org_id_tbl IN PO_TBL_NUMBER

Line 1605: , p_task_id_tbl IN PO_TBL_NUMBER

1601: PROCEDURE check_proj_related_validations(
1602: p_dist_id_tbl IN PO_TBL_NUMBER
1603: , p_dest_type_code_tbl IN PO_TBL_VARCHAR30
1604: , p_project_id_tbl IN PO_TBL_NUMBER
1605: , p_task_id_tbl IN PO_TBL_NUMBER
1606: , p_award_id_tbl IN PO_TBL_NUMBER
1607: , p_expenditure_type_tbl IN PO_TBL_VARCHAR30
1608: , p_expenditure_org_id_tbl IN PO_TBL_NUMBER
1609: , p_expenditure_item_date_tbl IN PO_TBL_DATE

Line 1606: , p_award_id_tbl IN PO_TBL_NUMBER

1602: p_dist_id_tbl IN PO_TBL_NUMBER
1603: , p_dest_type_code_tbl IN PO_TBL_VARCHAR30
1604: , p_project_id_tbl IN PO_TBL_NUMBER
1605: , p_task_id_tbl IN PO_TBL_NUMBER
1606: , p_award_id_tbl IN PO_TBL_NUMBER
1607: , p_expenditure_type_tbl IN PO_TBL_VARCHAR30
1608: , p_expenditure_org_id_tbl IN PO_TBL_NUMBER
1609: , p_expenditure_item_date_tbl IN PO_TBL_DATE
1610: , p_ship_to_org_id_tbl IN PO_TBL_NUMBER

Line 1608: , p_expenditure_org_id_tbl IN PO_TBL_NUMBER

1604: , p_project_id_tbl IN PO_TBL_NUMBER
1605: , p_task_id_tbl IN PO_TBL_NUMBER
1606: , p_award_id_tbl IN PO_TBL_NUMBER
1607: , p_expenditure_type_tbl IN PO_TBL_VARCHAR30
1608: , p_expenditure_org_id_tbl IN PO_TBL_NUMBER
1609: , p_expenditure_item_date_tbl IN PO_TBL_DATE
1610: , p_ship_to_org_id_tbl IN PO_TBL_NUMBER
1611: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1612: , x_result_type OUT NOCOPY VARCHAR2

Line 1610: , p_ship_to_org_id_tbl IN PO_TBL_NUMBER

1606: , p_award_id_tbl IN PO_TBL_NUMBER
1607: , p_expenditure_type_tbl IN PO_TBL_VARCHAR30
1608: , p_expenditure_org_id_tbl IN PO_TBL_NUMBER
1609: , p_expenditure_item_date_tbl IN PO_TBL_DATE
1610: , p_ship_to_org_id_tbl IN PO_TBL_NUMBER
1611: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1612: , x_result_type OUT NOCOPY VARCHAR2
1613: )
1614: IS

Line 1755: p_dist_id_tbl IN PO_TBL_NUMBER,

1751: -- Validates if Total Funded Value of Distributions is greater than the Funds
1752: -- Remaining on the PR they refer to.
1753: -----------------------------------------------------------------------------
1754: PROCEDURE funded_val_gt_req_funds_rmn(
1755: p_dist_id_tbl IN PO_TBL_NUMBER,
1756: p_dist_type_tbl IN PO_TBL_VARCHAR30,
1757: p_org_id_tbl IN PO_TBL_NUMBER,
1758: p_style_id_tbl IN PO_TBL_NUMBER,
1759: p_draft_id_tbl IN PO_TBL_NUMBER,

Line 1757: p_org_id_tbl IN PO_TBL_NUMBER,

1753: -----------------------------------------------------------------------------
1754: PROCEDURE funded_val_gt_req_funds_rmn(
1755: p_dist_id_tbl IN PO_TBL_NUMBER,
1756: p_dist_type_tbl IN PO_TBL_VARCHAR30,
1757: p_org_id_tbl IN PO_TBL_NUMBER,
1758: p_style_id_tbl IN PO_TBL_NUMBER,
1759: p_draft_id_tbl IN PO_TBL_NUMBER,
1760: p_funded_value_tbl IN PO_TBL_NUMBER,
1761: p_enc_amount_tbl IN PO_TBL_NUMBER,

Line 1758: p_style_id_tbl IN PO_TBL_NUMBER,

1754: PROCEDURE funded_val_gt_req_funds_rmn(
1755: p_dist_id_tbl IN PO_TBL_NUMBER,
1756: p_dist_type_tbl IN PO_TBL_VARCHAR30,
1757: p_org_id_tbl IN PO_TBL_NUMBER,
1758: p_style_id_tbl IN PO_TBL_NUMBER,
1759: p_draft_id_tbl IN PO_TBL_NUMBER,
1760: p_funded_value_tbl IN PO_TBL_NUMBER,
1761: p_enc_amount_tbl IN PO_TBL_NUMBER,
1762: p_req_dist_id_tbl IN PO_TBL_NUMBER,

Line 1759: p_draft_id_tbl IN PO_TBL_NUMBER,

1755: p_dist_id_tbl IN PO_TBL_NUMBER,
1756: p_dist_type_tbl IN PO_TBL_VARCHAR30,
1757: p_org_id_tbl IN PO_TBL_NUMBER,
1758: p_style_id_tbl IN PO_TBL_NUMBER,
1759: p_draft_id_tbl IN PO_TBL_NUMBER,
1760: p_funded_value_tbl IN PO_TBL_NUMBER,
1761: p_enc_amount_tbl IN PO_TBL_NUMBER,
1762: p_req_dist_id_tbl IN PO_TBL_NUMBER,
1763: x_result_set_id IN OUT NOCOPY NUMBER,

Line 1760: p_funded_value_tbl IN PO_TBL_NUMBER,

1756: p_dist_type_tbl IN PO_TBL_VARCHAR30,
1757: p_org_id_tbl IN PO_TBL_NUMBER,
1758: p_style_id_tbl IN PO_TBL_NUMBER,
1759: p_draft_id_tbl IN PO_TBL_NUMBER,
1760: p_funded_value_tbl IN PO_TBL_NUMBER,
1761: p_enc_amount_tbl IN PO_TBL_NUMBER,
1762: p_req_dist_id_tbl IN PO_TBL_NUMBER,
1763: x_result_set_id IN OUT NOCOPY NUMBER,
1764: x_result_type OUT NOCOPY VARCHAR2)

Line 1761: p_enc_amount_tbl IN PO_TBL_NUMBER,

1757: p_org_id_tbl IN PO_TBL_NUMBER,
1758: p_style_id_tbl IN PO_TBL_NUMBER,
1759: p_draft_id_tbl IN PO_TBL_NUMBER,
1760: p_funded_value_tbl IN PO_TBL_NUMBER,
1761: p_enc_amount_tbl IN PO_TBL_NUMBER,
1762: p_req_dist_id_tbl IN PO_TBL_NUMBER,
1763: x_result_set_id IN OUT NOCOPY NUMBER,
1764: x_result_type OUT NOCOPY VARCHAR2)
1765: IS

Line 1762: p_req_dist_id_tbl IN PO_TBL_NUMBER,

1758: p_style_id_tbl IN PO_TBL_NUMBER,
1759: p_draft_id_tbl IN PO_TBL_NUMBER,
1760: p_funded_value_tbl IN PO_TBL_NUMBER,
1761: p_enc_amount_tbl IN PO_TBL_NUMBER,
1762: p_req_dist_id_tbl IN PO_TBL_NUMBER,
1763: x_result_set_id IN OUT NOCOPY NUMBER,
1764: x_result_type OUT NOCOPY VARCHAR2)
1765: IS
1766: d_mod CONSTANT VARCHAR2(100) := D_funded_val_gt_req_funds_rmn;

Line 1921: p_dist_id_tbl IN PO_TBL_NUMBER,

1917: -- The results of the validations.
1918: --End of Comments
1919: -------------------------------------------------------------------------------
1920: PROCEDURE check_dist_values_inc_for_par(
1921: p_dist_id_tbl IN PO_TBL_NUMBER,
1922: p_draft_id_tbl IN PO_TBL_NUMBER,
1923: p_draft_type_tbl IN PO_TBL_VARCHAR30,
1924: p_quantity_ordered_tbl IN PO_TBL_NUMBER,
1925: p_amt_ordered_tbl IN PO_TBL_NUMBER,

Line 1922: p_draft_id_tbl IN PO_TBL_NUMBER,

1918: --End of Comments
1919: -------------------------------------------------------------------------------
1920: PROCEDURE check_dist_values_inc_for_par(
1921: p_dist_id_tbl IN PO_TBL_NUMBER,
1922: p_draft_id_tbl IN PO_TBL_NUMBER,
1923: p_draft_type_tbl IN PO_TBL_VARCHAR30,
1924: p_quantity_ordered_tbl IN PO_TBL_NUMBER,
1925: p_amt_ordered_tbl IN PO_TBL_NUMBER,
1926: p_old_qty_ordered_tbl IN PO_TBL_NUMBER,

Line 1924: p_quantity_ordered_tbl IN PO_TBL_NUMBER,

1920: PROCEDURE check_dist_values_inc_for_par(
1921: p_dist_id_tbl IN PO_TBL_NUMBER,
1922: p_draft_id_tbl IN PO_TBL_NUMBER,
1923: p_draft_type_tbl IN PO_TBL_VARCHAR30,
1924: p_quantity_ordered_tbl IN PO_TBL_NUMBER,
1925: p_amt_ordered_tbl IN PO_TBL_NUMBER,
1926: p_old_qty_ordered_tbl IN PO_TBL_NUMBER,
1927: p_change_status_tbl IN PO_TBL_VARCHAR30,
1928: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE ,

Line 1925: p_amt_ordered_tbl IN PO_TBL_NUMBER,

1921: p_dist_id_tbl IN PO_TBL_NUMBER,
1922: p_draft_id_tbl IN PO_TBL_NUMBER,
1923: p_draft_type_tbl IN PO_TBL_VARCHAR30,
1924: p_quantity_ordered_tbl IN PO_TBL_NUMBER,
1925: p_amt_ordered_tbl IN PO_TBL_NUMBER,
1926: p_old_qty_ordered_tbl IN PO_TBL_NUMBER,
1927: p_change_status_tbl IN PO_TBL_VARCHAR30,
1928: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE ,
1929: x_result_type OUT NOCOPY VARCHAR2)

Line 1926: p_old_qty_ordered_tbl IN PO_TBL_NUMBER,

1922: p_draft_id_tbl IN PO_TBL_NUMBER,
1923: p_draft_type_tbl IN PO_TBL_VARCHAR30,
1924: p_quantity_ordered_tbl IN PO_TBL_NUMBER,
1925: p_amt_ordered_tbl IN PO_TBL_NUMBER,
1926: p_old_qty_ordered_tbl IN PO_TBL_NUMBER,
1927: p_change_status_tbl IN PO_TBL_VARCHAR30,
1928: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE ,
1929: x_result_type OUT NOCOPY VARCHAR2)
1930:

Line 2005: p_intf_dist_id_tbl IN PO_TBL_NUMBER,

2001: against its clin
2002: -------------------------------------------------------------------------------*/
2003:
2004: PROCEDURE check_clin_slin_funding(
2005: p_intf_dist_id_tbl IN PO_TBL_NUMBER,
2006: --p_dist_id_tbl IN PO_TBL_NUMBER,
2007: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
2008: x_result_type OUT NOCOPY VARCHAR2)
2009: IS

Line 2006: --p_dist_id_tbl IN PO_TBL_NUMBER,

2002: -------------------------------------------------------------------------------*/
2003:
2004: PROCEDURE check_clin_slin_funding(
2005: p_intf_dist_id_tbl IN PO_TBL_NUMBER,
2006: --p_dist_id_tbl IN PO_TBL_NUMBER,
2007: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
2008: x_result_type OUT NOCOPY VARCHAR2)
2009: IS
2010:

Line 2075: p_intf_dist_id_tbl IN PO_TBL_NUMBER,

2071:
2072:
2073:
2074: PROCEDURE validate_defence_funding(
2075: p_intf_dist_id_tbl IN PO_TBL_NUMBER,
2076: p_clm_defence_funding_tbl IN PO_TBL_VARCHAR30,
2077: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
2078: x_result_type OUT NOCOPY VARCHAR2)
2079: IS

Line 2153: p_intf_dist_id_tbl IN PO_TBL_NUMBER,

2149:
2150:
2151:
2152: PROCEDURE validate_option_distribution(
2153: p_intf_dist_id_tbl IN PO_TBL_NUMBER,
2154: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
2155: x_result_type OUT NOCOPY VARCHAR2)
2156: IS
2157:

Line 2159: l_intf_dist_id_tbl PO_TBL_NUMBER;

2155: x_result_type OUT NOCOPY VARCHAR2)
2156: IS
2157:
2158: d_mod CONSTANT VARCHAR2(100) := D_validate_option_distribution;
2159: l_intf_dist_id_tbl PO_TBL_NUMBER;
2160: l_data_key NUMBER;
2161:
2162: BEGIN
2163: