DBA Data[Home] [Help]

APPS.PO_VAL_DISTRIBUTIONS2 dependencies on PO_TBL_VARCHAR30

Line 38: p_order_type_code_tbl IN po_tbl_varchar30,

34: -----------------------------------------------------------
35: PROCEDURE amount_ordered(
36: p_id_tbl IN po_tbl_number,
37: p_amount_ordered_tbl IN po_tbl_number,
38: p_order_type_code_tbl IN po_tbl_varchar30,
39: x_results IN OUT NOCOPY po_validation_results_type,
40: x_result_type OUT NOCOPY VARCHAR2)
41: IS
42: d_mod CONSTANT VARCHAR2(100) := d_amount_ordered;

Line 102: p_order_type_code_tbl IN po_tbl_varchar30,

98: -----------------------------------------------------------
99: PROCEDURE quantity_ordered(
100: p_id_tbl IN po_tbl_number,
101: p_quantity_ordered_tbl IN po_tbl_number,
102: p_order_type_code_tbl IN po_tbl_varchar30,
103: x_results IN OUT NOCOPY po_validation_results_type,
104: x_result_type OUT NOCOPY VARCHAR2)
105: IS
106: d_mod CONSTANT VARCHAR2(100) := d_quantity_ordered;

Line 429: p_dest_type_code_tbl IN po_tbl_varchar30,

425: -- If SHIKYU item, then dest type code must be INVENTORY.
426: -----------------------------------------------------------
427: PROCEDURE destination_type_code(
428: p_id_tbl IN po_tbl_number,
429: p_dest_type_code_tbl IN po_tbl_varchar30,
430: p_ship_to_org_id_tbl IN po_tbl_number,
431: p_item_id_tbl IN po_tbl_number,
432: p_txn_flow_header_id_tbl IN po_tbl_number,
433: p_accrue_on_receipt_flag_tbl IN po_tbl_varchar1,

Line 434: p_value_basis_tbl IN po_tbl_varchar30,

430: p_ship_to_org_id_tbl IN po_tbl_number,
431: p_item_id_tbl IN po_tbl_number,
432: p_txn_flow_header_id_tbl IN po_tbl_number,
433: p_accrue_on_receipt_flag_tbl IN po_tbl_varchar1,
434: p_value_basis_tbl IN po_tbl_varchar30,
435: p_purchase_basis_tbl IN po_tbl_varchar30, --bug 7644072
436: p_expense_accrual_code IN po_system_parameters.expense_accrual_code%TYPE,
437: p_loc_outsourced_assembly_tbl IN po_tbl_number,
438: x_result_set_id IN OUT NOCOPY NUMBER,

Line 435: p_purchase_basis_tbl IN po_tbl_varchar30, --bug 7644072

431: p_item_id_tbl IN po_tbl_number,
432: p_txn_flow_header_id_tbl IN po_tbl_number,
433: p_accrue_on_receipt_flag_tbl IN po_tbl_varchar1,
434: p_value_basis_tbl IN po_tbl_varchar30,
435: p_purchase_basis_tbl IN po_tbl_varchar30, --bug 7644072
436: p_expense_accrual_code IN po_system_parameters.expense_accrual_code%TYPE,
437: p_loc_outsourced_assembly_tbl IN po_tbl_number,
438: x_result_set_id IN OUT NOCOPY NUMBER,
439: x_results IN OUT NOCOPY po_validation_results_type,

Line 647: p_destination_subinv_tbl IN po_tbl_varchar30,

643: -- Need to validate that SHIKYU item can only have asset subinventory (inventory_asset = 1).
644: -----------------------------------------------------------
645: PROCEDURE destination_subinv(
646: p_id_tbl IN po_tbl_number,
647: p_destination_subinv_tbl IN po_tbl_varchar30,
648: p_dest_type_code_tbl IN po_tbl_varchar30,
649: p_item_id_tbl IN po_tbl_number,
650: p_ship_to_org_id_tbl IN po_tbl_number,
651: p_loc_outsourced_assembly_tbl IN po_tbl_number,

Line 648: p_dest_type_code_tbl IN po_tbl_varchar30,

644: -----------------------------------------------------------
645: PROCEDURE destination_subinv(
646: p_id_tbl IN po_tbl_number,
647: p_destination_subinv_tbl IN po_tbl_varchar30,
648: p_dest_type_code_tbl IN po_tbl_varchar30,
649: p_item_id_tbl IN po_tbl_number,
650: p_ship_to_org_id_tbl IN po_tbl_number,
651: p_loc_outsourced_assembly_tbl IN po_tbl_number,
652: x_result_set_id IN OUT NOCOPY NUMBER,

Line 811: p_dest_type_code_tbl IN po_tbl_varchar30,

807: PROCEDURE wip_entity_id(
808: p_id_tbl IN po_tbl_number,
809: p_wip_entity_id_tbl IN po_tbl_number,
810: p_wip_rep_schedule_id_tbl IN po_tbl_number,
811: p_dest_type_code_tbl IN po_tbl_varchar30,
812: p_destination_org_id_tbl IN po_tbl_number,
813: x_result_set_id IN OUT NOCOPY NUMBER,
814: x_results IN OUT NOCOPY po_validation_results_type,
815: x_result_type OUT NOCOPY VARCHAR2)

Line 946: p_dest_type_code_tbl IN po_tbl_varchar30,

942: -----------------------------------------------------------
943: PROCEDURE prevent_encumbrance_flag(
944: p_id_tbl IN po_tbl_number,
945: p_prevent_encum_flag_tbl IN po_tbl_varchar1,
946: p_dest_type_code_tbl IN po_tbl_varchar30,
947: x_results IN OUT NOCOPY po_validation_results_type,
948: x_result_type OUT NOCOPY VARCHAR2)
949: IS
950: d_mod CONSTANT VARCHAR2(100) := d_prevent_encumberance_flag;

Line 1083: p_dest_type_code_tbl IN po_tbl_varchar30,

1079: PROCEDURE budget_account_id(
1080: p_id_tbl IN po_tbl_number,
1081: p_budget_account_id_tbl IN po_tbl_number,
1082: p_gl_date_tbl IN po_tbl_date,
1083: p_dest_type_code_tbl IN po_tbl_varchar30,
1084: p_chart_of_account_id IN NUMBER,
1085: p_po_encumberance_flag IN VARCHAR2,
1086: x_result_set_id IN OUT NOCOPY NUMBER,
1087: x_result_type OUT NOCOPY VARCHAR2)

Line 1262: p_project_acct_ctx_tbl IN po_tbl_varchar30,

1258: -- expenditure_organization_id are all not null.
1259: -----------------------------------------------------------
1260: PROCEDURE project_acct_context(
1261: p_id_tbl IN po_tbl_number,
1262: p_project_acct_ctx_tbl IN po_tbl_varchar30,
1263: p_project_id_tbl IN po_tbl_number,
1264: p_task_id_tbl IN po_tbl_number,
1265: p_exp_type_tbl IN po_tbl_varchar30,
1266: p_exp_org_id_tbl IN po_tbl_number,

Line 1265: p_exp_type_tbl IN po_tbl_varchar30,

1261: p_id_tbl IN po_tbl_number,
1262: p_project_acct_ctx_tbl IN po_tbl_varchar30,
1263: p_project_id_tbl IN po_tbl_number,
1264: p_task_id_tbl IN po_tbl_number,
1265: p_exp_type_tbl IN po_tbl_varchar30,
1266: p_exp_org_id_tbl IN po_tbl_number,
1267: x_results IN OUT NOCOPY po_validation_results_type,
1268: x_result_type OUT NOCOPY VARCHAR2)
1269: IS

Line 1333: p_project_acct_ctx_tbl IN po_tbl_varchar30,

1329: -- c. validate expenditure_organization_id against per_organzaition_units.
1330: -----------------------------------------------------------
1331: PROCEDURE project_info(
1332: p_id_tbl IN po_tbl_number,
1333: p_project_acct_ctx_tbl IN po_tbl_varchar30,
1334: p_dest_type_code_tbl IN po_tbl_varchar30,
1335: p_project_id_tbl IN po_tbl_number,
1336: p_task_id_tbl IN po_tbl_number,
1337: p_expenditure_type_tbl IN po_tbl_varchar30,

Line 1334: p_dest_type_code_tbl IN po_tbl_varchar30,

1330: -----------------------------------------------------------
1331: PROCEDURE project_info(
1332: p_id_tbl IN po_tbl_number,
1333: p_project_acct_ctx_tbl IN po_tbl_varchar30,
1334: p_dest_type_code_tbl IN po_tbl_varchar30,
1335: p_project_id_tbl IN po_tbl_number,
1336: p_task_id_tbl IN po_tbl_number,
1337: p_expenditure_type_tbl IN po_tbl_varchar30,
1338: p_expenditure_org_id_tbl IN po_tbl_number,

Line 1337: p_expenditure_type_tbl IN po_tbl_varchar30,

1333: p_project_acct_ctx_tbl IN po_tbl_varchar30,
1334: p_dest_type_code_tbl IN po_tbl_varchar30,
1335: p_project_id_tbl IN po_tbl_number,
1336: p_task_id_tbl IN po_tbl_number,
1337: p_expenditure_type_tbl IN po_tbl_varchar30,
1338: p_expenditure_org_id_tbl IN po_tbl_number,
1339: p_ship_to_org_id_tbl IN po_tbl_number,
1340: p_need_by_date_tbl IN po_tbl_date,
1341: p_promised_date_tbl IN po_tbl_date,