APPS.PO_VAL_DISTRIBUTIONS dependencies on PO_TBL_VARCHAR30

Line 185: , p_value_basis_tbl IN PO_TBL_VARCHAR30 --

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
189: , p_header_id_tbl IN PO_TBL_NUMBER --

Line 186: , p_cost_constraint_tbl IN PO_TBL_VARCHAR30

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
189: , p_header_id_tbl IN PO_TBL_NUMBER --
190: )

Line 235: , p_dist_type_tbl IN PO_TBL_VARCHAR30

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
239: )

Line 338: , p_value_basis_tbl IN PO_TBL_VARCHAR30 --

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
342: , p_header_id_tbl IN PO_TBL_NUMBER --

Line 339: , p_cost_constraint_tbl IN PO_TBL_VARCHAR30

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
342: , p_header_id_tbl IN PO_TBL_NUMBER --
343: )

Line 387: , p_dist_type_tbl IN PO_TBL_VARCHAR30

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
391: )

Line 494: , p_end_item_unit_number_tbl IN PO_TBL_VARCHAR30

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
498: , p_destination_type_code_tbl IN PO_TBL_VARCHAR30

Line 498: , p_destination_type_code_tbl IN PO_TBL_VARCHAR30

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
501: )
502: IS

Line 582: , p_destination_type_code_tbl IN PO_TBL_VARCHAR30

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
586: )

Line 814: , p_dist_type_tbl IN PO_TBL_VARCHAR30 --Bug 14664343

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
817: )
818: IS

Line 905: , p_expenditure_type_tbl IN PO_TBL_VARCHAR30

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
908: , x_result_type OUT NOCOPY VARCHAR2
909: )

Line 1415: , p_line_matching_basis_tbl IN PO_TBL_VARCHAR30 --bug 13773450

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: )
1419: IS

Line 1603: , p_dest_type_code_tbl IN PO_TBL_VARCHAR30

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
1607: , p_expenditure_type_tbl IN PO_TBL_VARCHAR30

Line 1607: , p_expenditure_type_tbl IN PO_TBL_VARCHAR30

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
1611: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

Line 1756: p_dist_type_tbl IN PO_TBL_VARCHAR30,

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,
1760: p_funded_value_tbl IN PO_TBL_NUMBER,

Line 1923: p_draft_type_tbl IN PO_TBL_VARCHAR30,

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,
1927: p_change_status_tbl IN PO_TBL_VARCHAR30,

Line 1927: p_change_status_tbl IN PO_TBL_VARCHAR30,

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:
1931: IS

Line 2076: p_clm_defence_funding_tbl IN PO_TBL_VARCHAR30,

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
2080: