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.GMF_COPY_ITEM_COST dependencies on CM_CMPT_DTL

Line 30: pi_organization_id_from IN cm_cmpt_dtl.organization_id%TYPE,

26: pi_errmsg IN VARCHAR2
27: );
28:
29: PROCEDURE copy_cost_dtl(
30: pi_organization_id_from IN cm_cmpt_dtl.organization_id%TYPE,
31: pi_calendar_code_from IN cm_cmpt_dtl.calendar_code%TYPE,
32: pi_period_code_from IN cm_cmpt_dtl.period_code%TYPE,
33: pi_cost_type_id_from IN cm_cmpt_dtl.cost_type_id%TYPE,
34: pi_organization_id_to IN cm_cmpt_dtl.organization_id%TYPE,

Line 31: pi_calendar_code_from IN cm_cmpt_dtl.calendar_code%TYPE,

27: );
28:
29: PROCEDURE copy_cost_dtl(
30: pi_organization_id_from IN cm_cmpt_dtl.organization_id%TYPE,
31: pi_calendar_code_from IN cm_cmpt_dtl.calendar_code%TYPE,
32: pi_period_code_from IN cm_cmpt_dtl.period_code%TYPE,
33: pi_cost_type_id_from IN cm_cmpt_dtl.cost_type_id%TYPE,
34: pi_organization_id_to IN cm_cmpt_dtl.organization_id%TYPE,
35: pi_calendar_code_to IN cm_cmpt_dtl.calendar_code%TYPE,

Line 32: pi_period_code_from IN cm_cmpt_dtl.period_code%TYPE,

28:
29: PROCEDURE copy_cost_dtl(
30: pi_organization_id_from IN cm_cmpt_dtl.organization_id%TYPE,
31: pi_calendar_code_from IN cm_cmpt_dtl.calendar_code%TYPE,
32: pi_period_code_from IN cm_cmpt_dtl.period_code%TYPE,
33: pi_cost_type_id_from IN cm_cmpt_dtl.cost_type_id%TYPE,
34: pi_organization_id_to IN cm_cmpt_dtl.organization_id%TYPE,
35: pi_calendar_code_to IN cm_cmpt_dtl.calendar_code%TYPE,
36: pi_period_code_to IN cm_cmpt_dtl.period_code%TYPE,

Line 33: pi_cost_type_id_from IN cm_cmpt_dtl.cost_type_id%TYPE,

29: PROCEDURE copy_cost_dtl(
30: pi_organization_id_from IN cm_cmpt_dtl.organization_id%TYPE,
31: pi_calendar_code_from IN cm_cmpt_dtl.calendar_code%TYPE,
32: pi_period_code_from IN cm_cmpt_dtl.period_code%TYPE,
33: pi_cost_type_id_from IN cm_cmpt_dtl.cost_type_id%TYPE,
34: pi_organization_id_to IN cm_cmpt_dtl.organization_id%TYPE,
35: pi_calendar_code_to IN cm_cmpt_dtl.calendar_code%TYPE,
36: pi_period_code_to IN cm_cmpt_dtl.period_code%TYPE,
37: pi_cost_type_id_to IN cm_cmpt_dtl.cost_type_id%TYPE,

Line 34: pi_organization_id_to IN cm_cmpt_dtl.organization_id%TYPE,

30: pi_organization_id_from IN cm_cmpt_dtl.organization_id%TYPE,
31: pi_calendar_code_from IN cm_cmpt_dtl.calendar_code%TYPE,
32: pi_period_code_from IN cm_cmpt_dtl.period_code%TYPE,
33: pi_cost_type_id_from IN cm_cmpt_dtl.cost_type_id%TYPE,
34: pi_organization_id_to IN cm_cmpt_dtl.organization_id%TYPE,
35: pi_calendar_code_to IN cm_cmpt_dtl.calendar_code%TYPE,
36: pi_period_code_to IN cm_cmpt_dtl.period_code%TYPE,
37: pi_cost_type_id_to IN cm_cmpt_dtl.cost_type_id%TYPE,
38: pi_range_type IN NUMBER,

Line 35: pi_calendar_code_to IN cm_cmpt_dtl.calendar_code%TYPE,

31: pi_calendar_code_from IN cm_cmpt_dtl.calendar_code%TYPE,
32: pi_period_code_from IN cm_cmpt_dtl.period_code%TYPE,
33: pi_cost_type_id_from IN cm_cmpt_dtl.cost_type_id%TYPE,
34: pi_organization_id_to IN cm_cmpt_dtl.organization_id%TYPE,
35: pi_calendar_code_to IN cm_cmpt_dtl.calendar_code%TYPE,
36: pi_period_code_to IN cm_cmpt_dtl.period_code%TYPE,
37: pi_cost_type_id_to IN cm_cmpt_dtl.cost_type_id%TYPE,
38: pi_range_type IN NUMBER,
39: pi_from_range IN VARCHAR2,

Line 36: pi_period_code_to IN cm_cmpt_dtl.period_code%TYPE,

32: pi_period_code_from IN cm_cmpt_dtl.period_code%TYPE,
33: pi_cost_type_id_from IN cm_cmpt_dtl.cost_type_id%TYPE,
34: pi_organization_id_to IN cm_cmpt_dtl.organization_id%TYPE,
35: pi_calendar_code_to IN cm_cmpt_dtl.calendar_code%TYPE,
36: pi_period_code_to IN cm_cmpt_dtl.period_code%TYPE,
37: pi_cost_type_id_to IN cm_cmpt_dtl.cost_type_id%TYPE,
38: pi_range_type IN NUMBER,
39: pi_from_range IN VARCHAR2,
40: pi_to_range IN VARCHAR2,

Line 37: pi_cost_type_id_to IN cm_cmpt_dtl.cost_type_id%TYPE,

33: pi_cost_type_id_from IN cm_cmpt_dtl.cost_type_id%TYPE,
34: pi_organization_id_to IN cm_cmpt_dtl.organization_id%TYPE,
35: pi_calendar_code_to IN cm_cmpt_dtl.calendar_code%TYPE,
36: pi_period_code_to IN cm_cmpt_dtl.period_code%TYPE,
37: pi_cost_type_id_to IN cm_cmpt_dtl.cost_type_id%TYPE,
38: pi_range_type IN NUMBER,
39: pi_from_range IN VARCHAR2,
40: pi_to_range IN VARCHAR2,
41: pi_incr_pct IN NUMBER,

Line 44: pi_all_periods_from IN cm_cmpt_dtl.period_code%TYPE,

40: pi_to_range IN VARCHAR2,
41: pi_incr_pct IN NUMBER,
42: pi_incr_decr_cost IN NUMBER,
43: pi_rem_repl IN NUMBER,
44: pi_all_periods_from IN cm_cmpt_dtl.period_code%TYPE,
45: pi_all_periods_to IN cm_cmpt_dtl.period_code%TYPE,
46: pi_all_org_id IN gmf_legal_entities.legal_entity_id%TYPE,
47: pi_copy_to_upper_lvl IN NUMBER
48: );

Line 45: pi_all_periods_to IN cm_cmpt_dtl.period_code%TYPE,

41: pi_incr_pct IN NUMBER,
42: pi_incr_decr_cost IN NUMBER,
43: pi_rem_repl IN NUMBER,
44: pi_all_periods_from IN cm_cmpt_dtl.period_code%TYPE,
45: pi_all_periods_to IN cm_cmpt_dtl.period_code%TYPE,
46: pi_all_org_id IN gmf_legal_entities.legal_entity_id%TYPE,
47: pi_copy_to_upper_lvl IN NUMBER
48: );
49:

Line 54: pi_organization_id_from IN cm_cmpt_dtl.organization_id%TYPE,

50:
51:
52:
53: PROCEDURE copy_burden_dtl(
54: pi_organization_id_from IN cm_cmpt_dtl.organization_id%TYPE,
55: pi_calendar_code_from IN cm_cmpt_dtl.calendar_code%TYPE,
56: pi_period_code_from IN cm_cmpt_dtl.period_code%TYPE,
57: pi_cost_type_id_from IN cm_cmpt_dtl.cost_type_id%TYPE,
58: pi_organization_id_to IN cm_cmpt_dtl.organization_id%TYPE,

Line 55: pi_calendar_code_from IN cm_cmpt_dtl.calendar_code%TYPE,

51:
52:
53: PROCEDURE copy_burden_dtl(
54: pi_organization_id_from IN cm_cmpt_dtl.organization_id%TYPE,
55: pi_calendar_code_from IN cm_cmpt_dtl.calendar_code%TYPE,
56: pi_period_code_from IN cm_cmpt_dtl.period_code%TYPE,
57: pi_cost_type_id_from IN cm_cmpt_dtl.cost_type_id%TYPE,
58: pi_organization_id_to IN cm_cmpt_dtl.organization_id%TYPE,
59: pi_calendar_code_to IN cm_cmpt_dtl.calendar_code%TYPE,

Line 56: pi_period_code_from IN cm_cmpt_dtl.period_code%TYPE,

52:
53: PROCEDURE copy_burden_dtl(
54: pi_organization_id_from IN cm_cmpt_dtl.organization_id%TYPE,
55: pi_calendar_code_from IN cm_cmpt_dtl.calendar_code%TYPE,
56: pi_period_code_from IN cm_cmpt_dtl.period_code%TYPE,
57: pi_cost_type_id_from IN cm_cmpt_dtl.cost_type_id%TYPE,
58: pi_organization_id_to IN cm_cmpt_dtl.organization_id%TYPE,
59: pi_calendar_code_to IN cm_cmpt_dtl.calendar_code%TYPE,
60: pi_period_code_to IN cm_cmpt_dtl.period_code%TYPE,

Line 57: pi_cost_type_id_from IN cm_cmpt_dtl.cost_type_id%TYPE,

53: PROCEDURE copy_burden_dtl(
54: pi_organization_id_from IN cm_cmpt_dtl.organization_id%TYPE,
55: pi_calendar_code_from IN cm_cmpt_dtl.calendar_code%TYPE,
56: pi_period_code_from IN cm_cmpt_dtl.period_code%TYPE,
57: pi_cost_type_id_from IN cm_cmpt_dtl.cost_type_id%TYPE,
58: pi_organization_id_to IN cm_cmpt_dtl.organization_id%TYPE,
59: pi_calendar_code_to IN cm_cmpt_dtl.calendar_code%TYPE,
60: pi_period_code_to IN cm_cmpt_dtl.period_code%TYPE,
61: pi_cost_type_id_to IN cm_cmpt_dtl.cost_type_id%TYPE,

Line 58: pi_organization_id_to IN cm_cmpt_dtl.organization_id%TYPE,

54: pi_organization_id_from IN cm_cmpt_dtl.organization_id%TYPE,
55: pi_calendar_code_from IN cm_cmpt_dtl.calendar_code%TYPE,
56: pi_period_code_from IN cm_cmpt_dtl.period_code%TYPE,
57: pi_cost_type_id_from IN cm_cmpt_dtl.cost_type_id%TYPE,
58: pi_organization_id_to IN cm_cmpt_dtl.organization_id%TYPE,
59: pi_calendar_code_to IN cm_cmpt_dtl.calendar_code%TYPE,
60: pi_period_code_to IN cm_cmpt_dtl.period_code%TYPE,
61: pi_cost_type_id_to IN cm_cmpt_dtl.cost_type_id%TYPE,
62: pi_range_type IN NUMBER,

Line 59: pi_calendar_code_to IN cm_cmpt_dtl.calendar_code%TYPE,

55: pi_calendar_code_from IN cm_cmpt_dtl.calendar_code%TYPE,
56: pi_period_code_from IN cm_cmpt_dtl.period_code%TYPE,
57: pi_cost_type_id_from IN cm_cmpt_dtl.cost_type_id%TYPE,
58: pi_organization_id_to IN cm_cmpt_dtl.organization_id%TYPE,
59: pi_calendar_code_to IN cm_cmpt_dtl.calendar_code%TYPE,
60: pi_period_code_to IN cm_cmpt_dtl.period_code%TYPE,
61: pi_cost_type_id_to IN cm_cmpt_dtl.cost_type_id%TYPE,
62: pi_range_type IN NUMBER,
63: pi_from_range IN VARCHAR2,

Line 60: pi_period_code_to IN cm_cmpt_dtl.period_code%TYPE,

56: pi_period_code_from IN cm_cmpt_dtl.period_code%TYPE,
57: pi_cost_type_id_from IN cm_cmpt_dtl.cost_type_id%TYPE,
58: pi_organization_id_to IN cm_cmpt_dtl.organization_id%TYPE,
59: pi_calendar_code_to IN cm_cmpt_dtl.calendar_code%TYPE,
60: pi_period_code_to IN cm_cmpt_dtl.period_code%TYPE,
61: pi_cost_type_id_to IN cm_cmpt_dtl.cost_type_id%TYPE,
62: pi_range_type IN NUMBER,
63: pi_from_range IN VARCHAR2,
64: pi_to_range IN VARCHAR2,

Line 61: pi_cost_type_id_to IN cm_cmpt_dtl.cost_type_id%TYPE,

57: pi_cost_type_id_from IN cm_cmpt_dtl.cost_type_id%TYPE,
58: pi_organization_id_to IN cm_cmpt_dtl.organization_id%TYPE,
59: pi_calendar_code_to IN cm_cmpt_dtl.calendar_code%TYPE,
60: pi_period_code_to IN cm_cmpt_dtl.period_code%TYPE,
61: pi_cost_type_id_to IN cm_cmpt_dtl.cost_type_id%TYPE,
62: pi_range_type IN NUMBER,
63: pi_from_range IN VARCHAR2,
64: pi_to_range IN VARCHAR2,
65: pi_rem_repl IN NUMBER,

Line 66: pi_all_periods_from IN cm_cmpt_dtl.period_code%TYPE,

62: pi_range_type IN NUMBER,
63: pi_from_range IN VARCHAR2,
64: pi_to_range IN VARCHAR2,
65: pi_rem_repl IN NUMBER,
66: pi_all_periods_from IN cm_cmpt_dtl.period_code%TYPE,
67: pi_all_periods_to IN cm_cmpt_dtl.period_code%TYPE,
68: pi_all_org_id IN gmf_legal_entities.legal_entity_id%TYPE
69: );
70:

Line 67: pi_all_periods_to IN cm_cmpt_dtl.period_code%TYPE,

63: pi_from_range IN VARCHAR2,
64: pi_to_range IN VARCHAR2,
65: pi_rem_repl IN NUMBER,
66: pi_all_periods_from IN cm_cmpt_dtl.period_code%TYPE,
67: pi_all_periods_to IN cm_cmpt_dtl.period_code%TYPE,
68: pi_all_org_id IN gmf_legal_entities.legal_entity_id%TYPE
69: );
70:
71:

Line 75: pi_inventory_item_id IN cm_cmpt_dtl.inventory_item_id%TYPE,

71:
72:
73:
74: PROCEDURE delete_item_costs(
75: pi_inventory_item_id IN cm_cmpt_dtl.inventory_item_id%TYPE,
76: pi_organization_id IN cm_cmpt_dtl.organization_id%TYPE,
77: pi_calendar_code IN cm_cmpt_dtl.calendar_code%TYPE,
78: pi_period_id IN cm_cmpt_dtl.period_id%TYPE,
79: pi_cost_type_id IN cm_cmpt_dtl.cost_type_id%TYPE

Line 76: pi_organization_id IN cm_cmpt_dtl.organization_id%TYPE,

72:
73:
74: PROCEDURE delete_item_costs(
75: pi_inventory_item_id IN cm_cmpt_dtl.inventory_item_id%TYPE,
76: pi_organization_id IN cm_cmpt_dtl.organization_id%TYPE,
77: pi_calendar_code IN cm_cmpt_dtl.calendar_code%TYPE,
78: pi_period_id IN cm_cmpt_dtl.period_id%TYPE,
79: pi_cost_type_id IN cm_cmpt_dtl.cost_type_id%TYPE
80: );

Line 77: pi_calendar_code IN cm_cmpt_dtl.calendar_code%TYPE,

73:
74: PROCEDURE delete_item_costs(
75: pi_inventory_item_id IN cm_cmpt_dtl.inventory_item_id%TYPE,
76: pi_organization_id IN cm_cmpt_dtl.organization_id%TYPE,
77: pi_calendar_code IN cm_cmpt_dtl.calendar_code%TYPE,
78: pi_period_id IN cm_cmpt_dtl.period_id%TYPE,
79: pi_cost_type_id IN cm_cmpt_dtl.cost_type_id%TYPE
80: );
81:

Line 78: pi_period_id IN cm_cmpt_dtl.period_id%TYPE,

74: PROCEDURE delete_item_costs(
75: pi_inventory_item_id IN cm_cmpt_dtl.inventory_item_id%TYPE,
76: pi_organization_id IN cm_cmpt_dtl.organization_id%TYPE,
77: pi_calendar_code IN cm_cmpt_dtl.calendar_code%TYPE,
78: pi_period_id IN cm_cmpt_dtl.period_id%TYPE,
79: pi_cost_type_id IN cm_cmpt_dtl.cost_type_id%TYPE
80: );
81:
82:

Line 79: pi_cost_type_id IN cm_cmpt_dtl.cost_type_id%TYPE

75: pi_inventory_item_id IN cm_cmpt_dtl.inventory_item_id%TYPE,
76: pi_organization_id IN cm_cmpt_dtl.organization_id%TYPE,
77: pi_calendar_code IN cm_cmpt_dtl.calendar_code%TYPE,
78: pi_period_id IN cm_cmpt_dtl.period_id%TYPE,
79: pi_cost_type_id IN cm_cmpt_dtl.cost_type_id%TYPE
80: );
81:
82:
83: FUNCTION verify_frozen_costs(

Line 84: pi_inventory_item_id IN cm_cmpt_dtl.inventory_item_id%TYPE,

80: );
81:
82:
83: FUNCTION verify_frozen_costs(
84: pi_inventory_item_id IN cm_cmpt_dtl.inventory_item_id%TYPE,
85: pi_organization_id IN cm_cmpt_dtl.organization_id%TYPE,
86: pi_calendar_code IN cm_cmpt_dtl.calendar_code%TYPE,
87: pi_period_id IN cm_cmpt_dtl.period_id%TYPE,
88: pi_cost_type_id IN cm_cmpt_dtl.cost_type_id%TYPE

Line 85: pi_organization_id IN cm_cmpt_dtl.organization_id%TYPE,

81:
82:
83: FUNCTION verify_frozen_costs(
84: pi_inventory_item_id IN cm_cmpt_dtl.inventory_item_id%TYPE,
85: pi_organization_id IN cm_cmpt_dtl.organization_id%TYPE,
86: pi_calendar_code IN cm_cmpt_dtl.calendar_code%TYPE,
87: pi_period_id IN cm_cmpt_dtl.period_id%TYPE,
88: pi_cost_type_id IN cm_cmpt_dtl.cost_type_id%TYPE
89: )

Line 86: pi_calendar_code IN cm_cmpt_dtl.calendar_code%TYPE,

82:
83: FUNCTION verify_frozen_costs(
84: pi_inventory_item_id IN cm_cmpt_dtl.inventory_item_id%TYPE,
85: pi_organization_id IN cm_cmpt_dtl.organization_id%TYPE,
86: pi_calendar_code IN cm_cmpt_dtl.calendar_code%TYPE,
87: pi_period_id IN cm_cmpt_dtl.period_id%TYPE,
88: pi_cost_type_id IN cm_cmpt_dtl.cost_type_id%TYPE
89: )
90: RETURN NUMBER;

Line 87: pi_period_id IN cm_cmpt_dtl.period_id%TYPE,

83: FUNCTION verify_frozen_costs(
84: pi_inventory_item_id IN cm_cmpt_dtl.inventory_item_id%TYPE,
85: pi_organization_id IN cm_cmpt_dtl.organization_id%TYPE,
86: pi_calendar_code IN cm_cmpt_dtl.calendar_code%TYPE,
87: pi_period_id IN cm_cmpt_dtl.period_id%TYPE,
88: pi_cost_type_id IN cm_cmpt_dtl.cost_type_id%TYPE
89: )
90: RETURN NUMBER;
91:

Line 88: pi_cost_type_id IN cm_cmpt_dtl.cost_type_id%TYPE

84: pi_inventory_item_id IN cm_cmpt_dtl.inventory_item_id%TYPE,
85: pi_organization_id IN cm_cmpt_dtl.organization_id%TYPE,
86: pi_calendar_code IN cm_cmpt_dtl.calendar_code%TYPE,
87: pi_period_id IN cm_cmpt_dtl.period_id%TYPE,
88: pi_cost_type_id IN cm_cmpt_dtl.cost_type_id%TYPE
89: )
90: RETURN NUMBER;
91:
92: -- added this procedure as part of bug 5567102

Line 98: FUNCTION check_rec_infrozen_period(p_organization_id cm_cmpt_dtl.organization_id%TYPE,

94: p_period_code OUT NOCOPY gmf_period_statuses.period_code%TYPE,
95: p_period_status OUT NOCOPY gmf_period_statuses.period_status%TYPE );
96:
97: -- Added to check record exists in a frozen period, bug 5672543
98: FUNCTION check_rec_infrozen_period(p_organization_id cm_cmpt_dtl.organization_id%TYPE,
99: p_inventory_item_id cm_cmpt_dtl.inventory_item_id%TYPE,
100: p_period_id cm_cmpt_dtl.period_id%TYPE,
101: p_cost_type_id cm_cmpt_dtl.cost_type_id%TYPE)
102: RETURN BOOLEAN ;

Line 99: p_inventory_item_id cm_cmpt_dtl.inventory_item_id%TYPE,

95: p_period_status OUT NOCOPY gmf_period_statuses.period_status%TYPE );
96:
97: -- Added to check record exists in a frozen period, bug 5672543
98: FUNCTION check_rec_infrozen_period(p_organization_id cm_cmpt_dtl.organization_id%TYPE,
99: p_inventory_item_id cm_cmpt_dtl.inventory_item_id%TYPE,
100: p_period_id cm_cmpt_dtl.period_id%TYPE,
101: p_cost_type_id cm_cmpt_dtl.cost_type_id%TYPE)
102: RETURN BOOLEAN ;
103: FUNCTION verify_item_assigned_to_org(

Line 100: p_period_id cm_cmpt_dtl.period_id%TYPE,

96:
97: -- Added to check record exists in a frozen period, bug 5672543
98: FUNCTION check_rec_infrozen_period(p_organization_id cm_cmpt_dtl.organization_id%TYPE,
99: p_inventory_item_id cm_cmpt_dtl.inventory_item_id%TYPE,
100: p_period_id cm_cmpt_dtl.period_id%TYPE,
101: p_cost_type_id cm_cmpt_dtl.cost_type_id%TYPE)
102: RETURN BOOLEAN ;
103: FUNCTION verify_item_assigned_to_org(
104: pi_inventory_item_id IN cm_cmpt_dtl.inventory_item_id%TYPE,

Line 101: p_cost_type_id cm_cmpt_dtl.cost_type_id%TYPE)

97: -- Added to check record exists in a frozen period, bug 5672543
98: FUNCTION check_rec_infrozen_period(p_organization_id cm_cmpt_dtl.organization_id%TYPE,
99: p_inventory_item_id cm_cmpt_dtl.inventory_item_id%TYPE,
100: p_period_id cm_cmpt_dtl.period_id%TYPE,
101: p_cost_type_id cm_cmpt_dtl.cost_type_id%TYPE)
102: RETURN BOOLEAN ;
103: FUNCTION verify_item_assigned_to_org(
104: pi_inventory_item_id IN cm_cmpt_dtl.inventory_item_id%TYPE,
105: pi_organization_id IN cm_cmpt_dtl.organization_id%TYPE

Line 104: pi_inventory_item_id IN cm_cmpt_dtl.inventory_item_id%TYPE,

100: p_period_id cm_cmpt_dtl.period_id%TYPE,
101: p_cost_type_id cm_cmpt_dtl.cost_type_id%TYPE)
102: RETURN BOOLEAN ;
103: FUNCTION verify_item_assigned_to_org(
104: pi_inventory_item_id IN cm_cmpt_dtl.inventory_item_id%TYPE,
105: pi_organization_id IN cm_cmpt_dtl.organization_id%TYPE
106: )
107: RETURN NUMBER;
108:

Line 105: pi_organization_id IN cm_cmpt_dtl.organization_id%TYPE

101: p_cost_type_id cm_cmpt_dtl.cost_type_id%TYPE)
102: RETURN BOOLEAN ;
103: FUNCTION verify_item_assigned_to_org(
104: pi_inventory_item_id IN cm_cmpt_dtl.inventory_item_id%TYPE,
105: pi_organization_id IN cm_cmpt_dtl.organization_id%TYPE
106: )
107: RETURN NUMBER;
108:
109: PROCEDURE delete_burden_costs(

Line 110: pi_organization_id IN cm_cmpt_dtl.organization_id%TYPE,

106: )
107: RETURN NUMBER;
108:
109: PROCEDURE delete_burden_costs(
110: pi_organization_id IN cm_cmpt_dtl.organization_id%TYPE,
111: pi_period_id IN cm_cmpt_dtl.period_id%TYPE,
112: pi_cost_type_id IN cm_cmpt_dtl.cost_type_id%TYPE,
113: pi_range_type IN NUMBER,
114: pi_from_range IN VARCHAR2,

Line 111: pi_period_id IN cm_cmpt_dtl.period_id%TYPE,

107: RETURN NUMBER;
108:
109: PROCEDURE delete_burden_costs(
110: pi_organization_id IN cm_cmpt_dtl.organization_id%TYPE,
111: pi_period_id IN cm_cmpt_dtl.period_id%TYPE,
112: pi_cost_type_id IN cm_cmpt_dtl.cost_type_id%TYPE,
113: pi_range_type IN NUMBER,
114: pi_from_range IN VARCHAR2,
115: pi_to_range IN VARCHAR2

Line 112: pi_cost_type_id IN cm_cmpt_dtl.cost_type_id%TYPE,

108:
109: PROCEDURE delete_burden_costs(
110: pi_organization_id IN cm_cmpt_dtl.organization_id%TYPE,
111: pi_period_id IN cm_cmpt_dtl.period_id%TYPE,
112: pi_cost_type_id IN cm_cmpt_dtl.cost_type_id%TYPE,
113: pi_range_type IN NUMBER,
114: pi_from_range IN VARCHAR2,
115: pi_to_range IN VARCHAR2
116: );

Line 163: pi_organization_id_from IN cm_cmpt_dtl.organization_id%TYPE,

159: PROCEDURE copy_item_cost
160: (
161: po_errbuf OUT NOCOPY VARCHAR2,
162: po_retcode OUT NOCOPY VARCHAR2,
163: pi_organization_id_from IN cm_cmpt_dtl.organization_id%TYPE,
164: pi_calendar_code_from IN cm_cmpt_dtl.calendar_code%TYPE,
165: pi_period_code_from IN cm_cmpt_dtl.period_code%TYPE,
166: pi_cost_type_id_from IN cm_cmpt_dtl.cost_type_id%TYPE,
167: pi_organization_id_to IN cm_cmpt_dtl.organization_id%TYPE,

Line 164: pi_calendar_code_from IN cm_cmpt_dtl.calendar_code%TYPE,

160: (
161: po_errbuf OUT NOCOPY VARCHAR2,
162: po_retcode OUT NOCOPY VARCHAR2,
163: pi_organization_id_from IN cm_cmpt_dtl.organization_id%TYPE,
164: pi_calendar_code_from IN cm_cmpt_dtl.calendar_code%TYPE,
165: pi_period_code_from IN cm_cmpt_dtl.period_code%TYPE,
166: pi_cost_type_id_from IN cm_cmpt_dtl.cost_type_id%TYPE,
167: pi_organization_id_to IN cm_cmpt_dtl.organization_id%TYPE,
168: pi_calendar_code_to IN cm_cmpt_dtl.calendar_code%TYPE,

Line 165: pi_period_code_from IN cm_cmpt_dtl.period_code%TYPE,

161: po_errbuf OUT NOCOPY VARCHAR2,
162: po_retcode OUT NOCOPY VARCHAR2,
163: pi_organization_id_from IN cm_cmpt_dtl.organization_id%TYPE,
164: pi_calendar_code_from IN cm_cmpt_dtl.calendar_code%TYPE,
165: pi_period_code_from IN cm_cmpt_dtl.period_code%TYPE,
166: pi_cost_type_id_from IN cm_cmpt_dtl.cost_type_id%TYPE,
167: pi_organization_id_to IN cm_cmpt_dtl.organization_id%TYPE,
168: pi_calendar_code_to IN cm_cmpt_dtl.calendar_code%TYPE,
169: pi_period_code_to IN cm_cmpt_dtl.period_code%TYPE,

Line 166: pi_cost_type_id_from IN cm_cmpt_dtl.cost_type_id%TYPE,

162: po_retcode OUT NOCOPY VARCHAR2,
163: pi_organization_id_from IN cm_cmpt_dtl.organization_id%TYPE,
164: pi_calendar_code_from IN cm_cmpt_dtl.calendar_code%TYPE,
165: pi_period_code_from IN cm_cmpt_dtl.period_code%TYPE,
166: pi_cost_type_id_from IN cm_cmpt_dtl.cost_type_id%TYPE,
167: pi_organization_id_to IN cm_cmpt_dtl.organization_id%TYPE,
168: pi_calendar_code_to IN cm_cmpt_dtl.calendar_code%TYPE,
169: pi_period_code_to IN cm_cmpt_dtl.period_code%TYPE,
170: pi_cost_type_id_to IN cm_cmpt_dtl.cost_type_id%TYPE,

Line 167: pi_organization_id_to IN cm_cmpt_dtl.organization_id%TYPE,

163: pi_organization_id_from IN cm_cmpt_dtl.organization_id%TYPE,
164: pi_calendar_code_from IN cm_cmpt_dtl.calendar_code%TYPE,
165: pi_period_code_from IN cm_cmpt_dtl.period_code%TYPE,
166: pi_cost_type_id_from IN cm_cmpt_dtl.cost_type_id%TYPE,
167: pi_organization_id_to IN cm_cmpt_dtl.organization_id%TYPE,
168: pi_calendar_code_to IN cm_cmpt_dtl.calendar_code%TYPE,
169: pi_period_code_to IN cm_cmpt_dtl.period_code%TYPE,
170: pi_cost_type_id_to IN cm_cmpt_dtl.cost_type_id%TYPE,
171: pi_item_from IN mtl_system_items_b_kfv.concatenated_segments%TYPE,

Line 168: pi_calendar_code_to IN cm_cmpt_dtl.calendar_code%TYPE,

164: pi_calendar_code_from IN cm_cmpt_dtl.calendar_code%TYPE,
165: pi_period_code_from IN cm_cmpt_dtl.period_code%TYPE,
166: pi_cost_type_id_from IN cm_cmpt_dtl.cost_type_id%TYPE,
167: pi_organization_id_to IN cm_cmpt_dtl.organization_id%TYPE,
168: pi_calendar_code_to IN cm_cmpt_dtl.calendar_code%TYPE,
169: pi_period_code_to IN cm_cmpt_dtl.period_code%TYPE,
170: pi_cost_type_id_to IN cm_cmpt_dtl.cost_type_id%TYPE,
171: pi_item_from IN mtl_system_items_b_kfv.concatenated_segments%TYPE,
172: pi_item_to IN mtl_system_items_b_kfv.concatenated_segments%TYPE,

Line 169: pi_period_code_to IN cm_cmpt_dtl.period_code%TYPE,

165: pi_period_code_from IN cm_cmpt_dtl.period_code%TYPE,
166: pi_cost_type_id_from IN cm_cmpt_dtl.cost_type_id%TYPE,
167: pi_organization_id_to IN cm_cmpt_dtl.organization_id%TYPE,
168: pi_calendar_code_to IN cm_cmpt_dtl.calendar_code%TYPE,
169: pi_period_code_to IN cm_cmpt_dtl.period_code%TYPE,
170: pi_cost_type_id_to IN cm_cmpt_dtl.cost_type_id%TYPE,
171: pi_item_from IN mtl_system_items_b_kfv.concatenated_segments%TYPE,
172: pi_item_to IN mtl_system_items_b_kfv.concatenated_segments%TYPE,
173: pi_itemcc_from IN mtl_categories_b_kfv.concatenated_segments%TYPE,

Line 170: pi_cost_type_id_to IN cm_cmpt_dtl.cost_type_id%TYPE,

166: pi_cost_type_id_from IN cm_cmpt_dtl.cost_type_id%TYPE,
167: pi_organization_id_to IN cm_cmpt_dtl.organization_id%TYPE,
168: pi_calendar_code_to IN cm_cmpt_dtl.calendar_code%TYPE,
169: pi_period_code_to IN cm_cmpt_dtl.period_code%TYPE,
170: pi_cost_type_id_to IN cm_cmpt_dtl.cost_type_id%TYPE,
171: pi_item_from IN mtl_system_items_b_kfv.concatenated_segments%TYPE,
172: pi_item_to IN mtl_system_items_b_kfv.concatenated_segments%TYPE,
173: pi_itemcc_from IN mtl_categories_b_kfv.concatenated_segments%TYPE,
174: pi_itemcc_to IN mtl_categories_b_kfv.concatenated_segments%TYPE,

Line 178: pi_all_periods_from IN cm_cmpt_dtl.period_code%TYPE,

174: pi_itemcc_to IN mtl_categories_b_kfv.concatenated_segments%TYPE,
175: pi_incr_pct IN VARCHAR2,
176: pi_incr_decr_cost IN VARCHAR2,
177: pi_rem_repl IN VARCHAR2,
178: pi_all_periods_from IN cm_cmpt_dtl.period_code%TYPE,
179: pi_all_periods_to IN cm_cmpt_dtl.period_code%TYPE,
180: pi_all_org_id IN gmf_legal_entities.legal_entity_id%TYPE,
181: pi_copy_to_upper_lvl IN VARCHAR2
182: )

Line 179: pi_all_periods_to IN cm_cmpt_dtl.period_code%TYPE,

175: pi_incr_pct IN VARCHAR2,
176: pi_incr_decr_cost IN VARCHAR2,
177: pi_rem_repl IN VARCHAR2,
178: pi_all_periods_from IN cm_cmpt_dtl.period_code%TYPE,
179: pi_all_periods_to IN cm_cmpt_dtl.period_code%TYPE,
180: pi_all_org_id IN gmf_legal_entities.legal_entity_id%TYPE,
181: pi_copy_to_upper_lvl IN VARCHAR2
182: )
183: IS

Line 419: pi_organization_id_from IN cm_cmpt_dtl.organization_id%TYPE,

415: * But New costs can be added though,
416: ******************************************************************************/
417:
418: PROCEDURE copy_cost_dtl(
419: pi_organization_id_from IN cm_cmpt_dtl.organization_id%TYPE,
420: pi_calendar_code_from IN cm_cmpt_dtl.calendar_code%TYPE,
421: pi_period_code_from IN cm_cmpt_dtl.period_code%TYPE,
422: pi_cost_type_id_from IN cm_cmpt_dtl.cost_type_id%TYPE,
423: pi_organization_id_to IN cm_cmpt_dtl.organization_id%TYPE,

Line 420: pi_calendar_code_from IN cm_cmpt_dtl.calendar_code%TYPE,

416: ******************************************************************************/
417:
418: PROCEDURE copy_cost_dtl(
419: pi_organization_id_from IN cm_cmpt_dtl.organization_id%TYPE,
420: pi_calendar_code_from IN cm_cmpt_dtl.calendar_code%TYPE,
421: pi_period_code_from IN cm_cmpt_dtl.period_code%TYPE,
422: pi_cost_type_id_from IN cm_cmpt_dtl.cost_type_id%TYPE,
423: pi_organization_id_to IN cm_cmpt_dtl.organization_id%TYPE,
424: pi_calendar_code_to IN cm_cmpt_dtl.calendar_code%TYPE,

Line 421: pi_period_code_from IN cm_cmpt_dtl.period_code%TYPE,

417:
418: PROCEDURE copy_cost_dtl(
419: pi_organization_id_from IN cm_cmpt_dtl.organization_id%TYPE,
420: pi_calendar_code_from IN cm_cmpt_dtl.calendar_code%TYPE,
421: pi_period_code_from IN cm_cmpt_dtl.period_code%TYPE,
422: pi_cost_type_id_from IN cm_cmpt_dtl.cost_type_id%TYPE,
423: pi_organization_id_to IN cm_cmpt_dtl.organization_id%TYPE,
424: pi_calendar_code_to IN cm_cmpt_dtl.calendar_code%TYPE,
425: pi_period_code_to IN cm_cmpt_dtl.period_code%TYPE,

Line 422: pi_cost_type_id_from IN cm_cmpt_dtl.cost_type_id%TYPE,

418: PROCEDURE copy_cost_dtl(
419: pi_organization_id_from IN cm_cmpt_dtl.organization_id%TYPE,
420: pi_calendar_code_from IN cm_cmpt_dtl.calendar_code%TYPE,
421: pi_period_code_from IN cm_cmpt_dtl.period_code%TYPE,
422: pi_cost_type_id_from IN cm_cmpt_dtl.cost_type_id%TYPE,
423: pi_organization_id_to IN cm_cmpt_dtl.organization_id%TYPE,
424: pi_calendar_code_to IN cm_cmpt_dtl.calendar_code%TYPE,
425: pi_period_code_to IN cm_cmpt_dtl.period_code%TYPE,
426: pi_cost_type_id_to IN cm_cmpt_dtl.cost_type_id%TYPE,

Line 423: pi_organization_id_to IN cm_cmpt_dtl.organization_id%TYPE,

419: pi_organization_id_from IN cm_cmpt_dtl.organization_id%TYPE,
420: pi_calendar_code_from IN cm_cmpt_dtl.calendar_code%TYPE,
421: pi_period_code_from IN cm_cmpt_dtl.period_code%TYPE,
422: pi_cost_type_id_from IN cm_cmpt_dtl.cost_type_id%TYPE,
423: pi_organization_id_to IN cm_cmpt_dtl.organization_id%TYPE,
424: pi_calendar_code_to IN cm_cmpt_dtl.calendar_code%TYPE,
425: pi_period_code_to IN cm_cmpt_dtl.period_code%TYPE,
426: pi_cost_type_id_to IN cm_cmpt_dtl.cost_type_id%TYPE,
427: pi_range_type IN NUMBER,

Line 424: pi_calendar_code_to IN cm_cmpt_dtl.calendar_code%TYPE,

420: pi_calendar_code_from IN cm_cmpt_dtl.calendar_code%TYPE,
421: pi_period_code_from IN cm_cmpt_dtl.period_code%TYPE,
422: pi_cost_type_id_from IN cm_cmpt_dtl.cost_type_id%TYPE,
423: pi_organization_id_to IN cm_cmpt_dtl.organization_id%TYPE,
424: pi_calendar_code_to IN cm_cmpt_dtl.calendar_code%TYPE,
425: pi_period_code_to IN cm_cmpt_dtl.period_code%TYPE,
426: pi_cost_type_id_to IN cm_cmpt_dtl.cost_type_id%TYPE,
427: pi_range_type IN NUMBER,
428: pi_from_range IN VARCHAR2,

Line 425: pi_period_code_to IN cm_cmpt_dtl.period_code%TYPE,

421: pi_period_code_from IN cm_cmpt_dtl.period_code%TYPE,
422: pi_cost_type_id_from IN cm_cmpt_dtl.cost_type_id%TYPE,
423: pi_organization_id_to IN cm_cmpt_dtl.organization_id%TYPE,
424: pi_calendar_code_to IN cm_cmpt_dtl.calendar_code%TYPE,
425: pi_period_code_to IN cm_cmpt_dtl.period_code%TYPE,
426: pi_cost_type_id_to IN cm_cmpt_dtl.cost_type_id%TYPE,
427: pi_range_type IN NUMBER,
428: pi_from_range IN VARCHAR2,
429: pi_to_range IN VARCHAR2,

Line 426: pi_cost_type_id_to IN cm_cmpt_dtl.cost_type_id%TYPE,

422: pi_cost_type_id_from IN cm_cmpt_dtl.cost_type_id%TYPE,
423: pi_organization_id_to IN cm_cmpt_dtl.organization_id%TYPE,
424: pi_calendar_code_to IN cm_cmpt_dtl.calendar_code%TYPE,
425: pi_period_code_to IN cm_cmpt_dtl.period_code%TYPE,
426: pi_cost_type_id_to IN cm_cmpt_dtl.cost_type_id%TYPE,
427: pi_range_type IN NUMBER,
428: pi_from_range IN VARCHAR2,
429: pi_to_range IN VARCHAR2,
430: pi_incr_pct IN NUMBER,

Line 433: pi_all_periods_from IN cm_cmpt_dtl.period_code%TYPE,

429: pi_to_range IN VARCHAR2,
430: pi_incr_pct IN NUMBER,
431: pi_incr_decr_cost IN NUMBER,
432: pi_rem_repl IN NUMBER,
433: pi_all_periods_from IN cm_cmpt_dtl.period_code%TYPE,
434: pi_all_periods_to IN cm_cmpt_dtl.period_code%TYPE,
435: pi_all_org_id IN gmf_legal_entities.legal_entity_id%TYPE,
436: pi_copy_to_upper_lvl IN NUMBER
437: )

Line 434: pi_all_periods_to IN cm_cmpt_dtl.period_code%TYPE,

430: pi_incr_pct IN NUMBER,
431: pi_incr_decr_cost IN NUMBER,
432: pi_rem_repl IN NUMBER,
433: pi_all_periods_from IN cm_cmpt_dtl.period_code%TYPE,
434: pi_all_periods_to IN cm_cmpt_dtl.period_code%TYPE,
435: pi_all_org_id IN gmf_legal_entities.legal_entity_id%TYPE,
436: pi_copy_to_upper_lvl IN NUMBER
437: )
438: IS

Line 441: cmpntcost_id cm_cmpt_dtl.cmpntcost_id%TYPE,

437: )
438: IS
439:
440: TYPE rectyp_cost_detail IS RECORD (
441: cmpntcost_id cm_cmpt_dtl.cmpntcost_id%TYPE,
442: inventory_item_id cm_cmpt_dtl.inventory_item_id%TYPE,
443: cost_cmpntcls_id cm_cmpt_dtl.cost_cmpntcls_id%TYPE,
444: cost_analysis_code cm_cmpt_dtl.cost_analysis_code%TYPE,
445: cost_level cm_cmpt_dtl.cost_level%TYPE,

Line 442: inventory_item_id cm_cmpt_dtl.inventory_item_id%TYPE,

438: IS
439:
440: TYPE rectyp_cost_detail IS RECORD (
441: cmpntcost_id cm_cmpt_dtl.cmpntcost_id%TYPE,
442: inventory_item_id cm_cmpt_dtl.inventory_item_id%TYPE,
443: cost_cmpntcls_id cm_cmpt_dtl.cost_cmpntcls_id%TYPE,
444: cost_analysis_code cm_cmpt_dtl.cost_analysis_code%TYPE,
445: cost_level cm_cmpt_dtl.cost_level%TYPE,
446: cmpnt_cost cm_cmpt_dtl.cmpnt_cost%TYPE,

Line 443: cost_cmpntcls_id cm_cmpt_dtl.cost_cmpntcls_id%TYPE,

439:
440: TYPE rectyp_cost_detail IS RECORD (
441: cmpntcost_id cm_cmpt_dtl.cmpntcost_id%TYPE,
442: inventory_item_id cm_cmpt_dtl.inventory_item_id%TYPE,
443: cost_cmpntcls_id cm_cmpt_dtl.cost_cmpntcls_id%TYPE,
444: cost_analysis_code cm_cmpt_dtl.cost_analysis_code%TYPE,
445: cost_level cm_cmpt_dtl.cost_level%TYPE,
446: cmpnt_cost cm_cmpt_dtl.cmpnt_cost%TYPE,
447: burden_ind cm_cmpt_dtl.burden_ind%TYPE,

Line 444: cost_analysis_code cm_cmpt_dtl.cost_analysis_code%TYPE,

440: TYPE rectyp_cost_detail IS RECORD (
441: cmpntcost_id cm_cmpt_dtl.cmpntcost_id%TYPE,
442: inventory_item_id cm_cmpt_dtl.inventory_item_id%TYPE,
443: cost_cmpntcls_id cm_cmpt_dtl.cost_cmpntcls_id%TYPE,
444: cost_analysis_code cm_cmpt_dtl.cost_analysis_code%TYPE,
445: cost_level cm_cmpt_dtl.cost_level%TYPE,
446: cmpnt_cost cm_cmpt_dtl.cmpnt_cost%TYPE,
447: burden_ind cm_cmpt_dtl.burden_ind%TYPE,
448: total_qty cm_cmpt_dtl.total_qty%TYPE,

Line 445: cost_level cm_cmpt_dtl.cost_level%TYPE,

441: cmpntcost_id cm_cmpt_dtl.cmpntcost_id%TYPE,
442: inventory_item_id cm_cmpt_dtl.inventory_item_id%TYPE,
443: cost_cmpntcls_id cm_cmpt_dtl.cost_cmpntcls_id%TYPE,
444: cost_analysis_code cm_cmpt_dtl.cost_analysis_code%TYPE,
445: cost_level cm_cmpt_dtl.cost_level%TYPE,
446: cmpnt_cost cm_cmpt_dtl.cmpnt_cost%TYPE,
447: burden_ind cm_cmpt_dtl.burden_ind%TYPE,
448: total_qty cm_cmpt_dtl.total_qty%TYPE,
449: rmcalc_type cm_cmpt_dtl.rmcalc_type%TYPE,

Line 446: cmpnt_cost cm_cmpt_dtl.cmpnt_cost%TYPE,

442: inventory_item_id cm_cmpt_dtl.inventory_item_id%TYPE,
443: cost_cmpntcls_id cm_cmpt_dtl.cost_cmpntcls_id%TYPE,
444: cost_analysis_code cm_cmpt_dtl.cost_analysis_code%TYPE,
445: cost_level cm_cmpt_dtl.cost_level%TYPE,
446: cmpnt_cost cm_cmpt_dtl.cmpnt_cost%TYPE,
447: burden_ind cm_cmpt_dtl.burden_ind%TYPE,
448: total_qty cm_cmpt_dtl.total_qty%TYPE,
449: rmcalc_type cm_cmpt_dtl.rmcalc_type%TYPE,
450: fmeff_id cm_cmpt_dtl.fmeff_id%TYPE,

Line 447: burden_ind cm_cmpt_dtl.burden_ind%TYPE,

443: cost_cmpntcls_id cm_cmpt_dtl.cost_cmpntcls_id%TYPE,
444: cost_analysis_code cm_cmpt_dtl.cost_analysis_code%TYPE,
445: cost_level cm_cmpt_dtl.cost_level%TYPE,
446: cmpnt_cost cm_cmpt_dtl.cmpnt_cost%TYPE,
447: burden_ind cm_cmpt_dtl.burden_ind%TYPE,
448: total_qty cm_cmpt_dtl.total_qty%TYPE,
449: rmcalc_type cm_cmpt_dtl.rmcalc_type%TYPE,
450: fmeff_id cm_cmpt_dtl.fmeff_id%TYPE,
451: text_code cm_cmpt_dtl.text_code%TYPE,

Line 448: total_qty cm_cmpt_dtl.total_qty%TYPE,

444: cost_analysis_code cm_cmpt_dtl.cost_analysis_code%TYPE,
445: cost_level cm_cmpt_dtl.cost_level%TYPE,
446: cmpnt_cost cm_cmpt_dtl.cmpnt_cost%TYPE,
447: burden_ind cm_cmpt_dtl.burden_ind%TYPE,
448: total_qty cm_cmpt_dtl.total_qty%TYPE,
449: rmcalc_type cm_cmpt_dtl.rmcalc_type%TYPE,
450: fmeff_id cm_cmpt_dtl.fmeff_id%TYPE,
451: text_code cm_cmpt_dtl.text_code%TYPE,
452: attribute1 cm_cmpt_dtl.attribute1%TYPE,

Line 449: rmcalc_type cm_cmpt_dtl.rmcalc_type%TYPE,

445: cost_level cm_cmpt_dtl.cost_level%TYPE,
446: cmpnt_cost cm_cmpt_dtl.cmpnt_cost%TYPE,
447: burden_ind cm_cmpt_dtl.burden_ind%TYPE,
448: total_qty cm_cmpt_dtl.total_qty%TYPE,
449: rmcalc_type cm_cmpt_dtl.rmcalc_type%TYPE,
450: fmeff_id cm_cmpt_dtl.fmeff_id%TYPE,
451: text_code cm_cmpt_dtl.text_code%TYPE,
452: attribute1 cm_cmpt_dtl.attribute1%TYPE,
453: attribute2 cm_cmpt_dtl.attribute2%TYPE,

Line 450: fmeff_id cm_cmpt_dtl.fmeff_id%TYPE,

446: cmpnt_cost cm_cmpt_dtl.cmpnt_cost%TYPE,
447: burden_ind cm_cmpt_dtl.burden_ind%TYPE,
448: total_qty cm_cmpt_dtl.total_qty%TYPE,
449: rmcalc_type cm_cmpt_dtl.rmcalc_type%TYPE,
450: fmeff_id cm_cmpt_dtl.fmeff_id%TYPE,
451: text_code cm_cmpt_dtl.text_code%TYPE,
452: attribute1 cm_cmpt_dtl.attribute1%TYPE,
453: attribute2 cm_cmpt_dtl.attribute2%TYPE,
454: attribute3 cm_cmpt_dtl.attribute3%TYPE,

Line 451: text_code cm_cmpt_dtl.text_code%TYPE,

447: burden_ind cm_cmpt_dtl.burden_ind%TYPE,
448: total_qty cm_cmpt_dtl.total_qty%TYPE,
449: rmcalc_type cm_cmpt_dtl.rmcalc_type%TYPE,
450: fmeff_id cm_cmpt_dtl.fmeff_id%TYPE,
451: text_code cm_cmpt_dtl.text_code%TYPE,
452: attribute1 cm_cmpt_dtl.attribute1%TYPE,
453: attribute2 cm_cmpt_dtl.attribute2%TYPE,
454: attribute3 cm_cmpt_dtl.attribute3%TYPE,
455: attribute4 cm_cmpt_dtl.attribute4%TYPE,

Line 452: attribute1 cm_cmpt_dtl.attribute1%TYPE,

448: total_qty cm_cmpt_dtl.total_qty%TYPE,
449: rmcalc_type cm_cmpt_dtl.rmcalc_type%TYPE,
450: fmeff_id cm_cmpt_dtl.fmeff_id%TYPE,
451: text_code cm_cmpt_dtl.text_code%TYPE,
452: attribute1 cm_cmpt_dtl.attribute1%TYPE,
453: attribute2 cm_cmpt_dtl.attribute2%TYPE,
454: attribute3 cm_cmpt_dtl.attribute3%TYPE,
455: attribute4 cm_cmpt_dtl.attribute4%TYPE,
456: attribute5 cm_cmpt_dtl.attribute5%TYPE,

Line 453: attribute2 cm_cmpt_dtl.attribute2%TYPE,

449: rmcalc_type cm_cmpt_dtl.rmcalc_type%TYPE,
450: fmeff_id cm_cmpt_dtl.fmeff_id%TYPE,
451: text_code cm_cmpt_dtl.text_code%TYPE,
452: attribute1 cm_cmpt_dtl.attribute1%TYPE,
453: attribute2 cm_cmpt_dtl.attribute2%TYPE,
454: attribute3 cm_cmpt_dtl.attribute3%TYPE,
455: attribute4 cm_cmpt_dtl.attribute4%TYPE,
456: attribute5 cm_cmpt_dtl.attribute5%TYPE,
457: attribute6 cm_cmpt_dtl.attribute6%TYPE,

Line 454: attribute3 cm_cmpt_dtl.attribute3%TYPE,

450: fmeff_id cm_cmpt_dtl.fmeff_id%TYPE,
451: text_code cm_cmpt_dtl.text_code%TYPE,
452: attribute1 cm_cmpt_dtl.attribute1%TYPE,
453: attribute2 cm_cmpt_dtl.attribute2%TYPE,
454: attribute3 cm_cmpt_dtl.attribute3%TYPE,
455: attribute4 cm_cmpt_dtl.attribute4%TYPE,
456: attribute5 cm_cmpt_dtl.attribute5%TYPE,
457: attribute6 cm_cmpt_dtl.attribute6%TYPE,
458: attribute7 cm_cmpt_dtl.attribute7%TYPE,

Line 455: attribute4 cm_cmpt_dtl.attribute4%TYPE,

451: text_code cm_cmpt_dtl.text_code%TYPE,
452: attribute1 cm_cmpt_dtl.attribute1%TYPE,
453: attribute2 cm_cmpt_dtl.attribute2%TYPE,
454: attribute3 cm_cmpt_dtl.attribute3%TYPE,
455: attribute4 cm_cmpt_dtl.attribute4%TYPE,
456: attribute5 cm_cmpt_dtl.attribute5%TYPE,
457: attribute6 cm_cmpt_dtl.attribute6%TYPE,
458: attribute7 cm_cmpt_dtl.attribute7%TYPE,
459: attribute8 cm_cmpt_dtl.attribute8%TYPE,

Line 456: attribute5 cm_cmpt_dtl.attribute5%TYPE,

452: attribute1 cm_cmpt_dtl.attribute1%TYPE,
453: attribute2 cm_cmpt_dtl.attribute2%TYPE,
454: attribute3 cm_cmpt_dtl.attribute3%TYPE,
455: attribute4 cm_cmpt_dtl.attribute4%TYPE,
456: attribute5 cm_cmpt_dtl.attribute5%TYPE,
457: attribute6 cm_cmpt_dtl.attribute6%TYPE,
458: attribute7 cm_cmpt_dtl.attribute7%TYPE,
459: attribute8 cm_cmpt_dtl.attribute8%TYPE,
460: attribute9 cm_cmpt_dtl.attribute9%TYPE,

Line 457: attribute6 cm_cmpt_dtl.attribute6%TYPE,

453: attribute2 cm_cmpt_dtl.attribute2%TYPE,
454: attribute3 cm_cmpt_dtl.attribute3%TYPE,
455: attribute4 cm_cmpt_dtl.attribute4%TYPE,
456: attribute5 cm_cmpt_dtl.attribute5%TYPE,
457: attribute6 cm_cmpt_dtl.attribute6%TYPE,
458: attribute7 cm_cmpt_dtl.attribute7%TYPE,
459: attribute8 cm_cmpt_dtl.attribute8%TYPE,
460: attribute9 cm_cmpt_dtl.attribute9%TYPE,
461: attribute10 cm_cmpt_dtl.attribute10%TYPE,

Line 458: attribute7 cm_cmpt_dtl.attribute7%TYPE,

454: attribute3 cm_cmpt_dtl.attribute3%TYPE,
455: attribute4 cm_cmpt_dtl.attribute4%TYPE,
456: attribute5 cm_cmpt_dtl.attribute5%TYPE,
457: attribute6 cm_cmpt_dtl.attribute6%TYPE,
458: attribute7 cm_cmpt_dtl.attribute7%TYPE,
459: attribute8 cm_cmpt_dtl.attribute8%TYPE,
460: attribute9 cm_cmpt_dtl.attribute9%TYPE,
461: attribute10 cm_cmpt_dtl.attribute10%TYPE,
462: attribute11 cm_cmpt_dtl.attribute11%TYPE,

Line 459: attribute8 cm_cmpt_dtl.attribute8%TYPE,

455: attribute4 cm_cmpt_dtl.attribute4%TYPE,
456: attribute5 cm_cmpt_dtl.attribute5%TYPE,
457: attribute6 cm_cmpt_dtl.attribute6%TYPE,
458: attribute7 cm_cmpt_dtl.attribute7%TYPE,
459: attribute8 cm_cmpt_dtl.attribute8%TYPE,
460: attribute9 cm_cmpt_dtl.attribute9%TYPE,
461: attribute10 cm_cmpt_dtl.attribute10%TYPE,
462: attribute11 cm_cmpt_dtl.attribute11%TYPE,
463: attribute12 cm_cmpt_dtl.attribute12%TYPE,

Line 460: attribute9 cm_cmpt_dtl.attribute9%TYPE,

456: attribute5 cm_cmpt_dtl.attribute5%TYPE,
457: attribute6 cm_cmpt_dtl.attribute6%TYPE,
458: attribute7 cm_cmpt_dtl.attribute7%TYPE,
459: attribute8 cm_cmpt_dtl.attribute8%TYPE,
460: attribute9 cm_cmpt_dtl.attribute9%TYPE,
461: attribute10 cm_cmpt_dtl.attribute10%TYPE,
462: attribute11 cm_cmpt_dtl.attribute11%TYPE,
463: attribute12 cm_cmpt_dtl.attribute12%TYPE,
464: attribute13 cm_cmpt_dtl.attribute13%TYPE,

Line 461: attribute10 cm_cmpt_dtl.attribute10%TYPE,

457: attribute6 cm_cmpt_dtl.attribute6%TYPE,
458: attribute7 cm_cmpt_dtl.attribute7%TYPE,
459: attribute8 cm_cmpt_dtl.attribute8%TYPE,
460: attribute9 cm_cmpt_dtl.attribute9%TYPE,
461: attribute10 cm_cmpt_dtl.attribute10%TYPE,
462: attribute11 cm_cmpt_dtl.attribute11%TYPE,
463: attribute12 cm_cmpt_dtl.attribute12%TYPE,
464: attribute13 cm_cmpt_dtl.attribute13%TYPE,
465: attribute14 cm_cmpt_dtl.attribute14%TYPE,

Line 462: attribute11 cm_cmpt_dtl.attribute11%TYPE,

458: attribute7 cm_cmpt_dtl.attribute7%TYPE,
459: attribute8 cm_cmpt_dtl.attribute8%TYPE,
460: attribute9 cm_cmpt_dtl.attribute9%TYPE,
461: attribute10 cm_cmpt_dtl.attribute10%TYPE,
462: attribute11 cm_cmpt_dtl.attribute11%TYPE,
463: attribute12 cm_cmpt_dtl.attribute12%TYPE,
464: attribute13 cm_cmpt_dtl.attribute13%TYPE,
465: attribute14 cm_cmpt_dtl.attribute14%TYPE,
466: attribute15 cm_cmpt_dtl.attribute15%TYPE,

Line 463: attribute12 cm_cmpt_dtl.attribute12%TYPE,

459: attribute8 cm_cmpt_dtl.attribute8%TYPE,
460: attribute9 cm_cmpt_dtl.attribute9%TYPE,
461: attribute10 cm_cmpt_dtl.attribute10%TYPE,
462: attribute11 cm_cmpt_dtl.attribute11%TYPE,
463: attribute12 cm_cmpt_dtl.attribute12%TYPE,
464: attribute13 cm_cmpt_dtl.attribute13%TYPE,
465: attribute14 cm_cmpt_dtl.attribute14%TYPE,
466: attribute15 cm_cmpt_dtl.attribute15%TYPE,
467: attribute16 cm_cmpt_dtl.attribute16%TYPE,

Line 464: attribute13 cm_cmpt_dtl.attribute13%TYPE,

460: attribute9 cm_cmpt_dtl.attribute9%TYPE,
461: attribute10 cm_cmpt_dtl.attribute10%TYPE,
462: attribute11 cm_cmpt_dtl.attribute11%TYPE,
463: attribute12 cm_cmpt_dtl.attribute12%TYPE,
464: attribute13 cm_cmpt_dtl.attribute13%TYPE,
465: attribute14 cm_cmpt_dtl.attribute14%TYPE,
466: attribute15 cm_cmpt_dtl.attribute15%TYPE,
467: attribute16 cm_cmpt_dtl.attribute16%TYPE,
468: attribute17 cm_cmpt_dtl.attribute17%TYPE,

Line 465: attribute14 cm_cmpt_dtl.attribute14%TYPE,

461: attribute10 cm_cmpt_dtl.attribute10%TYPE,
462: attribute11 cm_cmpt_dtl.attribute11%TYPE,
463: attribute12 cm_cmpt_dtl.attribute12%TYPE,
464: attribute13 cm_cmpt_dtl.attribute13%TYPE,
465: attribute14 cm_cmpt_dtl.attribute14%TYPE,
466: attribute15 cm_cmpt_dtl.attribute15%TYPE,
467: attribute16 cm_cmpt_dtl.attribute16%TYPE,
468: attribute17 cm_cmpt_dtl.attribute17%TYPE,
469: attribute18 cm_cmpt_dtl.attribute18%TYPE,

Line 466: attribute15 cm_cmpt_dtl.attribute15%TYPE,

462: attribute11 cm_cmpt_dtl.attribute11%TYPE,
463: attribute12 cm_cmpt_dtl.attribute12%TYPE,
464: attribute13 cm_cmpt_dtl.attribute13%TYPE,
465: attribute14 cm_cmpt_dtl.attribute14%TYPE,
466: attribute15 cm_cmpt_dtl.attribute15%TYPE,
467: attribute16 cm_cmpt_dtl.attribute16%TYPE,
468: attribute17 cm_cmpt_dtl.attribute17%TYPE,
469: attribute18 cm_cmpt_dtl.attribute18%TYPE,
470: attribute19 cm_cmpt_dtl.attribute19%TYPE,

Line 467: attribute16 cm_cmpt_dtl.attribute16%TYPE,

463: attribute12 cm_cmpt_dtl.attribute12%TYPE,
464: attribute13 cm_cmpt_dtl.attribute13%TYPE,
465: attribute14 cm_cmpt_dtl.attribute14%TYPE,
466: attribute15 cm_cmpt_dtl.attribute15%TYPE,
467: attribute16 cm_cmpt_dtl.attribute16%TYPE,
468: attribute17 cm_cmpt_dtl.attribute17%TYPE,
469: attribute18 cm_cmpt_dtl.attribute18%TYPE,
470: attribute19 cm_cmpt_dtl.attribute19%TYPE,
471: attribute20 cm_cmpt_dtl.attribute20%TYPE,

Line 468: attribute17 cm_cmpt_dtl.attribute17%TYPE,

464: attribute13 cm_cmpt_dtl.attribute13%TYPE,
465: attribute14 cm_cmpt_dtl.attribute14%TYPE,
466: attribute15 cm_cmpt_dtl.attribute15%TYPE,
467: attribute16 cm_cmpt_dtl.attribute16%TYPE,
468: attribute17 cm_cmpt_dtl.attribute17%TYPE,
469: attribute18 cm_cmpt_dtl.attribute18%TYPE,
470: attribute19 cm_cmpt_dtl.attribute19%TYPE,
471: attribute20 cm_cmpt_dtl.attribute20%TYPE,
472: attribute21 cm_cmpt_dtl.attribute21%TYPE,

Line 469: attribute18 cm_cmpt_dtl.attribute18%TYPE,

465: attribute14 cm_cmpt_dtl.attribute14%TYPE,
466: attribute15 cm_cmpt_dtl.attribute15%TYPE,
467: attribute16 cm_cmpt_dtl.attribute16%TYPE,
468: attribute17 cm_cmpt_dtl.attribute17%TYPE,
469: attribute18 cm_cmpt_dtl.attribute18%TYPE,
470: attribute19 cm_cmpt_dtl.attribute19%TYPE,
471: attribute20 cm_cmpt_dtl.attribute20%TYPE,
472: attribute21 cm_cmpt_dtl.attribute21%TYPE,
473: attribute22 cm_cmpt_dtl.attribute22%TYPE,

Line 470: attribute19 cm_cmpt_dtl.attribute19%TYPE,

466: attribute15 cm_cmpt_dtl.attribute15%TYPE,
467: attribute16 cm_cmpt_dtl.attribute16%TYPE,
468: attribute17 cm_cmpt_dtl.attribute17%TYPE,
469: attribute18 cm_cmpt_dtl.attribute18%TYPE,
470: attribute19 cm_cmpt_dtl.attribute19%TYPE,
471: attribute20 cm_cmpt_dtl.attribute20%TYPE,
472: attribute21 cm_cmpt_dtl.attribute21%TYPE,
473: attribute22 cm_cmpt_dtl.attribute22%TYPE,
474: attribute23 cm_cmpt_dtl.attribute23%TYPE,

Line 471: attribute20 cm_cmpt_dtl.attribute20%TYPE,

467: attribute16 cm_cmpt_dtl.attribute16%TYPE,
468: attribute17 cm_cmpt_dtl.attribute17%TYPE,
469: attribute18 cm_cmpt_dtl.attribute18%TYPE,
470: attribute19 cm_cmpt_dtl.attribute19%TYPE,
471: attribute20 cm_cmpt_dtl.attribute20%TYPE,
472: attribute21 cm_cmpt_dtl.attribute21%TYPE,
473: attribute22 cm_cmpt_dtl.attribute22%TYPE,
474: attribute23 cm_cmpt_dtl.attribute23%TYPE,
475: attribute24 cm_cmpt_dtl.attribute24%TYPE,

Line 472: attribute21 cm_cmpt_dtl.attribute21%TYPE,

468: attribute17 cm_cmpt_dtl.attribute17%TYPE,
469: attribute18 cm_cmpt_dtl.attribute18%TYPE,
470: attribute19 cm_cmpt_dtl.attribute19%TYPE,
471: attribute20 cm_cmpt_dtl.attribute20%TYPE,
472: attribute21 cm_cmpt_dtl.attribute21%TYPE,
473: attribute22 cm_cmpt_dtl.attribute22%TYPE,
474: attribute23 cm_cmpt_dtl.attribute23%TYPE,
475: attribute24 cm_cmpt_dtl.attribute24%TYPE,
476: attribute25 cm_cmpt_dtl.attribute25%TYPE,

Line 473: attribute22 cm_cmpt_dtl.attribute22%TYPE,

469: attribute18 cm_cmpt_dtl.attribute18%TYPE,
470: attribute19 cm_cmpt_dtl.attribute19%TYPE,
471: attribute20 cm_cmpt_dtl.attribute20%TYPE,
472: attribute21 cm_cmpt_dtl.attribute21%TYPE,
473: attribute22 cm_cmpt_dtl.attribute22%TYPE,
474: attribute23 cm_cmpt_dtl.attribute23%TYPE,
475: attribute24 cm_cmpt_dtl.attribute24%TYPE,
476: attribute25 cm_cmpt_dtl.attribute25%TYPE,
477: attribute26 cm_cmpt_dtl.attribute26%TYPE,

Line 474: attribute23 cm_cmpt_dtl.attribute23%TYPE,

470: attribute19 cm_cmpt_dtl.attribute19%TYPE,
471: attribute20 cm_cmpt_dtl.attribute20%TYPE,
472: attribute21 cm_cmpt_dtl.attribute21%TYPE,
473: attribute22 cm_cmpt_dtl.attribute22%TYPE,
474: attribute23 cm_cmpt_dtl.attribute23%TYPE,
475: attribute24 cm_cmpt_dtl.attribute24%TYPE,
476: attribute25 cm_cmpt_dtl.attribute25%TYPE,
477: attribute26 cm_cmpt_dtl.attribute26%TYPE,
478: attribute27 cm_cmpt_dtl.attribute27%TYPE,

Line 475: attribute24 cm_cmpt_dtl.attribute24%TYPE,

471: attribute20 cm_cmpt_dtl.attribute20%TYPE,
472: attribute21 cm_cmpt_dtl.attribute21%TYPE,
473: attribute22 cm_cmpt_dtl.attribute22%TYPE,
474: attribute23 cm_cmpt_dtl.attribute23%TYPE,
475: attribute24 cm_cmpt_dtl.attribute24%TYPE,
476: attribute25 cm_cmpt_dtl.attribute25%TYPE,
477: attribute26 cm_cmpt_dtl.attribute26%TYPE,
478: attribute27 cm_cmpt_dtl.attribute27%TYPE,
479: attribute28 cm_cmpt_dtl.attribute28%TYPE,

Line 476: attribute25 cm_cmpt_dtl.attribute25%TYPE,

472: attribute21 cm_cmpt_dtl.attribute21%TYPE,
473: attribute22 cm_cmpt_dtl.attribute22%TYPE,
474: attribute23 cm_cmpt_dtl.attribute23%TYPE,
475: attribute24 cm_cmpt_dtl.attribute24%TYPE,
476: attribute25 cm_cmpt_dtl.attribute25%TYPE,
477: attribute26 cm_cmpt_dtl.attribute26%TYPE,
478: attribute27 cm_cmpt_dtl.attribute27%TYPE,
479: attribute28 cm_cmpt_dtl.attribute28%TYPE,
480: attribute29 cm_cmpt_dtl.attribute29%TYPE,

Line 477: attribute26 cm_cmpt_dtl.attribute26%TYPE,

473: attribute22 cm_cmpt_dtl.attribute22%TYPE,
474: attribute23 cm_cmpt_dtl.attribute23%TYPE,
475: attribute24 cm_cmpt_dtl.attribute24%TYPE,
476: attribute25 cm_cmpt_dtl.attribute25%TYPE,
477: attribute26 cm_cmpt_dtl.attribute26%TYPE,
478: attribute27 cm_cmpt_dtl.attribute27%TYPE,
479: attribute28 cm_cmpt_dtl.attribute28%TYPE,
480: attribute29 cm_cmpt_dtl.attribute29%TYPE,
481: attribute30 cm_cmpt_dtl.attribute30%TYPE

Line 478: attribute27 cm_cmpt_dtl.attribute27%TYPE,

474: attribute23 cm_cmpt_dtl.attribute23%TYPE,
475: attribute24 cm_cmpt_dtl.attribute24%TYPE,
476: attribute25 cm_cmpt_dtl.attribute25%TYPE,
477: attribute26 cm_cmpt_dtl.attribute26%TYPE,
478: attribute27 cm_cmpt_dtl.attribute27%TYPE,
479: attribute28 cm_cmpt_dtl.attribute28%TYPE,
480: attribute29 cm_cmpt_dtl.attribute29%TYPE,
481: attribute30 cm_cmpt_dtl.attribute30%TYPE
482: );

Line 479: attribute28 cm_cmpt_dtl.attribute28%TYPE,

475: attribute24 cm_cmpt_dtl.attribute24%TYPE,
476: attribute25 cm_cmpt_dtl.attribute25%TYPE,
477: attribute26 cm_cmpt_dtl.attribute26%TYPE,
478: attribute27 cm_cmpt_dtl.attribute27%TYPE,
479: attribute28 cm_cmpt_dtl.attribute28%TYPE,
480: attribute29 cm_cmpt_dtl.attribute29%TYPE,
481: attribute30 cm_cmpt_dtl.attribute30%TYPE
482: );
483:

Line 480: attribute29 cm_cmpt_dtl.attribute29%TYPE,

476: attribute25 cm_cmpt_dtl.attribute25%TYPE,
477: attribute26 cm_cmpt_dtl.attribute26%TYPE,
478: attribute27 cm_cmpt_dtl.attribute27%TYPE,
479: attribute28 cm_cmpt_dtl.attribute28%TYPE,
480: attribute29 cm_cmpt_dtl.attribute29%TYPE,
481: attribute30 cm_cmpt_dtl.attribute30%TYPE
482: );
483:
484: TYPE curtyp_cost_detail IS REF CURSOR;

Line 481: attribute30 cm_cmpt_dtl.attribute30%TYPE

477: attribute26 cm_cmpt_dtl.attribute26%TYPE,
478: attribute27 cm_cmpt_dtl.attribute27%TYPE,
479: attribute28 cm_cmpt_dtl.attribute28%TYPE,
480: attribute29 cm_cmpt_dtl.attribute29%TYPE,
481: attribute30 cm_cmpt_dtl.attribute30%TYPE
482: );
483:
484: TYPE curtyp_cost_detail IS REF CURSOR;
485: cv_cost_detail curtyp_cost_detail;

Line 500: l_organization_id_from cm_cmpt_dtl.organization_id%TYPE;

496: l_sql_stmt VARCHAR2(2000);
497: l_sql_org VARCHAR2(2000) ;
498: l_sql_periods VARCHAR2(2000) ;
499: l_org_id gmf_legal_entities.legal_entity_id%TYPE ;
500: l_organization_id_from cm_cmpt_dtl.organization_id%TYPE;
501: l_organization_id_to cm_cmpt_dtl.organization_id%TYPE;
502:
503: l_period_id_to cm_cmpt_dtl.period_id%TYPE;
504:

Line 501: l_organization_id_to cm_cmpt_dtl.organization_id%TYPE;

497: l_sql_org VARCHAR2(2000) ;
498: l_sql_periods VARCHAR2(2000) ;
499: l_org_id gmf_legal_entities.legal_entity_id%TYPE ;
500: l_organization_id_from cm_cmpt_dtl.organization_id%TYPE;
501: l_organization_id_to cm_cmpt_dtl.organization_id%TYPE;
502:
503: l_period_id_to cm_cmpt_dtl.period_id%TYPE;
504:
505: l_from_range VARCHAR2(32767);

Line 503: l_period_id_to cm_cmpt_dtl.period_id%TYPE;

499: l_org_id gmf_legal_entities.legal_entity_id%TYPE ;
500: l_organization_id_from cm_cmpt_dtl.organization_id%TYPE;
501: l_organization_id_to cm_cmpt_dtl.organization_id%TYPE;
502:
503: l_period_id_to cm_cmpt_dtl.period_id%TYPE;
504:
505: l_from_range VARCHAR2(32767);
506: l_to_range VARCHAR2(32767);
507:

Line 512: l_curr_inventory_item_id cm_cmpt_dtl.inventory_item_id%TYPE;

508: l_rem_repl NUMBER;
509: l_incr_pct NUMBER;
510: l_incr_decr_cost NUMBER;
511:
512: l_curr_inventory_item_id cm_cmpt_dtl.inventory_item_id%TYPE;
513: l_curr_organization_id cm_cmpt_dtl.organization_id%TYPE;
514: l_curr_period_code cm_cmpt_dtl.period_code%TYPE;
515: l_frozen_flag NUMBER;
516: l_assigned_flag NUMBER;

Line 513: l_curr_organization_id cm_cmpt_dtl.organization_id%TYPE;

509: l_incr_pct NUMBER;
510: l_incr_decr_cost NUMBER;
511:
512: l_curr_inventory_item_id cm_cmpt_dtl.inventory_item_id%TYPE;
513: l_curr_organization_id cm_cmpt_dtl.organization_id%TYPE;
514: l_curr_period_code cm_cmpt_dtl.period_code%TYPE;
515: l_frozen_flag NUMBER;
516: l_assigned_flag NUMBER;
517:

Line 514: l_curr_period_code cm_cmpt_dtl.period_code%TYPE;

510: l_incr_decr_cost NUMBER;
511:
512: l_curr_inventory_item_id cm_cmpt_dtl.inventory_item_id%TYPE;
513: l_curr_organization_id cm_cmpt_dtl.organization_id%TYPE;
514: l_curr_period_code cm_cmpt_dtl.period_code%TYPE;
515: l_frozen_flag NUMBER;
516: l_assigned_flag NUMBER;
517:
518: l_curr_inventory_item_id2 cm_cmpt_dtl.inventory_item_id%TYPE;

Line 518: l_curr_inventory_item_id2 cm_cmpt_dtl.inventory_item_id%TYPE;

514: l_curr_period_code cm_cmpt_dtl.period_code%TYPE;
515: l_frozen_flag NUMBER;
516: l_assigned_flag NUMBER;
517:
518: l_curr_inventory_item_id2 cm_cmpt_dtl.inventory_item_id%TYPE;
519: l_curr_organization_id2 cm_cmpt_dtl.organization_id%TYPE;
520: l_curr_period_code2 cm_cmpt_dtl.period_code%TYPE;
521:
522: l_cost_rows NUMBER;

Line 519: l_curr_organization_id2 cm_cmpt_dtl.organization_id%TYPE;

515: l_frozen_flag NUMBER;
516: l_assigned_flag NUMBER;
517:
518: l_curr_inventory_item_id2 cm_cmpt_dtl.inventory_item_id%TYPE;
519: l_curr_organization_id2 cm_cmpt_dtl.organization_id%TYPE;
520: l_curr_period_code2 cm_cmpt_dtl.period_code%TYPE;
521:
522: l_cost_rows NUMBER;
523: l_cost_rows_upd NUMBER;

Line 520: l_curr_period_code2 cm_cmpt_dtl.period_code%TYPE;

516: l_assigned_flag NUMBER;
517:
518: l_curr_inventory_item_id2 cm_cmpt_dtl.inventory_item_id%TYPE;
519: l_curr_organization_id2 cm_cmpt_dtl.organization_id%TYPE;
520: l_curr_period_code2 cm_cmpt_dtl.period_code%TYPE;
521:
522: l_cost_rows NUMBER;
523: l_cost_rows_upd NUMBER;
524: l_cost_rows_ins NUMBER;

Line 634: 'cm_cmpt_dtl cst' ||

630: 'cst.attribute28,' ||
631: 'cst.attribute29,' ||
632: 'cst.attribute30 ' ||
633: ' FROM ' ||
634: 'cm_cmpt_dtl cst' ||
635: ' WHERE ' ||
636: 'cst.organization_id = :b_organization_id AND ' ||
637: 'cst.period_id = :b_period_id AND ' ||
638: 'cst.cost_type_id = :b_cost_type_id '; -- AND ' ||

Line 915: * Try update of cm_cmpt_dtl first

911: FETCH cv_cost_detail INTO r_cost_detail;
912: EXIT WHEN cv_cost_detail%NOTFOUND;
913:
914: /**
915: * Try update of cm_cmpt_dtl first
916: * Update can fail for two reasons: either the row is not there
917: * or, the row exists but is frozen (rollover_ind = 1)
918: * If the costs are frozen in the target period then do not update the rows
919: * in cm_cmpt_dtl nor delete them from cm_scst_led/cm_acst_led.

Line 919: * in cm_cmpt_dtl nor delete them from cm_scst_led/cm_acst_led.

915: * Try update of cm_cmpt_dtl first
916: * Update can fail for two reasons: either the row is not there
917: * or, the row exists but is frozen (rollover_ind = 1)
918: * If the costs are frozen in the target period then do not update the rows
919: * in cm_cmpt_dtl nor delete them from cm_scst_led/cm_acst_led.
920: * The item cost rows should be left untouched in the target period even if
921: * one of the components is frozen.
922: */
923:

Line 1051: p_calendar_code IN cm_cmpt_dtl.calendar_code%TYPE,

1047:
1048: <>
1049: DECLARE
1050: CURSOR c_updins_cc_id(
1051: p_calendar_code IN cm_cmpt_dtl.calendar_code%TYPE,
1052: p_period_id IN cm_cmpt_dtl.period_id%TYPE,
1053: p_cost_type_id IN cm_cmpt_dtl.cost_type_id%TYPE,
1054: p_organization_id IN cm_cmpt_dtl.organization_id%TYPE,
1055: p_inventory_item_id IN cm_cmpt_dtl.inventory_item_id%TYPE,

Line 1052: p_period_id IN cm_cmpt_dtl.period_id%TYPE,

1048: <>
1049: DECLARE
1050: CURSOR c_updins_cc_id(
1051: p_calendar_code IN cm_cmpt_dtl.calendar_code%TYPE,
1052: p_period_id IN cm_cmpt_dtl.period_id%TYPE,
1053: p_cost_type_id IN cm_cmpt_dtl.cost_type_id%TYPE,
1054: p_organization_id IN cm_cmpt_dtl.organization_id%TYPE,
1055: p_inventory_item_id IN cm_cmpt_dtl.inventory_item_id%TYPE,
1056: p_cost_cmpntcls_id IN cm_cmpt_dtl.cost_cmpntcls_id%TYPE,

Line 1053: p_cost_type_id IN cm_cmpt_dtl.cost_type_id%TYPE,

1049: DECLARE
1050: CURSOR c_updins_cc_id(
1051: p_calendar_code IN cm_cmpt_dtl.calendar_code%TYPE,
1052: p_period_id IN cm_cmpt_dtl.period_id%TYPE,
1053: p_cost_type_id IN cm_cmpt_dtl.cost_type_id%TYPE,
1054: p_organization_id IN cm_cmpt_dtl.organization_id%TYPE,
1055: p_inventory_item_id IN cm_cmpt_dtl.inventory_item_id%TYPE,
1056: p_cost_cmpntcls_id IN cm_cmpt_dtl.cost_cmpntcls_id%TYPE,
1057: p_cost_analysis_code IN cm_cmpt_dtl.cost_analysis_code%TYPE,

Line 1054: p_organization_id IN cm_cmpt_dtl.organization_id%TYPE,

1050: CURSOR c_updins_cc_id(
1051: p_calendar_code IN cm_cmpt_dtl.calendar_code%TYPE,
1052: p_period_id IN cm_cmpt_dtl.period_id%TYPE,
1053: p_cost_type_id IN cm_cmpt_dtl.cost_type_id%TYPE,
1054: p_organization_id IN cm_cmpt_dtl.organization_id%TYPE,
1055: p_inventory_item_id IN cm_cmpt_dtl.inventory_item_id%TYPE,
1056: p_cost_cmpntcls_id IN cm_cmpt_dtl.cost_cmpntcls_id%TYPE,
1057: p_cost_analysis_code IN cm_cmpt_dtl.cost_analysis_code%TYPE,
1058: p_cost_level IN cm_cmpt_dtl.cost_level%TYPE

Line 1055: p_inventory_item_id IN cm_cmpt_dtl.inventory_item_id%TYPE,

1051: p_calendar_code IN cm_cmpt_dtl.calendar_code%TYPE,
1052: p_period_id IN cm_cmpt_dtl.period_id%TYPE,
1053: p_cost_type_id IN cm_cmpt_dtl.cost_type_id%TYPE,
1054: p_organization_id IN cm_cmpt_dtl.organization_id%TYPE,
1055: p_inventory_item_id IN cm_cmpt_dtl.inventory_item_id%TYPE,
1056: p_cost_cmpntcls_id IN cm_cmpt_dtl.cost_cmpntcls_id%TYPE,
1057: p_cost_analysis_code IN cm_cmpt_dtl.cost_analysis_code%TYPE,
1058: p_cost_level IN cm_cmpt_dtl.cost_level%TYPE
1059: ) IS

Line 1056: p_cost_cmpntcls_id IN cm_cmpt_dtl.cost_cmpntcls_id%TYPE,

1052: p_period_id IN cm_cmpt_dtl.period_id%TYPE,
1053: p_cost_type_id IN cm_cmpt_dtl.cost_type_id%TYPE,
1054: p_organization_id IN cm_cmpt_dtl.organization_id%TYPE,
1055: p_inventory_item_id IN cm_cmpt_dtl.inventory_item_id%TYPE,
1056: p_cost_cmpntcls_id IN cm_cmpt_dtl.cost_cmpntcls_id%TYPE,
1057: p_cost_analysis_code IN cm_cmpt_dtl.cost_analysis_code%TYPE,
1058: p_cost_level IN cm_cmpt_dtl.cost_level%TYPE
1059: ) IS
1060: SELECT

Line 1057: p_cost_analysis_code IN cm_cmpt_dtl.cost_analysis_code%TYPE,

1053: p_cost_type_id IN cm_cmpt_dtl.cost_type_id%TYPE,
1054: p_organization_id IN cm_cmpt_dtl.organization_id%TYPE,
1055: p_inventory_item_id IN cm_cmpt_dtl.inventory_item_id%TYPE,
1056: p_cost_cmpntcls_id IN cm_cmpt_dtl.cost_cmpntcls_id%TYPE,
1057: p_cost_analysis_code IN cm_cmpt_dtl.cost_analysis_code%TYPE,
1058: p_cost_level IN cm_cmpt_dtl.cost_level%TYPE
1059: ) IS
1060: SELECT
1061: cmpntcost_id

Line 1058: p_cost_level IN cm_cmpt_dtl.cost_level%TYPE

1054: p_organization_id IN cm_cmpt_dtl.organization_id%TYPE,
1055: p_inventory_item_id IN cm_cmpt_dtl.inventory_item_id%TYPE,
1056: p_cost_cmpntcls_id IN cm_cmpt_dtl.cost_cmpntcls_id%TYPE,
1057: p_cost_analysis_code IN cm_cmpt_dtl.cost_analysis_code%TYPE,
1058: p_cost_level IN cm_cmpt_dtl.cost_level%TYPE
1059: ) IS
1060: SELECT
1061: cmpntcost_id
1062: FROM

Line 1063: cm_cmpt_dtl

1059: ) IS
1060: SELECT
1061: cmpntcost_id
1062: FROM
1063: cm_cmpt_dtl
1064: WHERE
1065: period_id = p_period_id AND
1066: cost_type_id = p_cost_type_id AND
1067: organization_id = p_organization_id AND

Line 1073: l_updins_cc_id cm_cmpt_dtl.cmpntcost_id%TYPE;

1069: cost_cmpntcls_id = p_cost_cmpntcls_id AND
1070: cost_analysis_code = p_cost_analysis_code AND
1071: cost_level = p_cost_level;
1072:
1073: l_updins_cc_id cm_cmpt_dtl.cmpntcost_id%TYPE;
1074: e_insert_row EXCEPTION;
1075: BEGIN
1076:
1077: l_updins_cc_id := 0;

Line 1094: /** There is a unique index on cm_cmpt_dtl on these columns

1090: ' is Frozen. You can not Update Frozen period cost.', 0 );
1091: RAISE e_period_frozen;
1092: END IF; -- end for bug 5567102 pmarada
1093:
1094: /** There is a unique index on cm_cmpt_dtl on these columns
1095: * and we expect only one row and only one row is fetched
1096: * if not we have bigger problems, houston!
1097: */
1098: IF ( l_copy_to_upper_lvl = 1 ) THEN

Line 1157: cm_cmpt_dtl

1153: -- B2198228 We have read cost from lower level at source and user
1154: -- wants to copy it to this level at target
1155:
1156: UPDATE
1157: cm_cmpt_dtl
1158: SET
1159: cmpntcost_id = GEM5_CMPNT_COST_ID_S.NEXTVAL,
1160: cmpnt_cost = cmpnt_cost + r_cost_detail.cmpnt_cost,
1161: burden_ind = r_cost_detail.burden_ind,

Line 1183: cm_cmpt_dtl

1179: cmpntcost_id = l_updins_cc_id
1180: ;
1181: ELSE
1182: UPDATE
1183: cm_cmpt_dtl
1184: SET
1185: cmpntcost_id = GEM5_CMPNT_COST_ID_S.NEXTVAL,
1186: cmpnt_cost = r_cost_detail.cmpnt_cost,
1187: burden_ind = r_cost_detail.burden_ind,

Line 1245: -- update failed, try inserting the row into cm_cmpt_dtl

1241: gmf_util.trace( ' row updated to cmpt_dtl', 0 );
1242:
1243: END IF; /* l_copy_to_upper_lvl = 1 */
1244: ELSE -- cursor not found
1245: -- update failed, try inserting the row into cm_cmpt_dtl
1246: RAISE e_insert_row;
1247: END IF; -- if row is found in target period
1248:
1249: l_cost_rows_upd := l_cost_rows_upd + 1;

Line 1263: cm_cmpt_dtl(

1259: CLOSE c_updins_cc_id;
1260: END IF;
1261: -- Attempt to insert the row
1262: INSERT INTO
1263: cm_cmpt_dtl(
1264: cmpntcost_id,
1265: inventory_item_id,
1266: organization_id,
1267: cost_cmpntcls_id,

Line 1477: pi_inventory_item_id IN cm_cmpt_dtl.inventory_item_id%TYPE,

1473: *
1474: ******************************************************************************/
1475:
1476: PROCEDURE delete_item_costs(
1477: pi_inventory_item_id IN cm_cmpt_dtl.inventory_item_id%TYPE,
1478: pi_organization_id IN cm_cmpt_dtl.organization_id%TYPE,
1479: pi_calendar_code IN cm_cmpt_dtl.calendar_code%TYPE,
1480: pi_period_id IN cm_cmpt_dtl.period_id%TYPE,
1481: pi_cost_type_id IN cm_cmpt_dtl.cost_type_id%TYPE

Line 1478: pi_organization_id IN cm_cmpt_dtl.organization_id%TYPE,

1474: ******************************************************************************/
1475:
1476: PROCEDURE delete_item_costs(
1477: pi_inventory_item_id IN cm_cmpt_dtl.inventory_item_id%TYPE,
1478: pi_organization_id IN cm_cmpt_dtl.organization_id%TYPE,
1479: pi_calendar_code IN cm_cmpt_dtl.calendar_code%TYPE,
1480: pi_period_id IN cm_cmpt_dtl.period_id%TYPE,
1481: pi_cost_type_id IN cm_cmpt_dtl.cost_type_id%TYPE
1482: )

Line 1479: pi_calendar_code IN cm_cmpt_dtl.calendar_code%TYPE,

1475:
1476: PROCEDURE delete_item_costs(
1477: pi_inventory_item_id IN cm_cmpt_dtl.inventory_item_id%TYPE,
1478: pi_organization_id IN cm_cmpt_dtl.organization_id%TYPE,
1479: pi_calendar_code IN cm_cmpt_dtl.calendar_code%TYPE,
1480: pi_period_id IN cm_cmpt_dtl.period_id%TYPE,
1481: pi_cost_type_id IN cm_cmpt_dtl.cost_type_id%TYPE
1482: )
1483: IS

Line 1480: pi_period_id IN cm_cmpt_dtl.period_id%TYPE,

1476: PROCEDURE delete_item_costs(
1477: pi_inventory_item_id IN cm_cmpt_dtl.inventory_item_id%TYPE,
1478: pi_organization_id IN cm_cmpt_dtl.organization_id%TYPE,
1479: pi_calendar_code IN cm_cmpt_dtl.calendar_code%TYPE,
1480: pi_period_id IN cm_cmpt_dtl.period_id%TYPE,
1481: pi_cost_type_id IN cm_cmpt_dtl.cost_type_id%TYPE
1482: )
1483: IS
1484: CURSOR c_cc_id(

Line 1481: pi_cost_type_id IN cm_cmpt_dtl.cost_type_id%TYPE

1477: pi_inventory_item_id IN cm_cmpt_dtl.inventory_item_id%TYPE,
1478: pi_organization_id IN cm_cmpt_dtl.organization_id%TYPE,
1479: pi_calendar_code IN cm_cmpt_dtl.calendar_code%TYPE,
1480: pi_period_id IN cm_cmpt_dtl.period_id%TYPE,
1481: pi_cost_type_id IN cm_cmpt_dtl.cost_type_id%TYPE
1482: )
1483: IS
1484: CURSOR c_cc_id(
1485: p_inventory_item_id IN cm_cmpt_dtl.inventory_item_id%TYPE,

Line 1485: p_inventory_item_id IN cm_cmpt_dtl.inventory_item_id%TYPE,

1481: pi_cost_type_id IN cm_cmpt_dtl.cost_type_id%TYPE
1482: )
1483: IS
1484: CURSOR c_cc_id(
1485: p_inventory_item_id IN cm_cmpt_dtl.inventory_item_id%TYPE,
1486: p_organization_id IN cm_cmpt_dtl.organization_id%TYPE,
1487: p_calendar_code IN cm_cmpt_dtl.calendar_code%TYPE,
1488: p_period_id IN cm_cmpt_dtl.period_id%TYPE,
1489: p_cost_type_id IN cm_cmpt_dtl.cost_type_id%TYPE

Line 1486: p_organization_id IN cm_cmpt_dtl.organization_id%TYPE,

1482: )
1483: IS
1484: CURSOR c_cc_id(
1485: p_inventory_item_id IN cm_cmpt_dtl.inventory_item_id%TYPE,
1486: p_organization_id IN cm_cmpt_dtl.organization_id%TYPE,
1487: p_calendar_code IN cm_cmpt_dtl.calendar_code%TYPE,
1488: p_period_id IN cm_cmpt_dtl.period_id%TYPE,
1489: p_cost_type_id IN cm_cmpt_dtl.cost_type_id%TYPE
1490: )

Line 1487: p_calendar_code IN cm_cmpt_dtl.calendar_code%TYPE,

1483: IS
1484: CURSOR c_cc_id(
1485: p_inventory_item_id IN cm_cmpt_dtl.inventory_item_id%TYPE,
1486: p_organization_id IN cm_cmpt_dtl.organization_id%TYPE,
1487: p_calendar_code IN cm_cmpt_dtl.calendar_code%TYPE,
1488: p_period_id IN cm_cmpt_dtl.period_id%TYPE,
1489: p_cost_type_id IN cm_cmpt_dtl.cost_type_id%TYPE
1490: )
1491: IS

Line 1488: p_period_id IN cm_cmpt_dtl.period_id%TYPE,

1484: CURSOR c_cc_id(
1485: p_inventory_item_id IN cm_cmpt_dtl.inventory_item_id%TYPE,
1486: p_organization_id IN cm_cmpt_dtl.organization_id%TYPE,
1487: p_calendar_code IN cm_cmpt_dtl.calendar_code%TYPE,
1488: p_period_id IN cm_cmpt_dtl.period_id%TYPE,
1489: p_cost_type_id IN cm_cmpt_dtl.cost_type_id%TYPE
1490: )
1491: IS
1492: SELECT

Line 1489: p_cost_type_id IN cm_cmpt_dtl.cost_type_id%TYPE

1485: p_inventory_item_id IN cm_cmpt_dtl.inventory_item_id%TYPE,
1486: p_organization_id IN cm_cmpt_dtl.organization_id%TYPE,
1487: p_calendar_code IN cm_cmpt_dtl.calendar_code%TYPE,
1488: p_period_id IN cm_cmpt_dtl.period_id%TYPE,
1489: p_cost_type_id IN cm_cmpt_dtl.cost_type_id%TYPE
1490: )
1491: IS
1492: SELECT
1493: cmpntcost_id

Line 1495: cm_cmpt_dtl

1491: IS
1492: SELECT
1493: cmpntcost_id
1494: FROM
1495: cm_cmpt_dtl
1496: WHERE
1497: inventory_item_id = p_inventory_item_id AND
1498: organization_id = p_organization_id AND
1499: period_id = p_period_id AND

Line 1546: cm_cmpt_dtl

1542: gmf_util.trace( SQL%ROWCOUNT || ' rows updated in brdn_dtl', 3 );
1543:
1544: -- Finally delete the row itself from cmpt_dtl
1545: DELETE FROM
1546: cm_cmpt_dtl
1547: WHERE CURRENT OF c_cc_id
1548: ;
1549:
1550: gmf_util.trace( SQL%ROWCOUNT || ' rows deleted from cmpt_dtl', 3 );

Line 1572: pi_inventory_item_id IN cm_cmpt_dtl.inventory_item_id%TYPE,

1568: *
1569: ******************************************************************************/
1570:
1571: FUNCTION verify_frozen_costs(
1572: pi_inventory_item_id IN cm_cmpt_dtl.inventory_item_id%TYPE,
1573: pi_organization_id IN cm_cmpt_dtl.organization_id%TYPE,
1574: pi_calendar_code IN cm_cmpt_dtl.calendar_code%TYPE,
1575: pi_period_id IN cm_cmpt_dtl.period_id%TYPE,
1576: pi_cost_type_id IN cm_cmpt_dtl.cost_type_id%TYPE

Line 1573: pi_organization_id IN cm_cmpt_dtl.organization_id%TYPE,

1569: ******************************************************************************/
1570:
1571: FUNCTION verify_frozen_costs(
1572: pi_inventory_item_id IN cm_cmpt_dtl.inventory_item_id%TYPE,
1573: pi_organization_id IN cm_cmpt_dtl.organization_id%TYPE,
1574: pi_calendar_code IN cm_cmpt_dtl.calendar_code%TYPE,
1575: pi_period_id IN cm_cmpt_dtl.period_id%TYPE,
1576: pi_cost_type_id IN cm_cmpt_dtl.cost_type_id%TYPE
1577: )

Line 1574: pi_calendar_code IN cm_cmpt_dtl.calendar_code%TYPE,

1570:
1571: FUNCTION verify_frozen_costs(
1572: pi_inventory_item_id IN cm_cmpt_dtl.inventory_item_id%TYPE,
1573: pi_organization_id IN cm_cmpt_dtl.organization_id%TYPE,
1574: pi_calendar_code IN cm_cmpt_dtl.calendar_code%TYPE,
1575: pi_period_id IN cm_cmpt_dtl.period_id%TYPE,
1576: pi_cost_type_id IN cm_cmpt_dtl.cost_type_id%TYPE
1577: )
1578: RETURN NUMBER IS

Line 1575: pi_period_id IN cm_cmpt_dtl.period_id%TYPE,

1571: FUNCTION verify_frozen_costs(
1572: pi_inventory_item_id IN cm_cmpt_dtl.inventory_item_id%TYPE,
1573: pi_organization_id IN cm_cmpt_dtl.organization_id%TYPE,
1574: pi_calendar_code IN cm_cmpt_dtl.calendar_code%TYPE,
1575: pi_period_id IN cm_cmpt_dtl.period_id%TYPE,
1576: pi_cost_type_id IN cm_cmpt_dtl.cost_type_id%TYPE
1577: )
1578: RETURN NUMBER IS
1579:

Line 1576: pi_cost_type_id IN cm_cmpt_dtl.cost_type_id%TYPE

1572: pi_inventory_item_id IN cm_cmpt_dtl.inventory_item_id%TYPE,
1573: pi_organization_id IN cm_cmpt_dtl.organization_id%TYPE,
1574: pi_calendar_code IN cm_cmpt_dtl.calendar_code%TYPE,
1575: pi_period_id IN cm_cmpt_dtl.period_id%TYPE,
1576: pi_cost_type_id IN cm_cmpt_dtl.cost_type_id%TYPE
1577: )
1578: RETURN NUMBER IS
1579:
1580: l_frozen_ind NUMBER;

Line 1587: cm_cmpt_dtl

1583:
1584: l_frozen_ind := 0;
1585: SELECT nvl(max(rollover_ind),0) INTO l_frozen_ind
1586: FROM
1587: cm_cmpt_dtl
1588: WHERE period_id = pi_period_id AND
1589: cost_type_id = pi_cost_type_id AND
1590: organization_id = pi_organization_id AND
1591: inventory_item_id = pi_inventory_item_id

Line 1650: FUNCTION check_rec_infrozen_period(p_organization_id cm_cmpt_dtl.organization_id%TYPE,

1646: * HISTORY
1647: * 24-Apr-2007 pmarada, created for bug 5672543
1648: *
1649: ******************************************************************************/
1650: FUNCTION check_rec_infrozen_period(p_organization_id cm_cmpt_dtl.organization_id%TYPE,
1651: p_inventory_item_id cm_cmpt_dtl.inventory_item_id%TYPE,
1652: p_period_id cm_cmpt_dtl.period_id%TYPE,
1653: p_cost_type_id cm_cmpt_dtl.cost_type_id%TYPE
1654: )

Line 1651: p_inventory_item_id cm_cmpt_dtl.inventory_item_id%TYPE,

1647: * 24-Apr-2007 pmarada, created for bug 5672543
1648: *
1649: ******************************************************************************/
1650: FUNCTION check_rec_infrozen_period(p_organization_id cm_cmpt_dtl.organization_id%TYPE,
1651: p_inventory_item_id cm_cmpt_dtl.inventory_item_id%TYPE,
1652: p_period_id cm_cmpt_dtl.period_id%TYPE,
1653: p_cost_type_id cm_cmpt_dtl.cost_type_id%TYPE
1654: )
1655: RETURN BOOLEAN IS

Line 1652: p_period_id cm_cmpt_dtl.period_id%TYPE,

1648: *
1649: ******************************************************************************/
1650: FUNCTION check_rec_infrozen_period(p_organization_id cm_cmpt_dtl.organization_id%TYPE,
1651: p_inventory_item_id cm_cmpt_dtl.inventory_item_id%TYPE,
1652: p_period_id cm_cmpt_dtl.period_id%TYPE,
1653: p_cost_type_id cm_cmpt_dtl.cost_type_id%TYPE
1654: )
1655: RETURN BOOLEAN IS
1656:

Line 1653: p_cost_type_id cm_cmpt_dtl.cost_type_id%TYPE

1649: ******************************************************************************/
1650: FUNCTION check_rec_infrozen_period(p_organization_id cm_cmpt_dtl.organization_id%TYPE,
1651: p_inventory_item_id cm_cmpt_dtl.inventory_item_id%TYPE,
1652: p_period_id cm_cmpt_dtl.period_id%TYPE,
1653: p_cost_type_id cm_cmpt_dtl.cost_type_id%TYPE
1654: )
1655: RETURN BOOLEAN IS
1656:
1657: CURSOR cur_check_rec (cp_organization_id cm_cmpt_dtl.organization_id%TYPE,

Line 1657: CURSOR cur_check_rec (cp_organization_id cm_cmpt_dtl.organization_id%TYPE,

1653: p_cost_type_id cm_cmpt_dtl.cost_type_id%TYPE
1654: )
1655: RETURN BOOLEAN IS
1656:
1657: CURSOR cur_check_rec (cp_organization_id cm_cmpt_dtl.organization_id%TYPE,
1658: cp_inventory_item_id cm_cmpt_dtl.inventory_item_id%TYPE,
1659: cp_period_id cm_cmpt_dtl.period_id%TYPE,
1660: cp_cost_type_id cm_cmpt_dtl.cost_type_id%TYPE) IS
1661: SELECT 'x' FROM cm_cmpt_dtl

Line 1658: cp_inventory_item_id cm_cmpt_dtl.inventory_item_id%TYPE,

1654: )
1655: RETURN BOOLEAN IS
1656:
1657: CURSOR cur_check_rec (cp_organization_id cm_cmpt_dtl.organization_id%TYPE,
1658: cp_inventory_item_id cm_cmpt_dtl.inventory_item_id%TYPE,
1659: cp_period_id cm_cmpt_dtl.period_id%TYPE,
1660: cp_cost_type_id cm_cmpt_dtl.cost_type_id%TYPE) IS
1661: SELECT 'x' FROM cm_cmpt_dtl
1662: WHERE organization_id = cp_organization_id

Line 1659: cp_period_id cm_cmpt_dtl.period_id%TYPE,

1655: RETURN BOOLEAN IS
1656:
1657: CURSOR cur_check_rec (cp_organization_id cm_cmpt_dtl.organization_id%TYPE,
1658: cp_inventory_item_id cm_cmpt_dtl.inventory_item_id%TYPE,
1659: cp_period_id cm_cmpt_dtl.period_id%TYPE,
1660: cp_cost_type_id cm_cmpt_dtl.cost_type_id%TYPE) IS
1661: SELECT 'x' FROM cm_cmpt_dtl
1662: WHERE organization_id = cp_organization_id
1663: AND inventory_item_id = cp_inventory_item_id

Line 1660: cp_cost_type_id cm_cmpt_dtl.cost_type_id%TYPE) IS

1656:
1657: CURSOR cur_check_rec (cp_organization_id cm_cmpt_dtl.organization_id%TYPE,
1658: cp_inventory_item_id cm_cmpt_dtl.inventory_item_id%TYPE,
1659: cp_period_id cm_cmpt_dtl.period_id%TYPE,
1660: cp_cost_type_id cm_cmpt_dtl.cost_type_id%TYPE) IS
1661: SELECT 'x' FROM cm_cmpt_dtl
1662: WHERE organization_id = cp_organization_id
1663: AND inventory_item_id = cp_inventory_item_id
1664: AND period_id = cp_period_id

Line 1661: SELECT 'x' FROM cm_cmpt_dtl

1657: CURSOR cur_check_rec (cp_organization_id cm_cmpt_dtl.organization_id%TYPE,
1658: cp_inventory_item_id cm_cmpt_dtl.inventory_item_id%TYPE,
1659: cp_period_id cm_cmpt_dtl.period_id%TYPE,
1660: cp_cost_type_id cm_cmpt_dtl.cost_type_id%TYPE) IS
1661: SELECT 'x' FROM cm_cmpt_dtl
1662: WHERE organization_id = cp_organization_id
1663: AND inventory_item_id = cp_inventory_item_id
1664: AND period_id = cp_period_id
1665: AND cost_type_id = cp_cost_type_id;

Line 1714: pi_organization_id_from IN cm_cmpt_dtl.organization_id%TYPE,

1710: PROCEDURE copy_burden_cost
1711: (
1712: po_errbuf OUT NOCOPY VARCHAR2,
1713: po_retcode OUT NOCOPY VARCHAR2,
1714: pi_organization_id_from IN cm_cmpt_dtl.organization_id%TYPE,
1715: pi_calendar_code_from IN cm_cmpt_dtl.calendar_code%TYPE,
1716: pi_period_code_from IN cm_cmpt_dtl.period_code%TYPE,
1717: pi_cost_type_id_from IN cm_cmpt_dtl.cost_type_id%TYPE,
1718: pi_organization_id_to IN cm_cmpt_dtl.organization_id%TYPE,

Line 1715: pi_calendar_code_from IN cm_cmpt_dtl.calendar_code%TYPE,

1711: (
1712: po_errbuf OUT NOCOPY VARCHAR2,
1713: po_retcode OUT NOCOPY VARCHAR2,
1714: pi_organization_id_from IN cm_cmpt_dtl.organization_id%TYPE,
1715: pi_calendar_code_from IN cm_cmpt_dtl.calendar_code%TYPE,
1716: pi_period_code_from IN cm_cmpt_dtl.period_code%TYPE,
1717: pi_cost_type_id_from IN cm_cmpt_dtl.cost_type_id%TYPE,
1718: pi_organization_id_to IN cm_cmpt_dtl.organization_id%TYPE,
1719: pi_calendar_code_to IN cm_cmpt_dtl.calendar_code%TYPE,

Line 1716: pi_period_code_from IN cm_cmpt_dtl.period_code%TYPE,

1712: po_errbuf OUT NOCOPY VARCHAR2,
1713: po_retcode OUT NOCOPY VARCHAR2,
1714: pi_organization_id_from IN cm_cmpt_dtl.organization_id%TYPE,
1715: pi_calendar_code_from IN cm_cmpt_dtl.calendar_code%TYPE,
1716: pi_period_code_from IN cm_cmpt_dtl.period_code%TYPE,
1717: pi_cost_type_id_from IN cm_cmpt_dtl.cost_type_id%TYPE,
1718: pi_organization_id_to IN cm_cmpt_dtl.organization_id%TYPE,
1719: pi_calendar_code_to IN cm_cmpt_dtl.calendar_code%TYPE,
1720: pi_period_code_to IN cm_cmpt_dtl.period_code%TYPE,

Line 1717: pi_cost_type_id_from IN cm_cmpt_dtl.cost_type_id%TYPE,

1713: po_retcode OUT NOCOPY VARCHAR2,
1714: pi_organization_id_from IN cm_cmpt_dtl.organization_id%TYPE,
1715: pi_calendar_code_from IN cm_cmpt_dtl.calendar_code%TYPE,
1716: pi_period_code_from IN cm_cmpt_dtl.period_code%TYPE,
1717: pi_cost_type_id_from IN cm_cmpt_dtl.cost_type_id%TYPE,
1718: pi_organization_id_to IN cm_cmpt_dtl.organization_id%TYPE,
1719: pi_calendar_code_to IN cm_cmpt_dtl.calendar_code%TYPE,
1720: pi_period_code_to IN cm_cmpt_dtl.period_code%TYPE,
1721: pi_cost_type_id_to IN cm_cmpt_dtl.cost_type_id%TYPE,

Line 1718: pi_organization_id_to IN cm_cmpt_dtl.organization_id%TYPE,

1714: pi_organization_id_from IN cm_cmpt_dtl.organization_id%TYPE,
1715: pi_calendar_code_from IN cm_cmpt_dtl.calendar_code%TYPE,
1716: pi_period_code_from IN cm_cmpt_dtl.period_code%TYPE,
1717: pi_cost_type_id_from IN cm_cmpt_dtl.cost_type_id%TYPE,
1718: pi_organization_id_to IN cm_cmpt_dtl.organization_id%TYPE,
1719: pi_calendar_code_to IN cm_cmpt_dtl.calendar_code%TYPE,
1720: pi_period_code_to IN cm_cmpt_dtl.period_code%TYPE,
1721: pi_cost_type_id_to IN cm_cmpt_dtl.cost_type_id%TYPE,
1722: pi_item_from IN mtl_item_flexfields.item_number%TYPE,

Line 1719: pi_calendar_code_to IN cm_cmpt_dtl.calendar_code%TYPE,

1715: pi_calendar_code_from IN cm_cmpt_dtl.calendar_code%TYPE,
1716: pi_period_code_from IN cm_cmpt_dtl.period_code%TYPE,
1717: pi_cost_type_id_from IN cm_cmpt_dtl.cost_type_id%TYPE,
1718: pi_organization_id_to IN cm_cmpt_dtl.organization_id%TYPE,
1719: pi_calendar_code_to IN cm_cmpt_dtl.calendar_code%TYPE,
1720: pi_period_code_to IN cm_cmpt_dtl.period_code%TYPE,
1721: pi_cost_type_id_to IN cm_cmpt_dtl.cost_type_id%TYPE,
1722: pi_item_from IN mtl_item_flexfields.item_number%TYPE,
1723: pi_item_to IN mtl_item_flexfields.item_number%TYPE,

Line 1720: pi_period_code_to IN cm_cmpt_dtl.period_code%TYPE,

1716: pi_period_code_from IN cm_cmpt_dtl.period_code%TYPE,
1717: pi_cost_type_id_from IN cm_cmpt_dtl.cost_type_id%TYPE,
1718: pi_organization_id_to IN cm_cmpt_dtl.organization_id%TYPE,
1719: pi_calendar_code_to IN cm_cmpt_dtl.calendar_code%TYPE,
1720: pi_period_code_to IN cm_cmpt_dtl.period_code%TYPE,
1721: pi_cost_type_id_to IN cm_cmpt_dtl.cost_type_id%TYPE,
1722: pi_item_from IN mtl_item_flexfields.item_number%TYPE,
1723: pi_item_to IN mtl_item_flexfields.item_number%TYPE,
1724: pi_itemcc_from IN mtl_categories_b_kfv.concatenated_segments%TYPE,

Line 1721: pi_cost_type_id_to IN cm_cmpt_dtl.cost_type_id%TYPE,

1717: pi_cost_type_id_from IN cm_cmpt_dtl.cost_type_id%TYPE,
1718: pi_organization_id_to IN cm_cmpt_dtl.organization_id%TYPE,
1719: pi_calendar_code_to IN cm_cmpt_dtl.calendar_code%TYPE,
1720: pi_period_code_to IN cm_cmpt_dtl.period_code%TYPE,
1721: pi_cost_type_id_to IN cm_cmpt_dtl.cost_type_id%TYPE,
1722: pi_item_from IN mtl_item_flexfields.item_number%TYPE,
1723: pi_item_to IN mtl_item_flexfields.item_number%TYPE,
1724: pi_itemcc_from IN mtl_categories_b_kfv.concatenated_segments%TYPE,
1725: pi_itemcc_to IN mtl_categories_b_kfv.concatenated_segments%TYPE,

Line 1727: pi_all_periods_from IN cm_cmpt_dtl.period_code%TYPE,

1723: pi_item_to IN mtl_item_flexfields.item_number%TYPE,
1724: pi_itemcc_from IN mtl_categories_b_kfv.concatenated_segments%TYPE,
1725: pi_itemcc_to IN mtl_categories_b_kfv.concatenated_segments%TYPE,
1726: pi_rem_repl IN VARCHAR2,
1727: pi_all_periods_from IN cm_cmpt_dtl.period_code%TYPE,
1728: pi_all_periods_to IN cm_cmpt_dtl.period_code%TYPE,
1729: pi_all_org_id IN gmf_legal_entities.legal_entity_id%TYPE
1730: )
1731:

Line 1728: pi_all_periods_to IN cm_cmpt_dtl.period_code%TYPE,

1724: pi_itemcc_from IN mtl_categories_b_kfv.concatenated_segments%TYPE,
1725: pi_itemcc_to IN mtl_categories_b_kfv.concatenated_segments%TYPE,
1726: pi_rem_repl IN VARCHAR2,
1727: pi_all_periods_from IN cm_cmpt_dtl.period_code%TYPE,
1728: pi_all_periods_to IN cm_cmpt_dtl.period_code%TYPE,
1729: pi_all_org_id IN gmf_legal_entities.legal_entity_id%TYPE
1730: )
1731:
1732: IS

Line 1902: pi_organization_id_from IN cm_cmpt_dtl.organization_id%TYPE,

1898: ******************************************************************************/
1899:
1900:
1901: PROCEDURE copy_burden_dtl(
1902: pi_organization_id_from IN cm_cmpt_dtl.organization_id%TYPE,
1903: pi_calendar_code_from IN cm_cmpt_dtl.calendar_code%TYPE,
1904: pi_period_code_from IN cm_cmpt_dtl.period_code%TYPE,
1905: pi_cost_type_id_from IN cm_cmpt_dtl.cost_type_id%TYPE,
1906: pi_organization_id_to IN cm_cmpt_dtl.organization_id%TYPE,

Line 1903: pi_calendar_code_from IN cm_cmpt_dtl.calendar_code%TYPE,

1899:
1900:
1901: PROCEDURE copy_burden_dtl(
1902: pi_organization_id_from IN cm_cmpt_dtl.organization_id%TYPE,
1903: pi_calendar_code_from IN cm_cmpt_dtl.calendar_code%TYPE,
1904: pi_period_code_from IN cm_cmpt_dtl.period_code%TYPE,
1905: pi_cost_type_id_from IN cm_cmpt_dtl.cost_type_id%TYPE,
1906: pi_organization_id_to IN cm_cmpt_dtl.organization_id%TYPE,
1907: pi_calendar_code_to IN cm_cmpt_dtl.calendar_code%TYPE,

Line 1904: pi_period_code_from IN cm_cmpt_dtl.period_code%TYPE,

1900:
1901: PROCEDURE copy_burden_dtl(
1902: pi_organization_id_from IN cm_cmpt_dtl.organization_id%TYPE,
1903: pi_calendar_code_from IN cm_cmpt_dtl.calendar_code%TYPE,
1904: pi_period_code_from IN cm_cmpt_dtl.period_code%TYPE,
1905: pi_cost_type_id_from IN cm_cmpt_dtl.cost_type_id%TYPE,
1906: pi_organization_id_to IN cm_cmpt_dtl.organization_id%TYPE,
1907: pi_calendar_code_to IN cm_cmpt_dtl.calendar_code%TYPE,
1908: pi_period_code_to IN cm_cmpt_dtl.period_code%TYPE,

Line 1905: pi_cost_type_id_from IN cm_cmpt_dtl.cost_type_id%TYPE,

1901: PROCEDURE copy_burden_dtl(
1902: pi_organization_id_from IN cm_cmpt_dtl.organization_id%TYPE,
1903: pi_calendar_code_from IN cm_cmpt_dtl.calendar_code%TYPE,
1904: pi_period_code_from IN cm_cmpt_dtl.period_code%TYPE,
1905: pi_cost_type_id_from IN cm_cmpt_dtl.cost_type_id%TYPE,
1906: pi_organization_id_to IN cm_cmpt_dtl.organization_id%TYPE,
1907: pi_calendar_code_to IN cm_cmpt_dtl.calendar_code%TYPE,
1908: pi_period_code_to IN cm_cmpt_dtl.period_code%TYPE,
1909: pi_cost_type_id_to IN cm_cmpt_dtl.cost_type_id%TYPE,

Line 1906: pi_organization_id_to IN cm_cmpt_dtl.organization_id%TYPE,

1902: pi_organization_id_from IN cm_cmpt_dtl.organization_id%TYPE,
1903: pi_calendar_code_from IN cm_cmpt_dtl.calendar_code%TYPE,
1904: pi_period_code_from IN cm_cmpt_dtl.period_code%TYPE,
1905: pi_cost_type_id_from IN cm_cmpt_dtl.cost_type_id%TYPE,
1906: pi_organization_id_to IN cm_cmpt_dtl.organization_id%TYPE,
1907: pi_calendar_code_to IN cm_cmpt_dtl.calendar_code%TYPE,
1908: pi_period_code_to IN cm_cmpt_dtl.period_code%TYPE,
1909: pi_cost_type_id_to IN cm_cmpt_dtl.cost_type_id%TYPE,
1910: pi_range_type IN NUMBER,

Line 1907: pi_calendar_code_to IN cm_cmpt_dtl.calendar_code%TYPE,

1903: pi_calendar_code_from IN cm_cmpt_dtl.calendar_code%TYPE,
1904: pi_period_code_from IN cm_cmpt_dtl.period_code%TYPE,
1905: pi_cost_type_id_from IN cm_cmpt_dtl.cost_type_id%TYPE,
1906: pi_organization_id_to IN cm_cmpt_dtl.organization_id%TYPE,
1907: pi_calendar_code_to IN cm_cmpt_dtl.calendar_code%TYPE,
1908: pi_period_code_to IN cm_cmpt_dtl.period_code%TYPE,
1909: pi_cost_type_id_to IN cm_cmpt_dtl.cost_type_id%TYPE,
1910: pi_range_type IN NUMBER,
1911: pi_from_range IN VARCHAR2,

Line 1908: pi_period_code_to IN cm_cmpt_dtl.period_code%TYPE,

1904: pi_period_code_from IN cm_cmpt_dtl.period_code%TYPE,
1905: pi_cost_type_id_from IN cm_cmpt_dtl.cost_type_id%TYPE,
1906: pi_organization_id_to IN cm_cmpt_dtl.organization_id%TYPE,
1907: pi_calendar_code_to IN cm_cmpt_dtl.calendar_code%TYPE,
1908: pi_period_code_to IN cm_cmpt_dtl.period_code%TYPE,
1909: pi_cost_type_id_to IN cm_cmpt_dtl.cost_type_id%TYPE,
1910: pi_range_type IN NUMBER,
1911: pi_from_range IN VARCHAR2,
1912: pi_to_range IN VARCHAR2,

Line 1909: pi_cost_type_id_to IN cm_cmpt_dtl.cost_type_id%TYPE,

1905: pi_cost_type_id_from IN cm_cmpt_dtl.cost_type_id%TYPE,
1906: pi_organization_id_to IN cm_cmpt_dtl.organization_id%TYPE,
1907: pi_calendar_code_to IN cm_cmpt_dtl.calendar_code%TYPE,
1908: pi_period_code_to IN cm_cmpt_dtl.period_code%TYPE,
1909: pi_cost_type_id_to IN cm_cmpt_dtl.cost_type_id%TYPE,
1910: pi_range_type IN NUMBER,
1911: pi_from_range IN VARCHAR2,
1912: pi_to_range IN VARCHAR2,
1913: pi_rem_repl IN NUMBER,

Line 1914: pi_all_periods_from IN cm_cmpt_dtl.period_code%TYPE,

1910: pi_range_type IN NUMBER,
1911: pi_from_range IN VARCHAR2,
1912: pi_to_range IN VARCHAR2,
1913: pi_rem_repl IN NUMBER,
1914: pi_all_periods_from IN cm_cmpt_dtl.period_code%TYPE,
1915: pi_all_periods_to IN cm_cmpt_dtl.period_code%TYPE,
1916: pi_all_org_id IN gmf_legal_entities.legal_entity_id%TYPE
1917: )
1918:

Line 1915: pi_all_periods_to IN cm_cmpt_dtl.period_code%TYPE,

1911: pi_from_range IN VARCHAR2,
1912: pi_to_range IN VARCHAR2,
1913: pi_rem_repl IN NUMBER,
1914: pi_all_periods_from IN cm_cmpt_dtl.period_code%TYPE,
1915: pi_all_periods_to IN cm_cmpt_dtl.period_code%TYPE,
1916: pi_all_org_id IN gmf_legal_entities.legal_entity_id%TYPE
1917: )
1918:
1919: IS

Line 1955: l_organization_id_to cm_cmpt_dtl.organization_id%TYPE;

1951: l_brdn_rows NUMBER;
1952: l_brdn_rows_upd NUMBER;
1953: l_brdn_rows_ins NUMBER;
1954:
1955: l_organization_id_to cm_cmpt_dtl.organization_id%TYPE;
1956:
1957: pi_period_id_to NUMBER;
1958: pi_period_id_from NUMBER;
1959: l_sql_stmt VARCHAR2(2000);

Line 2458: pi_organization_id IN cm_cmpt_dtl.organization_id%TYPE,

2454: *
2455: ******************************************************************************/
2456:
2457: PROCEDURE delete_burden_costs(
2458: pi_organization_id IN cm_cmpt_dtl.organization_id%TYPE,
2459: pi_period_id IN cm_cmpt_dtl.period_id%TYPE,
2460: pi_cost_type_id IN cm_cmpt_dtl.cost_type_id%TYPE,
2461: pi_range_type IN NUMBER,
2462: pi_from_range IN VARCHAR2,

Line 2459: pi_period_id IN cm_cmpt_dtl.period_id%TYPE,

2455: ******************************************************************************/
2456:
2457: PROCEDURE delete_burden_costs(
2458: pi_organization_id IN cm_cmpt_dtl.organization_id%TYPE,
2459: pi_period_id IN cm_cmpt_dtl.period_id%TYPE,
2460: pi_cost_type_id IN cm_cmpt_dtl.cost_type_id%TYPE,
2461: pi_range_type IN NUMBER,
2462: pi_from_range IN VARCHAR2,
2463: pi_to_range IN VARCHAR2

Line 2460: pi_cost_type_id IN cm_cmpt_dtl.cost_type_id%TYPE,

2456:
2457: PROCEDURE delete_burden_costs(
2458: pi_organization_id IN cm_cmpt_dtl.organization_id%TYPE,
2459: pi_period_id IN cm_cmpt_dtl.period_id%TYPE,
2460: pi_cost_type_id IN cm_cmpt_dtl.cost_type_id%TYPE,
2461: pi_range_type IN NUMBER,
2462: pi_from_range IN VARCHAR2,
2463: pi_to_range IN VARCHAR2
2464: )

Line 2549: pi_inventory_item_id IN cm_cmpt_dtl.inventory_item_id%TYPE,

2545: *
2546: ******************************************************************************/
2547:
2548: FUNCTION verify_item_assigned_to_org(
2549: pi_inventory_item_id IN cm_cmpt_dtl.inventory_item_id%TYPE,
2550: pi_organization_id IN cm_cmpt_dtl.organization_id%TYPE
2551: )
2552: RETURN NUMBER IS
2553: l_assigned_ind NUMBER;

Line 2550: pi_organization_id IN cm_cmpt_dtl.organization_id%TYPE

2546: ******************************************************************************/
2547:
2548: FUNCTION verify_item_assigned_to_org(
2549: pi_inventory_item_id IN cm_cmpt_dtl.inventory_item_id%TYPE,
2550: pi_organization_id IN cm_cmpt_dtl.organization_id%TYPE
2551: )
2552: RETURN NUMBER IS
2553: l_assigned_ind NUMBER;
2554: BEGIN