APPS.PO_VAL_PRICE_DIFFS dependencies on PO_TBL_NUMBER

Line 5: p_price_differential_id_tbl IN PO_TBL_NUMBER

1: PACKAGE PO_VAL_PRICE_DIFFS AS
2: -- $Header: PO_VAL_PRICE_DIFFS.pls 120.1 2006/08/16 22:46:04 dedelgad noship $
3:
4: PROCEDURE max_mul_ge_zero(
5: p_price_differential_id_tbl IN PO_TBL_NUMBER
6: , p_max_multiplier_tbl IN PO_TBL_NUMBER
7: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
8: , x_result_type OUT NOCOPY VARCHAR2
9: );

Line 6: , p_max_multiplier_tbl IN PO_TBL_NUMBER

2: -- $Header: PO_VAL_PRICE_DIFFS.pls 120.1 2006/08/16 22:46:04 dedelgad noship $
3:
4: PROCEDURE max_mul_ge_zero(
5: p_price_differential_id_tbl IN PO_TBL_NUMBER
6: , p_max_multiplier_tbl IN PO_TBL_NUMBER
7: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
8: , x_result_type OUT NOCOPY VARCHAR2
9: );
10:

Line 12: p_price_differential_id_tbl IN PO_TBL_NUMBER

8: , x_result_type OUT NOCOPY VARCHAR2
9: );
10:
11: PROCEDURE max_mul_ge_min_mul(
12: p_price_differential_id_tbl IN PO_TBL_NUMBER
13: , p_min_multiplier_tbl IN PO_TBL_NUMBER
14: , p_max_multiplier_tbl IN PO_TBL_NUMBER
15: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
16: , x_result_type OUT NOCOPY VARCHAR2

Line 13: , p_min_multiplier_tbl IN PO_TBL_NUMBER

9: );
10:
11: PROCEDURE max_mul_ge_min_mul(
12: p_price_differential_id_tbl IN PO_TBL_NUMBER
13: , p_min_multiplier_tbl IN PO_TBL_NUMBER
14: , p_max_multiplier_tbl IN PO_TBL_NUMBER
15: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
16: , x_result_type OUT NOCOPY VARCHAR2
17: );

Line 14: , p_max_multiplier_tbl IN PO_TBL_NUMBER

10:
11: PROCEDURE max_mul_ge_min_mul(
12: p_price_differential_id_tbl IN PO_TBL_NUMBER
13: , p_min_multiplier_tbl IN PO_TBL_NUMBER
14: , p_max_multiplier_tbl IN PO_TBL_NUMBER
15: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
16: , x_result_type OUT NOCOPY VARCHAR2
17: );
18:

Line 20: p_price_differential_id_tbl IN PO_TBL_NUMBER

16: , x_result_type OUT NOCOPY VARCHAR2
17: );
18:
19: PROCEDURE min_mul_ge_zero(
20: p_price_differential_id_tbl IN PO_TBL_NUMBER
21: , p_min_multiplier_tbl IN PO_TBL_NUMBER
22: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
23: , x_result_type OUT NOCOPY VARCHAR2
24: );

Line 21: , p_min_multiplier_tbl IN PO_TBL_NUMBER

17: );
18:
19: PROCEDURE min_mul_ge_zero(
20: p_price_differential_id_tbl IN PO_TBL_NUMBER
21: , p_min_multiplier_tbl IN PO_TBL_NUMBER
22: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
23: , x_result_type OUT NOCOPY VARCHAR2
24: );
25:

Line 27: p_price_differential_id_tbl IN PO_TBL_NUMBER

23: , x_result_type OUT NOCOPY VARCHAR2
24: );
25:
26: PROCEDURE mul_ge_zero(
27: p_price_differential_id_tbl IN PO_TBL_NUMBER
28: , p_multiplier_tbl IN PO_TBL_NUMBER
29: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
30: , x_result_type OUT NOCOPY VARCHAR2
31: );

Line 28: , p_multiplier_tbl IN PO_TBL_NUMBER

24: );
25:
26: PROCEDURE mul_ge_zero(
27: p_price_differential_id_tbl IN PO_TBL_NUMBER
28: , p_multiplier_tbl IN PO_TBL_NUMBER
29: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
30: , x_result_type OUT NOCOPY VARCHAR2
31: );
32:

Line 34: p_price_differential_id_tbl IN PO_TBL_NUMBER

30: , x_result_type OUT NOCOPY VARCHAR2
31: );
32:
33: PROCEDURE unique_price_diff_num(
34: p_price_differential_id_tbl IN PO_TBL_NUMBER
35: , p_entity_id_tbl IN PO_TBL_NUMBER
36: , p_entity_type_tbl IN PO_TBL_VARCHAR30
37: , p_price_differential_num_tbl IN PO_TBL_NUMBER
38: , x_result_set_id IN OUT NOCOPY NUMBER

Line 35: , p_entity_id_tbl IN PO_TBL_NUMBER

31: );
32:
33: PROCEDURE unique_price_diff_num(
34: p_price_differential_id_tbl IN PO_TBL_NUMBER
35: , p_entity_id_tbl IN PO_TBL_NUMBER
36: , p_entity_type_tbl IN PO_TBL_VARCHAR30
37: , p_price_differential_num_tbl IN PO_TBL_NUMBER
38: , x_result_set_id IN OUT NOCOPY NUMBER
39: , x_result_type OUT NOCOPY VARCHAR2

Line 37: , p_price_differential_num_tbl IN PO_TBL_NUMBER

33: PROCEDURE unique_price_diff_num(
34: p_price_differential_id_tbl IN PO_TBL_NUMBER
35: , p_entity_id_tbl IN PO_TBL_NUMBER
36: , p_entity_type_tbl IN PO_TBL_VARCHAR30
37: , p_price_differential_num_tbl IN PO_TBL_NUMBER
38: , x_result_set_id IN OUT NOCOPY NUMBER
39: , x_result_type OUT NOCOPY VARCHAR2
40: );
41:

Line 43: p_price_differential_id_tbl IN PO_TBL_NUMBER

39: , x_result_type OUT NOCOPY VARCHAR2
40: );
41:
42: PROCEDURE price_diff_num_gt_zero(
43: p_price_differential_id_tbl IN PO_TBL_NUMBER
44: , p_price_differential_num_tbl IN PO_TBL_NUMBER
45: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
46: , x_result_type OUT NOCOPY VARCHAR2
47: );

Line 44: , p_price_differential_num_tbl IN PO_TBL_NUMBER

40: );
41:
42: PROCEDURE price_diff_num_gt_zero(
43: p_price_differential_id_tbl IN PO_TBL_NUMBER
44: , p_price_differential_num_tbl IN PO_TBL_NUMBER
45: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
46: , x_result_type OUT NOCOPY VARCHAR2
47: );
48:

Line 50: p_price_differential_id_tbl IN PO_TBL_NUMBER

46: , x_result_type OUT NOCOPY VARCHAR2
47: );
48:
49: PROCEDURE unique_price_type(
50: p_price_differential_id_tbl IN PO_TBL_NUMBER
51: , p_entity_id_tbl IN PO_TBL_NUMBER
52: , p_entity_type_tbl IN PO_TBL_VARCHAR30
53: , p_price_type_tbl IN PO_TBL_VARCHAR30
54: , x_result_set_id IN OUT NOCOPY NUMBER

Line 51: , p_entity_id_tbl IN PO_TBL_NUMBER

47: );
48:
49: PROCEDURE unique_price_type(
50: p_price_differential_id_tbl IN PO_TBL_NUMBER
51: , p_entity_id_tbl IN PO_TBL_NUMBER
52: , p_entity_type_tbl IN PO_TBL_VARCHAR30
53: , p_price_type_tbl IN PO_TBL_VARCHAR30
54: , x_result_set_id IN OUT NOCOPY NUMBER
55: , x_result_type OUT NOCOPY VARCHAR2

Line 59: p_price_differential_id_tbl IN PO_TBL_NUMBER

55: , x_result_type OUT NOCOPY VARCHAR2
56: );
57:
58: PROCEDURE spo_price_type_on_src_doc(
59: p_price_differential_id_tbl IN PO_TBL_NUMBER
60: , p_entity_type_tbl IN PO_TBL_VARCHAR30
61: , p_from_line_location_id_tbl IN PO_TBL_NUMBER
62: , p_from_line_id_tbl IN PO_TBL_NUMBER
63: , p_price_type_tbl IN PO_TBL_VARCHAR30

Line 61: , p_from_line_location_id_tbl IN PO_TBL_NUMBER

57:
58: PROCEDURE spo_price_type_on_src_doc(
59: p_price_differential_id_tbl IN PO_TBL_NUMBER
60: , p_entity_type_tbl IN PO_TBL_VARCHAR30
61: , p_from_line_location_id_tbl IN PO_TBL_NUMBER
62: , p_from_line_id_tbl IN PO_TBL_NUMBER
63: , p_price_type_tbl IN PO_TBL_VARCHAR30
64: , x_result_set_id IN OUT NOCOPY NUMBER
65: , x_result_type OUT NOCOPY VARCHAR2

Line 62: , p_from_line_id_tbl IN PO_TBL_NUMBER

58: PROCEDURE spo_price_type_on_src_doc(
59: p_price_differential_id_tbl IN PO_TBL_NUMBER
60: , p_entity_type_tbl IN PO_TBL_VARCHAR30
61: , p_from_line_location_id_tbl IN PO_TBL_NUMBER
62: , p_from_line_id_tbl IN PO_TBL_NUMBER
63: , p_price_type_tbl IN PO_TBL_VARCHAR30
64: , x_result_set_id IN OUT NOCOPY NUMBER
65: , x_result_type OUT NOCOPY VARCHAR2
66: );

Line 69: p_price_differential_id_tbl IN PO_TBL_NUMBER

65: , x_result_type OUT NOCOPY VARCHAR2
66: );
67:
68: PROCEDURE spo_mul_btwn_min_max(
69: p_price_differential_id_tbl IN PO_TBL_NUMBER
70: , p_entity_type_tbl IN PO_TBL_VARCHAR30
71: , p_from_line_location_id_tbl IN PO_TBL_NUMBER
72: , p_from_line_id_tbl IN PO_TBL_NUMBER
73: , p_multiplier_tbl IN PO_TBL_NUMBER

Line 71: , p_from_line_location_id_tbl IN PO_TBL_NUMBER

67:
68: PROCEDURE spo_mul_btwn_min_max(
69: p_price_differential_id_tbl IN PO_TBL_NUMBER
70: , p_entity_type_tbl IN PO_TBL_VARCHAR30
71: , p_from_line_location_id_tbl IN PO_TBL_NUMBER
72: , p_from_line_id_tbl IN PO_TBL_NUMBER
73: , p_multiplier_tbl IN PO_TBL_NUMBER
74: , p_price_type_tbl IN PO_TBL_VARCHAR30 --Bug 5415284
75: , x_result_set_id IN OUT NOCOPY NUMBER

Line 72: , p_from_line_id_tbl IN PO_TBL_NUMBER

68: PROCEDURE spo_mul_btwn_min_max(
69: p_price_differential_id_tbl IN PO_TBL_NUMBER
70: , p_entity_type_tbl IN PO_TBL_VARCHAR30
71: , p_from_line_location_id_tbl IN PO_TBL_NUMBER
72: , p_from_line_id_tbl IN PO_TBL_NUMBER
73: , p_multiplier_tbl IN PO_TBL_NUMBER
74: , p_price_type_tbl IN PO_TBL_VARCHAR30 --Bug 5415284
75: , x_result_set_id IN OUT NOCOPY NUMBER
76: , x_result_type OUT NOCOPY VARCHAR2

Line 73: , p_multiplier_tbl IN PO_TBL_NUMBER

69: p_price_differential_id_tbl IN PO_TBL_NUMBER
70: , p_entity_type_tbl IN PO_TBL_VARCHAR30
71: , p_from_line_location_id_tbl IN PO_TBL_NUMBER
72: , p_from_line_id_tbl IN PO_TBL_NUMBER
73: , p_multiplier_tbl IN PO_TBL_NUMBER
74: , p_price_type_tbl IN PO_TBL_VARCHAR30 --Bug 5415284
75: , x_result_set_id IN OUT NOCOPY NUMBER
76: , x_result_type OUT NOCOPY VARCHAR2
77: );

Line 80: p_price_differential_id_tbl IN PO_TBL_NUMBER

76: , x_result_type OUT NOCOPY VARCHAR2
77: );
78:
79: PROCEDURE spo_mul_ge_min(
80: p_price_differential_id_tbl IN PO_TBL_NUMBER
81: , p_entity_type_tbl IN PO_TBL_VARCHAR30
82: , p_from_line_location_id_tbl IN PO_TBL_NUMBER
83: , p_from_line_id_tbl IN PO_TBL_NUMBER
84: , p_multiplier_tbl IN PO_TBL_NUMBER

Line 82: , p_from_line_location_id_tbl IN PO_TBL_NUMBER

78:
79: PROCEDURE spo_mul_ge_min(
80: p_price_differential_id_tbl IN PO_TBL_NUMBER
81: , p_entity_type_tbl IN PO_TBL_VARCHAR30
82: , p_from_line_location_id_tbl IN PO_TBL_NUMBER
83: , p_from_line_id_tbl IN PO_TBL_NUMBER
84: , p_multiplier_tbl IN PO_TBL_NUMBER
85: , p_price_type_tbl IN PO_TBL_VARCHAR30 --Bug 5415284
86: , x_result_set_id IN OUT NOCOPY NUMBER

Line 83: , p_from_line_id_tbl IN PO_TBL_NUMBER

79: PROCEDURE spo_mul_ge_min(
80: p_price_differential_id_tbl IN PO_TBL_NUMBER
81: , p_entity_type_tbl IN PO_TBL_VARCHAR30
82: , p_from_line_location_id_tbl IN PO_TBL_NUMBER
83: , p_from_line_id_tbl IN PO_TBL_NUMBER
84: , p_multiplier_tbl IN PO_TBL_NUMBER
85: , p_price_type_tbl IN PO_TBL_VARCHAR30 --Bug 5415284
86: , x_result_set_id IN OUT NOCOPY NUMBER
87: , x_result_type OUT NOCOPY VARCHAR2

Line 84: , p_multiplier_tbl IN PO_TBL_NUMBER

80: p_price_differential_id_tbl IN PO_TBL_NUMBER
81: , p_entity_type_tbl IN PO_TBL_VARCHAR30
82: , p_from_line_location_id_tbl IN PO_TBL_NUMBER
83: , p_from_line_id_tbl IN PO_TBL_NUMBER
84: , p_multiplier_tbl IN PO_TBL_NUMBER
85: , p_price_type_tbl IN PO_TBL_VARCHAR30 --Bug 5415284
86: , x_result_set_id IN OUT NOCOPY NUMBER
87: , x_result_type OUT NOCOPY VARCHAR2
88: );