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_DISTRIBUTIONS dependencies on PO_TBL_VARCHAR30

Line 24: , p_value_basis_tbl IN PO_TBL_VARCHAR30 --

20:
21: PROCEDURE quantity_gt_zero(
22: p_dist_id_tbl IN PO_TBL_NUMBER
23: , p_qty_ordered_tbl IN PO_TBL_NUMBER
24: , p_value_basis_tbl IN PO_TBL_VARCHAR30 --
25: , p_cost_constraint_tbl IN PO_TBL_VARCHAR30
26: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
27: , x_result_type OUT NOCOPY VARCHAR2
28: , p_header_id_tbl IN PO_TBL_NUMBER --

Line 25: , p_cost_constraint_tbl IN PO_TBL_VARCHAR30

21: PROCEDURE quantity_gt_zero(
22: p_dist_id_tbl IN PO_TBL_NUMBER
23: , p_qty_ordered_tbl IN PO_TBL_NUMBER
24: , p_value_basis_tbl IN PO_TBL_VARCHAR30 --
25: , p_cost_constraint_tbl IN PO_TBL_VARCHAR30
26: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
27: , x_result_type OUT NOCOPY VARCHAR2
28: , p_header_id_tbl IN PO_TBL_NUMBER --
29: );

Line 36: , p_dist_type_tbl IN PO_TBL_VARCHAR30

32: -- Combined quantity billed/del into quantity exec
33:
34: PROCEDURE quantity_ge_quantity_exec(
35: p_dist_id_tbl IN PO_TBL_NUMBER
36: , p_dist_type_tbl IN PO_TBL_VARCHAR30
37: , p_qty_ordered_tbl IN PO_TBL_NUMBER
38: , x_result_set_id IN OUT NOCOPY NUMBER
39: , x_result_type OUT NOCOPY VARCHAR2
40: );

Line 47: , p_value_basis_tbl IN PO_TBL_VARCHAR30 --

43:
44: PROCEDURE amount_gt_zero(
45: p_dist_id_tbl IN PO_TBL_NUMBER
46: , p_amt_ordered_tbl IN PO_TBL_NUMBER
47: , p_value_basis_tbl IN PO_TBL_VARCHAR30 --
48: , p_cost_constraint_tbl IN PO_TBL_VARCHAR30
49: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
50: , x_result_type OUT NOCOPY VARCHAR2
51: , p_header_id_tbl IN PO_TBL_NUMBER --

Line 48: , p_cost_constraint_tbl IN PO_TBL_VARCHAR30

44: PROCEDURE amount_gt_zero(
45: p_dist_id_tbl IN PO_TBL_NUMBER
46: , p_amt_ordered_tbl IN PO_TBL_NUMBER
47: , p_value_basis_tbl IN PO_TBL_VARCHAR30 --
48: , p_cost_constraint_tbl IN PO_TBL_VARCHAR30
49: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
50: , x_result_type OUT NOCOPY VARCHAR2
51: , p_header_id_tbl IN PO_TBL_NUMBER --
52: );

Line 59: , p_dist_type_tbl IN PO_TBL_VARCHAR30

55: -- Combined amount billed/del into amount exec
56:
57: PROCEDURE amount_ge_amount_exec(
58: p_dist_id_tbl IN PO_TBL_NUMBER
59: , p_dist_type_tbl IN PO_TBL_VARCHAR30
60: , p_amt_ordered_tbl IN PO_TBL_NUMBER
61: , x_result_set_id IN OUT NOCOPY NUMBER
62: , x_result_type OUT NOCOPY VARCHAR2
63: );

Line 69: , p_end_item_unit_number_tbl IN PO_TBL_VARCHAR30

65: --
66:
67: PROCEDURE pjm_unit_number_effective(
68: p_dist_id_tbl IN PO_TBL_NUMBER
69: , p_end_item_unit_number_tbl IN PO_TBL_VARCHAR30
70: , p_item_id_tbl IN PO_TBL_NUMBER
71: , p_ship_to_org_id_tbl IN PO_TBL_NUMBER
72: -- Bug# 4338241: Checking if it is inventory and PJM is installed
73: , p_destination_type_code_tbl IN PO_TBL_VARCHAR30

Line 73: , p_destination_type_code_tbl IN PO_TBL_VARCHAR30

69: , p_end_item_unit_number_tbl IN PO_TBL_VARCHAR30
70: , p_item_id_tbl IN PO_TBL_NUMBER
71: , p_ship_to_org_id_tbl IN PO_TBL_NUMBER
72: -- Bug# 4338241: Checking if it is inventory and PJM is installed
73: , p_destination_type_code_tbl IN PO_TBL_VARCHAR30
74: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
75: , x_result_type OUT NOCOPY VARCHAR2
76: );
77:

Line 84: , p_destination_type_code_tbl IN PO_TBL_VARCHAR30

80: , p_line_line_type_id_tbl IN PO_TBL_NUMBER
81: , p_wip_entity_id_tbl IN PO_TBL_NUMBER
82: , p_wip_line_id_tbl IN PO_TBL_NUMBER
83: , p_wip_operation_seq_num_tbl IN PO_TBL_NUMBER
84: , p_destination_type_code_tbl IN PO_TBL_VARCHAR30
85: , p_wip_resource_seq_num_tbl IN PO_TBL_NUMBER
86: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
87: , x_result_type OUT NOCOPY VARCHAR2
88: );

Line 115: , p_dist_type_tbl IN PO_TBL_VARCHAR30 --Bug 14664343

111: PROCEDURE gl_enc_date_not_null_open(
112: p_dist_id_tbl IN PO_TBL_NUMBER
113: , p_org_id_tbl IN PO_TBL_NUMBER
114: , p_gl_encumbered_date_tbl IN PO_TBL_DATE
115: , p_dist_type_tbl IN PO_TBL_VARCHAR30 --Bug 14664343
116: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
117: , x_result_type OUT NOCOPY VARCHAR2
118: );
119:

Line 125: , p_expenditure_type_tbl IN PO_TBL_VARCHAR30

121: p_dist_id_tbl IN PO_TBL_NUMBER
122: , p_project_id_tbl IN PO_TBL_NUMBER
123: , p_task_id_tbl IN PO_TBL_NUMBER
124: , p_award_number_tbl IN PO_TBL_VARCHAR2000
125: , p_expenditure_type_tbl IN PO_TBL_VARCHAR30
126: , p_expenditure_item_date_tbl IN PO_TBL_DATE
127: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
128: , x_result_type OUT NOCOPY VARCHAR2
129: );

Line 198: , p_line_matching_basis_tbl IN PO_TBL_VARCHAR30 --Bug 13773450

194: , p_style_id_tbl IN PO_TBL_NUMBER
195: , p_amount_funded_tbl IN PO_TBL_NUMBER
196: , p_amount_billed_tbl IN PO_TBL_NUMBER
197: , p_amount_delivered_tbl IN PO_TBL_NUMBER
198: , p_line_matching_basis_tbl IN PO_TBL_VARCHAR30 --Bug 13773450
199: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
200: , x_result_type OUT NOCOPY VARCHAR2
201: );
202:

Line 227: , p_dest_type_code_tbl IN PO_TBL_VARCHAR30

223: -- Need to check for PJM Parameters before making Task as mandatory.
224: -- For fetching the PJM paramters passing ship to org id.
225: PROCEDURE check_proj_related_validations(
226: p_dist_id_tbl IN PO_TBL_NUMBER
227: , p_dest_type_code_tbl IN PO_TBL_VARCHAR30
228: , p_project_id_tbl IN PO_TBL_NUMBER
229: , p_task_id_tbl IN PO_TBL_NUMBER
230: , p_award_id_tbl IN PO_TBL_NUMBER
231: , p_expenditure_type_tbl IN PO_TBL_VARCHAR30

Line 231: , p_expenditure_type_tbl IN PO_TBL_VARCHAR30

227: , p_dest_type_code_tbl IN PO_TBL_VARCHAR30
228: , p_project_id_tbl IN PO_TBL_NUMBER
229: , p_task_id_tbl IN PO_TBL_NUMBER
230: , p_award_id_tbl IN PO_TBL_NUMBER
231: , p_expenditure_type_tbl IN PO_TBL_VARCHAR30
232: , p_expenditure_org_id_tbl IN PO_TBL_NUMBER
233: , p_expenditure_item_date_tbl IN PO_TBL_DATE
234: , p_ship_to_org_id_tbl IN PO_TBL_NUMBER
235: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

Line 242: p_dist_type_tbl IN PO_TBL_VARCHAR30,

238:
239: -- CLM-LnSc
240: PROCEDURE funded_val_gt_req_funds_rmn(
241: p_dist_id_tbl IN PO_TBL_NUMBER,
242: p_dist_type_tbl IN PO_TBL_VARCHAR30,
243: p_org_id_tbl IN PO_TBL_NUMBER,
244: p_style_id_tbl IN PO_TBL_NUMBER,
245: p_draft_id_tbl IN PO_TBL_NUMBER,
246: p_funded_value_tbl IN PO_TBL_NUMBER,

Line 257: p_draft_type_tbl IN PO_TBL_VARCHAR30,

253: --PAR Project
254: PROCEDURE check_dist_values_inc_for_par(
255: p_dist_id_tbl IN PO_TBL_NUMBER,
256: p_draft_id_tbl IN PO_TBL_NUMBER,
257: p_draft_type_tbl IN PO_TBL_VARCHAR30,
258: p_quantity_ordered_tbl IN PO_TBL_NUMBER,
259: p_amt_ordered_tbl IN PO_TBL_NUMBER,
260: p_old_qty_ordered_tbl IN PO_TBL_NUMBER,
261: p_change_status_tbl IN PO_TBL_VARCHAR30,

Line 261: p_change_status_tbl IN PO_TBL_VARCHAR30,

257: p_draft_type_tbl IN PO_TBL_VARCHAR30,
258: p_quantity_ordered_tbl IN PO_TBL_NUMBER,
259: p_amt_ordered_tbl IN PO_TBL_NUMBER,
260: p_old_qty_ordered_tbl IN PO_TBL_NUMBER,
261: p_change_status_tbl IN PO_TBL_VARCHAR30,
262: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE ,
263: x_result_type OUT NOCOPY VARCHAR2);
264:
265: --CLM PDOI Integration Starts

Line 273: p_clm_defence_funding_tbl IN PO_TBL_VARCHAR30,

269: x_result_type OUT NOCOPY VARCHAR2);
270:
271: PROCEDURE validate_defence_funding(
272: p_intf_dist_id_tbl IN PO_TBL_NUMBER,
273: p_clm_defence_funding_tbl IN PO_TBL_VARCHAR30,
274: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
275: x_result_type OUT NOCOPY VARCHAR2);
276:
277: PROCEDURE validate_option_distribution(