eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_VAL_DISTRIBUTIONS dependencies on PO_TBL_NUMBER

Line 89: p_dist_id_tbl IN PO_TBL_NUMBER

85: -- Assumption:
86: -- All of the unposted distribution data will be passed in
87: -- to this routine in order to get accurate results.
88: PROCEDURE dist_num_unique(
89: p_dist_id_tbl IN PO_TBL_NUMBER
90: , p_line_loc_id_tbl IN PO_TBL_NUMBER
91: , p_dist_num_tbl IN PO_TBL_NUMBER
92: , x_result_set_id IN OUT NOCOPY NUMBER
93: , x_result_type OUT NOCOPY VARCHAR2

Line 90: , p_line_loc_id_tbl IN PO_TBL_NUMBER

86: -- All of the unposted distribution data will be passed in
87: -- to this routine in order to get accurate results.
88: PROCEDURE dist_num_unique(
89: p_dist_id_tbl IN PO_TBL_NUMBER
90: , p_line_loc_id_tbl IN PO_TBL_NUMBER
91: , p_dist_num_tbl IN PO_TBL_NUMBER
92: , x_result_set_id IN OUT NOCOPY NUMBER
93: , x_result_type OUT NOCOPY VARCHAR2
94: )

Line 91: , p_dist_num_tbl IN PO_TBL_NUMBER

87: -- to this routine in order to get accurate results.
88: PROCEDURE dist_num_unique(
89: p_dist_id_tbl IN PO_TBL_NUMBER
90: , p_line_loc_id_tbl IN PO_TBL_NUMBER
91: , p_dist_num_tbl IN PO_TBL_NUMBER
92: , x_result_set_id IN OUT NOCOPY NUMBER
93: , x_result_type OUT NOCOPY VARCHAR2
94: )
95: IS

Line 114: p_dist_id_tbl IN PO_TBL_NUMBER

110: -----------------------------------------------------------------------------
111: -- Checks for null or non-positive distribution numbers.
112: -----------------------------------------------------------------------------
113: PROCEDURE dist_num_gt_zero(
114: p_dist_id_tbl IN PO_TBL_NUMBER
115: , p_dist_num_tbl IN PO_TBL_NUMBER
116: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
117: , x_result_type OUT NOCOPY VARCHAR2
118: )

Line 115: , p_dist_num_tbl IN PO_TBL_NUMBER

111: -- Checks for null or non-positive distribution numbers.
112: -----------------------------------------------------------------------------
113: PROCEDURE dist_num_gt_zero(
114: p_dist_id_tbl IN PO_TBL_NUMBER
115: , p_dist_num_tbl IN PO_TBL_NUMBER
116: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
117: , x_result_type OUT NOCOPY VARCHAR2
118: )
119: IS

Line 142: p_dist_id_tbl IN PO_TBL_NUMBER

138: -- Validates that quantity is not null and greater than zero if it is not
139: -- a Rate or Fixed Price line.
140: -----------------------------------------------------------------------------
141: PROCEDURE quantity_gt_zero(
142: p_dist_id_tbl IN PO_TBL_NUMBER
143: , p_qty_ordered_tbl IN PO_TBL_NUMBER
144: , p_value_basis_tbl IN PO_TBL_VARCHAR30 --
145: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
146: , x_result_type OUT NOCOPY VARCHAR2

Line 143: , p_qty_ordered_tbl IN PO_TBL_NUMBER

139: -- a Rate or Fixed Price line.
140: -----------------------------------------------------------------------------
141: PROCEDURE quantity_gt_zero(
142: p_dist_id_tbl IN PO_TBL_NUMBER
143: , p_qty_ordered_tbl IN PO_TBL_NUMBER
144: , p_value_basis_tbl IN PO_TBL_VARCHAR30 --
145: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
146: , x_result_type OUT NOCOPY VARCHAR2
147: )

Line 177: p_dist_id_tbl IN PO_TBL_NUMBER

173: -- This check is only performed if quantity is being reduced below the
174: -- current transaction quantity, since over-billing/delivery is allowed.
175: -----------------------------------------------------------------------------
176: PROCEDURE quantity_ge_quantity_exec(
177: p_dist_id_tbl IN PO_TBL_NUMBER
178: , p_dist_type_tbl IN PO_TBL_VARCHAR30
179: , p_qty_ordered_tbl IN PO_TBL_NUMBER
180: , x_result_set_id IN OUT NOCOPY NUMBER
181: , x_result_type OUT NOCOPY VARCHAR2

Line 179: , p_qty_ordered_tbl IN PO_TBL_NUMBER

175: -----------------------------------------------------------------------------
176: PROCEDURE quantity_ge_quantity_exec(
177: p_dist_id_tbl IN PO_TBL_NUMBER
178: , p_dist_type_tbl IN PO_TBL_VARCHAR30
179: , p_qty_ordered_tbl IN PO_TBL_NUMBER
180: , x_result_set_id IN OUT NOCOPY NUMBER
181: , x_result_type OUT NOCOPY VARCHAR2
182: )
183: IS

Line 279: p_dist_id_tbl IN PO_TBL_NUMBER

275: -- Validates that amount is not null and greater than zero if the line is
276: -- Rate or Fixed Price.
277: -----------------------------------------------------------------------------
278: PROCEDURE amount_gt_zero(
279: p_dist_id_tbl IN PO_TBL_NUMBER
280: , p_amt_ordered_tbl IN PO_TBL_NUMBER
281: , p_value_basis_tbl IN PO_TBL_VARCHAR30 --
282: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
283: , x_result_type OUT NOCOPY VARCHAR2

Line 280: , p_amt_ordered_tbl IN PO_TBL_NUMBER

276: -- Rate or Fixed Price.
277: -----------------------------------------------------------------------------
278: PROCEDURE amount_gt_zero(
279: p_dist_id_tbl IN PO_TBL_NUMBER
280: , p_amt_ordered_tbl IN PO_TBL_NUMBER
281: , p_value_basis_tbl IN PO_TBL_VARCHAR30 --
282: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
283: , x_result_type OUT NOCOPY VARCHAR2
284: )

Line 313: p_dist_id_tbl IN PO_TBL_NUMBER

309: -- This check is only performed if amount is being reduced below the
310: -- current transaction amount, since over-delivery/billing is allowed.
311: -----------------------------------------------------------------------------
312: PROCEDURE amount_ge_amount_exec(
313: p_dist_id_tbl IN PO_TBL_NUMBER
314: , p_dist_type_tbl IN PO_TBL_VARCHAR30
315: , p_amt_ordered_tbl IN PO_TBL_NUMBER
316: , x_result_set_id IN OUT NOCOPY NUMBER
317: , x_result_type OUT NOCOPY VARCHAR2

Line 315: , p_amt_ordered_tbl IN PO_TBL_NUMBER

311: -----------------------------------------------------------------------------
312: PROCEDURE amount_ge_amount_exec(
313: p_dist_id_tbl IN PO_TBL_NUMBER
314: , p_dist_type_tbl IN PO_TBL_VARCHAR30
315: , p_amt_ordered_tbl IN PO_TBL_NUMBER
316: , x_result_set_id IN OUT NOCOPY NUMBER
317: , x_result_type OUT NOCOPY VARCHAR2
318: )
319: IS

Line 419: p_dist_id_tbl IN PO_TBL_NUMBER

415: --
416: -- Where clauses derived from PJM_UNIT_EFF.UNIT_EFFECTIVE_ITEM
417: ------------------------------------------------------------------------
418: PROCEDURE pjm_unit_number_effective(
419: p_dist_id_tbl IN PO_TBL_NUMBER
420: , p_end_item_unit_number_tbl IN PO_TBL_VARCHAR30
421: , p_item_id_tbl IN PO_TBL_NUMBER
422: , p_ship_to_org_id_tbl IN PO_TBL_NUMBER
423: -- Bug# 4338241: Checking if it is inventory and PJM is installed

Line 421: , p_item_id_tbl IN PO_TBL_NUMBER

417: ------------------------------------------------------------------------
418: PROCEDURE pjm_unit_number_effective(
419: p_dist_id_tbl IN PO_TBL_NUMBER
420: , p_end_item_unit_number_tbl IN PO_TBL_VARCHAR30
421: , p_item_id_tbl IN PO_TBL_NUMBER
422: , p_ship_to_org_id_tbl IN PO_TBL_NUMBER
423: -- Bug# 4338241: Checking if it is inventory and PJM is installed
424: , p_destination_type_code_tbl IN PO_TBL_VARCHAR30
425: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

Line 422: , p_ship_to_org_id_tbl IN PO_TBL_NUMBER

418: PROCEDURE pjm_unit_number_effective(
419: p_dist_id_tbl IN PO_TBL_NUMBER
420: , p_end_item_unit_number_tbl IN PO_TBL_VARCHAR30
421: , p_item_id_tbl IN PO_TBL_NUMBER
422: , p_ship_to_org_id_tbl IN PO_TBL_NUMBER
423: -- Bug# 4338241: Checking if it is inventory and PJM is installed
424: , p_destination_type_code_tbl IN PO_TBL_VARCHAR30
425: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
426: , x_result_type OUT NOCOPY VARCHAR2

Line 503: p_dist_id_tbl IN PO_TBL_NUMBER

499:
500: END pjm_unit_number_effective;
501:
502: PROCEDURE oop_enter_all_fields(
503: p_dist_id_tbl IN PO_TBL_NUMBER
504: , p_line_line_type_id_tbl IN PO_TBL_NUMBER
505: , p_wip_entity_id_tbl IN PO_TBL_NUMBER
506: , p_wip_line_id_tbl IN PO_TBL_NUMBER
507: , p_wip_operation_seq_num_tbl IN PO_TBL_NUMBER

Line 504: , p_line_line_type_id_tbl IN PO_TBL_NUMBER

500: END pjm_unit_number_effective;
501:
502: PROCEDURE oop_enter_all_fields(
503: p_dist_id_tbl IN PO_TBL_NUMBER
504: , p_line_line_type_id_tbl IN PO_TBL_NUMBER
505: , p_wip_entity_id_tbl IN PO_TBL_NUMBER
506: , p_wip_line_id_tbl IN PO_TBL_NUMBER
507: , p_wip_operation_seq_num_tbl IN PO_TBL_NUMBER
508: , p_destination_type_code_tbl IN PO_TBL_VARCHAR30

Line 505: , p_wip_entity_id_tbl IN PO_TBL_NUMBER

501:
502: PROCEDURE oop_enter_all_fields(
503: p_dist_id_tbl IN PO_TBL_NUMBER
504: , p_line_line_type_id_tbl IN PO_TBL_NUMBER
505: , p_wip_entity_id_tbl IN PO_TBL_NUMBER
506: , p_wip_line_id_tbl IN PO_TBL_NUMBER
507: , p_wip_operation_seq_num_tbl IN PO_TBL_NUMBER
508: , p_destination_type_code_tbl IN PO_TBL_VARCHAR30
509: , p_wip_resource_seq_num_tbl IN PO_TBL_NUMBER

Line 506: , p_wip_line_id_tbl IN PO_TBL_NUMBER

502: PROCEDURE oop_enter_all_fields(
503: p_dist_id_tbl IN PO_TBL_NUMBER
504: , p_line_line_type_id_tbl IN PO_TBL_NUMBER
505: , p_wip_entity_id_tbl IN PO_TBL_NUMBER
506: , p_wip_line_id_tbl IN PO_TBL_NUMBER
507: , p_wip_operation_seq_num_tbl IN PO_TBL_NUMBER
508: , p_destination_type_code_tbl IN PO_TBL_VARCHAR30
509: , p_wip_resource_seq_num_tbl IN PO_TBL_NUMBER
510: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

Line 507: , p_wip_operation_seq_num_tbl IN PO_TBL_NUMBER

503: p_dist_id_tbl IN PO_TBL_NUMBER
504: , p_line_line_type_id_tbl IN PO_TBL_NUMBER
505: , p_wip_entity_id_tbl IN PO_TBL_NUMBER
506: , p_wip_line_id_tbl IN PO_TBL_NUMBER
507: , p_wip_operation_seq_num_tbl IN PO_TBL_NUMBER
508: , p_destination_type_code_tbl IN PO_TBL_VARCHAR30
509: , p_wip_resource_seq_num_tbl IN PO_TBL_NUMBER
510: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
511: , x_result_type OUT NOCOPY VARCHAR2

Line 509: , p_wip_resource_seq_num_tbl IN PO_TBL_NUMBER

505: , p_wip_entity_id_tbl IN PO_TBL_NUMBER
506: , p_wip_line_id_tbl IN PO_TBL_NUMBER
507: , p_wip_operation_seq_num_tbl IN PO_TBL_NUMBER
508: , p_destination_type_code_tbl IN PO_TBL_VARCHAR30
509: , p_wip_resource_seq_num_tbl IN PO_TBL_NUMBER
510: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
511: , x_result_type OUT NOCOPY VARCHAR2
512: )
513: IS

Line 627: p_dist_id_tbl IN PO_TBL_NUMBER

623: -- encumber.
624: -- Agreements only.
625: -------------------------------------------------------------------------
626: PROCEDURE unencum_amt_le_amt_to_encum(
627: p_dist_id_tbl IN PO_TBL_NUMBER
628: , p_amount_to_encumber_tbl IN PO_TBL_NUMBER
629: , p_unencumbered_amount_tbl IN PO_TBL_NUMBER
630: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
631: , x_result_type OUT NOCOPY VARCHAR2

Line 628: , p_amount_to_encumber_tbl IN PO_TBL_NUMBER

624: -- Agreements only.
625: -------------------------------------------------------------------------
626: PROCEDURE unencum_amt_le_amt_to_encum(
627: p_dist_id_tbl IN PO_TBL_NUMBER
628: , p_amount_to_encumber_tbl IN PO_TBL_NUMBER
629: , p_unencumbered_amount_tbl IN PO_TBL_NUMBER
630: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
631: , x_result_type OUT NOCOPY VARCHAR2
632: )

Line 629: , p_unencumbered_amount_tbl IN PO_TBL_NUMBER

625: -------------------------------------------------------------------------
626: PROCEDURE unencum_amt_le_amt_to_encum(
627: p_dist_id_tbl IN PO_TBL_NUMBER
628: , p_amount_to_encumber_tbl IN PO_TBL_NUMBER
629: , p_unencumbered_amount_tbl IN PO_TBL_NUMBER
630: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
631: , x_result_type OUT NOCOPY VARCHAR2
632: )
633: IS

Line 655: p_dist_id_tbl IN PO_TBL_NUMBER

651: -- Checks that the Amount To Encumber is not null and >= 0.
652: -- Agreements only.
653: -----------------------------------------------------------------------------
654: PROCEDURE amount_to_encumber_ge_zero(
655: p_dist_id_tbl IN PO_TBL_NUMBER
656: , p_amount_to_encumber_tbl IN PO_TBL_NUMBER
657: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
658: , x_result_type OUT NOCOPY VARCHAR2
659: )

Line 656: , p_amount_to_encumber_tbl IN PO_TBL_NUMBER

652: -- Agreements only.
653: -----------------------------------------------------------------------------
654: PROCEDURE amount_to_encumber_ge_zero(
655: p_dist_id_tbl IN PO_TBL_NUMBER
656: , p_amount_to_encumber_tbl IN PO_TBL_NUMBER
657: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
658: , x_result_type OUT NOCOPY VARCHAR2
659: )
660: IS

Line 683: p_dist_id_tbl IN PO_TBL_NUMBER

679: -- Ensures that the Budget Account is not null.
680: -- Agreements only.
681: -------------------------------------------------------------------------------
682: PROCEDURE budget_account_id_not_null(
683: p_dist_id_tbl IN PO_TBL_NUMBER
684: , p_budget_account_id_tbl IN PO_TBL_NUMBER
685: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
686: , x_result_type OUT NOCOPY VARCHAR2
687: )

Line 684: , p_budget_account_id_tbl IN PO_TBL_NUMBER

680: -- Agreements only.
681: -------------------------------------------------------------------------------
682: PROCEDURE budget_account_id_not_null(
683: p_dist_id_tbl IN PO_TBL_NUMBER
684: , p_budget_account_id_tbl IN PO_TBL_NUMBER
685: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
686: , x_result_type OUT NOCOPY VARCHAR2
687: )
688: IS

Line 710: p_dist_id_tbl IN PO_TBL_NUMBER

706: -- Ensures that the GL Encumbered Date is not null.
707: -- Agreements only.
708: -------------------------------------------------------------------------------
709: PROCEDURE gl_encumbered_date_not_null(
710: p_dist_id_tbl IN PO_TBL_NUMBER
711: , p_gl_encumbered_date_tbl IN PO_TBL_DATE
712: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
713: , x_result_type OUT NOCOPY VARCHAR2
714: )

Line 737: p_dist_id_tbl IN PO_TBL_NUMBER

733: -- is in an open period.
734: -- For both SPOs and BPAs.
735: ------------------------------------------------------------------------
736: PROCEDURE gl_enc_date_not_null_open(
737: p_dist_id_tbl IN PO_TBL_NUMBER
738: , p_org_id_tbl IN PO_TBL_NUMBER
739: , p_gl_encumbered_date_tbl IN PO_TBL_DATE
740: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
741: , x_result_type OUT NOCOPY VARCHAR2

Line 738: , p_org_id_tbl IN PO_TBL_NUMBER

734: -- For both SPOs and BPAs.
735: ------------------------------------------------------------------------
736: PROCEDURE gl_enc_date_not_null_open(
737: p_dist_id_tbl IN PO_TBL_NUMBER
738: , p_org_id_tbl IN PO_TBL_NUMBER
739: , p_gl_encumbered_date_tbl IN PO_TBL_DATE
740: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
741: , x_result_type OUT NOCOPY VARCHAR2
742: )

Line 808: p_dist_id_tbl IN PO_TBL_NUMBER

804: -- award data on a distribution is valid.
805: --
806: ------------------------------------------------------------------------
807: PROCEDURE gms_data_valid(
808: p_dist_id_tbl IN PO_TBL_NUMBER
809: , p_project_id_tbl IN PO_TBL_NUMBER
810: , p_task_id_tbl IN PO_TBL_NUMBER
811: , p_award_number_tbl IN PO_TBL_VARCHAR2000
812: , p_expenditure_type_tbl IN PO_TBL_VARCHAR30

Line 809: , p_project_id_tbl IN PO_TBL_NUMBER

805: --
806: ------------------------------------------------------------------------
807: PROCEDURE gms_data_valid(
808: p_dist_id_tbl IN PO_TBL_NUMBER
809: , p_project_id_tbl IN PO_TBL_NUMBER
810: , p_task_id_tbl IN PO_TBL_NUMBER
811: , p_award_number_tbl IN PO_TBL_VARCHAR2000
812: , p_expenditure_type_tbl IN PO_TBL_VARCHAR30
813: , p_expenditure_item_date_tbl IN PO_TBL_DATE

Line 810: , p_task_id_tbl IN PO_TBL_NUMBER

806: ------------------------------------------------------------------------
807: PROCEDURE gms_data_valid(
808: p_dist_id_tbl IN PO_TBL_NUMBER
809: , p_project_id_tbl IN PO_TBL_NUMBER
810: , p_task_id_tbl IN PO_TBL_NUMBER
811: , p_award_number_tbl IN PO_TBL_VARCHAR2000
812: , p_expenditure_type_tbl IN PO_TBL_VARCHAR30
813: , p_expenditure_item_date_tbl IN PO_TBL_DATE
814: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

Line 818: l_failure_dist_id_tbl PO_TBL_NUMBER;

814: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
815: , x_result_type OUT NOCOPY VARCHAR2
816: )
817: IS
818: l_failure_dist_id_tbl PO_TBL_NUMBER;
819: l_failure_message_tbl PO_TBL_VARCHAR4000;
820: l_results_count NUMBER;
821:
822: BEGIN

Line 872: p_dist_id_tbl IN PO_TBL_NUMBER

868: -- Performs the federal financial validations for distributions
869: -- For Standard POs only.
870: ------------------------------------------------------------------------
871: PROCEDURE check_fv_validations(
872: p_dist_id_tbl IN PO_TBL_NUMBER
873: , p_ccid_tbl IN PO_TBL_NUMBER
874: , p_org_id_tbl IN PO_TBL_NUMBER
875: , p_attribute1_tbl IN PO_TBL_VARCHAR2000
876: , p_attribute2_tbl IN PO_TBL_VARCHAR2000

Line 873: , p_ccid_tbl IN PO_TBL_NUMBER

869: -- For Standard POs only.
870: ------------------------------------------------------------------------
871: PROCEDURE check_fv_validations(
872: p_dist_id_tbl IN PO_TBL_NUMBER
873: , p_ccid_tbl IN PO_TBL_NUMBER
874: , p_org_id_tbl IN PO_TBL_NUMBER
875: , p_attribute1_tbl IN PO_TBL_VARCHAR2000
876: , p_attribute2_tbl IN PO_TBL_VARCHAR2000
877: , p_attribute3_tbl IN PO_TBL_VARCHAR2000

Line 874: , p_org_id_tbl IN PO_TBL_NUMBER

870: ------------------------------------------------------------------------
871: PROCEDURE check_fv_validations(
872: p_dist_id_tbl IN PO_TBL_NUMBER
873: , p_ccid_tbl IN PO_TBL_NUMBER
874: , p_org_id_tbl IN PO_TBL_NUMBER
875: , p_attribute1_tbl IN PO_TBL_VARCHAR2000
876: , p_attribute2_tbl IN PO_TBL_VARCHAR2000
877: , p_attribute3_tbl IN PO_TBL_VARCHAR2000
878: , p_attribute4_tbl IN PO_TBL_VARCHAR2000

Line 1012: p_dist_id_tbl IN PO_TBL_NUMBER

1008: -- 4. If gms is not installed or if award is not required,
1009: -- expenditure item type is required.
1010: ------------------------------------------------------------------------
1011: PROCEDURE check_proj_related_validations(
1012: p_dist_id_tbl IN PO_TBL_NUMBER
1013: , p_dest_type_code_tbl IN PO_TBL_VARCHAR30
1014: , p_project_id_tbl IN PO_TBL_NUMBER
1015: , p_task_id_tbl IN PO_TBL_NUMBER
1016: , p_award_id_tbl IN PO_TBL_NUMBER

Line 1014: , p_project_id_tbl IN PO_TBL_NUMBER

1010: ------------------------------------------------------------------------
1011: PROCEDURE check_proj_related_validations(
1012: p_dist_id_tbl IN PO_TBL_NUMBER
1013: , p_dest_type_code_tbl IN PO_TBL_VARCHAR30
1014: , p_project_id_tbl IN PO_TBL_NUMBER
1015: , p_task_id_tbl IN PO_TBL_NUMBER
1016: , p_award_id_tbl IN PO_TBL_NUMBER
1017: , p_expenditure_type_tbl IN PO_TBL_VARCHAR30
1018: , p_expenditure_org_id_tbl IN PO_TBL_NUMBER

Line 1015: , p_task_id_tbl IN PO_TBL_NUMBER

1011: PROCEDURE check_proj_related_validations(
1012: p_dist_id_tbl IN PO_TBL_NUMBER
1013: , p_dest_type_code_tbl IN PO_TBL_VARCHAR30
1014: , p_project_id_tbl IN PO_TBL_NUMBER
1015: , p_task_id_tbl IN PO_TBL_NUMBER
1016: , p_award_id_tbl IN PO_TBL_NUMBER
1017: , p_expenditure_type_tbl IN PO_TBL_VARCHAR30
1018: , p_expenditure_org_id_tbl IN PO_TBL_NUMBER
1019: , p_expenditure_item_date_tbl IN PO_TBL_DATE

Line 1016: , p_award_id_tbl IN PO_TBL_NUMBER

1012: p_dist_id_tbl IN PO_TBL_NUMBER
1013: , p_dest_type_code_tbl IN PO_TBL_VARCHAR30
1014: , p_project_id_tbl IN PO_TBL_NUMBER
1015: , p_task_id_tbl IN PO_TBL_NUMBER
1016: , p_award_id_tbl IN PO_TBL_NUMBER
1017: , p_expenditure_type_tbl IN PO_TBL_VARCHAR30
1018: , p_expenditure_org_id_tbl IN PO_TBL_NUMBER
1019: , p_expenditure_item_date_tbl IN PO_TBL_DATE
1020: , p_ship_to_org_id_tbl IN PO_TBL_NUMBER

Line 1018: , p_expenditure_org_id_tbl IN PO_TBL_NUMBER

1014: , p_project_id_tbl IN PO_TBL_NUMBER
1015: , p_task_id_tbl IN PO_TBL_NUMBER
1016: , p_award_id_tbl IN PO_TBL_NUMBER
1017: , p_expenditure_type_tbl IN PO_TBL_VARCHAR30
1018: , p_expenditure_org_id_tbl IN PO_TBL_NUMBER
1019: , p_expenditure_item_date_tbl IN PO_TBL_DATE
1020: , p_ship_to_org_id_tbl IN PO_TBL_NUMBER
1021: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1022: , x_result_type OUT NOCOPY VARCHAR2

Line 1020: , p_ship_to_org_id_tbl IN PO_TBL_NUMBER

1016: , p_award_id_tbl IN PO_TBL_NUMBER
1017: , p_expenditure_type_tbl IN PO_TBL_VARCHAR30
1018: , p_expenditure_org_id_tbl IN PO_TBL_NUMBER
1019: , p_expenditure_item_date_tbl IN PO_TBL_DATE
1020: , p_ship_to_org_id_tbl IN PO_TBL_NUMBER
1021: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1022: , x_result_type OUT NOCOPY VARCHAR2
1023: )
1024: IS