APPS.CS_COUNTERS_PUB dependencies on FND_API

Line 10: name VARCHAR2(30), -- := FND_API.G_MISS_CHAR,

6: -- ---------------------------------------------------------
7:
8: TYPE CtrGrp_Rec_Type IS RECORD
9: (
10: name VARCHAR2(30), -- := FND_API.G_MISS_CHAR,
11: description VARCHAR2(240), -- := FND_API.G_MISS_CHAR,
12: association_type VARCHAR2(30), -- := FND_API.G_MISS_CHAR,
13: start_date_active DATE, -- := FND_API.G_MISS_DATE,
14: end_date_active DATE, -- := FND_API.G_MISS_DATE,

Line 11: description VARCHAR2(240), -- := FND_API.G_MISS_CHAR,

7:
8: TYPE CtrGrp_Rec_Type IS RECORD
9: (
10: name VARCHAR2(30), -- := FND_API.G_MISS_CHAR,
11: description VARCHAR2(240), -- := FND_API.G_MISS_CHAR,
12: association_type VARCHAR2(30), -- := FND_API.G_MISS_CHAR,
13: start_date_active DATE, -- := FND_API.G_MISS_DATE,
14: end_date_active DATE, -- := FND_API.G_MISS_DATE,
15: desc_flex CS_COUNTERS_EXT_PVT.DFF_Rec_Type

Line 12: association_type VARCHAR2(30), -- := FND_API.G_MISS_CHAR,

8: TYPE CtrGrp_Rec_Type IS RECORD
9: (
10: name VARCHAR2(30), -- := FND_API.G_MISS_CHAR,
11: description VARCHAR2(240), -- := FND_API.G_MISS_CHAR,
12: association_type VARCHAR2(30), -- := FND_API.G_MISS_CHAR,
13: start_date_active DATE, -- := FND_API.G_MISS_DATE,
14: end_date_active DATE, -- := FND_API.G_MISS_DATE,
15: desc_flex CS_COUNTERS_EXT_PVT.DFF_Rec_Type
16: );

Line 13: start_date_active DATE, -- := FND_API.G_MISS_DATE,

9: (
10: name VARCHAR2(30), -- := FND_API.G_MISS_CHAR,
11: description VARCHAR2(240), -- := FND_API.G_MISS_CHAR,
12: association_type VARCHAR2(30), -- := FND_API.G_MISS_CHAR,
13: start_date_active DATE, -- := FND_API.G_MISS_DATE,
14: end_date_active DATE, -- := FND_API.G_MISS_DATE,
15: desc_flex CS_COUNTERS_EXT_PVT.DFF_Rec_Type
16: );
17:

Line 14: end_date_active DATE, -- := FND_API.G_MISS_DATE,

10: name VARCHAR2(30), -- := FND_API.G_MISS_CHAR,
11: description VARCHAR2(240), -- := FND_API.G_MISS_CHAR,
12: association_type VARCHAR2(30), -- := FND_API.G_MISS_CHAR,
13: start_date_active DATE, -- := FND_API.G_MISS_DATE,
14: end_date_active DATE, -- := FND_API.G_MISS_DATE,
15: desc_flex CS_COUNTERS_EXT_PVT.DFF_Rec_Type
16: );
17:
18: TYPE Ctr_Rec_Type IS RECORD

Line 20: ctr_tbl_index NUMBER , -- := FND_API.G_MISS_NUM,

16: );
17:
18: TYPE Ctr_Rec_Type IS RECORD
19: (
20: ctr_tbl_index NUMBER , -- := FND_API.G_MISS_NUM,
21: counter_group_id NUMBER , -- := FND_API.G_MISS_NUM,
22: name VARCHAR2(30), -- := FND_API.G_MISS_CHAR,
23: description VARCHAR2(240), -- := FND_API.G_MISS_CHAR,
24: type VARCHAR2(30), -- := FND_API.G_MISS_CHAR,

Line 21: counter_group_id NUMBER , -- := FND_API.G_MISS_NUM,

17:
18: TYPE Ctr_Rec_Type IS RECORD
19: (
20: ctr_tbl_index NUMBER , -- := FND_API.G_MISS_NUM,
21: counter_group_id NUMBER , -- := FND_API.G_MISS_NUM,
22: name VARCHAR2(30), -- := FND_API.G_MISS_CHAR,
23: description VARCHAR2(240), -- := FND_API.G_MISS_CHAR,
24: type VARCHAR2(30), -- := FND_API.G_MISS_CHAR,
25: step_value NUMBER, -- := FND_API.G_MISS_NUM,

Line 22: name VARCHAR2(30), -- := FND_API.G_MISS_CHAR,

18: TYPE Ctr_Rec_Type IS RECORD
19: (
20: ctr_tbl_index NUMBER , -- := FND_API.G_MISS_NUM,
21: counter_group_id NUMBER , -- := FND_API.G_MISS_NUM,
22: name VARCHAR2(30), -- := FND_API.G_MISS_CHAR,
23: description VARCHAR2(240), -- := FND_API.G_MISS_CHAR,
24: type VARCHAR2(30), -- := FND_API.G_MISS_CHAR,
25: step_value NUMBER, -- := FND_API.G_MISS_NUM,
26: initial_reading NUMBER, -- := FND_API.G_MISS_NUM,

Line 23: description VARCHAR2(240), -- := FND_API.G_MISS_CHAR,

19: (
20: ctr_tbl_index NUMBER , -- := FND_API.G_MISS_NUM,
21: counter_group_id NUMBER , -- := FND_API.G_MISS_NUM,
22: name VARCHAR2(30), -- := FND_API.G_MISS_CHAR,
23: description VARCHAR2(240), -- := FND_API.G_MISS_CHAR,
24: type VARCHAR2(30), -- := FND_API.G_MISS_CHAR,
25: step_value NUMBER, -- := FND_API.G_MISS_NUM,
26: initial_reading NUMBER, -- := FND_API.G_MISS_NUM,
27: rollover_last_reading NUMBER, -- := FND_API.G_MISS_NUM,

Line 24: type VARCHAR2(30), -- := FND_API.G_MISS_CHAR,

20: ctr_tbl_index NUMBER , -- := FND_API.G_MISS_NUM,
21: counter_group_id NUMBER , -- := FND_API.G_MISS_NUM,
22: name VARCHAR2(30), -- := FND_API.G_MISS_CHAR,
23: description VARCHAR2(240), -- := FND_API.G_MISS_CHAR,
24: type VARCHAR2(30), -- := FND_API.G_MISS_CHAR,
25: step_value NUMBER, -- := FND_API.G_MISS_NUM,
26: initial_reading NUMBER, -- := FND_API.G_MISS_NUM,
27: rollover_last_reading NUMBER, -- := FND_API.G_MISS_NUM,
28: rollover_first_reading NUMBER, -- := FND_API.G_MISS_NUM,

Line 25: step_value NUMBER, -- := FND_API.G_MISS_NUM,

21: counter_group_id NUMBER , -- := FND_API.G_MISS_NUM,
22: name VARCHAR2(30), -- := FND_API.G_MISS_CHAR,
23: description VARCHAR2(240), -- := FND_API.G_MISS_CHAR,
24: type VARCHAR2(30), -- := FND_API.G_MISS_CHAR,
25: step_value NUMBER, -- := FND_API.G_MISS_NUM,
26: initial_reading NUMBER, -- := FND_API.G_MISS_NUM,
27: rollover_last_reading NUMBER, -- := FND_API.G_MISS_NUM,
28: rollover_first_reading NUMBER, -- := FND_API.G_MISS_NUM,
29: uom_code VARCHAR2(3), -- := FND_API.G_MISS_CHAR,

Line 26: initial_reading NUMBER, -- := FND_API.G_MISS_NUM,

22: name VARCHAR2(30), -- := FND_API.G_MISS_CHAR,
23: description VARCHAR2(240), -- := FND_API.G_MISS_CHAR,
24: type VARCHAR2(30), -- := FND_API.G_MISS_CHAR,
25: step_value NUMBER, -- := FND_API.G_MISS_NUM,
26: initial_reading NUMBER, -- := FND_API.G_MISS_NUM,
27: rollover_last_reading NUMBER, -- := FND_API.G_MISS_NUM,
28: rollover_first_reading NUMBER, -- := FND_API.G_MISS_NUM,
29: uom_code VARCHAR2(3), -- := FND_API.G_MISS_CHAR,
30: tolerance_plus NUMBER, -- := FND_API.G_MISS_NUM,

Line 27: rollover_last_reading NUMBER, -- := FND_API.G_MISS_NUM,

23: description VARCHAR2(240), -- := FND_API.G_MISS_CHAR,
24: type VARCHAR2(30), -- := FND_API.G_MISS_CHAR,
25: step_value NUMBER, -- := FND_API.G_MISS_NUM,
26: initial_reading NUMBER, -- := FND_API.G_MISS_NUM,
27: rollover_last_reading NUMBER, -- := FND_API.G_MISS_NUM,
28: rollover_first_reading NUMBER, -- := FND_API.G_MISS_NUM,
29: uom_code VARCHAR2(3), -- := FND_API.G_MISS_CHAR,
30: tolerance_plus NUMBER, -- := FND_API.G_MISS_NUM,
31: tolerance_minus NUMBER, -- := FND_API.G_MISS_NUM,

Line 28: rollover_first_reading NUMBER, -- := FND_API.G_MISS_NUM,

24: type VARCHAR2(30), -- := FND_API.G_MISS_CHAR,
25: step_value NUMBER, -- := FND_API.G_MISS_NUM,
26: initial_reading NUMBER, -- := FND_API.G_MISS_NUM,
27: rollover_last_reading NUMBER, -- := FND_API.G_MISS_NUM,
28: rollover_first_reading NUMBER, -- := FND_API.G_MISS_NUM,
29: uom_code VARCHAR2(3), -- := FND_API.G_MISS_CHAR,
30: tolerance_plus NUMBER, -- := FND_API.G_MISS_NUM,
31: tolerance_minus NUMBER, -- := FND_API.G_MISS_NUM,
32: derive_function VARCHAR2(30), -- := FND_API.G_MISS_CHAR,

Line 29: uom_code VARCHAR2(3), -- := FND_API.G_MISS_CHAR,

25: step_value NUMBER, -- := FND_API.G_MISS_NUM,
26: initial_reading NUMBER, -- := FND_API.G_MISS_NUM,
27: rollover_last_reading NUMBER, -- := FND_API.G_MISS_NUM,
28: rollover_first_reading NUMBER, -- := FND_API.G_MISS_NUM,
29: uom_code VARCHAR2(3), -- := FND_API.G_MISS_CHAR,
30: tolerance_plus NUMBER, -- := FND_API.G_MISS_NUM,
31: tolerance_minus NUMBER, -- := FND_API.G_MISS_NUM,
32: derive_function VARCHAR2(30), -- := FND_API.G_MISS_CHAR,
33: derive_counter_id NUMBER, -- := FND_API.G_MISS_NUM,

Line 30: tolerance_plus NUMBER, -- := FND_API.G_MISS_NUM,

26: initial_reading NUMBER, -- := FND_API.G_MISS_NUM,
27: rollover_last_reading NUMBER, -- := FND_API.G_MISS_NUM,
28: rollover_first_reading NUMBER, -- := FND_API.G_MISS_NUM,
29: uom_code VARCHAR2(3), -- := FND_API.G_MISS_CHAR,
30: tolerance_plus NUMBER, -- := FND_API.G_MISS_NUM,
31: tolerance_minus NUMBER, -- := FND_API.G_MISS_NUM,
32: derive_function VARCHAR2(30), -- := FND_API.G_MISS_CHAR,
33: derive_counter_id NUMBER, -- := FND_API.G_MISS_NUM,
34: derive_property_id NUMBER, -- := FND_API.G_MISS_NUM,

Line 31: tolerance_minus NUMBER, -- := FND_API.G_MISS_NUM,

27: rollover_last_reading NUMBER, -- := FND_API.G_MISS_NUM,
28: rollover_first_reading NUMBER, -- := FND_API.G_MISS_NUM,
29: uom_code VARCHAR2(3), -- := FND_API.G_MISS_CHAR,
30: tolerance_plus NUMBER, -- := FND_API.G_MISS_NUM,
31: tolerance_minus NUMBER, -- := FND_API.G_MISS_NUM,
32: derive_function VARCHAR2(30), -- := FND_API.G_MISS_CHAR,
33: derive_counter_id NUMBER, -- := FND_API.G_MISS_NUM,
34: derive_property_id NUMBER, -- := FND_API.G_MISS_NUM,
35: formula_text VARCHAR2(1996), -- := FND_API.G_MISS_CHAR,

Line 32: derive_function VARCHAR2(30), -- := FND_API.G_MISS_CHAR,

28: rollover_first_reading NUMBER, -- := FND_API.G_MISS_NUM,
29: uom_code VARCHAR2(3), -- := FND_API.G_MISS_CHAR,
30: tolerance_plus NUMBER, -- := FND_API.G_MISS_NUM,
31: tolerance_minus NUMBER, -- := FND_API.G_MISS_NUM,
32: derive_function VARCHAR2(30), -- := FND_API.G_MISS_CHAR,
33: derive_counter_id NUMBER, -- := FND_API.G_MISS_NUM,
34: derive_property_id NUMBER, -- := FND_API.G_MISS_NUM,
35: formula_text VARCHAR2(1996), -- := FND_API.G_MISS_CHAR,
36: comments VARCHAR2(1996), -- := FND_API.G_MISS_CHAR,

Line 33: derive_counter_id NUMBER, -- := FND_API.G_MISS_NUM,

29: uom_code VARCHAR2(3), -- := FND_API.G_MISS_CHAR,
30: tolerance_plus NUMBER, -- := FND_API.G_MISS_NUM,
31: tolerance_minus NUMBER, -- := FND_API.G_MISS_NUM,
32: derive_function VARCHAR2(30), -- := FND_API.G_MISS_CHAR,
33: derive_counter_id NUMBER, -- := FND_API.G_MISS_NUM,
34: derive_property_id NUMBER, -- := FND_API.G_MISS_NUM,
35: formula_text VARCHAR2(1996), -- := FND_API.G_MISS_CHAR,
36: comments VARCHAR2(1996), -- := FND_API.G_MISS_CHAR,
37: usage_item_id NUMBER , -- := FND_API.G_MISS_NUM,

Line 34: derive_property_id NUMBER, -- := FND_API.G_MISS_NUM,

30: tolerance_plus NUMBER, -- := FND_API.G_MISS_NUM,
31: tolerance_minus NUMBER, -- := FND_API.G_MISS_NUM,
32: derive_function VARCHAR2(30), -- := FND_API.G_MISS_CHAR,
33: derive_counter_id NUMBER, -- := FND_API.G_MISS_NUM,
34: derive_property_id NUMBER, -- := FND_API.G_MISS_NUM,
35: formula_text VARCHAR2(1996), -- := FND_API.G_MISS_CHAR,
36: comments VARCHAR2(1996), -- := FND_API.G_MISS_CHAR,
37: usage_item_id NUMBER , -- := FND_API.G_MISS_NUM,
38: start_date_active DATE, -- := FND_API.G_MISS_DATE,

Line 35: formula_text VARCHAR2(1996), -- := FND_API.G_MISS_CHAR,

31: tolerance_minus NUMBER, -- := FND_API.G_MISS_NUM,
32: derive_function VARCHAR2(30), -- := FND_API.G_MISS_CHAR,
33: derive_counter_id NUMBER, -- := FND_API.G_MISS_NUM,
34: derive_property_id NUMBER, -- := FND_API.G_MISS_NUM,
35: formula_text VARCHAR2(1996), -- := FND_API.G_MISS_CHAR,
36: comments VARCHAR2(1996), -- := FND_API.G_MISS_CHAR,
37: usage_item_id NUMBER , -- := FND_API.G_MISS_NUM,
38: start_date_active DATE, -- := FND_API.G_MISS_DATE,
39: end_date_active DATE, -- := FND_API.G_MISS_DATE,

Line 36: comments VARCHAR2(1996), -- := FND_API.G_MISS_CHAR,

32: derive_function VARCHAR2(30), -- := FND_API.G_MISS_CHAR,
33: derive_counter_id NUMBER, -- := FND_API.G_MISS_NUM,
34: derive_property_id NUMBER, -- := FND_API.G_MISS_NUM,
35: formula_text VARCHAR2(1996), -- := FND_API.G_MISS_CHAR,
36: comments VARCHAR2(1996), -- := FND_API.G_MISS_CHAR,
37: usage_item_id NUMBER , -- := FND_API.G_MISS_NUM,
38: start_date_active DATE, -- := FND_API.G_MISS_DATE,
39: end_date_active DATE, -- := FND_API.G_MISS_DATE,
40: desc_flex CS_COUNTERS_EXT_PVT.DFF_Rec_Type,

Line 37: usage_item_id NUMBER , -- := FND_API.G_MISS_NUM,

33: derive_counter_id NUMBER, -- := FND_API.G_MISS_NUM,
34: derive_property_id NUMBER, -- := FND_API.G_MISS_NUM,
35: formula_text VARCHAR2(1996), -- := FND_API.G_MISS_CHAR,
36: comments VARCHAR2(1996), -- := FND_API.G_MISS_CHAR,
37: usage_item_id NUMBER , -- := FND_API.G_MISS_NUM,
38: start_date_active DATE, -- := FND_API.G_MISS_DATE,
39: end_date_active DATE, -- := FND_API.G_MISS_DATE,
40: desc_flex CS_COUNTERS_EXT_PVT.DFF_Rec_Type,
41: customer_view VARCHAR2(1), -- := FND_API.G_MISS_CHAR,

Line 38: start_date_active DATE, -- := FND_API.G_MISS_DATE,

34: derive_property_id NUMBER, -- := FND_API.G_MISS_NUM,
35: formula_text VARCHAR2(1996), -- := FND_API.G_MISS_CHAR,
36: comments VARCHAR2(1996), -- := FND_API.G_MISS_CHAR,
37: usage_item_id NUMBER , -- := FND_API.G_MISS_NUM,
38: start_date_active DATE, -- := FND_API.G_MISS_DATE,
39: end_date_active DATE, -- := FND_API.G_MISS_DATE,
40: desc_flex CS_COUNTERS_EXT_PVT.DFF_Rec_Type,
41: customer_view VARCHAR2(1), -- := FND_API.G_MISS_CHAR,
42: duration NUMBER, -- := FND_API.G_MISS_NUM,

Line 39: end_date_active DATE, -- := FND_API.G_MISS_DATE,

35: formula_text VARCHAR2(1996), -- := FND_API.G_MISS_CHAR,
36: comments VARCHAR2(1996), -- := FND_API.G_MISS_CHAR,
37: usage_item_id NUMBER , -- := FND_API.G_MISS_NUM,
38: start_date_active DATE, -- := FND_API.G_MISS_DATE,
39: end_date_active DATE, -- := FND_API.G_MISS_DATE,
40: desc_flex CS_COUNTERS_EXT_PVT.DFF_Rec_Type,
41: customer_view VARCHAR2(1), -- := FND_API.G_MISS_CHAR,
42: duration NUMBER, -- := FND_API.G_MISS_NUM,
43: duration_uom VARCHAR2(3), -- := FND_API.G_MISS_CHAR,

Line 41: customer_view VARCHAR2(1), -- := FND_API.G_MISS_CHAR,

37: usage_item_id NUMBER , -- := FND_API.G_MISS_NUM,
38: start_date_active DATE, -- := FND_API.G_MISS_DATE,
39: end_date_active DATE, -- := FND_API.G_MISS_DATE,
40: desc_flex CS_COUNTERS_EXT_PVT.DFF_Rec_Type,
41: customer_view VARCHAR2(1), -- := FND_API.G_MISS_CHAR,
42: duration NUMBER, -- := FND_API.G_MISS_NUM,
43: duration_uom VARCHAR2(3), -- := FND_API.G_MISS_CHAR,
44: direction VARCHAR2(1), -- := FND_API.G_MISS_CHAR,
45: filter_reading_count NUMBER , -- := FND_API.G_MISS_NUM,

Line 42: duration NUMBER, -- := FND_API.G_MISS_NUM,

38: start_date_active DATE, -- := FND_API.G_MISS_DATE,
39: end_date_active DATE, -- := FND_API.G_MISS_DATE,
40: desc_flex CS_COUNTERS_EXT_PVT.DFF_Rec_Type,
41: customer_view VARCHAR2(1), -- := FND_API.G_MISS_CHAR,
42: duration NUMBER, -- := FND_API.G_MISS_NUM,
43: duration_uom VARCHAR2(3), -- := FND_API.G_MISS_CHAR,
44: direction VARCHAR2(1), -- := FND_API.G_MISS_CHAR,
45: filter_reading_count NUMBER , -- := FND_API.G_MISS_NUM,
46: filter_type VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,

Line 43: duration_uom VARCHAR2(3), -- := FND_API.G_MISS_CHAR,

39: end_date_active DATE, -- := FND_API.G_MISS_DATE,
40: desc_flex CS_COUNTERS_EXT_PVT.DFF_Rec_Type,
41: customer_view VARCHAR2(1), -- := FND_API.G_MISS_CHAR,
42: duration NUMBER, -- := FND_API.G_MISS_NUM,
43: duration_uom VARCHAR2(3), -- := FND_API.G_MISS_CHAR,
44: direction VARCHAR2(1), -- := FND_API.G_MISS_CHAR,
45: filter_reading_count NUMBER , -- := FND_API.G_MISS_NUM,
46: filter_type VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
47: filter_time_uom VARCHAR2(30), -- := FND_API.G_MISS_CHAR,

Line 44: direction VARCHAR2(1), -- := FND_API.G_MISS_CHAR,

40: desc_flex CS_COUNTERS_EXT_PVT.DFF_Rec_Type,
41: customer_view VARCHAR2(1), -- := FND_API.G_MISS_CHAR,
42: duration NUMBER, -- := FND_API.G_MISS_NUM,
43: duration_uom VARCHAR2(3), -- := FND_API.G_MISS_CHAR,
44: direction VARCHAR2(1), -- := FND_API.G_MISS_CHAR,
45: filter_reading_count NUMBER , -- := FND_API.G_MISS_NUM,
46: filter_type VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
47: filter_time_uom VARCHAR2(30), -- := FND_API.G_MISS_CHAR,
48: estimation_id NUMBER -- := FND_API.G_MISS_NUM

Line 45: filter_reading_count NUMBER , -- := FND_API.G_MISS_NUM,

41: customer_view VARCHAR2(1), -- := FND_API.G_MISS_CHAR,
42: duration NUMBER, -- := FND_API.G_MISS_NUM,
43: duration_uom VARCHAR2(3), -- := FND_API.G_MISS_CHAR,
44: direction VARCHAR2(1), -- := FND_API.G_MISS_CHAR,
45: filter_reading_count NUMBER , -- := FND_API.G_MISS_NUM,
46: filter_type VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
47: filter_time_uom VARCHAR2(30), -- := FND_API.G_MISS_CHAR,
48: estimation_id NUMBER -- := FND_API.G_MISS_NUM
49: );

Line 46: filter_type VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,

42: duration NUMBER, -- := FND_API.G_MISS_NUM,
43: duration_uom VARCHAR2(3), -- := FND_API.G_MISS_CHAR,
44: direction VARCHAR2(1), -- := FND_API.G_MISS_CHAR,
45: filter_reading_count NUMBER , -- := FND_API.G_MISS_NUM,
46: filter_type VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
47: filter_time_uom VARCHAR2(30), -- := FND_API.G_MISS_CHAR,
48: estimation_id NUMBER -- := FND_API.G_MISS_NUM
49: );
50:

Line 47: filter_time_uom VARCHAR2(30), -- := FND_API.G_MISS_CHAR,

43: duration_uom VARCHAR2(3), -- := FND_API.G_MISS_CHAR,
44: direction VARCHAR2(1), -- := FND_API.G_MISS_CHAR,
45: filter_reading_count NUMBER , -- := FND_API.G_MISS_NUM,
46: filter_type VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
47: filter_time_uom VARCHAR2(30), -- := FND_API.G_MISS_CHAR,
48: estimation_id NUMBER -- := FND_API.G_MISS_NUM
49: );
50:
51: TYPE Ctr_Prop_Rec_Type IS RECORD

Line 48: estimation_id NUMBER -- := FND_API.G_MISS_NUM

44: direction VARCHAR2(1), -- := FND_API.G_MISS_CHAR,
45: filter_reading_count NUMBER , -- := FND_API.G_MISS_NUM,
46: filter_type VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
47: filter_time_uom VARCHAR2(30), -- := FND_API.G_MISS_CHAR,
48: estimation_id NUMBER -- := FND_API.G_MISS_NUM
49: );
50:
51: TYPE Ctr_Prop_Rec_Type IS RECORD
52: (

Line 53: ctr_tbl_index NUMBER , -- := FND_API.G_MISS_NUM,

49: );
50:
51: TYPE Ctr_Prop_Rec_Type IS RECORD
52: (
53: ctr_tbl_index NUMBER , -- := FND_API.G_MISS_NUM,
54: counter_id NUMBER, -- := FND_API.G_MISS_NUM,
55: name VARCHAR2(30), -- := FND_API.G_MISS_CHAR,
56: description VARCHAR2(240), -- := FND_API.G_MISS_CHAR,
57: property_data_type VARCHAR2(30), -- := FND_API.G_MISS_CHAR,

Line 54: counter_id NUMBER, -- := FND_API.G_MISS_NUM,

50:
51: TYPE Ctr_Prop_Rec_Type IS RECORD
52: (
53: ctr_tbl_index NUMBER , -- := FND_API.G_MISS_NUM,
54: counter_id NUMBER, -- := FND_API.G_MISS_NUM,
55: name VARCHAR2(30), -- := FND_API.G_MISS_CHAR,
56: description VARCHAR2(240), -- := FND_API.G_MISS_CHAR,
57: property_data_type VARCHAR2(30), -- := FND_API.G_MISS_CHAR,
58: is_nullable VARCHAR2(1), -- := FND_API.G_MISS_CHAR,

Line 55: name VARCHAR2(30), -- := FND_API.G_MISS_CHAR,

51: TYPE Ctr_Prop_Rec_Type IS RECORD
52: (
53: ctr_tbl_index NUMBER , -- := FND_API.G_MISS_NUM,
54: counter_id NUMBER, -- := FND_API.G_MISS_NUM,
55: name VARCHAR2(30), -- := FND_API.G_MISS_CHAR,
56: description VARCHAR2(240), -- := FND_API.G_MISS_CHAR,
57: property_data_type VARCHAR2(30), -- := FND_API.G_MISS_CHAR,
58: is_nullable VARCHAR2(1), -- := FND_API.G_MISS_CHAR,
59: default_value VARCHAR2(240), -- := FND_API.G_MISS_CHAR,

Line 56: description VARCHAR2(240), -- := FND_API.G_MISS_CHAR,

52: (
53: ctr_tbl_index NUMBER , -- := FND_API.G_MISS_NUM,
54: counter_id NUMBER, -- := FND_API.G_MISS_NUM,
55: name VARCHAR2(30), -- := FND_API.G_MISS_CHAR,
56: description VARCHAR2(240), -- := FND_API.G_MISS_CHAR,
57: property_data_type VARCHAR2(30), -- := FND_API.G_MISS_CHAR,
58: is_nullable VARCHAR2(1), -- := FND_API.G_MISS_CHAR,
59: default_value VARCHAR2(240), -- := FND_API.G_MISS_CHAR,
60: minimum_value VARCHAR2(240), -- := FND_API.G_MISS_CHAR,

Line 57: property_data_type VARCHAR2(30), -- := FND_API.G_MISS_CHAR,

53: ctr_tbl_index NUMBER , -- := FND_API.G_MISS_NUM,
54: counter_id NUMBER, -- := FND_API.G_MISS_NUM,
55: name VARCHAR2(30), -- := FND_API.G_MISS_CHAR,
56: description VARCHAR2(240), -- := FND_API.G_MISS_CHAR,
57: property_data_type VARCHAR2(30), -- := FND_API.G_MISS_CHAR,
58: is_nullable VARCHAR2(1), -- := FND_API.G_MISS_CHAR,
59: default_value VARCHAR2(240), -- := FND_API.G_MISS_CHAR,
60: minimum_value VARCHAR2(240), -- := FND_API.G_MISS_CHAR,
61: maximum_value VARCHAR2(240), -- := FND_API.G_MISS_CHAR,

Line 58: is_nullable VARCHAR2(1), -- := FND_API.G_MISS_CHAR,

54: counter_id NUMBER, -- := FND_API.G_MISS_NUM,
55: name VARCHAR2(30), -- := FND_API.G_MISS_CHAR,
56: description VARCHAR2(240), -- := FND_API.G_MISS_CHAR,
57: property_data_type VARCHAR2(30), -- := FND_API.G_MISS_CHAR,
58: is_nullable VARCHAR2(1), -- := FND_API.G_MISS_CHAR,
59: default_value VARCHAR2(240), -- := FND_API.G_MISS_CHAR,
60: minimum_value VARCHAR2(240), -- := FND_API.G_MISS_CHAR,
61: maximum_value VARCHAR2(240), -- := FND_API.G_MISS_CHAR,
62: uom_code VARCHAR2(3), -- := FND_API.G_MISS_CHAR,

Line 59: default_value VARCHAR2(240), -- := FND_API.G_MISS_CHAR,

55: name VARCHAR2(30), -- := FND_API.G_MISS_CHAR,
56: description VARCHAR2(240), -- := FND_API.G_MISS_CHAR,
57: property_data_type VARCHAR2(30), -- := FND_API.G_MISS_CHAR,
58: is_nullable VARCHAR2(1), -- := FND_API.G_MISS_CHAR,
59: default_value VARCHAR2(240), -- := FND_API.G_MISS_CHAR,
60: minimum_value VARCHAR2(240), -- := FND_API.G_MISS_CHAR,
61: maximum_value VARCHAR2(240), -- := FND_API.G_MISS_CHAR,
62: uom_code VARCHAR2(3), -- := FND_API.G_MISS_CHAR,
63: start_date_active DATE, -- := FND_API.G_MISS_DATE,

Line 60: minimum_value VARCHAR2(240), -- := FND_API.G_MISS_CHAR,

56: description VARCHAR2(240), -- := FND_API.G_MISS_CHAR,
57: property_data_type VARCHAR2(30), -- := FND_API.G_MISS_CHAR,
58: is_nullable VARCHAR2(1), -- := FND_API.G_MISS_CHAR,
59: default_value VARCHAR2(240), -- := FND_API.G_MISS_CHAR,
60: minimum_value VARCHAR2(240), -- := FND_API.G_MISS_CHAR,
61: maximum_value VARCHAR2(240), -- := FND_API.G_MISS_CHAR,
62: uom_code VARCHAR2(3), -- := FND_API.G_MISS_CHAR,
63: start_date_active DATE, -- := FND_API.G_MISS_DATE,
64: end_date_active DATE, -- := FND_API.G_MISS_DATE,

Line 61: maximum_value VARCHAR2(240), -- := FND_API.G_MISS_CHAR,

57: property_data_type VARCHAR2(30), -- := FND_API.G_MISS_CHAR,
58: is_nullable VARCHAR2(1), -- := FND_API.G_MISS_CHAR,
59: default_value VARCHAR2(240), -- := FND_API.G_MISS_CHAR,
60: minimum_value VARCHAR2(240), -- := FND_API.G_MISS_CHAR,
61: maximum_value VARCHAR2(240), -- := FND_API.G_MISS_CHAR,
62: uom_code VARCHAR2(3), -- := FND_API.G_MISS_CHAR,
63: start_date_active DATE, -- := FND_API.G_MISS_DATE,
64: end_date_active DATE, -- := FND_API.G_MISS_DATE,
65: desc_flex CS_COUNTERS_EXT_PVT.DFF_Rec_Type,

Line 62: uom_code VARCHAR2(3), -- := FND_API.G_MISS_CHAR,

58: is_nullable VARCHAR2(1), -- := FND_API.G_MISS_CHAR,
59: default_value VARCHAR2(240), -- := FND_API.G_MISS_CHAR,
60: minimum_value VARCHAR2(240), -- := FND_API.G_MISS_CHAR,
61: maximum_value VARCHAR2(240), -- := FND_API.G_MISS_CHAR,
62: uom_code VARCHAR2(3), -- := FND_API.G_MISS_CHAR,
63: start_date_active DATE, -- := FND_API.G_MISS_DATE,
64: end_date_active DATE, -- := FND_API.G_MISS_DATE,
65: desc_flex CS_COUNTERS_EXT_PVT.DFF_Rec_Type,
66: property_lov_type VARCHAR2(30) -- := FND_API.G_MISS_CHAR

Line 63: start_date_active DATE, -- := FND_API.G_MISS_DATE,

59: default_value VARCHAR2(240), -- := FND_API.G_MISS_CHAR,
60: minimum_value VARCHAR2(240), -- := FND_API.G_MISS_CHAR,
61: maximum_value VARCHAR2(240), -- := FND_API.G_MISS_CHAR,
62: uom_code VARCHAR2(3), -- := FND_API.G_MISS_CHAR,
63: start_date_active DATE, -- := FND_API.G_MISS_DATE,
64: end_date_active DATE, -- := FND_API.G_MISS_DATE,
65: desc_flex CS_COUNTERS_EXT_PVT.DFF_Rec_Type,
66: property_lov_type VARCHAR2(30) -- := FND_API.G_MISS_CHAR
67: );

Line 64: end_date_active DATE, -- := FND_API.G_MISS_DATE,

60: minimum_value VARCHAR2(240), -- := FND_API.G_MISS_CHAR,
61: maximum_value VARCHAR2(240), -- := FND_API.G_MISS_CHAR,
62: uom_code VARCHAR2(3), -- := FND_API.G_MISS_CHAR,
63: start_date_active DATE, -- := FND_API.G_MISS_DATE,
64: end_date_active DATE, -- := FND_API.G_MISS_DATE,
65: desc_flex CS_COUNTERS_EXT_PVT.DFF_Rec_Type,
66: property_lov_type VARCHAR2(30) -- := FND_API.G_MISS_CHAR
67: );
68:

Line 66: property_lov_type VARCHAR2(30) -- := FND_API.G_MISS_CHAR

62: uom_code VARCHAR2(3), -- := FND_API.G_MISS_CHAR,
63: start_date_active DATE, -- := FND_API.G_MISS_DATE,
64: end_date_active DATE, -- := FND_API.G_MISS_DATE,
65: desc_flex CS_COUNTERS_EXT_PVT.DFF_Rec_Type,
66: property_lov_type VARCHAR2(30) -- := FND_API.G_MISS_CHAR
67: );
68:
69: TYPE CTR_Estimation_Rec_Type IS RECORD
70: (

Line 71: estimation_name VARCHAR2(30), -- := FND_API.G_MISS_CHAR,

67: );
68:
69: TYPE CTR_Estimation_Rec_Type IS RECORD
70: (
71: estimation_name VARCHAR2(30), -- := FND_API.G_MISS_CHAR,
72: estimation_description VARCHAR2(240), -- := FND_API.G_MISS_CHAR,
73: estimation_type VARCHAR2(10), -- := FND_API.G_MISS_CHAR,
74: estimation_avg_type VARCHAR2(3), -- := FND_API.G_MISS_CHAR,
75: fixed_Value NUMBER , -- := FND_API.G_MISS_NUM,

Line 72: estimation_description VARCHAR2(240), -- := FND_API.G_MISS_CHAR,

68:
69: TYPE CTR_Estimation_Rec_Type IS RECORD
70: (
71: estimation_name VARCHAR2(30), -- := FND_API.G_MISS_CHAR,
72: estimation_description VARCHAR2(240), -- := FND_API.G_MISS_CHAR,
73: estimation_type VARCHAR2(10), -- := FND_API.G_MISS_CHAR,
74: estimation_avg_type VARCHAR2(3), -- := FND_API.G_MISS_CHAR,
75: fixed_Value NUMBER , -- := FND_API.G_MISS_NUM,
76: Usage_Markup NUMBER , -- := FND_API.G_MISS_NUM,

Line 73: estimation_type VARCHAR2(10), -- := FND_API.G_MISS_CHAR,

69: TYPE CTR_Estimation_Rec_Type IS RECORD
70: (
71: estimation_name VARCHAR2(30), -- := FND_API.G_MISS_CHAR,
72: estimation_description VARCHAR2(240), -- := FND_API.G_MISS_CHAR,
73: estimation_type VARCHAR2(10), -- := FND_API.G_MISS_CHAR,
74: estimation_avg_type VARCHAR2(3), -- := FND_API.G_MISS_CHAR,
75: fixed_Value NUMBER , -- := FND_API.G_MISS_NUM,
76: Usage_Markup NUMBER , -- := FND_API.G_MISS_NUM,
77: Default_Value NUMBER , -- := FND_API.G_MISS_NUM,

Line 74: estimation_avg_type VARCHAR2(3), -- := FND_API.G_MISS_CHAR,

70: (
71: estimation_name VARCHAR2(30), -- := FND_API.G_MISS_CHAR,
72: estimation_description VARCHAR2(240), -- := FND_API.G_MISS_CHAR,
73: estimation_type VARCHAR2(10), -- := FND_API.G_MISS_CHAR,
74: estimation_avg_type VARCHAR2(3), -- := FND_API.G_MISS_CHAR,
75: fixed_Value NUMBER , -- := FND_API.G_MISS_NUM,
76: Usage_Markup NUMBER , -- := FND_API.G_MISS_NUM,
77: Default_Value NUMBER , -- := FND_API.G_MISS_NUM,
78: Counter_Group_id NUMBER , -- := FND_API.G_MISS_NUM,

Line 75: fixed_Value NUMBER , -- := FND_API.G_MISS_NUM,

71: estimation_name VARCHAR2(30), -- := FND_API.G_MISS_CHAR,
72: estimation_description VARCHAR2(240), -- := FND_API.G_MISS_CHAR,
73: estimation_type VARCHAR2(10), -- := FND_API.G_MISS_CHAR,
74: estimation_avg_type VARCHAR2(3), -- := FND_API.G_MISS_CHAR,
75: fixed_Value NUMBER , -- := FND_API.G_MISS_NUM,
76: Usage_Markup NUMBER , -- := FND_API.G_MISS_NUM,
77: Default_Value NUMBER , -- := FND_API.G_MISS_NUM,
78: Counter_Group_id NUMBER , -- := FND_API.G_MISS_NUM,
79: Counter_id NUMBER , -- := FND_API.G_MISS_NUM,

Line 76: Usage_Markup NUMBER , -- := FND_API.G_MISS_NUM,

72: estimation_description VARCHAR2(240), -- := FND_API.G_MISS_CHAR,
73: estimation_type VARCHAR2(10), -- := FND_API.G_MISS_CHAR,
74: estimation_avg_type VARCHAR2(3), -- := FND_API.G_MISS_CHAR,
75: fixed_Value NUMBER , -- := FND_API.G_MISS_NUM,
76: Usage_Markup NUMBER , -- := FND_API.G_MISS_NUM,
77: Default_Value NUMBER , -- := FND_API.G_MISS_NUM,
78: Counter_Group_id NUMBER , -- := FND_API.G_MISS_NUM,
79: Counter_id NUMBER , -- := FND_API.G_MISS_NUM,
80: start_date_active DATE , -- := FND_API.G_MISS_DATE,

Line 77: Default_Value NUMBER , -- := FND_API.G_MISS_NUM,

73: estimation_type VARCHAR2(10), -- := FND_API.G_MISS_CHAR,
74: estimation_avg_type VARCHAR2(3), -- := FND_API.G_MISS_CHAR,
75: fixed_Value NUMBER , -- := FND_API.G_MISS_NUM,
76: Usage_Markup NUMBER , -- := FND_API.G_MISS_NUM,
77: Default_Value NUMBER , -- := FND_API.G_MISS_NUM,
78: Counter_Group_id NUMBER , -- := FND_API.G_MISS_NUM,
79: Counter_id NUMBER , -- := FND_API.G_MISS_NUM,
80: start_date_active DATE , -- := FND_API.G_MISS_DATE,
81: end_date_active DATE , -- := FND_API.G_MISS_DATE,

Line 78: Counter_Group_id NUMBER , -- := FND_API.G_MISS_NUM,

74: estimation_avg_type VARCHAR2(3), -- := FND_API.G_MISS_CHAR,
75: fixed_Value NUMBER , -- := FND_API.G_MISS_NUM,
76: Usage_Markup NUMBER , -- := FND_API.G_MISS_NUM,
77: Default_Value NUMBER , -- := FND_API.G_MISS_NUM,
78: Counter_Group_id NUMBER , -- := FND_API.G_MISS_NUM,
79: Counter_id NUMBER , -- := FND_API.G_MISS_NUM,
80: start_date_active DATE , -- := FND_API.G_MISS_DATE,
81: end_date_active DATE , -- := FND_API.G_MISS_DATE,
82: ATTRIBUTE1 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,

Line 79: Counter_id NUMBER , -- := FND_API.G_MISS_NUM,

75: fixed_Value NUMBER , -- := FND_API.G_MISS_NUM,
76: Usage_Markup NUMBER , -- := FND_API.G_MISS_NUM,
77: Default_Value NUMBER , -- := FND_API.G_MISS_NUM,
78: Counter_Group_id NUMBER , -- := FND_API.G_MISS_NUM,
79: Counter_id NUMBER , -- := FND_API.G_MISS_NUM,
80: start_date_active DATE , -- := FND_API.G_MISS_DATE,
81: end_date_active DATE , -- := FND_API.G_MISS_DATE,
82: ATTRIBUTE1 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
83: ATTRIBUTE2 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,

Line 80: start_date_active DATE , -- := FND_API.G_MISS_DATE,

76: Usage_Markup NUMBER , -- := FND_API.G_MISS_NUM,
77: Default_Value NUMBER , -- := FND_API.G_MISS_NUM,
78: Counter_Group_id NUMBER , -- := FND_API.G_MISS_NUM,
79: Counter_id NUMBER , -- := FND_API.G_MISS_NUM,
80: start_date_active DATE , -- := FND_API.G_MISS_DATE,
81: end_date_active DATE , -- := FND_API.G_MISS_DATE,
82: ATTRIBUTE1 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
83: ATTRIBUTE2 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
84: ATTRIBUTE3 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,

Line 81: end_date_active DATE , -- := FND_API.G_MISS_DATE,

77: Default_Value NUMBER , -- := FND_API.G_MISS_NUM,
78: Counter_Group_id NUMBER , -- := FND_API.G_MISS_NUM,
79: Counter_id NUMBER , -- := FND_API.G_MISS_NUM,
80: start_date_active DATE , -- := FND_API.G_MISS_DATE,
81: end_date_active DATE , -- := FND_API.G_MISS_DATE,
82: ATTRIBUTE1 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
83: ATTRIBUTE2 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
84: ATTRIBUTE3 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
85: ATTRIBUTE4 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,

Line 82: ATTRIBUTE1 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,

78: Counter_Group_id NUMBER , -- := FND_API.G_MISS_NUM,
79: Counter_id NUMBER , -- := FND_API.G_MISS_NUM,
80: start_date_active DATE , -- := FND_API.G_MISS_DATE,
81: end_date_active DATE , -- := FND_API.G_MISS_DATE,
82: ATTRIBUTE1 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
83: ATTRIBUTE2 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
84: ATTRIBUTE3 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
85: ATTRIBUTE4 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
86: ATTRIBUTE5 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,

Line 83: ATTRIBUTE2 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,

79: Counter_id NUMBER , -- := FND_API.G_MISS_NUM,
80: start_date_active DATE , -- := FND_API.G_MISS_DATE,
81: end_date_active DATE , -- := FND_API.G_MISS_DATE,
82: ATTRIBUTE1 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
83: ATTRIBUTE2 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
84: ATTRIBUTE3 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
85: ATTRIBUTE4 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
86: ATTRIBUTE5 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
87: ATTRIBUTE6 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,

Line 84: ATTRIBUTE3 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,

80: start_date_active DATE , -- := FND_API.G_MISS_DATE,
81: end_date_active DATE , -- := FND_API.G_MISS_DATE,
82: ATTRIBUTE1 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
83: ATTRIBUTE2 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
84: ATTRIBUTE3 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
85: ATTRIBUTE4 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
86: ATTRIBUTE5 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
87: ATTRIBUTE6 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
88: ATTRIBUTE7 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,

Line 85: ATTRIBUTE4 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,

81: end_date_active DATE , -- := FND_API.G_MISS_DATE,
82: ATTRIBUTE1 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
83: ATTRIBUTE2 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
84: ATTRIBUTE3 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
85: ATTRIBUTE4 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
86: ATTRIBUTE5 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
87: ATTRIBUTE6 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
88: ATTRIBUTE7 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
89: ATTRIBUTE8 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,

Line 86: ATTRIBUTE5 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,

82: ATTRIBUTE1 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
83: ATTRIBUTE2 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
84: ATTRIBUTE3 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
85: ATTRIBUTE4 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
86: ATTRIBUTE5 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
87: ATTRIBUTE6 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
88: ATTRIBUTE7 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
89: ATTRIBUTE8 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
90: ATTRIBUTE9 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,

Line 87: ATTRIBUTE6 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,

83: ATTRIBUTE2 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
84: ATTRIBUTE3 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
85: ATTRIBUTE4 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
86: ATTRIBUTE5 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
87: ATTRIBUTE6 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
88: ATTRIBUTE7 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
89: ATTRIBUTE8 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
90: ATTRIBUTE9 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
91: ATTRIBUTE10 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,

Line 88: ATTRIBUTE7 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,

84: ATTRIBUTE3 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
85: ATTRIBUTE4 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
86: ATTRIBUTE5 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
87: ATTRIBUTE6 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
88: ATTRIBUTE7 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
89: ATTRIBUTE8 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
90: ATTRIBUTE9 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
91: ATTRIBUTE10 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
92: ATTRIBUTE11 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,

Line 89: ATTRIBUTE8 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,

85: ATTRIBUTE4 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
86: ATTRIBUTE5 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
87: ATTRIBUTE6 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
88: ATTRIBUTE7 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
89: ATTRIBUTE8 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
90: ATTRIBUTE9 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
91: ATTRIBUTE10 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
92: ATTRIBUTE11 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
93: ATTRIBUTE12 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,

Line 90: ATTRIBUTE9 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,

86: ATTRIBUTE5 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
87: ATTRIBUTE6 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
88: ATTRIBUTE7 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
89: ATTRIBUTE8 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
90: ATTRIBUTE9 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
91: ATTRIBUTE10 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
92: ATTRIBUTE11 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
93: ATTRIBUTE12 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
94: ATTRIBUTE13 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,

Line 91: ATTRIBUTE10 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,

87: ATTRIBUTE6 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
88: ATTRIBUTE7 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
89: ATTRIBUTE8 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
90: ATTRIBUTE9 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
91: ATTRIBUTE10 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
92: ATTRIBUTE11 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
93: ATTRIBUTE12 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
94: ATTRIBUTE13 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
95: ATTRIBUTE14 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,

Line 92: ATTRIBUTE11 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,

88: ATTRIBUTE7 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
89: ATTRIBUTE8 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
90: ATTRIBUTE9 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
91: ATTRIBUTE10 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
92: ATTRIBUTE11 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
93: ATTRIBUTE12 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
94: ATTRIBUTE13 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
95: ATTRIBUTE14 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
96: ATTRIBUTE15 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,

Line 93: ATTRIBUTE12 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,

89: ATTRIBUTE8 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
90: ATTRIBUTE9 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
91: ATTRIBUTE10 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
92: ATTRIBUTE11 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
93: ATTRIBUTE12 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
94: ATTRIBUTE13 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
95: ATTRIBUTE14 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
96: ATTRIBUTE15 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
97: ATTRIBUTE_CATEGORY VARCHAR2(30) -- := FND_API.G_MISS_CHAR

Line 94: ATTRIBUTE13 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,

90: ATTRIBUTE9 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
91: ATTRIBUTE10 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
92: ATTRIBUTE11 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
93: ATTRIBUTE12 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
94: ATTRIBUTE13 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
95: ATTRIBUTE14 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
96: ATTRIBUTE15 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
97: ATTRIBUTE_CATEGORY VARCHAR2(30) -- := FND_API.G_MISS_CHAR
98: );

Line 95: ATTRIBUTE14 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,

91: ATTRIBUTE10 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
92: ATTRIBUTE11 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
93: ATTRIBUTE12 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
94: ATTRIBUTE13 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
95: ATTRIBUTE14 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
96: ATTRIBUTE15 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
97: ATTRIBUTE_CATEGORY VARCHAR2(30) -- := FND_API.G_MISS_CHAR
98: );
99:

Line 96: ATTRIBUTE15 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,

92: ATTRIBUTE11 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
93: ATTRIBUTE12 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
94: ATTRIBUTE13 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
95: ATTRIBUTE14 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
96: ATTRIBUTE15 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
97: ATTRIBUTE_CATEGORY VARCHAR2(30) -- := FND_API.G_MISS_CHAR
98: );
99:
100: TYPE Ctr_Association_Rec_Type IS RECORD

Line 97: ATTRIBUTE_CATEGORY VARCHAR2(30) -- := FND_API.G_MISS_CHAR

93: ATTRIBUTE12 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
94: ATTRIBUTE13 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
95: ATTRIBUTE14 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
96: ATTRIBUTE15 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
97: ATTRIBUTE_CATEGORY VARCHAR2(30) -- := FND_API.G_MISS_CHAR
98: );
99:
100: TYPE Ctr_Association_Rec_Type IS RECORD
101: (

Line 102: counter_group_id NUMBER, -- := FND_API.G_MISS_NUM,

98: );
99:
100: TYPE Ctr_Association_Rec_Type IS RECORD
101: (
102: counter_group_id NUMBER, -- := FND_API.G_MISS_NUM,
103: source_object_id NUMBER, -- := FND_API.G_MISS_NUM,
104: desc_flex CS_COUNTERS_EXT_PVT.DFF_Rec_Type
105: );
106:

Line 103: source_object_id NUMBER, -- := FND_API.G_MISS_NUM,

99:
100: TYPE Ctr_Association_Rec_Type IS RECORD
101: (
102: counter_group_id NUMBER, -- := FND_API.G_MISS_NUM,
103: source_object_id NUMBER, -- := FND_API.G_MISS_NUM,
104: desc_flex CS_COUNTERS_EXT_PVT.DFF_Rec_Type
105: );
106:
107: --

Line 125: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

121:
122: PROCEDURE Create_Ctr_Grp_Template
123: (
124: p_api_version IN NUMBER,
125: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
126: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
127: x_return_status OUT NOCOPY VARCHAR2,
128: x_msg_count OUT NOCOPY NUMBER,
129: x_msg_data OUT NOCOPY VARCHAR2,

Line 126: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

122: PROCEDURE Create_Ctr_Grp_Template
123: (
124: p_api_version IN NUMBER,
125: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
126: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
127: x_return_status OUT NOCOPY VARCHAR2,
128: x_msg_count OUT NOCOPY NUMBER,
129: x_msg_data OUT NOCOPY VARCHAR2,
130: p_ctr_grp_rec IN CS_COUNTERS_PUB.CtrGrp_Rec_Type,

Line 138: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

134:
135: PROCEDURE Create_Ctr_Grp_Instance
136: (
137: p_api_version IN NUMBER,
138: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
139: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
140: x_return_status OUT NOCOPY VARCHAR2,
141: x_msg_count OUT NOCOPY NUMBER,
142: x_msg_data OUT NOCOPY VARCHAR2,

Line 139: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

135: PROCEDURE Create_Ctr_Grp_Instance
136: (
137: p_api_version IN NUMBER,
138: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
139: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
140: x_return_status OUT NOCOPY VARCHAR2,
141: x_msg_count OUT NOCOPY NUMBER,
142: x_msg_data OUT NOCOPY VARCHAR2,
143: p_ctr_grp_rec IN CS_COUNTERS_PUB.CtrGrp_Rec_Type,

Line 153: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

149:
150: PROCEDURE Create_Counter
151: (
152: p_api_version IN NUMBER,
153: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
154: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
155: x_return_status OUT NOCOPY VARCHAR2,
156: x_msg_count OUT NOCOPY NUMBER,
157: x_msg_data OUT NOCOPY VARCHAR2,

Line 154: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

150: PROCEDURE Create_Counter
151: (
152: p_api_version IN NUMBER,
153: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
154: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
155: x_return_status OUT NOCOPY VARCHAR2,
156: x_msg_count OUT NOCOPY NUMBER,
157: x_msg_data OUT NOCOPY VARCHAR2,
158: p_ctr_rec IN CS_COUNTERS_PUB.Ctr_Rec_Type,

Line 166: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

162:
163: PROCEDURE Create_Ctr_Prop
164: (
165: p_api_version IN NUMBER,
166: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
167: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
168: x_return_status OUT NOCOPY VARCHAR2,
169: x_msg_count OUT NOCOPY NUMBER,
170: x_msg_data OUT NOCOPY VARCHAR2,

Line 167: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

163: PROCEDURE Create_Ctr_Prop
164: (
165: p_api_version IN NUMBER,
166: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
167: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
168: x_return_status OUT NOCOPY VARCHAR2,
169: x_msg_count OUT NOCOPY NUMBER,
170: x_msg_data OUT NOCOPY VARCHAR2,
171: p_ctr_prop_rec IN Ctr_Prop_Rec_Type,

Line 179: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

175:
176: PROCEDURE Create_Formula_Ref
177: (
178: p_api_version IN NUMBER,
179: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
180: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
181: x_return_status OUT NOCOPY VARCHAR2,
182: x_msg_count OUT NOCOPY NUMBER,
183: x_msg_data OUT NOCOPY VARCHAR2,

Line 180: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

176: PROCEDURE Create_Formula_Ref
177: (
178: p_api_version IN NUMBER,
179: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
180: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
181: x_return_status OUT NOCOPY VARCHAR2,
182: x_msg_count OUT NOCOPY NUMBER,
183: x_msg_data OUT NOCOPY VARCHAR2,
184: p_counter_id IN NUMBER,

Line 197: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

193:
194: PROCEDURE Create_GrpOp_Filter
195: (
196: p_api_version IN NUMBER,
197: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
198: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
199: x_return_status OUT NOCOPY VARCHAR2,
200: x_msg_count OUT NOCOPY NUMBER,
201: x_msg_data OUT NOCOPY VARCHAR2,

Line 198: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

194: PROCEDURE Create_GrpOp_Filter
195: (
196: p_api_version IN NUMBER,
197: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
198: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
199: x_return_status OUT NOCOPY VARCHAR2,
200: x_msg_count OUT NOCOPY NUMBER,
201: x_msg_data OUT NOCOPY VARCHAR2,
202: p_seq_no IN NUMBER DEFAULT null,

Line 218: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

214:
215: PROCEDURE Create_Ctr_Association
216: (
217: p_api_version IN NUMBER,
218: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
219: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
220: x_return_status OUT NOCOPY VARCHAR2,
221: x_msg_count OUT NOCOPY NUMBER,
222: x_msg_data OUT NOCOPY VARCHAR2,

Line 219: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

215: PROCEDURE Create_Ctr_Association
216: (
217: p_api_version IN NUMBER,
218: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
219: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
220: x_return_status OUT NOCOPY VARCHAR2,
221: x_msg_count OUT NOCOPY NUMBER,
222: x_msg_data OUT NOCOPY VARCHAR2,
223: p_ctr_grp_id IN NUMBER,

Line 233: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

229:
230: PROCEDURE AutoInstantiate_Counters
231: (
232: p_api_version IN NUMBER,
233: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
234: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
235: x_return_status OUT NOCOPY VARCHAR2,
236: x_msg_count OUT NOCOPY NUMBER,
237: x_msg_data OUT NOCOPY VARCHAR2,

Line 234: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

230: PROCEDURE AutoInstantiate_Counters
231: (
232: p_api_version IN NUMBER,
233: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
234: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
235: x_return_status OUT NOCOPY VARCHAR2,
236: x_msg_count OUT NOCOPY NUMBER,
237: x_msg_data OUT NOCOPY VARCHAR2,
238: p_source_object_id_template IN NUMBER,

Line 248: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

244:
245: PROCEDURE Update_Ctr_Grp
246: (
247: p_api_version IN NUMBER,
248: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
249: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
250: x_return_status OUT NOCOPY VARCHAR2,
251: x_msg_count OUT NOCOPY NUMBER,
252: x_msg_data OUT NOCOPY VARCHAR2,

Line 249: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

245: PROCEDURE Update_Ctr_Grp
246: (
247: p_api_version IN NUMBER,
248: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
249: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
250: x_return_status OUT NOCOPY VARCHAR2,
251: x_msg_count OUT NOCOPY NUMBER,
252: x_msg_data OUT NOCOPY VARCHAR2,
253: p_ctr_grp_id IN NUMBER,

Line 256: p_cascade_upd_to_instances IN VARCHAR2 DEFAULT FND_API.G_FALSE,

252: x_msg_data OUT NOCOPY VARCHAR2,
253: p_ctr_grp_id IN NUMBER,
254: p_object_version_number IN NUMBER,
255: p_ctr_grp_rec IN CS_COUNTERS_PUB.CtrGrp_Rec_Type,
256: p_cascade_upd_to_instances IN VARCHAR2 DEFAULT FND_API.G_FALSE,
257: x_object_version_number OUT NOCOPY NUMBER
258: );
259:
260: PROCEDURE Update_Counter

Line 263: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

259:
260: PROCEDURE Update_Counter
261: (
262: p_api_version IN NUMBER,
263: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
264: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
265: x_return_status OUT NOCOPY VARCHAR2,
266: x_msg_count OUT NOCOPY NUMBER,
267: x_msg_data OUT NOCOPY VARCHAR2,

Line 264: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

260: PROCEDURE Update_Counter
261: (
262: p_api_version IN NUMBER,
263: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
264: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
265: x_return_status OUT NOCOPY VARCHAR2,
266: x_msg_count OUT NOCOPY NUMBER,
267: x_msg_data OUT NOCOPY VARCHAR2,
268: p_ctr_id IN NUMBER,

Line 271: p_cascade_upd_to_instances IN VARCHAR2 DEFAULT FND_API.G_FALSE,

267: x_msg_data OUT NOCOPY VARCHAR2,
268: p_ctr_id IN NUMBER,
269: p_object_version_number IN NUMBER,
270: p_ctr_rec IN CS_COUNTERS_PUB.Ctr_Rec_Type,
271: p_cascade_upd_to_instances IN VARCHAR2 DEFAULT FND_API.G_FALSE,
272: x_object_version_number OUT NOCOPY NUMBER
273: );
274:
275: PROCEDURE Update_Ctr_Prop

Line 278: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

274:
275: PROCEDURE Update_Ctr_Prop
276: (
277: p_api_version IN NUMBER,
278: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
279: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
280: x_return_status OUT NOCOPY VARCHAR2,
281: x_msg_count OUT NOCOPY NUMBER,
282: x_msg_data OUT NOCOPY VARCHAR2,

Line 279: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

275: PROCEDURE Update_Ctr_Prop
276: (
277: p_api_version IN NUMBER,
278: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
279: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
280: x_return_status OUT NOCOPY VARCHAR2,
281: x_msg_count OUT NOCOPY NUMBER,
282: x_msg_data OUT NOCOPY VARCHAR2,
283: p_ctr_prop_id IN NUMBER,

Line 286: p_cascade_upd_to_instances IN VARCHAR2 DEFAULT FND_API.G_FALSE,

282: x_msg_data OUT NOCOPY VARCHAR2,
283: p_ctr_prop_id IN NUMBER,
284: p_object_version_number IN NUMBER,
285: p_ctr_prop_rec IN Ctr_Prop_Rec_Type,
286: p_cascade_upd_to_instances IN VARCHAR2 DEFAULT FND_API.G_FALSE,
287: x_object_version_number OUT NOCOPY NUMBER
288: );
289:
290: PROCEDURE Update_Formula_Ref

Line 293: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

289:
290: PROCEDURE Update_Formula_Ref
291: (
292: p_api_version IN NUMBER,
293: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
294: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
295: x_return_status OUT NOCOPY VARCHAR2,
296: x_msg_count OUT NOCOPY NUMBER,
297: x_msg_data OUT NOCOPY VARCHAR2,

Line 294: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

290: PROCEDURE Update_Formula_Ref
291: (
292: p_api_version IN NUMBER,
293: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
294: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
295: x_return_status OUT NOCOPY VARCHAR2,
296: x_msg_count OUT NOCOPY NUMBER,
297: x_msg_data OUT NOCOPY VARCHAR2,
298: p_ctr_formula_bvar_id IN NUMBER,

Line 305: p_cascade_upd_to_instances IN VARCHAR2 DEFAULT FND_API.G_FALSE,

301: p_bind_var_name IN VARCHAR2,
302: p_mapped_item_id IN NUMBER default null,
303: p_mapped_counter_id IN NUMBER,
304: p_desc_flex IN CS_COUNTERS_EXT_PVT.DFF_Rec_Type,
305: p_cascade_upd_to_instances IN VARCHAR2 DEFAULT FND_API.G_FALSE,
306: x_object_version_number OUT NOCOPY NUMBER,
307: p_reading_type IN VARCHAR2
308: );
309:

Line 313: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

309:
310: PROCEDURE Update_GrpOp_Filter
311: (
312: p_api_version IN NUMBER,
313: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
314: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
315: x_return_status OUT NOCOPY VARCHAR2,
316: x_msg_count OUT NOCOPY NUMBER,
317: x_msg_data OUT NOCOPY VARCHAR2,

Line 314: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

310: PROCEDURE Update_GrpOp_Filter
311: (
312: p_api_version IN NUMBER,
313: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
314: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
315: x_return_status OUT NOCOPY VARCHAR2,
316: x_msg_count OUT NOCOPY NUMBER,
317: x_msg_data OUT NOCOPY VARCHAR2,
318: p_ctr_der_filter_id IN NUMBER,

Line 329: p_cascade_upd_to_instances IN VARCHAR2 DEFAULT FND_API.G_FALSE,

325: p_right_val IN VARCHAR2,
326: p_right_paren IN VARCHAR2,
327: p_log_op IN VARCHAR2,
328: p_desc_flex IN CS_COUNTERS_EXT_PVT.DFF_Rec_Type,
329: p_cascade_upd_to_instances IN VARCHAR2 DEFAULT FND_API.G_FALSE,
330: x_object_version_number OUT NOCOPY NUMBER
331: );
332:
333: PROCEDURE Update_Ctr_Association

Line 336: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

332:
333: PROCEDURE Update_Ctr_Association
334: (
335: p_api_version IN NUMBER,
336: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
337: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
338: x_return_status OUT NOCOPY VARCHAR2,
339: x_msg_count OUT NOCOPY NUMBER,
340: x_msg_data OUT NOCOPY VARCHAR2,

Line 337: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

333: PROCEDURE Update_Ctr_Association
334: (
335: p_api_version IN NUMBER,
336: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
337: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
338: x_return_status OUT NOCOPY VARCHAR2,
339: x_msg_count OUT NOCOPY NUMBER,
340: x_msg_data OUT NOCOPY VARCHAR2,
341: p_ctr_association_id IN NUMBER,

Line 352: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

348:
349: PROCEDURE Delete_Counter
350: (
351: p_api_version IN NUMBER,
352: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
353: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
354: x_return_status OUT NOCOPY VARCHAR2,
355: x_msg_count OUT NOCOPY NUMBER,
356: x_msg_data OUT NOCOPY VARCHAR2,

Line 353: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

349: PROCEDURE Delete_Counter
350: (
351: p_api_version IN NUMBER,
352: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
353: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
354: x_return_status OUT NOCOPY VARCHAR2,
355: x_msg_count OUT NOCOPY NUMBER,
356: x_msg_data OUT NOCOPY VARCHAR2,
357: p_ctr_id IN NUMBER

Line 363: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

359:
360: PROCEDURE Delete_Ctr_Prop
361: (
362: p_api_version IN NUMBER,
363: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
364: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
365: x_return_status OUT NOCOPY VARCHAR2,
366: x_msg_count OUT NOCOPY NUMBER,
367: x_msg_data OUT NOCOPY VARCHAR2,

Line 364: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

360: PROCEDURE Delete_Ctr_Prop
361: (
362: p_api_version IN NUMBER,
363: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
364: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
365: x_return_status OUT NOCOPY VARCHAR2,
366: x_msg_count OUT NOCOPY NUMBER,
367: x_msg_data OUT NOCOPY VARCHAR2,
368: p_ctr_prop_id IN NUMBER

Line 374: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

370:
371: PROCEDURE Delete_Formula_Ref
372: (
373: p_api_version IN NUMBER,
374: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
375: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
376: x_return_status OUT NOCOPY VARCHAR2,
377: x_msg_count OUT NOCOPY NUMBER,
378: x_msg_data OUT NOCOPY VARCHAR2,

Line 375: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

371: PROCEDURE Delete_Formula_Ref
372: (
373: p_api_version IN NUMBER,
374: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
375: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
376: x_return_status OUT NOCOPY VARCHAR2,
377: x_msg_count OUT NOCOPY NUMBER,
378: x_msg_data OUT NOCOPY VARCHAR2,
379: p_ctr_formula_bvar_id IN NUMBER

Line 385: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

381:
382: PROCEDURE Delete_GrpOp_Filter
383: (
384: p_api_version IN NUMBER,
385: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
386: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
387: x_return_status OUT NOCOPY VARCHAR2,
388: x_msg_count OUT NOCOPY NUMBER,
389: x_msg_data OUT NOCOPY VARCHAR2,

Line 386: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

382: PROCEDURE Delete_GrpOp_Filter
383: (
384: p_api_version IN NUMBER,
385: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
386: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
387: x_return_status OUT NOCOPY VARCHAR2,
388: x_msg_count OUT NOCOPY NUMBER,
389: x_msg_data OUT NOCOPY VARCHAR2,
390: p_ctr_der_filter_id IN NUMBER

Line 396: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

392:
393: PROCEDURE Delete_Ctr_Association
394: (
395: p_api_version IN NUMBER,
396: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
397: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
398: x_return_status OUT NOCOPY VARCHAR2,
399: x_msg_count OUT NOCOPY NUMBER,
400: x_msg_data OUT NOCOPY VARCHAR2,

Line 397: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

393: PROCEDURE Delete_Ctr_Association
394: (
395: p_api_version IN NUMBER,
396: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
397: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
398: x_return_status OUT NOCOPY VARCHAR2,
399: x_msg_count OUT NOCOPY NUMBER,
400: x_msg_data OUT NOCOPY VARCHAR2,
401: p_ctr_association_id IN NUMBER

Line 407: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

403:
404: PROCEDURE Instantiate_Counters
405: (
406: p_api_version IN NUMBER,
407: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
408: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
409: x_return_status OUT NOCOPY VARCHAR2,
410: x_msg_count OUT NOCOPY NUMBER,
411: x_msg_data OUT NOCOPY VARCHAR2,

Line 408: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

404: PROCEDURE Instantiate_Counters
405: (
406: p_api_version IN NUMBER,
407: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
408: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
409: x_return_status OUT NOCOPY VARCHAR2,
410: x_msg_count OUT NOCOPY NUMBER,
411: x_msg_data OUT NOCOPY VARCHAR2,
412: p_counter_group_id_template IN NUMBER,

Line 421: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

417: );
418:
419: PROCEDURE DELETE_COUNTER_INSTANCE(
420: p_Api_Version IN NUMBER,
421: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
422: p_commit IN VARCHAR2 := FND_API.G_FALSE,
423: p_SOURCE_OBJECT_ID IN NUMBER,
424: p_SOURCE_OBJECT_CODE IN VARCHAR2,
425: x_Return_status OUT NOCOPY VARCHAR2,

Line 422: p_commit IN VARCHAR2 := FND_API.G_FALSE,

418:
419: PROCEDURE DELETE_COUNTER_INSTANCE(
420: p_Api_Version IN NUMBER,
421: p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
422: p_commit IN VARCHAR2 := FND_API.G_FALSE,
423: p_SOURCE_OBJECT_ID IN NUMBER,
424: p_SOURCE_OBJECT_CODE IN VARCHAR2,
425: x_Return_status OUT NOCOPY VARCHAR2,
426: x_Msg_Count OUT NOCOPY NUMBER,

Line 434: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

430:
431: PROCEDURE Instantiate_single_Ctr
432: (
433: p_api_version IN NUMBER,
434: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
435: p_commit IN VARCHAR2 := FND_API.G_FALSE,
436: x_return_status OUT NOCOPY VARCHAR2,
437: x_msg_count OUT NOCOPY NUMBER,
438: x_msg_data OUT NOCOPY VARCHAR2,

Line 435: p_commit IN VARCHAR2 := FND_API.G_FALSE,

431: PROCEDURE Instantiate_single_Ctr
432: (
433: p_api_version IN NUMBER,
434: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
435: p_commit IN VARCHAR2 := FND_API.G_FALSE,
436: x_return_status OUT NOCOPY VARCHAR2,
437: x_msg_count OUT NOCOPY NUMBER,
438: x_msg_data OUT NOCOPY VARCHAR2,
439: p_counter_id_template IN NUMBER,

Line 448: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

444:
445: PROCEDURE Create_Estimation_Method
446: (
447: p_api_version IN NUMBER,
448: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
449: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
450: x_return_status OUT NOCOPY VARCHAR2,
451: x_msg_count OUT NOCOPY NUMBER,
452: x_msg_data OUT NOCOPY VARCHAR2,

Line 449: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

445: PROCEDURE Create_Estimation_Method
446: (
447: p_api_version IN NUMBER,
448: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
449: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
450: x_return_status OUT NOCOPY VARCHAR2,
451: x_msg_count OUT NOCOPY NUMBER,
452: x_msg_data OUT NOCOPY VARCHAR2,
453: p_ctr_estimation_rec IN CS_COUNTERS_PUB.Ctr_Estimation_Rec_Type,

Line 461: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

457:
458: PROCEDURE Update_Estimation_Method
459: (
460: p_api_version IN NUMBER,
461: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
462: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
463: x_return_status OUT NOCOPY VARCHAR2,
464: x_msg_count OUT NOCOPY NUMBER,
465: x_msg_data OUT NOCOPY VARCHAR2,

Line 462: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

458: PROCEDURE Update_Estimation_Method
459: (
460: p_api_version IN NUMBER,
461: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
462: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
463: x_return_status OUT NOCOPY VARCHAR2,
464: x_msg_count OUT NOCOPY NUMBER,
465: x_msg_data OUT NOCOPY VARCHAR2,
466: p_estimation_id IN NUMBER,