DBA Data[Home] [Help]

APPS.PO_VAL_PRICE_DIFFS2 dependencies on PO_TBL_VARCHAR30

Line 6: p_price_type_tbl IN PO_TBL_VARCHAR30,

2: -- $Header: PO_VAL_PRICE_DIFFS2.pls 120.3 2006/08/02 23:14:24 jinwang noship $
3:
4:
5: PROCEDURE price_type(p_id_tbl IN PO_TBL_NUMBER,
6: p_price_type_tbl IN PO_TBL_VARCHAR30,
7: x_result_set_id IN OUT NOCOPY NUMBER,
8: x_result_type OUT NOCOPY VARCHAR2);
9:
10: PROCEDURE multiple_price_diff(p_id_tbl IN PO_TBL_NUMBER,

Line 11: p_price_type_tbl IN PO_TBL_VARCHAR30,

7: x_result_set_id IN OUT NOCOPY NUMBER,
8: x_result_type OUT NOCOPY VARCHAR2);
9:
10: PROCEDURE multiple_price_diff(p_id_tbl IN PO_TBL_NUMBER,
11: p_price_type_tbl IN PO_TBL_VARCHAR30,
12: p_entity_type_tbl IN PO_TBL_VARCHAR30,
13: p_entity_id_tbl IN PO_TBL_NUMBER,
14: x_result_set_id IN OUT NOCOPY NUMBER,
15: x_result_type OUT NOCOPY VARCHAR2);

Line 12: p_entity_type_tbl IN PO_TBL_VARCHAR30,

8: x_result_type OUT NOCOPY VARCHAR2);
9:
10: PROCEDURE multiple_price_diff(p_id_tbl IN PO_TBL_NUMBER,
11: p_price_type_tbl IN PO_TBL_VARCHAR30,
12: p_entity_type_tbl IN PO_TBL_VARCHAR30,
13: p_entity_id_tbl IN PO_TBL_NUMBER,
14: x_result_set_id IN OUT NOCOPY NUMBER,
15: x_result_type OUT NOCOPY VARCHAR2);
16:

Line 18: p_entity_type_tbl IN PO_TBL_VARCHAR30,

14: x_result_set_id IN OUT NOCOPY NUMBER,
15: x_result_type OUT NOCOPY VARCHAR2);
16:
17: PROCEDURE entity_type(p_id_tbl IN PO_TBL_NUMBER,
18: p_entity_type_tbl IN PO_TBL_VARCHAR30,
19: p_doc_type IN VARCHAR2,
20: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
21: x_result_type OUT NOCOPY VARCHAR2);
22:

Line 24: p_entity_type_tbl IN PO_TBL_VARCHAR30,

20: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
21: x_result_type OUT NOCOPY VARCHAR2);
22:
23: PROCEDURE multiplier(p_id_tbl IN PO_TBL_NUMBER,
24: p_entity_type_tbl IN PO_TBL_VARCHAR30,
25: p_multiplier_tbl IN PO_TBL_NUMBER,
26: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
27: x_result_type OUT NOCOPY VARCHAR2);
28:

Line 30: p_entity_type_tbl IN PO_TBL_VARCHAR30,

26: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
27: x_result_type OUT NOCOPY VARCHAR2);
28:
29: PROCEDURE min_multiplier(p_id_tbl IN PO_TBL_NUMBER,
30: p_entity_type_tbl IN PO_TBL_VARCHAR30,
31: p_min_multiplier_tbl IN PO_TBL_NUMBER,
32: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
33: x_result_type OUT NOCOPY VARCHAR2);
34:

Line 36: p_entity_type_tbl IN PO_TBL_VARCHAR30,

32: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
33: x_result_type OUT NOCOPY VARCHAR2);
34:
35: PROCEDURE max_multiplier(p_id_tbl IN PO_TBL_NUMBER,
36: p_entity_type_tbl IN PO_TBL_VARCHAR30,
37: p_max_multiplier_tbl IN PO_TBL_NUMBER,
38: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
39: x_result_type OUT NOCOPY VARCHAR2);
40: