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_DISTRIBUTIONS2 dependencies on PO_TBL_NUMBER

Line 40: p_id_tbl IN po_tbl_number,

36: -- If order_type_code is other than RATE or FIXED PRICE,
37: -- Quantity_ordered must not be null and be greater than 0
38: -----------------------------------------------------------
39: PROCEDURE amount_ordered(
40: p_id_tbl IN po_tbl_number,
41: p_amount_ordered_tbl IN po_tbl_number,
42: p_order_type_code_tbl IN po_tbl_varchar30,
43: p_distribution_type_tbl IN po_tbl_varchar30, -- PDOI for Complex PO Project
44: x_results IN OUT NOCOPY po_validation_results_type,

Line 41: p_amount_ordered_tbl IN po_tbl_number,

37: -- Quantity_ordered must not be null and be greater than 0
38: -----------------------------------------------------------
39: PROCEDURE amount_ordered(
40: p_id_tbl IN po_tbl_number,
41: p_amount_ordered_tbl IN po_tbl_number,
42: p_order_type_code_tbl IN po_tbl_varchar30,
43: p_distribution_type_tbl IN po_tbl_varchar30, -- PDOI for Complex PO Project
44: x_results IN OUT NOCOPY po_validation_results_type,
45: x_result_type OUT NOCOPY VARCHAR2)

Line 108: p_id_tbl IN po_tbl_number,

104: -- If order_type_code is other than RATE or FIXED PRICE,
105: -- Quantity_ordered must not be null and be greater than 0
106: -----------------------------------------------------------
107: PROCEDURE quantity_ordered(
108: p_id_tbl IN po_tbl_number,
109: p_quantity_ordered_tbl IN po_tbl_number,
110: p_order_type_code_tbl IN po_tbl_varchar30,
111: p_distribution_type_tbl IN po_tbl_varchar30, -- PDOI for Complex PO Project
112: x_results IN OUT NOCOPY po_validation_results_type,

Line 109: p_quantity_ordered_tbl IN po_tbl_number,

105: -- Quantity_ordered must not be null and be greater than 0
106: -----------------------------------------------------------
107: PROCEDURE quantity_ordered(
108: p_id_tbl IN po_tbl_number,
109: p_quantity_ordered_tbl IN po_tbl_number,
110: p_order_type_code_tbl IN po_tbl_varchar30,
111: p_distribution_type_tbl IN po_tbl_varchar30, -- PDOI for Complex PO Project
112: x_results IN OUT NOCOPY po_validation_results_type,
113: x_result_type OUT NOCOPY VARCHAR2)

Line 173: p_id_tbl IN po_tbl_number,

169: -- Validation Logic:
170: -- Should be the same as ship_to_organization_id.
171: -----------------------------------------------------------
172: PROCEDURE destination_org_id(
173: p_id_tbl IN po_tbl_number,
174: p_dest_org_id_tbl IN po_tbl_number,
175: p_ship_to_org_id_tbl IN po_tbl_number,
176: x_results IN OUT NOCOPY po_validation_results_type,
177: x_result_type OUT NOCOPY VARCHAR2)

Line 174: p_dest_org_id_tbl IN po_tbl_number,

170: -- Should be the same as ship_to_organization_id.
171: -----------------------------------------------------------
172: PROCEDURE destination_org_id(
173: p_id_tbl IN po_tbl_number,
174: p_dest_org_id_tbl IN po_tbl_number,
175: p_ship_to_org_id_tbl IN po_tbl_number,
176: x_results IN OUT NOCOPY po_validation_results_type,
177: x_result_type OUT NOCOPY VARCHAR2)
178: IS

Line 175: p_ship_to_org_id_tbl IN po_tbl_number,

171: -----------------------------------------------------------
172: PROCEDURE destination_org_id(
173: p_id_tbl IN po_tbl_number,
174: p_dest_org_id_tbl IN po_tbl_number,
175: p_ship_to_org_id_tbl IN po_tbl_number,
176: x_results IN OUT NOCOPY po_validation_results_type,
177: x_result_type OUT NOCOPY VARCHAR2)
178: IS
179: d_mod CONSTANT VARCHAR2(100) := d_destination_org_id;

Line 226: p_id_tbl IN po_tbl_number,

222: -- If deliver_to_location_id is not null,
223: -- then validate against hr_locations based on ship_to_organization_id
224: -----------------------------------------------------------
225: PROCEDURE deliver_to_location_id(
226: p_id_tbl IN po_tbl_number,
227: p_deliver_to_location_id_tbl IN po_tbl_number,
228: p_ship_to_org_id_tbl IN po_tbl_number,
229: x_result_set_id IN OUT NOCOPY NUMBER,
230: x_result_type OUT NOCOPY VARCHAR2)

Line 227: p_deliver_to_location_id_tbl IN po_tbl_number,

223: -- then validate against hr_locations based on ship_to_organization_id
224: -----------------------------------------------------------
225: PROCEDURE deliver_to_location_id(
226: p_id_tbl IN po_tbl_number,
227: p_deliver_to_location_id_tbl IN po_tbl_number,
228: p_ship_to_org_id_tbl IN po_tbl_number,
229: x_result_set_id IN OUT NOCOPY NUMBER,
230: x_result_type OUT NOCOPY VARCHAR2)
231: IS

Line 228: p_ship_to_org_id_tbl IN po_tbl_number,

224: -----------------------------------------------------------
225: PROCEDURE deliver_to_location_id(
226: p_id_tbl IN po_tbl_number,
227: p_deliver_to_location_id_tbl IN po_tbl_number,
228: p_ship_to_org_id_tbl IN po_tbl_number,
229: x_result_set_id IN OUT NOCOPY NUMBER,
230: x_result_type OUT NOCOPY VARCHAR2)
231: IS
232: d_mod CONSTANT VARCHAR2(100) := d_deliver_to_location_id;

Line 304: p_id_tbl IN po_tbl_number,

300: -- Validation Logic:
301: -- If deliver_to_person_id is not null, then validate against hr_employees_current_v
302: -----------------------------------------------------------
303: PROCEDURE deliver_to_person_id(
304: p_id_tbl IN po_tbl_number,
305: p_deliver_to_person_id_tbl IN po_tbl_number,
306: x_result_set_id IN OUT NOCOPY NUMBER,
307: x_result_type OUT NOCOPY VARCHAR2)
308: IS

Line 305: p_deliver_to_person_id_tbl IN po_tbl_number,

301: -- If deliver_to_person_id is not null, then validate against hr_employees_current_v
302: -----------------------------------------------------------
303: PROCEDURE deliver_to_person_id(
304: p_id_tbl IN po_tbl_number,
305: p_deliver_to_person_id_tbl IN po_tbl_number,
306: x_result_set_id IN OUT NOCOPY NUMBER,
307: x_result_type OUT NOCOPY VARCHAR2)
308: IS
309: d_mod CONSTANT VARCHAR2(100) := d_deliver_to_person_id;

Line 440: p_id_tbl IN po_tbl_number,

436: -- Cannot be INVENTORY if item_id is null.
437: -- If SHIKYU item, then dest type code must be INVENTORY.
438: -----------------------------------------------------------
439: PROCEDURE destination_type_code(
440: p_id_tbl IN po_tbl_number,
441: p_dest_type_code_tbl IN po_tbl_varchar30,
442: p_ship_to_org_id_tbl IN po_tbl_number,
443: p_item_id_tbl IN po_tbl_number,
444: p_txn_flow_header_id_tbl IN po_tbl_number,

Line 442: p_ship_to_org_id_tbl IN po_tbl_number,

438: -----------------------------------------------------------
439: PROCEDURE destination_type_code(
440: p_id_tbl IN po_tbl_number,
441: p_dest_type_code_tbl IN po_tbl_varchar30,
442: p_ship_to_org_id_tbl IN po_tbl_number,
443: p_item_id_tbl IN po_tbl_number,
444: p_txn_flow_header_id_tbl IN po_tbl_number,
445: p_accrue_on_receipt_flag_tbl IN po_tbl_varchar1,
446: p_value_basis_tbl IN po_tbl_varchar30,

Line 443: p_item_id_tbl IN po_tbl_number,

439: PROCEDURE destination_type_code(
440: p_id_tbl IN po_tbl_number,
441: p_dest_type_code_tbl IN po_tbl_varchar30,
442: p_ship_to_org_id_tbl IN po_tbl_number,
443: p_item_id_tbl IN po_tbl_number,
444: p_txn_flow_header_id_tbl IN po_tbl_number,
445: p_accrue_on_receipt_flag_tbl IN po_tbl_varchar1,
446: p_value_basis_tbl IN po_tbl_varchar30,
447: p_purchase_basis_tbl IN po_tbl_varchar30, --bug 7644072

Line 444: p_txn_flow_header_id_tbl IN po_tbl_number,

440: p_id_tbl IN po_tbl_number,
441: p_dest_type_code_tbl IN po_tbl_varchar30,
442: p_ship_to_org_id_tbl IN po_tbl_number,
443: p_item_id_tbl IN po_tbl_number,
444: p_txn_flow_header_id_tbl IN po_tbl_number,
445: p_accrue_on_receipt_flag_tbl IN po_tbl_varchar1,
446: p_value_basis_tbl IN po_tbl_varchar30,
447: p_purchase_basis_tbl IN po_tbl_varchar30, --bug 7644072
448: p_expense_accrual_code IN po_system_parameters.expense_accrual_code%TYPE,

Line 449: p_loc_outsourced_assembly_tbl IN po_tbl_number,

445: p_accrue_on_receipt_flag_tbl IN po_tbl_varchar1,
446: p_value_basis_tbl IN po_tbl_varchar30,
447: p_purchase_basis_tbl IN po_tbl_varchar30, --bug 7644072
448: p_expense_accrual_code IN po_system_parameters.expense_accrual_code%TYPE,
449: p_loc_outsourced_assembly_tbl IN po_tbl_number,
450: x_result_set_id IN OUT NOCOPY NUMBER,
451: x_results IN OUT NOCOPY po_validation_results_type,
452: x_result_type OUT NOCOPY VARCHAR2)
453: IS

Line 463: l_index_tbl PO_TBL_NUMBER;

459: l_key po_session_gt.key%TYPE;
460: l_num_list_tbl DBMS_SQL.NUMBER_TABLE;
461:
462: -- tables to store the derived result
463: l_index_tbl PO_TBL_NUMBER;
464: l_result_tbl PO_TBL_VARCHAR1;
465: l_item_status_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
466:
467: BEGIN

Line 658: p_id_tbl IN po_tbl_number,

654: -- If destination_type_code is SHOP FLOOR and EXPENSE, the value has to be NULL.
655: -- Need to validate that SHIKYU item can only have asset subinventory (inventory_asset = 1).
656: -----------------------------------------------------------
657: PROCEDURE destination_subinv(
658: p_id_tbl IN po_tbl_number,
659: p_destination_subinv_tbl IN po_tbl_varchar30,
660: p_dest_type_code_tbl IN po_tbl_varchar30,
661: p_item_id_tbl IN po_tbl_number,
662: p_ship_to_org_id_tbl IN po_tbl_number,

Line 661: p_item_id_tbl IN po_tbl_number,

657: PROCEDURE destination_subinv(
658: p_id_tbl IN po_tbl_number,
659: p_destination_subinv_tbl IN po_tbl_varchar30,
660: p_dest_type_code_tbl IN po_tbl_varchar30,
661: p_item_id_tbl IN po_tbl_number,
662: p_ship_to_org_id_tbl IN po_tbl_number,
663: p_loc_outsourced_assembly_tbl IN po_tbl_number,
664: x_result_set_id IN OUT NOCOPY NUMBER,
665: x_results IN OUT NOCOPY po_validation_results_type,

Line 662: p_ship_to_org_id_tbl IN po_tbl_number,

658: p_id_tbl IN po_tbl_number,
659: p_destination_subinv_tbl IN po_tbl_varchar30,
660: p_dest_type_code_tbl IN po_tbl_varchar30,
661: p_item_id_tbl IN po_tbl_number,
662: p_ship_to_org_id_tbl IN po_tbl_number,
663: p_loc_outsourced_assembly_tbl IN po_tbl_number,
664: x_result_set_id IN OUT NOCOPY NUMBER,
665: x_results IN OUT NOCOPY po_validation_results_type,
666: x_result_type OUT NOCOPY VARCHAR2)

Line 663: p_loc_outsourced_assembly_tbl IN po_tbl_number,

659: p_destination_subinv_tbl IN po_tbl_varchar30,
660: p_dest_type_code_tbl IN po_tbl_varchar30,
661: p_item_id_tbl IN po_tbl_number,
662: p_ship_to_org_id_tbl IN po_tbl_number,
663: p_loc_outsourced_assembly_tbl IN po_tbl_number,
664: x_result_set_id IN OUT NOCOPY NUMBER,
665: x_results IN OUT NOCOPY po_validation_results_type,
666: x_result_type OUT NOCOPY VARCHAR2)
667: IS

Line 820: p_id_tbl IN po_tbl_number,

816: -- WIP_REPETITIVE_SCHEDULE_ID is NULL, then it
817: -- must be a discrete job)
818: -----------------------------------------------------------
819: PROCEDURE wip_entity_id(
820: p_id_tbl IN po_tbl_number,
821: p_wip_entity_id_tbl IN po_tbl_number,
822: p_wip_rep_schedule_id_tbl IN po_tbl_number,
823: p_dest_type_code_tbl IN po_tbl_varchar30,
824: p_destination_org_id_tbl IN po_tbl_number,

Line 821: p_wip_entity_id_tbl IN po_tbl_number,

817: -- must be a discrete job)
818: -----------------------------------------------------------
819: PROCEDURE wip_entity_id(
820: p_id_tbl IN po_tbl_number,
821: p_wip_entity_id_tbl IN po_tbl_number,
822: p_wip_rep_schedule_id_tbl IN po_tbl_number,
823: p_dest_type_code_tbl IN po_tbl_varchar30,
824: p_destination_org_id_tbl IN po_tbl_number,
825: x_result_set_id IN OUT NOCOPY NUMBER,

Line 822: p_wip_rep_schedule_id_tbl IN po_tbl_number,

818: -----------------------------------------------------------
819: PROCEDURE wip_entity_id(
820: p_id_tbl IN po_tbl_number,
821: p_wip_entity_id_tbl IN po_tbl_number,
822: p_wip_rep_schedule_id_tbl IN po_tbl_number,
823: p_dest_type_code_tbl IN po_tbl_varchar30,
824: p_destination_org_id_tbl IN po_tbl_number,
825: x_result_set_id IN OUT NOCOPY NUMBER,
826: x_results IN OUT NOCOPY po_validation_results_type,

Line 824: p_destination_org_id_tbl IN po_tbl_number,

820: p_id_tbl IN po_tbl_number,
821: p_wip_entity_id_tbl IN po_tbl_number,
822: p_wip_rep_schedule_id_tbl IN po_tbl_number,
823: p_dest_type_code_tbl IN po_tbl_varchar30,
824: p_destination_org_id_tbl IN po_tbl_number,
825: x_result_set_id IN OUT NOCOPY NUMBER,
826: x_results IN OUT NOCOPY po_validation_results_type,
827: x_result_type OUT NOCOPY VARCHAR2)
828: IS

Line 956: p_id_tbl IN po_tbl_number,

952: -- The value needs to be 'Y' if the destination_type_code is 'SHOP FLOOR'.
953: -- For other destination type, the value has to be 'N'.
954: -----------------------------------------------------------
955: PROCEDURE prevent_encumbrance_flag(
956: p_id_tbl IN po_tbl_number,
957: p_prevent_encum_flag_tbl IN po_tbl_varchar1,
958: p_dest_type_code_tbl IN po_tbl_varchar30,
959: p_distribution_type_tbl IN po_tbl_varchar30, -- PDOI for Complex PO Project
960: p_wip_entity_id_tbl IN po_tbl_number,

Line 960: p_wip_entity_id_tbl IN po_tbl_number,

956: p_id_tbl IN po_tbl_number,
957: p_prevent_encum_flag_tbl IN po_tbl_varchar1,
958: p_dest_type_code_tbl IN po_tbl_varchar30,
959: p_distribution_type_tbl IN po_tbl_varchar30, -- PDOI for Complex PO Project
960: p_wip_entity_id_tbl IN po_tbl_number,
961: x_results IN OUT NOCOPY po_validation_results_type,
962: x_result_type OUT NOCOPY VARCHAR2)
963: IS
964: d_mod CONSTANT VARCHAR2(100) := d_prevent_encumberance_flag;

Line 1030: p_id_tbl IN po_tbl_number,

1026: -- The charge_account_id can not be null.
1027: -- If it is not null, it must be a valid id in gl_code_combinations.
1028: -----------------------------------------------------------
1029: PROCEDURE charge_account_id(
1030: p_id_tbl IN po_tbl_number,
1031: p_charge_account_id_tbl IN po_tbl_number,
1032: p_gl_date_tbl IN po_tbl_date,
1033: p_chart_of_account_id IN NUMBER,
1034: x_result_set_id IN OUT NOCOPY NUMBER,

Line 1031: p_charge_account_id_tbl IN po_tbl_number,

1027: -- If it is not null, it must be a valid id in gl_code_combinations.
1028: -----------------------------------------------------------
1029: PROCEDURE charge_account_id(
1030: p_id_tbl IN po_tbl_number,
1031: p_charge_account_id_tbl IN po_tbl_number,
1032: p_gl_date_tbl IN po_tbl_date,
1033: p_chart_of_account_id IN NUMBER,
1034: x_result_set_id IN OUT NOCOPY NUMBER,
1035: x_result_type OUT NOCOPY VARCHAR2)

Line 1114: p_id_tbl IN po_tbl_number,

1110: -- the budget_account_id can not be null.
1111: -- 2. If the account_id is not null, it must be a valid id in gl_code_combinations.
1112: -----------------------------------------------------------
1113: PROCEDURE budget_account_id(
1114: p_id_tbl IN po_tbl_number,
1115: p_budget_account_id_tbl IN po_tbl_number,
1116: p_gl_date_tbl IN po_tbl_date,
1117: p_dest_type_code_tbl IN po_tbl_varchar30,
1118: p_distribution_type_tbl IN po_tbl_varchar30, -- PDOI for Complex PO Project

Line 1115: p_budget_account_id_tbl IN po_tbl_number,

1111: -- 2. If the account_id is not null, it must be a valid id in gl_code_combinations.
1112: -----------------------------------------------------------
1113: PROCEDURE budget_account_id(
1114: p_id_tbl IN po_tbl_number,
1115: p_budget_account_id_tbl IN po_tbl_number,
1116: p_gl_date_tbl IN po_tbl_date,
1117: p_dest_type_code_tbl IN po_tbl_varchar30,
1118: p_distribution_type_tbl IN po_tbl_varchar30, -- PDOI for Complex PO Project
1119: p_chart_of_account_id IN NUMBER,

Line 1121: p_wip_entity_id_tbl IN po_tbl_number,

1117: p_dest_type_code_tbl IN po_tbl_varchar30,
1118: p_distribution_type_tbl IN po_tbl_varchar30, -- PDOI for Complex PO Project
1119: p_chart_of_account_id IN NUMBER,
1120: p_po_encumberance_flag IN VARCHAR2,
1121: p_wip_entity_id_tbl IN po_tbl_number,
1122: x_result_set_id IN OUT NOCOPY NUMBER,
1123: x_result_type OUT NOCOPY VARCHAR2)
1124: IS
1125: d_mod CONSTANT VARCHAR2(100) := d_budget_account_id;

Line 1214: p_id_tbl IN po_tbl_number,

1210: -- If the account_id is not null, it must be a valid id in gl_code_combinations.
1211: -- Used to validate accrual account id and variance account id.
1212: ----------------------------------------------------------------------------------
1213: PROCEDURE account_id(
1214: p_id_tbl IN po_tbl_number,
1215: p_account_id_tbl IN po_tbl_number,
1216: p_gl_date_tbl IN po_tbl_date,
1217: p_chart_of_account_id IN NUMBER,
1218: p_message_name IN VARCHAR2,

Line 1215: p_account_id_tbl IN po_tbl_number,

1211: -- Used to validate accrual account id and variance account id.
1212: ----------------------------------------------------------------------------------
1213: PROCEDURE account_id(
1214: p_id_tbl IN po_tbl_number,
1215: p_account_id_tbl IN po_tbl_number,
1216: p_gl_date_tbl IN po_tbl_date,
1217: p_chart_of_account_id IN NUMBER,
1218: p_message_name IN VARCHAR2,
1219: p_column_name IN VARCHAR2,

Line 1302: p_id_tbl IN po_tbl_number,

1298: -- Project_accounting_context must be 'Y' if the values of project_id, task_id, expenditure_type,
1299: -- expenditure_organization_id are all not null.
1300: -----------------------------------------------------------
1301: PROCEDURE project_acct_context(
1302: p_id_tbl IN po_tbl_number,
1303: p_project_acct_ctx_tbl IN po_tbl_varchar30,
1304: p_project_id_tbl IN po_tbl_number,
1305: p_task_id_tbl IN po_tbl_number,
1306: p_exp_type_tbl IN po_tbl_varchar30,

Line 1304: p_project_id_tbl IN po_tbl_number,

1300: -----------------------------------------------------------
1301: PROCEDURE project_acct_context(
1302: p_id_tbl IN po_tbl_number,
1303: p_project_acct_ctx_tbl IN po_tbl_varchar30,
1304: p_project_id_tbl IN po_tbl_number,
1305: p_task_id_tbl IN po_tbl_number,
1306: p_exp_type_tbl IN po_tbl_varchar30,
1307: p_exp_org_id_tbl IN po_tbl_number,
1308: x_results IN OUT NOCOPY po_validation_results_type,

Line 1305: p_task_id_tbl IN po_tbl_number,

1301: PROCEDURE project_acct_context(
1302: p_id_tbl IN po_tbl_number,
1303: p_project_acct_ctx_tbl IN po_tbl_varchar30,
1304: p_project_id_tbl IN po_tbl_number,
1305: p_task_id_tbl IN po_tbl_number,
1306: p_exp_type_tbl IN po_tbl_varchar30,
1307: p_exp_org_id_tbl IN po_tbl_number,
1308: x_results IN OUT NOCOPY po_validation_results_type,
1309: x_result_type OUT NOCOPY VARCHAR2)

Line 1307: p_exp_org_id_tbl IN po_tbl_number,

1303: p_project_acct_ctx_tbl IN po_tbl_varchar30,
1304: p_project_id_tbl IN po_tbl_number,
1305: p_task_id_tbl IN po_tbl_number,
1306: p_exp_type_tbl IN po_tbl_varchar30,
1307: p_exp_org_id_tbl IN po_tbl_number,
1308: x_results IN OUT NOCOPY po_validation_results_type,
1309: x_result_type OUT NOCOPY VARCHAR2)
1310: IS
1311: d_mod CONSTANT VARCHAR2(100) := d_project_acct_context;

Line 1373: p_id_tbl IN po_tbl_number,

1369: -- b. validate expenditure_type against pa_expenditure_types if not null
1370: -- c. validate expenditure_organization_id against per_organzaition_units.
1371: -----------------------------------------------------------
1372: PROCEDURE project_info(
1373: p_id_tbl IN po_tbl_number,
1374: p_project_acct_ctx_tbl IN po_tbl_varchar30,
1375: p_dest_type_code_tbl IN po_tbl_varchar30,
1376: p_project_id_tbl IN po_tbl_number,
1377: p_task_id_tbl IN po_tbl_number,

Line 1376: p_project_id_tbl IN po_tbl_number,

1372: PROCEDURE project_info(
1373: p_id_tbl IN po_tbl_number,
1374: p_project_acct_ctx_tbl IN po_tbl_varchar30,
1375: p_dest_type_code_tbl IN po_tbl_varchar30,
1376: p_project_id_tbl IN po_tbl_number,
1377: p_task_id_tbl IN po_tbl_number,
1378: p_expenditure_type_tbl IN po_tbl_varchar30,
1379: p_expenditure_org_id_tbl IN po_tbl_number,
1380: p_ship_to_org_id_tbl IN po_tbl_number,

Line 1377: p_task_id_tbl IN po_tbl_number,

1373: p_id_tbl IN po_tbl_number,
1374: p_project_acct_ctx_tbl IN po_tbl_varchar30,
1375: p_dest_type_code_tbl IN po_tbl_varchar30,
1376: p_project_id_tbl IN po_tbl_number,
1377: p_task_id_tbl IN po_tbl_number,
1378: p_expenditure_type_tbl IN po_tbl_varchar30,
1379: p_expenditure_org_id_tbl IN po_tbl_number,
1380: p_ship_to_org_id_tbl IN po_tbl_number,
1381: p_need_by_date_tbl IN po_tbl_date,

Line 1379: p_expenditure_org_id_tbl IN po_tbl_number,

1375: p_dest_type_code_tbl IN po_tbl_varchar30,
1376: p_project_id_tbl IN po_tbl_number,
1377: p_task_id_tbl IN po_tbl_number,
1378: p_expenditure_type_tbl IN po_tbl_varchar30,
1379: p_expenditure_org_id_tbl IN po_tbl_number,
1380: p_ship_to_org_id_tbl IN po_tbl_number,
1381: p_need_by_date_tbl IN po_tbl_date,
1382: p_promised_date_tbl IN po_tbl_date,
1383: p_expenditure_item_date_tbl IN po_tbl_date,

Line 1380: p_ship_to_org_id_tbl IN po_tbl_number,

1376: p_project_id_tbl IN po_tbl_number,
1377: p_task_id_tbl IN po_tbl_number,
1378: p_expenditure_type_tbl IN po_tbl_varchar30,
1379: p_expenditure_org_id_tbl IN po_tbl_number,
1380: p_ship_to_org_id_tbl IN po_tbl_number,
1381: p_need_by_date_tbl IN po_tbl_date,
1382: p_promised_date_tbl IN po_tbl_date,
1383: p_expenditure_item_date_tbl IN po_tbl_date,
1384: p_ship_to_ou_id IN NUMBER,

Line 1385: p_deliver_to_person_id_tbl IN po_tbl_number,

1381: p_need_by_date_tbl IN po_tbl_date,
1382: p_promised_date_tbl IN po_tbl_date,
1383: p_expenditure_item_date_tbl IN po_tbl_date,
1384: p_ship_to_ou_id IN NUMBER,
1385: p_deliver_to_person_id_tbl IN po_tbl_number,
1386: p_agent_id_tbl IN po_tbl_number,
1387: p_txn_flow_header_id_tbl IN po_tbl_number,
1388: x_results IN OUT NOCOPY po_validation_results_type,
1389: x_result_type OUT NOCOPY VARCHAR2)

Line 1386: p_agent_id_tbl IN po_tbl_number,

1382: p_promised_date_tbl IN po_tbl_date,
1383: p_expenditure_item_date_tbl IN po_tbl_date,
1384: p_ship_to_ou_id IN NUMBER,
1385: p_deliver_to_person_id_tbl IN po_tbl_number,
1386: p_agent_id_tbl IN po_tbl_number,
1387: p_txn_flow_header_id_tbl IN po_tbl_number,
1388: x_results IN OUT NOCOPY po_validation_results_type,
1389: x_result_type OUT NOCOPY VARCHAR2)
1390: IS

Line 1387: p_txn_flow_header_id_tbl IN po_tbl_number,

1383: p_expenditure_item_date_tbl IN po_tbl_date,
1384: p_ship_to_ou_id IN NUMBER,
1385: p_deliver_to_person_id_tbl IN po_tbl_number,
1386: p_agent_id_tbl IN po_tbl_number,
1387: p_txn_flow_header_id_tbl IN po_tbl_number,
1388: x_results IN OUT NOCOPY po_validation_results_type,
1389: x_result_type OUT NOCOPY VARCHAR2)
1390: IS
1391: d_mod CONSTANT VARCHAR2(100) := d_project_info;

Line 1490: PROCEDURE tax_recovery_override_flag(p_id_tbl IN po_tbl_number,

1486: -- Validation Logic:
1487: -- If tax_recovery_override_flag is 'Y' and
1488: -- p_allow_tax_rate_override is not 'Y', throw an error
1489: -----------------------------------------------------------
1490: PROCEDURE tax_recovery_override_flag(p_id_tbl IN po_tbl_number,
1491: p_recovery_override_flag_tbl IN po_tbl_varchar1,
1492: p_allow_tax_rate_override IN VARCHAR2,
1493: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
1494: x_result_type OUT NOCOPY VARCHAR2)

Line 1545: p_dist_id_tbl IN PO_TBL_NUMBER

1541: -- returns an error then throw an error
1542: -----------------------------------------------------------
1543:
1544: PROCEDURE ACRN_value_valid(
1545: p_dist_id_tbl IN PO_TBL_NUMBER
1546: , p_style_id_tbl IN PO_TBL_NUMBER
1547: , p_ACRN_tbl IN PO_TBL_VARCHAR30
1548: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1549: , x_result_type OUT NOCOPY VARCHAR2

Line 1546: , p_style_id_tbl IN PO_TBL_NUMBER

1542: -----------------------------------------------------------
1543:
1544: PROCEDURE ACRN_value_valid(
1545: p_dist_id_tbl IN PO_TBL_NUMBER
1546: , p_style_id_tbl IN PO_TBL_NUMBER
1547: , p_ACRN_tbl IN PO_TBL_VARCHAR30
1548: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
1549: , x_result_type OUT NOCOPY VARCHAR2
1550: )

Line 1639: PROCEDURE partial_funded_flag(p_id_tbl IN po_tbl_number,

1635: -- Note: If Funded value is greater than the Total Order value, a warning
1636: -- need to be thrown. But the tax amount is not yet calculated, this
1637: -- validation will be done in Post Processing.
1638: --------------------------------------------------------------------------
1639: PROCEDURE partial_funded_flag(p_id_tbl IN po_tbl_number,
1640: p_partial_funded_flag_tbl IN po_tbl_varchar1,
1641: p_funded_value_tbl IN po_tbl_number,
1642: p_style_id_tbl IN po_tbl_number,
1643: p_po_encumberance_flag IN VARCHAR2,

Line 1641: p_funded_value_tbl IN po_tbl_number,

1637: -- validation will be done in Post Processing.
1638: --------------------------------------------------------------------------
1639: PROCEDURE partial_funded_flag(p_id_tbl IN po_tbl_number,
1640: p_partial_funded_flag_tbl IN po_tbl_varchar1,
1641: p_funded_value_tbl IN po_tbl_number,
1642: p_style_id_tbl IN po_tbl_number,
1643: p_po_encumberance_flag IN VARCHAR2,
1644: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
1645: x_result_type OUT NOCOPY VARCHAR2)

Line 1642: p_style_id_tbl IN po_tbl_number,

1638: --------------------------------------------------------------------------
1639: PROCEDURE partial_funded_flag(p_id_tbl IN po_tbl_number,
1640: p_partial_funded_flag_tbl IN po_tbl_varchar1,
1641: p_funded_value_tbl IN po_tbl_number,
1642: p_style_id_tbl IN po_tbl_number,
1643: p_po_encumberance_flag IN VARCHAR2,
1644: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
1645: x_result_type OUT NOCOPY VARCHAR2)
1646: IS