DBA Data[Home] [Help]

APPS.PO_VAL_DISTRIBUTIONS2 dependencies on PO_TBL_VARCHAR30

Line 6: p_order_type_code_tbl IN po_tbl_varchar30,

2: -- $Header: PO_VAL_DISTRIBUTIONS2.pls 120.7.12010000.2 2008/12/18 13:21:32 ggandhi ship $
3:
4: PROCEDURE amount_ordered(p_id_tbl IN po_tbl_number,
5: p_amount_ordered_tbl IN po_tbl_number,
6: p_order_type_code_tbl IN po_tbl_varchar30,
7: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
8: x_result_type OUT NOCOPY VARCHAR2);
9:
10: PROCEDURE quantity_ordered(p_id_tbl IN po_tbl_number,

Line 12: p_order_type_code_tbl IN po_tbl_varchar30,

8: x_result_type OUT NOCOPY VARCHAR2);
9:
10: PROCEDURE quantity_ordered(p_id_tbl IN po_tbl_number,
11: p_quantity_ordered_tbl IN po_tbl_number,
12: p_order_type_code_tbl IN po_tbl_varchar30,
13: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
14: x_result_type OUT NOCOPY VARCHAR2);
15:
16: PROCEDURE destination_org_id(p_id_tbl IN po_tbl_number,

Line 34: p_dest_type_code_tbl IN po_tbl_varchar30,

30: x_result_set_id IN OUT NOCOPY NUMBER,
31: x_result_type OUT NOCOPY VARCHAR2);
32:
33: PROCEDURE destination_type_code(p_id_tbl IN po_tbl_number,
34: p_dest_type_code_tbl IN po_tbl_varchar30,
35: p_ship_to_org_id_tbl IN po_tbl_number,
36: p_item_id_tbl IN po_tbl_number,
37: p_txn_flow_header_id_tbl IN po_tbl_number,
38: p_accrue_on_receipt_flag_tbl IN po_tbl_varchar1,

Line 39: p_value_basis_tbl IN po_tbl_varchar30,

35: p_ship_to_org_id_tbl IN po_tbl_number,
36: p_item_id_tbl IN po_tbl_number,
37: p_txn_flow_header_id_tbl IN po_tbl_number,
38: p_accrue_on_receipt_flag_tbl IN po_tbl_varchar1,
39: p_value_basis_tbl IN po_tbl_varchar30,
40: p_purchase_basis_tbl IN po_tbl_varchar30, --bug7644072
41: p_expense_accrual_code IN po_system_parameters.expense_accrual_code%TYPE,
42: p_loc_outsourced_assembly_tbl IN po_tbl_number,
43: x_result_set_id IN OUT NOCOPY NUMBER,

Line 40: p_purchase_basis_tbl IN po_tbl_varchar30, --bug7644072

36: p_item_id_tbl IN po_tbl_number,
37: p_txn_flow_header_id_tbl IN po_tbl_number,
38: p_accrue_on_receipt_flag_tbl IN po_tbl_varchar1,
39: p_value_basis_tbl IN po_tbl_varchar30,
40: p_purchase_basis_tbl IN po_tbl_varchar30, --bug7644072
41: p_expense_accrual_code IN po_system_parameters.expense_accrual_code%TYPE,
42: p_loc_outsourced_assembly_tbl IN po_tbl_number,
43: x_result_set_id IN OUT NOCOPY NUMBER,
44: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

Line 48: p_destination_subinv_tbl IN po_tbl_varchar30,

44: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
45: x_result_type OUT NOCOPY VARCHAR2);
46:
47: PROCEDURE destination_subinv(p_id_tbl IN po_tbl_number,
48: p_destination_subinv_tbl IN po_tbl_varchar30,
49: p_dest_type_code_tbl IN po_tbl_varchar30,
50: p_item_id_tbl IN po_tbl_number,
51: p_ship_to_org_id_tbl IN po_tbl_number,
52: p_loc_outsourced_assembly_tbl IN po_tbl_number,

Line 49: p_dest_type_code_tbl IN po_tbl_varchar30,

45: x_result_type OUT NOCOPY VARCHAR2);
46:
47: PROCEDURE destination_subinv(p_id_tbl IN po_tbl_number,
48: p_destination_subinv_tbl IN po_tbl_varchar30,
49: p_dest_type_code_tbl IN po_tbl_varchar30,
50: p_item_id_tbl IN po_tbl_number,
51: p_ship_to_org_id_tbl IN po_tbl_number,
52: p_loc_outsourced_assembly_tbl IN po_tbl_number,
53: x_result_set_id IN OUT NOCOPY NUMBER,

Line 60: p_dest_type_code_tbl IN po_tbl_varchar30,

56:
57: PROCEDURE wip_entity_id(p_id_tbl IN po_tbl_number,
58: p_wip_entity_id_tbl IN po_tbl_number,
59: p_wip_rep_schedule_id_tbl IN po_tbl_number,
60: p_dest_type_code_tbl IN po_tbl_varchar30,
61: p_destination_org_id_tbl IN po_tbl_number,
62: x_result_set_id IN OUT NOCOPY NUMBER,
63: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
64: x_result_type OUT NOCOPY VARCHAR2);

Line 68: p_dest_type_code_tbl IN po_tbl_varchar30,

64: x_result_type OUT NOCOPY VARCHAR2);
65:
66: PROCEDURE prevent_encumbrance_flag(p_id_tbl IN po_tbl_number,
67: p_prevent_encum_flag_tbl IN po_tbl_varchar1,
68: p_dest_type_code_tbl IN po_tbl_varchar30,
69: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
70: x_result_type OUT NOCOPY VARCHAR2);
71:
72: PROCEDURE charge_account_id(p_id_tbl IN po_tbl_number,

Line 82: p_dest_type_code_tbl IN po_tbl_varchar30,

78:
79: PROCEDURE budget_account_id(p_id_tbl IN po_tbl_number,
80: p_budget_account_id_tbl IN po_tbl_number,
81: p_gl_date_tbl IN po_tbl_date,
82: p_dest_type_code_tbl IN po_tbl_varchar30,
83: p_chart_of_account_id IN NUMBER,
84: p_po_encumberance_flag IN VARCHAR2,
85: x_result_set_id IN OUT NOCOPY NUMBER,
86: x_result_type OUT NOCOPY VARCHAR2);

Line 99: p_project_acct_ctx_tbl IN po_tbl_varchar30,

95: x_result_set_id IN OUT NOCOPY NUMBER,
96: x_result_type OUT NOCOPY VARCHAR2);
97:
98: PROCEDURE project_acct_context(p_id_tbl IN po_tbl_number,
99: p_project_acct_ctx_tbl IN po_tbl_varchar30,
100: p_project_id_tbl IN po_tbl_number,
101: p_task_id_tbl IN po_tbl_number,
102: p_exp_type_tbl IN po_tbl_varchar30,
103: p_exp_org_id_tbl IN po_tbl_number,

Line 102: p_exp_type_tbl IN po_tbl_varchar30,

98: PROCEDURE project_acct_context(p_id_tbl IN po_tbl_number,
99: p_project_acct_ctx_tbl IN po_tbl_varchar30,
100: p_project_id_tbl IN po_tbl_number,
101: p_task_id_tbl IN po_tbl_number,
102: p_exp_type_tbl IN po_tbl_varchar30,
103: p_exp_org_id_tbl IN po_tbl_number,
104: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
105: x_result_type OUT NOCOPY VARCHAR2);
106:

Line 108: p_project_acct_ctx_tbl IN po_tbl_varchar30,

104: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
105: x_result_type OUT NOCOPY VARCHAR2);
106:
107: PROCEDURE project_info(p_id_tbl IN po_tbl_number,
108: p_project_acct_ctx_tbl IN po_tbl_varchar30,
109: p_dest_type_code_tbl IN po_tbl_varchar30,
110: p_project_id_tbl IN po_tbl_number,
111: p_task_id_tbl IN po_tbl_number,
112: p_expenditure_type_tbl IN po_tbl_varchar30,

Line 109: p_dest_type_code_tbl IN po_tbl_varchar30,

105: x_result_type OUT NOCOPY VARCHAR2);
106:
107: PROCEDURE project_info(p_id_tbl IN po_tbl_number,
108: p_project_acct_ctx_tbl IN po_tbl_varchar30,
109: p_dest_type_code_tbl IN po_tbl_varchar30,
110: p_project_id_tbl IN po_tbl_number,
111: p_task_id_tbl IN po_tbl_number,
112: p_expenditure_type_tbl IN po_tbl_varchar30,
113: p_expenditure_org_id_tbl IN po_tbl_number,

Line 112: p_expenditure_type_tbl IN po_tbl_varchar30,

108: p_project_acct_ctx_tbl IN po_tbl_varchar30,
109: p_dest_type_code_tbl IN po_tbl_varchar30,
110: p_project_id_tbl IN po_tbl_number,
111: p_task_id_tbl IN po_tbl_number,
112: p_expenditure_type_tbl IN po_tbl_varchar30,
113: p_expenditure_org_id_tbl IN po_tbl_number,
114: p_ship_to_org_id_tbl IN po_tbl_number,
115: p_need_by_date_tbl IN po_tbl_date,
116: p_promised_date_tbl IN po_tbl_date,