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_VARCHAR30

Line 42: p_order_type_code_tbl IN po_tbl_varchar30,

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

Line 43: p_distribution_type_tbl IN po_tbl_varchar30, -- PDOI for Complex PO Project

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)
46: IS
47: d_mod CONSTANT VARCHAR2(100) := d_amount_ordered;

Line 110: p_order_type_code_tbl IN po_tbl_varchar30,

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

Line 111: p_distribution_type_tbl IN po_tbl_varchar30, -- PDOI for Complex PO Project

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)
114: IS
115: d_mod CONSTANT VARCHAR2(100) := d_quantity_ordered;

Line 441: p_dest_type_code_tbl IN po_tbl_varchar30,

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,
445: p_accrue_on_receipt_flag_tbl IN po_tbl_varchar1,

Line 446: p_value_basis_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,
449: p_loc_outsourced_assembly_tbl IN po_tbl_number,
450: x_result_set_id IN OUT NOCOPY NUMBER,

Line 447: p_purchase_basis_tbl IN po_tbl_varchar30, --bug 7644072

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,
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,

Line 659: p_destination_subinv_tbl IN po_tbl_varchar30,

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,
663: p_loc_outsourced_assembly_tbl IN po_tbl_number,

Line 660: p_dest_type_code_tbl IN po_tbl_varchar30,

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,
663: p_loc_outsourced_assembly_tbl IN po_tbl_number,
664: x_result_set_id IN OUT NOCOPY NUMBER,

Line 823: p_dest_type_code_tbl IN po_tbl_varchar30,

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

Line 958: p_dest_type_code_tbl IN po_tbl_varchar30,

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,
961: x_results IN OUT NOCOPY po_validation_results_type,
962: x_result_type OUT NOCOPY VARCHAR2)

Line 959: p_distribution_type_tbl IN po_tbl_varchar30, -- PDOI for Complex PO Project

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,
961: x_results IN OUT NOCOPY po_validation_results_type,
962: x_result_type OUT NOCOPY VARCHAR2)
963: IS

Line 1117: p_dest_type_code_tbl IN po_tbl_varchar30,

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,
1120: p_po_encumberance_flag IN VARCHAR2,
1121: p_wip_entity_id_tbl IN po_tbl_number,

Line 1118: p_distribution_type_tbl IN po_tbl_varchar30, -- PDOI for Complex PO Project

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,
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,

Line 1303: p_project_acct_ctx_tbl IN po_tbl_varchar30,

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,
1307: p_exp_org_id_tbl IN po_tbl_number,

Line 1306: p_exp_type_tbl IN po_tbl_varchar30,

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

Line 1374: p_project_acct_ctx_tbl IN po_tbl_varchar30,

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,
1378: p_expenditure_type_tbl IN po_tbl_varchar30,

Line 1375: p_dest_type_code_tbl IN po_tbl_varchar30,

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,
1378: p_expenditure_type_tbl IN po_tbl_varchar30,
1379: p_expenditure_org_id_tbl IN po_tbl_number,

Line 1378: p_expenditure_type_tbl IN po_tbl_varchar30,

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,
1382: p_promised_date_tbl IN po_tbl_date,

Line 1547: , p_ACRN_tbl IN PO_TBL_VARCHAR30

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