DBA Data[Home] [Help]

APPS.PO_VAL_DISTRIBUTIONS2 dependencies on PO_TBL_NUMBER

Line 4: PROCEDURE amount_ordered(p_id_tbl IN po_tbl_number,

1: PACKAGE PO_VAL_DISTRIBUTIONS2 AS
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);

Line 5: p_amount_ordered_tbl IN po_tbl_number,

1: PACKAGE PO_VAL_DISTRIBUTIONS2 AS
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:

Line 10: PROCEDURE quantity_ordered(p_id_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,
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);

Line 11: p_quantity_ordered_tbl IN po_tbl_number,

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

Line 16: PROCEDURE destination_org_id(p_id_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,
17: p_dest_org_id_tbl IN po_tbl_number,
18: p_ship_to_org_id_tbl IN po_tbl_number,
19: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
20: x_result_type OUT NOCOPY VARCHAR2);

Line 17: p_dest_org_id_tbl IN po_tbl_number,

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,
17: p_dest_org_id_tbl IN po_tbl_number,
18: p_ship_to_org_id_tbl IN po_tbl_number,
19: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
20: x_result_type OUT NOCOPY VARCHAR2);
21:

Line 18: p_ship_to_org_id_tbl IN po_tbl_number,

14: x_result_type OUT NOCOPY VARCHAR2);
15:
16: PROCEDURE destination_org_id(p_id_tbl IN po_tbl_number,
17: p_dest_org_id_tbl IN po_tbl_number,
18: p_ship_to_org_id_tbl IN po_tbl_number,
19: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
20: x_result_type OUT NOCOPY VARCHAR2);
21:
22: PROCEDURE deliver_to_location_id(p_id_tbl IN po_tbl_number,

Line 22: PROCEDURE deliver_to_location_id(p_id_tbl IN po_tbl_number,

18: p_ship_to_org_id_tbl IN po_tbl_number,
19: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
20: x_result_type OUT NOCOPY VARCHAR2);
21:
22: PROCEDURE deliver_to_location_id(p_id_tbl IN po_tbl_number,
23: p_deliver_to_location_id_tbl IN po_tbl_number,
24: p_ship_to_org_id_tbl IN po_tbl_number,
25: x_result_set_id IN OUT NOCOPY NUMBER,
26: x_result_type OUT NOCOPY VARCHAR2);

Line 23: p_deliver_to_location_id_tbl IN po_tbl_number,

19: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
20: x_result_type OUT NOCOPY VARCHAR2);
21:
22: PROCEDURE deliver_to_location_id(p_id_tbl IN po_tbl_number,
23: p_deliver_to_location_id_tbl IN po_tbl_number,
24: p_ship_to_org_id_tbl IN po_tbl_number,
25: x_result_set_id IN OUT NOCOPY NUMBER,
26: x_result_type OUT NOCOPY VARCHAR2);
27:

Line 24: p_ship_to_org_id_tbl IN po_tbl_number,

20: x_result_type OUT NOCOPY VARCHAR2);
21:
22: PROCEDURE deliver_to_location_id(p_id_tbl IN po_tbl_number,
23: p_deliver_to_location_id_tbl IN po_tbl_number,
24: p_ship_to_org_id_tbl IN po_tbl_number,
25: x_result_set_id IN OUT NOCOPY NUMBER,
26: x_result_type OUT NOCOPY VARCHAR2);
27:
28: PROCEDURE deliver_to_person_id(p_id_tbl IN po_tbl_number,

Line 28: PROCEDURE deliver_to_person_id(p_id_tbl IN po_tbl_number,

24: p_ship_to_org_id_tbl IN po_tbl_number,
25: x_result_set_id IN OUT NOCOPY NUMBER,
26: x_result_type OUT NOCOPY VARCHAR2);
27:
28: PROCEDURE deliver_to_person_id(p_id_tbl IN po_tbl_number,
29: p_deliver_to_person_id_tbl IN po_tbl_number,
30: x_result_set_id IN OUT NOCOPY NUMBER,
31: x_result_type OUT NOCOPY VARCHAR2);
32:

Line 29: p_deliver_to_person_id_tbl IN po_tbl_number,

25: x_result_set_id IN OUT NOCOPY NUMBER,
26: x_result_type OUT NOCOPY VARCHAR2);
27:
28: PROCEDURE deliver_to_person_id(p_id_tbl IN po_tbl_number,
29: p_deliver_to_person_id_tbl IN po_tbl_number,
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,

Line 33: PROCEDURE destination_type_code(p_id_tbl IN po_tbl_number,

29: p_deliver_to_person_id_tbl IN po_tbl_number,
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,

Line 35: p_ship_to_org_id_tbl IN po_tbl_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,
39: p_value_basis_tbl IN po_tbl_varchar30,

Line 36: p_item_id_tbl IN po_tbl_number,

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,
39: p_value_basis_tbl IN po_tbl_varchar30,
40: p_purchase_basis_tbl IN po_tbl_varchar30, --bug7644072

Line 37: p_txn_flow_header_id_tbl IN po_tbl_number,

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

Line 42: p_loc_outsourced_assembly_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,
45: x_result_type OUT NOCOPY VARCHAR2);
46:

Line 47: PROCEDURE destination_subinv(p_id_tbl IN po_tbl_number,

43: x_result_set_id IN OUT NOCOPY NUMBER,
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,

Line 50: p_item_id_tbl IN po_tbl_number,

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,
54: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

Line 51: p_ship_to_org_id_tbl IN po_tbl_number,

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,
54: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
55: x_result_type OUT NOCOPY VARCHAR2);

Line 52: p_loc_outsourced_assembly_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,
54: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
55: x_result_type OUT NOCOPY VARCHAR2);
56:

Line 57: PROCEDURE wip_entity_id(p_id_tbl IN po_tbl_number,

53: x_result_set_id IN OUT NOCOPY NUMBER,
54: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
55: x_result_type OUT NOCOPY VARCHAR2);
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,

Line 58: p_wip_entity_id_tbl IN po_tbl_number,

54: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
55: x_result_type OUT NOCOPY VARCHAR2);
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,

Line 59: p_wip_rep_schedule_id_tbl IN po_tbl_number,

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

Line 61: p_destination_org_id_tbl IN po_tbl_number,

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);
65:

Line 66: PROCEDURE prevent_encumbrance_flag(p_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);
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);

Line 72: PROCEDURE charge_account_id(p_id_tbl IN po_tbl_number,

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,
73: p_charge_account_id_tbl IN po_tbl_number,
74: p_gl_date_tbl IN po_tbl_date,
75: p_chart_of_account_id IN NUMBER,
76: x_result_set_id IN OUT NOCOPY NUMBER,

Line 73: p_charge_account_id_tbl IN po_tbl_number,

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,
73: p_charge_account_id_tbl IN po_tbl_number,
74: p_gl_date_tbl IN po_tbl_date,
75: p_chart_of_account_id IN NUMBER,
76: x_result_set_id IN OUT NOCOPY NUMBER,
77: x_result_type OUT NOCOPY VARCHAR2);

Line 79: PROCEDURE budget_account_id(p_id_tbl IN po_tbl_number,

75: p_chart_of_account_id IN NUMBER,
76: x_result_set_id IN OUT NOCOPY NUMBER,
77: x_result_type OUT NOCOPY VARCHAR2);
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,

Line 80: p_budget_account_id_tbl IN po_tbl_number,

76: x_result_set_id IN OUT NOCOPY NUMBER,
77: x_result_type OUT NOCOPY VARCHAR2);
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,

Line 88: PROCEDURE account_id(p_id_tbl IN po_tbl_number,

84: p_po_encumberance_flag IN VARCHAR2,
85: x_result_set_id IN OUT NOCOPY NUMBER,
86: x_result_type OUT NOCOPY VARCHAR2);
87:
88: PROCEDURE account_id(p_id_tbl IN po_tbl_number,
89: p_account_id_tbl IN po_tbl_number,
90: p_gl_date_tbl IN po_tbl_date,
91: p_chart_of_account_id IN NUMBER,
92: p_message_name IN varchar2,

Line 89: p_account_id_tbl IN po_tbl_number,

85: x_result_set_id IN OUT NOCOPY NUMBER,
86: x_result_type OUT NOCOPY VARCHAR2);
87:
88: PROCEDURE account_id(p_id_tbl IN po_tbl_number,
89: p_account_id_tbl IN po_tbl_number,
90: p_gl_date_tbl IN po_tbl_date,
91: p_chart_of_account_id IN NUMBER,
92: p_message_name IN varchar2,
93: p_column_name IN varchar2,

Line 98: PROCEDURE project_acct_context(p_id_tbl IN po_tbl_number,

94: p_token_name IN varchar2,
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,

Line 100: p_project_id_tbl IN po_tbl_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,
104: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

Line 101: p_task_id_tbl IN po_tbl_number,

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,
104: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
105: x_result_type OUT NOCOPY VARCHAR2);

Line 103: p_exp_org_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:
107: PROCEDURE project_info(p_id_tbl IN po_tbl_number,

Line 107: PROCEDURE project_info(p_id_tbl IN po_tbl_number,

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

Line 110: p_project_id_tbl IN po_tbl_number,

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,
114: p_ship_to_org_id_tbl IN po_tbl_number,

Line 111: p_task_id_tbl IN po_tbl_number,

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,
114: p_ship_to_org_id_tbl IN po_tbl_number,
115: p_need_by_date_tbl IN po_tbl_date,

Line 113: p_expenditure_org_id_tbl IN po_tbl_number,

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,
117: p_expenditure_item_date_tbl IN po_tbl_date,

Line 114: p_ship_to_org_id_tbl IN po_tbl_number,

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,
117: p_expenditure_item_date_tbl IN po_tbl_date,
118: p_ship_to_ou_id IN NUMBER,

Line 119: p_deliver_to_person_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,
117: p_expenditure_item_date_tbl IN po_tbl_date,
118: p_ship_to_ou_id IN NUMBER,
119: p_deliver_to_person_id_tbl IN po_tbl_number,
120: p_agent_id_tbl IN po_tbl_number,
121: p_txn_flow_header_id_tbl IN po_tbl_number,
122: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
123: x_result_type OUT NOCOPY VARCHAR2);

Line 120: p_agent_id_tbl IN po_tbl_number,

116: p_promised_date_tbl IN po_tbl_date,
117: p_expenditure_item_date_tbl IN po_tbl_date,
118: p_ship_to_ou_id IN NUMBER,
119: p_deliver_to_person_id_tbl IN po_tbl_number,
120: p_agent_id_tbl IN po_tbl_number,
121: p_txn_flow_header_id_tbl IN po_tbl_number,
122: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
123: x_result_type OUT NOCOPY VARCHAR2);
124:

Line 121: p_txn_flow_header_id_tbl IN po_tbl_number,

117: p_expenditure_item_date_tbl IN po_tbl_date,
118: p_ship_to_ou_id IN NUMBER,
119: p_deliver_to_person_id_tbl IN po_tbl_number,
120: p_agent_id_tbl IN po_tbl_number,
121: p_txn_flow_header_id_tbl IN po_tbl_number,
122: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
123: x_result_type OUT NOCOPY VARCHAR2);
124:
125: PROCEDURE tax_recovery_override_flag(p_id_tbl IN po_tbl_number,

Line 125: PROCEDURE tax_recovery_override_flag(p_id_tbl IN po_tbl_number,

121: p_txn_flow_header_id_tbl IN po_tbl_number,
122: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
123: x_result_type OUT NOCOPY VARCHAR2);
124:
125: PROCEDURE tax_recovery_override_flag(p_id_tbl IN po_tbl_number,
126: p_recovery_override_flag_tbl IN po_tbl_varchar1,
127: p_allow_tax_rate_override IN VARCHAR2,
128: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
129: x_result_type OUT NOCOPY VARCHAR2);