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.12 2011/10/16 11:00:10 dtoshniw 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: p_distribution_type_tbl IN po_tbl_varchar30, -- PDOI for Complex PO Project
8: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
9: x_result_type OUT NOCOPY VARCHAR2);
10:

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

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: p_distribution_type_tbl IN po_tbl_varchar30, -- PDOI for Complex PO Project
8: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
9: x_result_type OUT NOCOPY VARCHAR2);
10:
11: PROCEDURE quantity_ordered(p_id_tbl IN po_tbl_number,

Line 13: p_order_type_code_tbl IN po_tbl_varchar30,

9: x_result_type OUT NOCOPY VARCHAR2);
10:
11: PROCEDURE quantity_ordered(p_id_tbl IN po_tbl_number,
12: p_quantity_ordered_tbl IN po_tbl_number,
13: p_order_type_code_tbl IN po_tbl_varchar30,
14: p_distribution_type_tbl IN po_tbl_varchar30, -- PDOI for Complex PO Project
15: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
16: x_result_type OUT NOCOPY VARCHAR2);
17:

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

10:
11: PROCEDURE quantity_ordered(p_id_tbl IN po_tbl_number,
12: p_quantity_ordered_tbl IN po_tbl_number,
13: p_order_type_code_tbl IN po_tbl_varchar30,
14: p_distribution_type_tbl IN po_tbl_varchar30, -- PDOI for Complex PO Project
15: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
16: x_result_type OUT NOCOPY VARCHAR2);
17:
18: PROCEDURE destination_org_id(p_id_tbl IN po_tbl_number,

Line 36: p_dest_type_code_tbl IN po_tbl_varchar30,

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

Line 41: p_value_basis_tbl IN po_tbl_varchar30,

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

Line 42: p_purchase_basis_tbl IN po_tbl_varchar30, --bug7644072

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

Line 50: p_destination_subinv_tbl IN po_tbl_varchar30,

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

Line 51: p_dest_type_code_tbl IN po_tbl_varchar30,

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

Line 62: p_dest_type_code_tbl IN po_tbl_varchar30,

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

Line 70: p_dest_type_code_tbl IN po_tbl_varchar30,

66: x_result_type OUT NOCOPY VARCHAR2);
67:
68: PROCEDURE prevent_encumbrance_flag(p_id_tbl IN po_tbl_number,
69: p_prevent_encum_flag_tbl IN po_tbl_varchar1,
70: p_dest_type_code_tbl IN po_tbl_varchar30,
71: p_distribution_type_tbl IN po_tbl_varchar30, -- PDOI for Complex PO Project
72: p_wip_entity_id_tbl IN po_tbl_number, /* Encumbrance Project */
73: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
74: x_result_type OUT NOCOPY VARCHAR2);

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

67:
68: PROCEDURE prevent_encumbrance_flag(p_id_tbl IN po_tbl_number,
69: p_prevent_encum_flag_tbl IN po_tbl_varchar1,
70: p_dest_type_code_tbl IN po_tbl_varchar30,
71: p_distribution_type_tbl IN po_tbl_varchar30, -- PDOI for Complex PO Project
72: p_wip_entity_id_tbl IN po_tbl_number, /* Encumbrance Project */
73: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
74: x_result_type OUT NOCOPY VARCHAR2);
75:

Line 86: p_dest_type_code_tbl IN po_tbl_varchar30,

82:
83: PROCEDURE budget_account_id(p_id_tbl IN po_tbl_number,
84: p_budget_account_id_tbl IN po_tbl_number,
85: p_gl_date_tbl IN po_tbl_date,
86: p_dest_type_code_tbl IN po_tbl_varchar30,
87: p_distribution_type_tbl IN po_tbl_varchar30, -- PDOI for Complex PO Project
88: p_chart_of_account_id IN NUMBER,
89: p_po_encumberance_flag IN VARCHAR2,
90: p_wip_entity_id_tbl IN po_tbl_number, /* Encumbrance Project */

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

83: PROCEDURE budget_account_id(p_id_tbl IN po_tbl_number,
84: p_budget_account_id_tbl IN po_tbl_number,
85: p_gl_date_tbl IN po_tbl_date,
86: p_dest_type_code_tbl IN po_tbl_varchar30,
87: p_distribution_type_tbl IN po_tbl_varchar30, -- PDOI for Complex PO Project
88: p_chart_of_account_id IN NUMBER,
89: p_po_encumberance_flag IN VARCHAR2,
90: p_wip_entity_id_tbl IN po_tbl_number, /* Encumbrance Project */
91: x_result_set_id IN OUT NOCOPY NUMBER,

Line 105: p_project_acct_ctx_tbl IN po_tbl_varchar30,

101: x_result_set_id IN OUT NOCOPY NUMBER,
102: x_result_type OUT NOCOPY VARCHAR2);
103:
104: PROCEDURE project_acct_context(p_id_tbl IN po_tbl_number,
105: p_project_acct_ctx_tbl IN po_tbl_varchar30,
106: p_project_id_tbl IN po_tbl_number,
107: p_task_id_tbl IN po_tbl_number,
108: p_exp_type_tbl IN po_tbl_varchar30,
109: p_exp_org_id_tbl IN po_tbl_number,

Line 108: p_exp_type_tbl IN po_tbl_varchar30,

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

Line 114: p_project_acct_ctx_tbl IN po_tbl_varchar30,

110: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
111: x_result_type OUT NOCOPY VARCHAR2);
112:
113: PROCEDURE project_info(p_id_tbl IN po_tbl_number,
114: p_project_acct_ctx_tbl IN po_tbl_varchar30,
115: p_dest_type_code_tbl IN po_tbl_varchar30,
116: p_project_id_tbl IN po_tbl_number,
117: p_task_id_tbl IN po_tbl_number,
118: p_expenditure_type_tbl IN po_tbl_varchar30,

Line 115: p_dest_type_code_tbl IN po_tbl_varchar30,

111: x_result_type OUT NOCOPY VARCHAR2);
112:
113: PROCEDURE project_info(p_id_tbl IN po_tbl_number,
114: p_project_acct_ctx_tbl IN po_tbl_varchar30,
115: p_dest_type_code_tbl IN po_tbl_varchar30,
116: p_project_id_tbl IN po_tbl_number,
117: p_task_id_tbl IN po_tbl_number,
118: p_expenditure_type_tbl IN po_tbl_varchar30,
119: p_expenditure_org_id_tbl IN po_tbl_number,

Line 118: p_expenditure_type_tbl IN po_tbl_varchar30,

114: p_project_acct_ctx_tbl IN po_tbl_varchar30,
115: p_dest_type_code_tbl IN po_tbl_varchar30,
116: p_project_id_tbl IN po_tbl_number,
117: p_task_id_tbl IN po_tbl_number,
118: p_expenditure_type_tbl IN po_tbl_varchar30,
119: p_expenditure_org_id_tbl IN po_tbl_number,
120: p_ship_to_org_id_tbl IN po_tbl_number,
121: p_need_by_date_tbl IN po_tbl_date,
122: p_promised_date_tbl IN po_tbl_date,

Line 141: , p_ACRN_tbl IN PO_TBL_VARCHAR30

137: -- <>
138: PROCEDURE ACRN_value_valid(
139: p_dist_id_tbl IN PO_TBL_NUMBER
140: , p_style_id_tbl IN PO_TBL_NUMBER
141: , p_ACRN_tbl IN PO_TBL_VARCHAR30
142: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
143: , x_result_type OUT NOCOPY VARCHAR2
144: );
145: -- <>