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 22: * Changed cm_cmpt_dtl.calendar_code%TYPE, cm_cmpt_dtl.period_code%TYPE and cm_cmpt_dtl.period_id%TYPE to

18: * for enhancement fix related to cost rollup (Ref. Bug 2116142).
19: * 30/Oct/2002 R.Sharath Kumar Bug# 2641405
20: * Added NOCOPY hint
21: * 14-Aug-2012 Saptagirish Pabolu - Bug#14291764
22: * Changed cm_cmpt_dtl.calendar_code%TYPE, cm_cmpt_dtl.period_code%TYPE and cm_cmpt_dtl.period_id%TYPE to
23: * gmf_period_statuses.calendar_code%TYPE, gmf_period_statuses.period_code%TYPE and gmf_period_statuses.period_id%TYPE respectively.
24: ******************************************************************************/
25:
26:

Line 33: pi_organization_id_from IN cm_cmpt_dtl.organization_id%TYPE,

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

Line 36: pi_cost_type_id_from IN cm_cmpt_dtl.cost_type_id%TYPE,

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

Line 37: pi_organization_id_to IN cm_cmpt_dtl.organization_id%TYPE,

33: pi_organization_id_from IN cm_cmpt_dtl.organization_id%TYPE,
34: pi_calendar_code_from IN gmf_period_statuses.calendar_code%TYPE,
35: pi_period_code_from IN gmf_period_statuses.period_code%TYPE,
36: pi_cost_type_id_from IN cm_cmpt_dtl.cost_type_id%TYPE,
37: pi_organization_id_to IN cm_cmpt_dtl.organization_id%TYPE,
38: pi_calendar_code_to IN gmf_period_statuses.calendar_code%TYPE,
39: pi_period_code_to IN gmf_period_statuses.period_code%TYPE,
40: pi_cost_type_id_to IN cm_cmpt_dtl.cost_type_id%TYPE,
41: pi_range_type IN NUMBER,

Line 40: pi_cost_type_id_to IN cm_cmpt_dtl.cost_type_id%TYPE,

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

Line 57: pi_organization_id_from IN cm_cmpt_dtl.organization_id%TYPE,

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

Line 60: pi_cost_type_id_from IN cm_cmpt_dtl.cost_type_id%TYPE,

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

Line 61: pi_organization_id_to IN cm_cmpt_dtl.organization_id%TYPE,

57: pi_organization_id_from IN cm_cmpt_dtl.organization_id%TYPE,
58: pi_calendar_code_from IN gmf_period_statuses.calendar_code%TYPE,
59: pi_period_code_from IN gmf_period_statuses.period_code%TYPE,
60: pi_cost_type_id_from IN cm_cmpt_dtl.cost_type_id%TYPE,
61: pi_organization_id_to IN cm_cmpt_dtl.organization_id%TYPE,
62: pi_calendar_code_to IN gmf_period_statuses.calendar_code%TYPE,
63: pi_period_code_to IN gmf_period_statuses.period_code%TYPE,
64: pi_cost_type_id_to IN cm_cmpt_dtl.cost_type_id%TYPE,
65: pi_range_type IN NUMBER,

Line 64: pi_cost_type_id_to IN cm_cmpt_dtl.cost_type_id%TYPE,

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

Line 78: pi_inventory_item_id IN cm_cmpt_dtl.inventory_item_id%TYPE,

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

Line 79: pi_organization_id IN cm_cmpt_dtl.organization_id%TYPE,

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

Line 82: pi_cost_type_id IN cm_cmpt_dtl.cost_type_id%TYPE

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

Line 87: pi_inventory_item_id IN cm_cmpt_dtl.inventory_item_id%TYPE,

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

Line 88: pi_organization_id IN cm_cmpt_dtl.organization_id%TYPE,

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

Line 91: pi_cost_type_id IN cm_cmpt_dtl.cost_type_id%TYPE

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

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

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

Line 102: p_inventory_item_id cm_cmpt_dtl.inventory_item_id%TYPE,

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

Line 104: p_cost_type_id cm_cmpt_dtl.cost_type_id%TYPE)

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

Line 107: pi_inventory_item_id IN cm_cmpt_dtl.inventory_item_id%TYPE,

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

Line 108: pi_organization_id IN cm_cmpt_dtl.organization_id%TYPE

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

Line 113: pi_organization_id IN cm_cmpt_dtl.organization_id%TYPE,

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

Line 115: pi_cost_type_id IN cm_cmpt_dtl.cost_type_id%TYPE,

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

Line 166: pi_organization_id_from IN cm_cmpt_dtl.organization_id%TYPE,

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

Line 169: pi_cost_type_id_from IN cm_cmpt_dtl.cost_type_id%TYPE,

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

Line 170: pi_organization_id_to IN cm_cmpt_dtl.organization_id%TYPE,

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

Line 173: pi_cost_type_id_to IN cm_cmpt_dtl.cost_type_id%TYPE,

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

Line 444: pi_organization_id_from IN cm_cmpt_dtl.organization_id%TYPE,

440: * But New costs can be added though,
441: ******************************************************************************/
442:
443: PROCEDURE copy_cost_dtl(
444: pi_organization_id_from IN cm_cmpt_dtl.organization_id%TYPE,
445: pi_calendar_code_from IN gmf_period_statuses.calendar_code%TYPE,
446: pi_period_code_from IN gmf_period_statuses.period_code%TYPE,
447: pi_cost_type_id_from IN cm_cmpt_dtl.cost_type_id%TYPE,
448: pi_organization_id_to IN cm_cmpt_dtl.organization_id%TYPE,

Line 447: pi_cost_type_id_from IN cm_cmpt_dtl.cost_type_id%TYPE,

443: PROCEDURE copy_cost_dtl(
444: pi_organization_id_from IN cm_cmpt_dtl.organization_id%TYPE,
445: pi_calendar_code_from IN gmf_period_statuses.calendar_code%TYPE,
446: pi_period_code_from IN gmf_period_statuses.period_code%TYPE,
447: pi_cost_type_id_from IN cm_cmpt_dtl.cost_type_id%TYPE,
448: pi_organization_id_to IN cm_cmpt_dtl.organization_id%TYPE,
449: pi_calendar_code_to IN gmf_period_statuses.calendar_code%TYPE,
450: pi_period_code_to IN gmf_period_statuses.period_code%TYPE,
451: pi_cost_type_id_to IN cm_cmpt_dtl.cost_type_id%TYPE,

Line 448: pi_organization_id_to IN cm_cmpt_dtl.organization_id%TYPE,

444: pi_organization_id_from IN cm_cmpt_dtl.organization_id%TYPE,
445: pi_calendar_code_from IN gmf_period_statuses.calendar_code%TYPE,
446: pi_period_code_from IN gmf_period_statuses.period_code%TYPE,
447: pi_cost_type_id_from IN cm_cmpt_dtl.cost_type_id%TYPE,
448: pi_organization_id_to IN cm_cmpt_dtl.organization_id%TYPE,
449: pi_calendar_code_to IN gmf_period_statuses.calendar_code%TYPE,
450: pi_period_code_to IN gmf_period_statuses.period_code%TYPE,
451: pi_cost_type_id_to IN cm_cmpt_dtl.cost_type_id%TYPE,
452: pi_range_type IN NUMBER,

Line 451: pi_cost_type_id_to IN cm_cmpt_dtl.cost_type_id%TYPE,

447: pi_cost_type_id_from IN cm_cmpt_dtl.cost_type_id%TYPE,
448: pi_organization_id_to IN cm_cmpt_dtl.organization_id%TYPE,
449: pi_calendar_code_to IN gmf_period_statuses.calendar_code%TYPE,
450: pi_period_code_to IN gmf_period_statuses.period_code%TYPE,
451: pi_cost_type_id_to IN cm_cmpt_dtl.cost_type_id%TYPE,
452: pi_range_type IN NUMBER,
453: pi_from_range IN VARCHAR2,
454: pi_to_range IN VARCHAR2,
455: pi_incr_pct IN NUMBER,

Line 466: cmpntcost_id cm_cmpt_dtl.cmpntcost_id%TYPE,

462: )
463: IS
464:
465: TYPE rectyp_cost_detail IS RECORD (
466: cmpntcost_id cm_cmpt_dtl.cmpntcost_id%TYPE,
467: inventory_item_id cm_cmpt_dtl.inventory_item_id%TYPE,
468: cost_cmpntcls_id cm_cmpt_dtl.cost_cmpntcls_id%TYPE,
469: cost_analysis_code cm_cmpt_dtl.cost_analysis_code%TYPE,
470: cost_level cm_cmpt_dtl.cost_level%TYPE,

Line 467: inventory_item_id cm_cmpt_dtl.inventory_item_id%TYPE,

463: IS
464:
465: TYPE rectyp_cost_detail IS RECORD (
466: cmpntcost_id cm_cmpt_dtl.cmpntcost_id%TYPE,
467: inventory_item_id cm_cmpt_dtl.inventory_item_id%TYPE,
468: cost_cmpntcls_id cm_cmpt_dtl.cost_cmpntcls_id%TYPE,
469: cost_analysis_code cm_cmpt_dtl.cost_analysis_code%TYPE,
470: cost_level cm_cmpt_dtl.cost_level%TYPE,
471: cmpnt_cost cm_cmpt_dtl.cmpnt_cost%TYPE,

Line 468: cost_cmpntcls_id cm_cmpt_dtl.cost_cmpntcls_id%TYPE,

464:
465: TYPE rectyp_cost_detail IS RECORD (
466: cmpntcost_id cm_cmpt_dtl.cmpntcost_id%TYPE,
467: inventory_item_id cm_cmpt_dtl.inventory_item_id%TYPE,
468: cost_cmpntcls_id cm_cmpt_dtl.cost_cmpntcls_id%TYPE,
469: cost_analysis_code cm_cmpt_dtl.cost_analysis_code%TYPE,
470: cost_level cm_cmpt_dtl.cost_level%TYPE,
471: cmpnt_cost cm_cmpt_dtl.cmpnt_cost%TYPE,
472: burden_ind cm_cmpt_dtl.burden_ind%TYPE,

Line 469: cost_analysis_code cm_cmpt_dtl.cost_analysis_code%TYPE,

465: TYPE rectyp_cost_detail IS RECORD (
466: cmpntcost_id cm_cmpt_dtl.cmpntcost_id%TYPE,
467: inventory_item_id cm_cmpt_dtl.inventory_item_id%TYPE,
468: cost_cmpntcls_id cm_cmpt_dtl.cost_cmpntcls_id%TYPE,
469: cost_analysis_code cm_cmpt_dtl.cost_analysis_code%TYPE,
470: cost_level cm_cmpt_dtl.cost_level%TYPE,
471: cmpnt_cost cm_cmpt_dtl.cmpnt_cost%TYPE,
472: burden_ind cm_cmpt_dtl.burden_ind%TYPE,
473: total_qty cm_cmpt_dtl.total_qty%TYPE,

Line 470: cost_level cm_cmpt_dtl.cost_level%TYPE,

466: cmpntcost_id cm_cmpt_dtl.cmpntcost_id%TYPE,
467: inventory_item_id cm_cmpt_dtl.inventory_item_id%TYPE,
468: cost_cmpntcls_id cm_cmpt_dtl.cost_cmpntcls_id%TYPE,
469: cost_analysis_code cm_cmpt_dtl.cost_analysis_code%TYPE,
470: cost_level cm_cmpt_dtl.cost_level%TYPE,
471: cmpnt_cost cm_cmpt_dtl.cmpnt_cost%TYPE,
472: burden_ind cm_cmpt_dtl.burden_ind%TYPE,
473: total_qty cm_cmpt_dtl.total_qty%TYPE,
474: rmcalc_type cm_cmpt_dtl.rmcalc_type%TYPE,

Line 471: cmpnt_cost cm_cmpt_dtl.cmpnt_cost%TYPE,

467: inventory_item_id cm_cmpt_dtl.inventory_item_id%TYPE,
468: cost_cmpntcls_id cm_cmpt_dtl.cost_cmpntcls_id%TYPE,
469: cost_analysis_code cm_cmpt_dtl.cost_analysis_code%TYPE,
470: cost_level cm_cmpt_dtl.cost_level%TYPE,
471: cmpnt_cost cm_cmpt_dtl.cmpnt_cost%TYPE,
472: burden_ind cm_cmpt_dtl.burden_ind%TYPE,
473: total_qty cm_cmpt_dtl.total_qty%TYPE,
474: rmcalc_type cm_cmpt_dtl.rmcalc_type%TYPE,
475: fmeff_id cm_cmpt_dtl.fmeff_id%TYPE,

Line 472: burden_ind cm_cmpt_dtl.burden_ind%TYPE,

468: cost_cmpntcls_id cm_cmpt_dtl.cost_cmpntcls_id%TYPE,
469: cost_analysis_code cm_cmpt_dtl.cost_analysis_code%TYPE,
470: cost_level cm_cmpt_dtl.cost_level%TYPE,
471: cmpnt_cost cm_cmpt_dtl.cmpnt_cost%TYPE,
472: burden_ind cm_cmpt_dtl.burden_ind%TYPE,
473: total_qty cm_cmpt_dtl.total_qty%TYPE,
474: rmcalc_type cm_cmpt_dtl.rmcalc_type%TYPE,
475: fmeff_id cm_cmpt_dtl.fmeff_id%TYPE,
476: costcalc_orig cm_cmpt_dtl.costcalc_orig%TYPE, --B16103415

Line 473: total_qty cm_cmpt_dtl.total_qty%TYPE,

469: cost_analysis_code cm_cmpt_dtl.cost_analysis_code%TYPE,
470: cost_level cm_cmpt_dtl.cost_level%TYPE,
471: cmpnt_cost cm_cmpt_dtl.cmpnt_cost%TYPE,
472: burden_ind cm_cmpt_dtl.burden_ind%TYPE,
473: total_qty cm_cmpt_dtl.total_qty%TYPE,
474: rmcalc_type cm_cmpt_dtl.rmcalc_type%TYPE,
475: fmeff_id cm_cmpt_dtl.fmeff_id%TYPE,
476: costcalc_orig cm_cmpt_dtl.costcalc_orig%TYPE, --B16103415
477: text_code cm_cmpt_dtl.text_code%TYPE,

Line 474: rmcalc_type cm_cmpt_dtl.rmcalc_type%TYPE,

470: cost_level cm_cmpt_dtl.cost_level%TYPE,
471: cmpnt_cost cm_cmpt_dtl.cmpnt_cost%TYPE,
472: burden_ind cm_cmpt_dtl.burden_ind%TYPE,
473: total_qty cm_cmpt_dtl.total_qty%TYPE,
474: rmcalc_type cm_cmpt_dtl.rmcalc_type%TYPE,
475: fmeff_id cm_cmpt_dtl.fmeff_id%TYPE,
476: costcalc_orig cm_cmpt_dtl.costcalc_orig%TYPE, --B16103415
477: text_code cm_cmpt_dtl.text_code%TYPE,
478: attribute1 cm_cmpt_dtl.attribute1%TYPE,

Line 475: fmeff_id cm_cmpt_dtl.fmeff_id%TYPE,

471: cmpnt_cost cm_cmpt_dtl.cmpnt_cost%TYPE,
472: burden_ind cm_cmpt_dtl.burden_ind%TYPE,
473: total_qty cm_cmpt_dtl.total_qty%TYPE,
474: rmcalc_type cm_cmpt_dtl.rmcalc_type%TYPE,
475: fmeff_id cm_cmpt_dtl.fmeff_id%TYPE,
476: costcalc_orig cm_cmpt_dtl.costcalc_orig%TYPE, --B16103415
477: text_code cm_cmpt_dtl.text_code%TYPE,
478: attribute1 cm_cmpt_dtl.attribute1%TYPE,
479: attribute2 cm_cmpt_dtl.attribute2%TYPE,

Line 476: costcalc_orig cm_cmpt_dtl.costcalc_orig%TYPE, --B16103415

472: burden_ind cm_cmpt_dtl.burden_ind%TYPE,
473: total_qty cm_cmpt_dtl.total_qty%TYPE,
474: rmcalc_type cm_cmpt_dtl.rmcalc_type%TYPE,
475: fmeff_id cm_cmpt_dtl.fmeff_id%TYPE,
476: costcalc_orig cm_cmpt_dtl.costcalc_orig%TYPE, --B16103415
477: text_code cm_cmpt_dtl.text_code%TYPE,
478: attribute1 cm_cmpt_dtl.attribute1%TYPE,
479: attribute2 cm_cmpt_dtl.attribute2%TYPE,
480: attribute3 cm_cmpt_dtl.attribute3%TYPE,

Line 477: text_code cm_cmpt_dtl.text_code%TYPE,

473: total_qty cm_cmpt_dtl.total_qty%TYPE,
474: rmcalc_type cm_cmpt_dtl.rmcalc_type%TYPE,
475: fmeff_id cm_cmpt_dtl.fmeff_id%TYPE,
476: costcalc_orig cm_cmpt_dtl.costcalc_orig%TYPE, --B16103415
477: text_code cm_cmpt_dtl.text_code%TYPE,
478: attribute1 cm_cmpt_dtl.attribute1%TYPE,
479: attribute2 cm_cmpt_dtl.attribute2%TYPE,
480: attribute3 cm_cmpt_dtl.attribute3%TYPE,
481: attribute4 cm_cmpt_dtl.attribute4%TYPE,

Line 478: attribute1 cm_cmpt_dtl.attribute1%TYPE,

474: rmcalc_type cm_cmpt_dtl.rmcalc_type%TYPE,
475: fmeff_id cm_cmpt_dtl.fmeff_id%TYPE,
476: costcalc_orig cm_cmpt_dtl.costcalc_orig%TYPE, --B16103415
477: text_code cm_cmpt_dtl.text_code%TYPE,
478: attribute1 cm_cmpt_dtl.attribute1%TYPE,
479: attribute2 cm_cmpt_dtl.attribute2%TYPE,
480: attribute3 cm_cmpt_dtl.attribute3%TYPE,
481: attribute4 cm_cmpt_dtl.attribute4%TYPE,
482: attribute5 cm_cmpt_dtl.attribute5%TYPE,

Line 479: attribute2 cm_cmpt_dtl.attribute2%TYPE,

475: fmeff_id cm_cmpt_dtl.fmeff_id%TYPE,
476: costcalc_orig cm_cmpt_dtl.costcalc_orig%TYPE, --B16103415
477: text_code cm_cmpt_dtl.text_code%TYPE,
478: attribute1 cm_cmpt_dtl.attribute1%TYPE,
479: attribute2 cm_cmpt_dtl.attribute2%TYPE,
480: attribute3 cm_cmpt_dtl.attribute3%TYPE,
481: attribute4 cm_cmpt_dtl.attribute4%TYPE,
482: attribute5 cm_cmpt_dtl.attribute5%TYPE,
483: attribute6 cm_cmpt_dtl.attribute6%TYPE,

Line 480: attribute3 cm_cmpt_dtl.attribute3%TYPE,

476: costcalc_orig cm_cmpt_dtl.costcalc_orig%TYPE, --B16103415
477: text_code cm_cmpt_dtl.text_code%TYPE,
478: attribute1 cm_cmpt_dtl.attribute1%TYPE,
479: attribute2 cm_cmpt_dtl.attribute2%TYPE,
480: attribute3 cm_cmpt_dtl.attribute3%TYPE,
481: attribute4 cm_cmpt_dtl.attribute4%TYPE,
482: attribute5 cm_cmpt_dtl.attribute5%TYPE,
483: attribute6 cm_cmpt_dtl.attribute6%TYPE,
484: attribute7 cm_cmpt_dtl.attribute7%TYPE,

Line 481: attribute4 cm_cmpt_dtl.attribute4%TYPE,

477: text_code cm_cmpt_dtl.text_code%TYPE,
478: attribute1 cm_cmpt_dtl.attribute1%TYPE,
479: attribute2 cm_cmpt_dtl.attribute2%TYPE,
480: attribute3 cm_cmpt_dtl.attribute3%TYPE,
481: attribute4 cm_cmpt_dtl.attribute4%TYPE,
482: attribute5 cm_cmpt_dtl.attribute5%TYPE,
483: attribute6 cm_cmpt_dtl.attribute6%TYPE,
484: attribute7 cm_cmpt_dtl.attribute7%TYPE,
485: attribute8 cm_cmpt_dtl.attribute8%TYPE,

Line 482: attribute5 cm_cmpt_dtl.attribute5%TYPE,

478: attribute1 cm_cmpt_dtl.attribute1%TYPE,
479: attribute2 cm_cmpt_dtl.attribute2%TYPE,
480: attribute3 cm_cmpt_dtl.attribute3%TYPE,
481: attribute4 cm_cmpt_dtl.attribute4%TYPE,
482: attribute5 cm_cmpt_dtl.attribute5%TYPE,
483: attribute6 cm_cmpt_dtl.attribute6%TYPE,
484: attribute7 cm_cmpt_dtl.attribute7%TYPE,
485: attribute8 cm_cmpt_dtl.attribute8%TYPE,
486: attribute9 cm_cmpt_dtl.attribute9%TYPE,

Line 483: attribute6 cm_cmpt_dtl.attribute6%TYPE,

479: attribute2 cm_cmpt_dtl.attribute2%TYPE,
480: attribute3 cm_cmpt_dtl.attribute3%TYPE,
481: attribute4 cm_cmpt_dtl.attribute4%TYPE,
482: attribute5 cm_cmpt_dtl.attribute5%TYPE,
483: attribute6 cm_cmpt_dtl.attribute6%TYPE,
484: attribute7 cm_cmpt_dtl.attribute7%TYPE,
485: attribute8 cm_cmpt_dtl.attribute8%TYPE,
486: attribute9 cm_cmpt_dtl.attribute9%TYPE,
487: attribute10 cm_cmpt_dtl.attribute10%TYPE,

Line 484: attribute7 cm_cmpt_dtl.attribute7%TYPE,

480: attribute3 cm_cmpt_dtl.attribute3%TYPE,
481: attribute4 cm_cmpt_dtl.attribute4%TYPE,
482: attribute5 cm_cmpt_dtl.attribute5%TYPE,
483: attribute6 cm_cmpt_dtl.attribute6%TYPE,
484: attribute7 cm_cmpt_dtl.attribute7%TYPE,
485: attribute8 cm_cmpt_dtl.attribute8%TYPE,
486: attribute9 cm_cmpt_dtl.attribute9%TYPE,
487: attribute10 cm_cmpt_dtl.attribute10%TYPE,
488: attribute11 cm_cmpt_dtl.attribute11%TYPE,

Line 485: attribute8 cm_cmpt_dtl.attribute8%TYPE,

481: attribute4 cm_cmpt_dtl.attribute4%TYPE,
482: attribute5 cm_cmpt_dtl.attribute5%TYPE,
483: attribute6 cm_cmpt_dtl.attribute6%TYPE,
484: attribute7 cm_cmpt_dtl.attribute7%TYPE,
485: attribute8 cm_cmpt_dtl.attribute8%TYPE,
486: attribute9 cm_cmpt_dtl.attribute9%TYPE,
487: attribute10 cm_cmpt_dtl.attribute10%TYPE,
488: attribute11 cm_cmpt_dtl.attribute11%TYPE,
489: attribute12 cm_cmpt_dtl.attribute12%TYPE,

Line 486: attribute9 cm_cmpt_dtl.attribute9%TYPE,

482: attribute5 cm_cmpt_dtl.attribute5%TYPE,
483: attribute6 cm_cmpt_dtl.attribute6%TYPE,
484: attribute7 cm_cmpt_dtl.attribute7%TYPE,
485: attribute8 cm_cmpt_dtl.attribute8%TYPE,
486: attribute9 cm_cmpt_dtl.attribute9%TYPE,
487: attribute10 cm_cmpt_dtl.attribute10%TYPE,
488: attribute11 cm_cmpt_dtl.attribute11%TYPE,
489: attribute12 cm_cmpt_dtl.attribute12%TYPE,
490: attribute13 cm_cmpt_dtl.attribute13%TYPE,

Line 487: attribute10 cm_cmpt_dtl.attribute10%TYPE,

483: attribute6 cm_cmpt_dtl.attribute6%TYPE,
484: attribute7 cm_cmpt_dtl.attribute7%TYPE,
485: attribute8 cm_cmpt_dtl.attribute8%TYPE,
486: attribute9 cm_cmpt_dtl.attribute9%TYPE,
487: attribute10 cm_cmpt_dtl.attribute10%TYPE,
488: attribute11 cm_cmpt_dtl.attribute11%TYPE,
489: attribute12 cm_cmpt_dtl.attribute12%TYPE,
490: attribute13 cm_cmpt_dtl.attribute13%TYPE,
491: attribute14 cm_cmpt_dtl.attribute14%TYPE,

Line 488: attribute11 cm_cmpt_dtl.attribute11%TYPE,

484: attribute7 cm_cmpt_dtl.attribute7%TYPE,
485: attribute8 cm_cmpt_dtl.attribute8%TYPE,
486: attribute9 cm_cmpt_dtl.attribute9%TYPE,
487: attribute10 cm_cmpt_dtl.attribute10%TYPE,
488: attribute11 cm_cmpt_dtl.attribute11%TYPE,
489: attribute12 cm_cmpt_dtl.attribute12%TYPE,
490: attribute13 cm_cmpt_dtl.attribute13%TYPE,
491: attribute14 cm_cmpt_dtl.attribute14%TYPE,
492: attribute15 cm_cmpt_dtl.attribute15%TYPE,

Line 489: attribute12 cm_cmpt_dtl.attribute12%TYPE,

485: attribute8 cm_cmpt_dtl.attribute8%TYPE,
486: attribute9 cm_cmpt_dtl.attribute9%TYPE,
487: attribute10 cm_cmpt_dtl.attribute10%TYPE,
488: attribute11 cm_cmpt_dtl.attribute11%TYPE,
489: attribute12 cm_cmpt_dtl.attribute12%TYPE,
490: attribute13 cm_cmpt_dtl.attribute13%TYPE,
491: attribute14 cm_cmpt_dtl.attribute14%TYPE,
492: attribute15 cm_cmpt_dtl.attribute15%TYPE,
493: attribute16 cm_cmpt_dtl.attribute16%TYPE,

Line 490: attribute13 cm_cmpt_dtl.attribute13%TYPE,

486: attribute9 cm_cmpt_dtl.attribute9%TYPE,
487: attribute10 cm_cmpt_dtl.attribute10%TYPE,
488: attribute11 cm_cmpt_dtl.attribute11%TYPE,
489: attribute12 cm_cmpt_dtl.attribute12%TYPE,
490: attribute13 cm_cmpt_dtl.attribute13%TYPE,
491: attribute14 cm_cmpt_dtl.attribute14%TYPE,
492: attribute15 cm_cmpt_dtl.attribute15%TYPE,
493: attribute16 cm_cmpt_dtl.attribute16%TYPE,
494: attribute17 cm_cmpt_dtl.attribute17%TYPE,

Line 491: attribute14 cm_cmpt_dtl.attribute14%TYPE,

487: attribute10 cm_cmpt_dtl.attribute10%TYPE,
488: attribute11 cm_cmpt_dtl.attribute11%TYPE,
489: attribute12 cm_cmpt_dtl.attribute12%TYPE,
490: attribute13 cm_cmpt_dtl.attribute13%TYPE,
491: attribute14 cm_cmpt_dtl.attribute14%TYPE,
492: attribute15 cm_cmpt_dtl.attribute15%TYPE,
493: attribute16 cm_cmpt_dtl.attribute16%TYPE,
494: attribute17 cm_cmpt_dtl.attribute17%TYPE,
495: attribute18 cm_cmpt_dtl.attribute18%TYPE,

Line 492: attribute15 cm_cmpt_dtl.attribute15%TYPE,

488: attribute11 cm_cmpt_dtl.attribute11%TYPE,
489: attribute12 cm_cmpt_dtl.attribute12%TYPE,
490: attribute13 cm_cmpt_dtl.attribute13%TYPE,
491: attribute14 cm_cmpt_dtl.attribute14%TYPE,
492: attribute15 cm_cmpt_dtl.attribute15%TYPE,
493: attribute16 cm_cmpt_dtl.attribute16%TYPE,
494: attribute17 cm_cmpt_dtl.attribute17%TYPE,
495: attribute18 cm_cmpt_dtl.attribute18%TYPE,
496: attribute19 cm_cmpt_dtl.attribute19%TYPE,

Line 493: attribute16 cm_cmpt_dtl.attribute16%TYPE,

489: attribute12 cm_cmpt_dtl.attribute12%TYPE,
490: attribute13 cm_cmpt_dtl.attribute13%TYPE,
491: attribute14 cm_cmpt_dtl.attribute14%TYPE,
492: attribute15 cm_cmpt_dtl.attribute15%TYPE,
493: attribute16 cm_cmpt_dtl.attribute16%TYPE,
494: attribute17 cm_cmpt_dtl.attribute17%TYPE,
495: attribute18 cm_cmpt_dtl.attribute18%TYPE,
496: attribute19 cm_cmpt_dtl.attribute19%TYPE,
497: attribute20 cm_cmpt_dtl.attribute20%TYPE,

Line 494: attribute17 cm_cmpt_dtl.attribute17%TYPE,

490: attribute13 cm_cmpt_dtl.attribute13%TYPE,
491: attribute14 cm_cmpt_dtl.attribute14%TYPE,
492: attribute15 cm_cmpt_dtl.attribute15%TYPE,
493: attribute16 cm_cmpt_dtl.attribute16%TYPE,
494: attribute17 cm_cmpt_dtl.attribute17%TYPE,
495: attribute18 cm_cmpt_dtl.attribute18%TYPE,
496: attribute19 cm_cmpt_dtl.attribute19%TYPE,
497: attribute20 cm_cmpt_dtl.attribute20%TYPE,
498: attribute21 cm_cmpt_dtl.attribute21%TYPE,

Line 495: attribute18 cm_cmpt_dtl.attribute18%TYPE,

491: attribute14 cm_cmpt_dtl.attribute14%TYPE,
492: attribute15 cm_cmpt_dtl.attribute15%TYPE,
493: attribute16 cm_cmpt_dtl.attribute16%TYPE,
494: attribute17 cm_cmpt_dtl.attribute17%TYPE,
495: attribute18 cm_cmpt_dtl.attribute18%TYPE,
496: attribute19 cm_cmpt_dtl.attribute19%TYPE,
497: attribute20 cm_cmpt_dtl.attribute20%TYPE,
498: attribute21 cm_cmpt_dtl.attribute21%TYPE,
499: attribute22 cm_cmpt_dtl.attribute22%TYPE,

Line 496: attribute19 cm_cmpt_dtl.attribute19%TYPE,

492: attribute15 cm_cmpt_dtl.attribute15%TYPE,
493: attribute16 cm_cmpt_dtl.attribute16%TYPE,
494: attribute17 cm_cmpt_dtl.attribute17%TYPE,
495: attribute18 cm_cmpt_dtl.attribute18%TYPE,
496: attribute19 cm_cmpt_dtl.attribute19%TYPE,
497: attribute20 cm_cmpt_dtl.attribute20%TYPE,
498: attribute21 cm_cmpt_dtl.attribute21%TYPE,
499: attribute22 cm_cmpt_dtl.attribute22%TYPE,
500: attribute23 cm_cmpt_dtl.attribute23%TYPE,

Line 497: attribute20 cm_cmpt_dtl.attribute20%TYPE,

493: attribute16 cm_cmpt_dtl.attribute16%TYPE,
494: attribute17 cm_cmpt_dtl.attribute17%TYPE,
495: attribute18 cm_cmpt_dtl.attribute18%TYPE,
496: attribute19 cm_cmpt_dtl.attribute19%TYPE,
497: attribute20 cm_cmpt_dtl.attribute20%TYPE,
498: attribute21 cm_cmpt_dtl.attribute21%TYPE,
499: attribute22 cm_cmpt_dtl.attribute22%TYPE,
500: attribute23 cm_cmpt_dtl.attribute23%TYPE,
501: attribute24 cm_cmpt_dtl.attribute24%TYPE,

Line 498: attribute21 cm_cmpt_dtl.attribute21%TYPE,

494: attribute17 cm_cmpt_dtl.attribute17%TYPE,
495: attribute18 cm_cmpt_dtl.attribute18%TYPE,
496: attribute19 cm_cmpt_dtl.attribute19%TYPE,
497: attribute20 cm_cmpt_dtl.attribute20%TYPE,
498: attribute21 cm_cmpt_dtl.attribute21%TYPE,
499: attribute22 cm_cmpt_dtl.attribute22%TYPE,
500: attribute23 cm_cmpt_dtl.attribute23%TYPE,
501: attribute24 cm_cmpt_dtl.attribute24%TYPE,
502: attribute25 cm_cmpt_dtl.attribute25%TYPE,

Line 499: attribute22 cm_cmpt_dtl.attribute22%TYPE,

495: attribute18 cm_cmpt_dtl.attribute18%TYPE,
496: attribute19 cm_cmpt_dtl.attribute19%TYPE,
497: attribute20 cm_cmpt_dtl.attribute20%TYPE,
498: attribute21 cm_cmpt_dtl.attribute21%TYPE,
499: attribute22 cm_cmpt_dtl.attribute22%TYPE,
500: attribute23 cm_cmpt_dtl.attribute23%TYPE,
501: attribute24 cm_cmpt_dtl.attribute24%TYPE,
502: attribute25 cm_cmpt_dtl.attribute25%TYPE,
503: attribute26 cm_cmpt_dtl.attribute26%TYPE,

Line 500: attribute23 cm_cmpt_dtl.attribute23%TYPE,

496: attribute19 cm_cmpt_dtl.attribute19%TYPE,
497: attribute20 cm_cmpt_dtl.attribute20%TYPE,
498: attribute21 cm_cmpt_dtl.attribute21%TYPE,
499: attribute22 cm_cmpt_dtl.attribute22%TYPE,
500: attribute23 cm_cmpt_dtl.attribute23%TYPE,
501: attribute24 cm_cmpt_dtl.attribute24%TYPE,
502: attribute25 cm_cmpt_dtl.attribute25%TYPE,
503: attribute26 cm_cmpt_dtl.attribute26%TYPE,
504: attribute27 cm_cmpt_dtl.attribute27%TYPE,

Line 501: attribute24 cm_cmpt_dtl.attribute24%TYPE,

497: attribute20 cm_cmpt_dtl.attribute20%TYPE,
498: attribute21 cm_cmpt_dtl.attribute21%TYPE,
499: attribute22 cm_cmpt_dtl.attribute22%TYPE,
500: attribute23 cm_cmpt_dtl.attribute23%TYPE,
501: attribute24 cm_cmpt_dtl.attribute24%TYPE,
502: attribute25 cm_cmpt_dtl.attribute25%TYPE,
503: attribute26 cm_cmpt_dtl.attribute26%TYPE,
504: attribute27 cm_cmpt_dtl.attribute27%TYPE,
505: attribute28 cm_cmpt_dtl.attribute28%TYPE,

Line 502: attribute25 cm_cmpt_dtl.attribute25%TYPE,

498: attribute21 cm_cmpt_dtl.attribute21%TYPE,
499: attribute22 cm_cmpt_dtl.attribute22%TYPE,
500: attribute23 cm_cmpt_dtl.attribute23%TYPE,
501: attribute24 cm_cmpt_dtl.attribute24%TYPE,
502: attribute25 cm_cmpt_dtl.attribute25%TYPE,
503: attribute26 cm_cmpt_dtl.attribute26%TYPE,
504: attribute27 cm_cmpt_dtl.attribute27%TYPE,
505: attribute28 cm_cmpt_dtl.attribute28%TYPE,
506: attribute29 cm_cmpt_dtl.attribute29%TYPE,

Line 503: attribute26 cm_cmpt_dtl.attribute26%TYPE,

499: attribute22 cm_cmpt_dtl.attribute22%TYPE,
500: attribute23 cm_cmpt_dtl.attribute23%TYPE,
501: attribute24 cm_cmpt_dtl.attribute24%TYPE,
502: attribute25 cm_cmpt_dtl.attribute25%TYPE,
503: attribute26 cm_cmpt_dtl.attribute26%TYPE,
504: attribute27 cm_cmpt_dtl.attribute27%TYPE,
505: attribute28 cm_cmpt_dtl.attribute28%TYPE,
506: attribute29 cm_cmpt_dtl.attribute29%TYPE,
507: attribute30 cm_cmpt_dtl.attribute30%TYPE,

Line 504: attribute27 cm_cmpt_dtl.attribute27%TYPE,

500: attribute23 cm_cmpt_dtl.attribute23%TYPE,
501: attribute24 cm_cmpt_dtl.attribute24%TYPE,
502: attribute25 cm_cmpt_dtl.attribute25%TYPE,
503: attribute26 cm_cmpt_dtl.attribute26%TYPE,
504: attribute27 cm_cmpt_dtl.attribute27%TYPE,
505: attribute28 cm_cmpt_dtl.attribute28%TYPE,
506: attribute29 cm_cmpt_dtl.attribute29%TYPE,
507: attribute30 cm_cmpt_dtl.attribute30%TYPE,
508: c_delete_mark cm_cmpt_dtl.delete_mark%TYPE --B10200720

Line 505: attribute28 cm_cmpt_dtl.attribute28%TYPE,

501: attribute24 cm_cmpt_dtl.attribute24%TYPE,
502: attribute25 cm_cmpt_dtl.attribute25%TYPE,
503: attribute26 cm_cmpt_dtl.attribute26%TYPE,
504: attribute27 cm_cmpt_dtl.attribute27%TYPE,
505: attribute28 cm_cmpt_dtl.attribute28%TYPE,
506: attribute29 cm_cmpt_dtl.attribute29%TYPE,
507: attribute30 cm_cmpt_dtl.attribute30%TYPE,
508: c_delete_mark cm_cmpt_dtl.delete_mark%TYPE --B10200720
509: );

Line 506: attribute29 cm_cmpt_dtl.attribute29%TYPE,

502: attribute25 cm_cmpt_dtl.attribute25%TYPE,
503: attribute26 cm_cmpt_dtl.attribute26%TYPE,
504: attribute27 cm_cmpt_dtl.attribute27%TYPE,
505: attribute28 cm_cmpt_dtl.attribute28%TYPE,
506: attribute29 cm_cmpt_dtl.attribute29%TYPE,
507: attribute30 cm_cmpt_dtl.attribute30%TYPE,
508: c_delete_mark cm_cmpt_dtl.delete_mark%TYPE --B10200720
509: );
510:

Line 507: attribute30 cm_cmpt_dtl.attribute30%TYPE,

503: attribute26 cm_cmpt_dtl.attribute26%TYPE,
504: attribute27 cm_cmpt_dtl.attribute27%TYPE,
505: attribute28 cm_cmpt_dtl.attribute28%TYPE,
506: attribute29 cm_cmpt_dtl.attribute29%TYPE,
507: attribute30 cm_cmpt_dtl.attribute30%TYPE,
508: c_delete_mark cm_cmpt_dtl.delete_mark%TYPE --B10200720
509: );
510:
511: TYPE curtyp_cost_detail IS REF CURSOR;

Line 508: c_delete_mark cm_cmpt_dtl.delete_mark%TYPE --B10200720

504: attribute27 cm_cmpt_dtl.attribute27%TYPE,
505: attribute28 cm_cmpt_dtl.attribute28%TYPE,
506: attribute29 cm_cmpt_dtl.attribute29%TYPE,
507: attribute30 cm_cmpt_dtl.attribute30%TYPE,
508: c_delete_mark cm_cmpt_dtl.delete_mark%TYPE --B10200720
509: );
510:
511: TYPE curtyp_cost_detail IS REF CURSOR;
512: cv_cost_detail curtyp_cost_detail;

Line 527: l_organization_id_from cm_cmpt_dtl.organization_id%TYPE;

523: l_sql_stmt VARCHAR2(2000);
524: l_sql_org VARCHAR2(2000) ;
525: l_sql_periods VARCHAR2(2000) ;
526: l_org_id gmf_legal_entities.legal_entity_id%TYPE ;
527: l_organization_id_from cm_cmpt_dtl.organization_id%TYPE;
528: l_organization_id_to cm_cmpt_dtl.organization_id%TYPE;
529:
530: l_period_id_to gmf_period_statuses.period_id%TYPE;
531:

Line 528: l_organization_id_to cm_cmpt_dtl.organization_id%TYPE;

524: l_sql_org VARCHAR2(2000) ;
525: l_sql_periods VARCHAR2(2000) ;
526: l_org_id gmf_legal_entities.legal_entity_id%TYPE ;
527: l_organization_id_from cm_cmpt_dtl.organization_id%TYPE;
528: l_organization_id_to cm_cmpt_dtl.organization_id%TYPE;
529:
530: l_period_id_to gmf_period_statuses.period_id%TYPE;
531:
532: l_from_range VARCHAR2(32767);

Line 539: l_curr_inventory_item_id cm_cmpt_dtl.inventory_item_id%TYPE;

535: l_rem_repl NUMBER;
536: l_incr_pct NUMBER;
537: l_incr_decr_cost NUMBER;
538:
539: l_curr_inventory_item_id cm_cmpt_dtl.inventory_item_id%TYPE;
540: l_curr_organization_id cm_cmpt_dtl.organization_id%TYPE;
541: l_curr_period_code gmf_period_statuses.period_code%TYPE;
542: l_frozen_flag NUMBER;
543: l_assigned_flag NUMBER;

Line 540: l_curr_organization_id cm_cmpt_dtl.organization_id%TYPE;

536: l_incr_pct NUMBER;
537: l_incr_decr_cost NUMBER;
538:
539: l_curr_inventory_item_id cm_cmpt_dtl.inventory_item_id%TYPE;
540: l_curr_organization_id cm_cmpt_dtl.organization_id%TYPE;
541: l_curr_period_code gmf_period_statuses.period_code%TYPE;
542: l_frozen_flag NUMBER;
543: l_assigned_flag NUMBER;
544:

Line 545: l_curr_inventory_item_id2 cm_cmpt_dtl.inventory_item_id%TYPE;

541: l_curr_period_code gmf_period_statuses.period_code%TYPE;
542: l_frozen_flag NUMBER;
543: l_assigned_flag NUMBER;
544:
545: l_curr_inventory_item_id2 cm_cmpt_dtl.inventory_item_id%TYPE;
546: l_curr_organization_id2 cm_cmpt_dtl.organization_id%TYPE;
547: l_curr_period_code2 gmf_period_statuses.period_code%TYPE;
548:
549: l_cost_rows NUMBER;

Line 546: l_curr_organization_id2 cm_cmpt_dtl.organization_id%TYPE;

542: l_frozen_flag NUMBER;
543: l_assigned_flag NUMBER;
544:
545: l_curr_inventory_item_id2 cm_cmpt_dtl.inventory_item_id%TYPE;
546: l_curr_organization_id2 cm_cmpt_dtl.organization_id%TYPE;
547: l_curr_period_code2 gmf_period_statuses.period_code%TYPE;
548:
549: l_cost_rows NUMBER;
550: l_cost_rows_upd NUMBER;

Line 663: 'cm_cmpt_dtl cst' ||

659: 'cst.attribute29,' ||
660: 'cst.attribute30, ' || --B10200720
661: 'cst.delete_mark' || --B10200720
662: ' FROM ' ||
663: 'cm_cmpt_dtl cst' ||
664: ' WHERE ' ||
665: 'cst.organization_id = :b_organization_id AND ' ||
666: 'cst.period_id = :b_period_id AND ' ||
667: 'cst.cost_type_id = :b_cost_type_id '; -- AND ' ||

Line 944: * Try update of cm_cmpt_dtl first

940: FETCH cv_cost_detail INTO r_cost_detail;
941: EXIT WHEN cv_cost_detail%NOTFOUND;
942:
943: /**
944: * Try update of cm_cmpt_dtl first
945: * Update can fail for two reasons: either the row is not there
946: * or, the row exists but is frozen (rollover_ind = 1)
947: * If the costs are frozen in the target period then do not update the rows
948: * in cm_cmpt_dtl nor delete them from cm_scst_led/cm_acst_led.

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

944: * Try update of cm_cmpt_dtl first
945: * Update can fail for two reasons: either the row is not there
946: * or, the row exists but is frozen (rollover_ind = 1)
947: * If the costs are frozen in the target period then do not update the rows
948: * in cm_cmpt_dtl nor delete them from cm_scst_led/cm_acst_led.
949: * The item cost rows should be left untouched in the target period even if
950: * one of the components is frozen.
951: */
952:

Line 1084: p_cost_type_id IN cm_cmpt_dtl.cost_type_id%TYPE,

1080: DECLARE
1081: CURSOR c_updins_cc_id(
1082: p_calendar_code IN gmf_period_statuses.calendar_code%TYPE,
1083: p_period_id IN gmf_period_statuses.period_id%TYPE,
1084: p_cost_type_id IN cm_cmpt_dtl.cost_type_id%TYPE,
1085: p_organization_id IN cm_cmpt_dtl.organization_id%TYPE,
1086: p_inventory_item_id IN cm_cmpt_dtl.inventory_item_id%TYPE,
1087: p_cost_cmpntcls_id IN cm_cmpt_dtl.cost_cmpntcls_id%TYPE,
1088: p_cost_analysis_code IN cm_cmpt_dtl.cost_analysis_code%TYPE,

Line 1085: p_organization_id IN cm_cmpt_dtl.organization_id%TYPE,

1081: CURSOR c_updins_cc_id(
1082: p_calendar_code IN gmf_period_statuses.calendar_code%TYPE,
1083: p_period_id IN gmf_period_statuses.period_id%TYPE,
1084: p_cost_type_id IN cm_cmpt_dtl.cost_type_id%TYPE,
1085: p_organization_id IN cm_cmpt_dtl.organization_id%TYPE,
1086: p_inventory_item_id IN cm_cmpt_dtl.inventory_item_id%TYPE,
1087: p_cost_cmpntcls_id IN cm_cmpt_dtl.cost_cmpntcls_id%TYPE,
1088: p_cost_analysis_code IN cm_cmpt_dtl.cost_analysis_code%TYPE,
1089: p_cost_level IN cm_cmpt_dtl.cost_level%TYPE

Line 1086: p_inventory_item_id IN cm_cmpt_dtl.inventory_item_id%TYPE,

1082: p_calendar_code IN gmf_period_statuses.calendar_code%TYPE,
1083: p_period_id IN gmf_period_statuses.period_id%TYPE,
1084: p_cost_type_id IN cm_cmpt_dtl.cost_type_id%TYPE,
1085: p_organization_id IN cm_cmpt_dtl.organization_id%TYPE,
1086: p_inventory_item_id IN cm_cmpt_dtl.inventory_item_id%TYPE,
1087: p_cost_cmpntcls_id IN cm_cmpt_dtl.cost_cmpntcls_id%TYPE,
1088: p_cost_analysis_code IN cm_cmpt_dtl.cost_analysis_code%TYPE,
1089: p_cost_level IN cm_cmpt_dtl.cost_level%TYPE
1090: ) IS

Line 1087: p_cost_cmpntcls_id IN cm_cmpt_dtl.cost_cmpntcls_id%TYPE,

1083: p_period_id IN gmf_period_statuses.period_id%TYPE,
1084: p_cost_type_id IN cm_cmpt_dtl.cost_type_id%TYPE,
1085: p_organization_id IN cm_cmpt_dtl.organization_id%TYPE,
1086: p_inventory_item_id IN cm_cmpt_dtl.inventory_item_id%TYPE,
1087: p_cost_cmpntcls_id IN cm_cmpt_dtl.cost_cmpntcls_id%TYPE,
1088: p_cost_analysis_code IN cm_cmpt_dtl.cost_analysis_code%TYPE,
1089: p_cost_level IN cm_cmpt_dtl.cost_level%TYPE
1090: ) IS
1091: SELECT

Line 1088: p_cost_analysis_code IN cm_cmpt_dtl.cost_analysis_code%TYPE,

1084: p_cost_type_id IN cm_cmpt_dtl.cost_type_id%TYPE,
1085: p_organization_id IN cm_cmpt_dtl.organization_id%TYPE,
1086: p_inventory_item_id IN cm_cmpt_dtl.inventory_item_id%TYPE,
1087: p_cost_cmpntcls_id IN cm_cmpt_dtl.cost_cmpntcls_id%TYPE,
1088: p_cost_analysis_code IN cm_cmpt_dtl.cost_analysis_code%TYPE,
1089: p_cost_level IN cm_cmpt_dtl.cost_level%TYPE
1090: ) IS
1091: SELECT
1092: cmpntcost_id

Line 1089: p_cost_level IN cm_cmpt_dtl.cost_level%TYPE

1085: p_organization_id IN cm_cmpt_dtl.organization_id%TYPE,
1086: p_inventory_item_id IN cm_cmpt_dtl.inventory_item_id%TYPE,
1087: p_cost_cmpntcls_id IN cm_cmpt_dtl.cost_cmpntcls_id%TYPE,
1088: p_cost_analysis_code IN cm_cmpt_dtl.cost_analysis_code%TYPE,
1089: p_cost_level IN cm_cmpt_dtl.cost_level%TYPE
1090: ) IS
1091: SELECT
1092: cmpntcost_id
1093: FROM

Line 1094: cm_cmpt_dtl

1090: ) IS
1091: SELECT
1092: cmpntcost_id
1093: FROM
1094: cm_cmpt_dtl
1095: WHERE
1096: period_id = p_period_id AND
1097: cost_type_id = p_cost_type_id AND
1098: organization_id = p_organization_id AND

Line 1104: l_updins_cc_id cm_cmpt_dtl.cmpntcost_id%TYPE;

1100: cost_cmpntcls_id = p_cost_cmpntcls_id AND
1101: cost_analysis_code = p_cost_analysis_code AND
1102: cost_level = p_cost_level;
1103:
1104: l_updins_cc_id cm_cmpt_dtl.cmpntcost_id%TYPE;
1105: e_insert_row EXCEPTION;
1106: BEGIN
1107:
1108: l_updins_cc_id := 0;

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

1121: ' is Frozen. You can not Update Frozen period cost.', 0 );
1122: RAISE e_period_frozen;
1123: END IF; -- end for bug 5567102 pmarada
1124:
1125: /** There is a unique index on cm_cmpt_dtl on these columns
1126: * and we expect only one row and only one row is fetched
1127: * if not we have bigger problems, houston!
1128: */
1129: IF ( l_copy_to_upper_lvl = 1 ) THEN

Line 1188: cm_cmpt_dtl

1184: -- B2198228 We have read cost from lower level at source and user
1185: -- wants to copy it to this level at target
1186:
1187: UPDATE
1188: cm_cmpt_dtl
1189: SET
1190: cmpntcost_id = GEM5_CMPNT_COST_ID_S.NEXTVAL,
1191: cmpnt_cost = cmpnt_cost + r_cost_detail.cmpnt_cost,
1192: burden_ind = r_cost_detail.burden_ind,

Line 1215: cm_cmpt_dtl

1211: cmpntcost_id = l_updins_cc_id
1212: ;
1213: ELSE
1214: UPDATE
1215: cm_cmpt_dtl
1216: SET
1217: cmpntcost_id = GEM5_CMPNT_COST_ID_S.NEXTVAL,
1218: cmpnt_cost = r_cost_detail.cmpnt_cost,
1219: burden_ind = r_cost_detail.burden_ind,

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

1274: gmf_util.trace( ' row updated to cmpt_dtl', 0 );
1275:
1276: END IF; /* l_copy_to_upper_lvl = 1 */
1277: ELSE -- cursor not found
1278: -- update failed, try inserting the row into cm_cmpt_dtl
1279: RAISE e_insert_row;
1280: END IF; -- if row is found in target period
1281:
1282: l_cost_rows_upd := l_cost_rows_upd + 1;

Line 1296: cm_cmpt_dtl(

1292: CLOSE c_updins_cc_id;
1293: END IF;
1294: -- Attempt to insert the row
1295: INSERT INTO
1296: cm_cmpt_dtl(
1297: cmpntcost_id,
1298: inventory_item_id,
1299: organization_id,
1300: cost_cmpntcls_id,

Line 1513: pi_inventory_item_id IN cm_cmpt_dtl.inventory_item_id%TYPE,

1509: *
1510: ******************************************************************************/
1511:
1512: PROCEDURE delete_item_costs(
1513: pi_inventory_item_id IN cm_cmpt_dtl.inventory_item_id%TYPE,
1514: pi_organization_id IN cm_cmpt_dtl.organization_id%TYPE,
1515: pi_calendar_code IN gmf_period_statuses.calendar_code%TYPE,
1516: pi_period_id IN gmf_period_statuses.period_id%TYPE,
1517: pi_cost_type_id IN cm_cmpt_dtl.cost_type_id%TYPE

Line 1514: pi_organization_id IN cm_cmpt_dtl.organization_id%TYPE,

1510: ******************************************************************************/
1511:
1512: PROCEDURE delete_item_costs(
1513: pi_inventory_item_id IN cm_cmpt_dtl.inventory_item_id%TYPE,
1514: pi_organization_id IN cm_cmpt_dtl.organization_id%TYPE,
1515: pi_calendar_code IN gmf_period_statuses.calendar_code%TYPE,
1516: pi_period_id IN gmf_period_statuses.period_id%TYPE,
1517: pi_cost_type_id IN cm_cmpt_dtl.cost_type_id%TYPE
1518: )

Line 1517: pi_cost_type_id IN cm_cmpt_dtl.cost_type_id%TYPE

1513: pi_inventory_item_id IN cm_cmpt_dtl.inventory_item_id%TYPE,
1514: pi_organization_id IN cm_cmpt_dtl.organization_id%TYPE,
1515: pi_calendar_code IN gmf_period_statuses.calendar_code%TYPE,
1516: pi_period_id IN gmf_period_statuses.period_id%TYPE,
1517: pi_cost_type_id IN cm_cmpt_dtl.cost_type_id%TYPE
1518: )
1519: IS
1520: CURSOR c_cc_id(
1521: p_inventory_item_id IN cm_cmpt_dtl.inventory_item_id%TYPE,

Line 1521: p_inventory_item_id IN cm_cmpt_dtl.inventory_item_id%TYPE,

1517: pi_cost_type_id IN cm_cmpt_dtl.cost_type_id%TYPE
1518: )
1519: IS
1520: CURSOR c_cc_id(
1521: p_inventory_item_id IN cm_cmpt_dtl.inventory_item_id%TYPE,
1522: p_organization_id IN cm_cmpt_dtl.organization_id%TYPE,
1523: p_calendar_code IN gmf_period_statuses.calendar_code%TYPE,
1524: p_period_id IN gmf_period_statuses.period_id%TYPE,
1525: p_cost_type_id IN cm_cmpt_dtl.cost_type_id%TYPE

Line 1522: p_organization_id IN cm_cmpt_dtl.organization_id%TYPE,

1518: )
1519: IS
1520: CURSOR c_cc_id(
1521: p_inventory_item_id IN cm_cmpt_dtl.inventory_item_id%TYPE,
1522: p_organization_id IN cm_cmpt_dtl.organization_id%TYPE,
1523: p_calendar_code IN gmf_period_statuses.calendar_code%TYPE,
1524: p_period_id IN gmf_period_statuses.period_id%TYPE,
1525: p_cost_type_id IN cm_cmpt_dtl.cost_type_id%TYPE
1526: )

Line 1525: p_cost_type_id IN cm_cmpt_dtl.cost_type_id%TYPE

1521: p_inventory_item_id IN cm_cmpt_dtl.inventory_item_id%TYPE,
1522: p_organization_id IN cm_cmpt_dtl.organization_id%TYPE,
1523: p_calendar_code IN gmf_period_statuses.calendar_code%TYPE,
1524: p_period_id IN gmf_period_statuses.period_id%TYPE,
1525: p_cost_type_id IN cm_cmpt_dtl.cost_type_id%TYPE
1526: )
1527: IS
1528: SELECT
1529: cmpntcost_id

Line 1531: cm_cmpt_dtl

1527: IS
1528: SELECT
1529: cmpntcost_id
1530: FROM
1531: cm_cmpt_dtl
1532: WHERE
1533: inventory_item_id = p_inventory_item_id AND
1534: organization_id = p_organization_id AND
1535: period_id = p_period_id AND

Line 1582: cm_cmpt_dtl

1578: gmf_util.trace( SQL%ROWCOUNT || ' rows updated in brdn_dtl', 3 );
1579:
1580: -- Finally delete the row itself from cmpt_dtl
1581: DELETE FROM
1582: cm_cmpt_dtl
1583: WHERE CURRENT OF c_cc_id
1584: ;
1585:
1586: gmf_util.trace( SQL%ROWCOUNT || ' rows deleted from cmpt_dtl', 3 );

Line 1608: pi_inventory_item_id IN cm_cmpt_dtl.inventory_item_id%TYPE,

1604: *
1605: ******************************************************************************/
1606:
1607: FUNCTION verify_frozen_costs(
1608: pi_inventory_item_id IN cm_cmpt_dtl.inventory_item_id%TYPE,
1609: pi_organization_id IN cm_cmpt_dtl.organization_id%TYPE,
1610: pi_calendar_code IN gmf_period_statuses.calendar_code%TYPE,
1611: pi_period_id IN gmf_period_statuses.period_id%TYPE,
1612: pi_cost_type_id IN cm_cmpt_dtl.cost_type_id%TYPE

Line 1609: pi_organization_id IN cm_cmpt_dtl.organization_id%TYPE,

1605: ******************************************************************************/
1606:
1607: FUNCTION verify_frozen_costs(
1608: pi_inventory_item_id IN cm_cmpt_dtl.inventory_item_id%TYPE,
1609: pi_organization_id IN cm_cmpt_dtl.organization_id%TYPE,
1610: pi_calendar_code IN gmf_period_statuses.calendar_code%TYPE,
1611: pi_period_id IN gmf_period_statuses.period_id%TYPE,
1612: pi_cost_type_id IN cm_cmpt_dtl.cost_type_id%TYPE
1613: )

Line 1612: pi_cost_type_id IN cm_cmpt_dtl.cost_type_id%TYPE

1608: pi_inventory_item_id IN cm_cmpt_dtl.inventory_item_id%TYPE,
1609: pi_organization_id IN cm_cmpt_dtl.organization_id%TYPE,
1610: pi_calendar_code IN gmf_period_statuses.calendar_code%TYPE,
1611: pi_period_id IN gmf_period_statuses.period_id%TYPE,
1612: pi_cost_type_id IN cm_cmpt_dtl.cost_type_id%TYPE
1613: )
1614: RETURN NUMBER IS
1615:
1616: l_frozen_ind NUMBER;

Line 1623: cm_cmpt_dtl

1619:
1620: l_frozen_ind := 0;
1621: SELECT nvl(max(rollover_ind),0) INTO l_frozen_ind
1622: FROM
1623: cm_cmpt_dtl
1624: WHERE period_id = pi_period_id AND
1625: cost_type_id = pi_cost_type_id AND
1626: organization_id = pi_organization_id AND
1627: inventory_item_id = pi_inventory_item_id

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

1682: * HISTORY
1683: * 24-Apr-2007 pmarada, created for bug 5672543
1684: *
1685: ******************************************************************************/
1686: FUNCTION check_rec_infrozen_period(p_organization_id cm_cmpt_dtl.organization_id%TYPE,
1687: p_inventory_item_id cm_cmpt_dtl.inventory_item_id%TYPE,
1688: p_period_id gmf_period_statuses.period_id%TYPE,
1689: p_cost_type_id cm_cmpt_dtl.cost_type_id%TYPE
1690: )

Line 1687: p_inventory_item_id cm_cmpt_dtl.inventory_item_id%TYPE,

1683: * 24-Apr-2007 pmarada, created for bug 5672543
1684: *
1685: ******************************************************************************/
1686: FUNCTION check_rec_infrozen_period(p_organization_id cm_cmpt_dtl.organization_id%TYPE,
1687: p_inventory_item_id cm_cmpt_dtl.inventory_item_id%TYPE,
1688: p_period_id gmf_period_statuses.period_id%TYPE,
1689: p_cost_type_id cm_cmpt_dtl.cost_type_id%TYPE
1690: )
1691: RETURN BOOLEAN IS

Line 1689: p_cost_type_id cm_cmpt_dtl.cost_type_id%TYPE

1685: ******************************************************************************/
1686: FUNCTION check_rec_infrozen_period(p_organization_id cm_cmpt_dtl.organization_id%TYPE,
1687: p_inventory_item_id cm_cmpt_dtl.inventory_item_id%TYPE,
1688: p_period_id gmf_period_statuses.period_id%TYPE,
1689: p_cost_type_id cm_cmpt_dtl.cost_type_id%TYPE
1690: )
1691: RETURN BOOLEAN IS
1692:
1693: CURSOR cur_check_rec (cp_organization_id cm_cmpt_dtl.organization_id%TYPE,

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

1689: p_cost_type_id cm_cmpt_dtl.cost_type_id%TYPE
1690: )
1691: RETURN BOOLEAN IS
1692:
1693: CURSOR cur_check_rec (cp_organization_id cm_cmpt_dtl.organization_id%TYPE,
1694: cp_inventory_item_id cm_cmpt_dtl.inventory_item_id%TYPE,
1695: cp_period_id gmf_period_statuses.period_id%TYPE,
1696: cp_cost_type_id cm_cmpt_dtl.cost_type_id%TYPE) IS
1697: SELECT 'x' FROM cm_cmpt_dtl

Line 1694: cp_inventory_item_id cm_cmpt_dtl.inventory_item_id%TYPE,

1690: )
1691: RETURN BOOLEAN IS
1692:
1693: CURSOR cur_check_rec (cp_organization_id cm_cmpt_dtl.organization_id%TYPE,
1694: cp_inventory_item_id cm_cmpt_dtl.inventory_item_id%TYPE,
1695: cp_period_id gmf_period_statuses.period_id%TYPE,
1696: cp_cost_type_id cm_cmpt_dtl.cost_type_id%TYPE) IS
1697: SELECT 'x' FROM cm_cmpt_dtl
1698: WHERE organization_id = cp_organization_id

Line 1696: cp_cost_type_id cm_cmpt_dtl.cost_type_id%TYPE) IS

1692:
1693: CURSOR cur_check_rec (cp_organization_id cm_cmpt_dtl.organization_id%TYPE,
1694: cp_inventory_item_id cm_cmpt_dtl.inventory_item_id%TYPE,
1695: cp_period_id gmf_period_statuses.period_id%TYPE,
1696: cp_cost_type_id cm_cmpt_dtl.cost_type_id%TYPE) IS
1697: SELECT 'x' FROM cm_cmpt_dtl
1698: WHERE organization_id = cp_organization_id
1699: AND inventory_item_id = cp_inventory_item_id
1700: AND period_id = cp_period_id

Line 1697: SELECT 'x' FROM cm_cmpt_dtl

1693: CURSOR cur_check_rec (cp_organization_id cm_cmpt_dtl.organization_id%TYPE,
1694: cp_inventory_item_id cm_cmpt_dtl.inventory_item_id%TYPE,
1695: cp_period_id gmf_period_statuses.period_id%TYPE,
1696: cp_cost_type_id cm_cmpt_dtl.cost_type_id%TYPE) IS
1697: SELECT 'x' FROM cm_cmpt_dtl
1698: WHERE organization_id = cp_organization_id
1699: AND inventory_item_id = cp_inventory_item_id
1700: AND period_id = cp_period_id
1701: AND cost_type_id = cp_cost_type_id;

Line 1750: pi_organization_id_from IN cm_cmpt_dtl.organization_id%TYPE,

1746: PROCEDURE copy_burden_cost
1747: (
1748: po_errbuf OUT NOCOPY VARCHAR2,
1749: po_retcode OUT NOCOPY VARCHAR2,
1750: pi_organization_id_from IN cm_cmpt_dtl.organization_id%TYPE,
1751: pi_calendar_code_from IN gmf_period_statuses.calendar_code%TYPE,
1752: pi_period_code_from IN gmf_period_statuses.period_code%TYPE,
1753: pi_cost_type_id_from IN cm_cmpt_dtl.cost_type_id%TYPE,
1754: pi_organization_id_to IN cm_cmpt_dtl.organization_id%TYPE,

Line 1753: pi_cost_type_id_from IN cm_cmpt_dtl.cost_type_id%TYPE,

1749: po_retcode OUT NOCOPY VARCHAR2,
1750: pi_organization_id_from IN cm_cmpt_dtl.organization_id%TYPE,
1751: pi_calendar_code_from IN gmf_period_statuses.calendar_code%TYPE,
1752: pi_period_code_from IN gmf_period_statuses.period_code%TYPE,
1753: pi_cost_type_id_from IN cm_cmpt_dtl.cost_type_id%TYPE,
1754: pi_organization_id_to IN cm_cmpt_dtl.organization_id%TYPE,
1755: pi_calendar_code_to IN gmf_period_statuses.calendar_code%TYPE,
1756: pi_period_code_to IN gmf_period_statuses.period_code%TYPE,
1757: pi_cost_type_id_to IN cm_cmpt_dtl.cost_type_id%TYPE,

Line 1754: pi_organization_id_to IN cm_cmpt_dtl.organization_id%TYPE,

1750: pi_organization_id_from IN cm_cmpt_dtl.organization_id%TYPE,
1751: pi_calendar_code_from IN gmf_period_statuses.calendar_code%TYPE,
1752: pi_period_code_from IN gmf_period_statuses.period_code%TYPE,
1753: pi_cost_type_id_from IN cm_cmpt_dtl.cost_type_id%TYPE,
1754: pi_organization_id_to IN cm_cmpt_dtl.organization_id%TYPE,
1755: pi_calendar_code_to IN gmf_period_statuses.calendar_code%TYPE,
1756: pi_period_code_to IN gmf_period_statuses.period_code%TYPE,
1757: pi_cost_type_id_to IN cm_cmpt_dtl.cost_type_id%TYPE,
1758: pi_item_from IN mtl_item_flexfields.item_number%TYPE,

Line 1757: pi_cost_type_id_to IN cm_cmpt_dtl.cost_type_id%TYPE,

1753: pi_cost_type_id_from IN cm_cmpt_dtl.cost_type_id%TYPE,
1754: pi_organization_id_to IN cm_cmpt_dtl.organization_id%TYPE,
1755: pi_calendar_code_to IN gmf_period_statuses.calendar_code%TYPE,
1756: pi_period_code_to IN gmf_period_statuses.period_code%TYPE,
1757: pi_cost_type_id_to IN cm_cmpt_dtl.cost_type_id%TYPE,
1758: pi_item_from IN mtl_item_flexfields.item_number%TYPE,
1759: pi_item_to IN mtl_item_flexfields.item_number%TYPE,
1760: pi_itemcc_from IN mtl_categories_b_kfv.concatenated_segments%TYPE,
1761: pi_itemcc_to IN mtl_categories_b_kfv.concatenated_segments%TYPE,

Line 1938: pi_organization_id_from IN cm_cmpt_dtl.organization_id%TYPE,

1934: ******************************************************************************/
1935:
1936:
1937: PROCEDURE copy_burden_dtl(
1938: pi_organization_id_from IN cm_cmpt_dtl.organization_id%TYPE,
1939: pi_calendar_code_from IN gmf_period_statuses.calendar_code%TYPE,
1940: pi_period_code_from IN gmf_period_statuses.period_code%TYPE,
1941: pi_cost_type_id_from IN cm_cmpt_dtl.cost_type_id%TYPE,
1942: pi_organization_id_to IN cm_cmpt_dtl.organization_id%TYPE,

Line 1941: pi_cost_type_id_from IN cm_cmpt_dtl.cost_type_id%TYPE,

1937: PROCEDURE copy_burden_dtl(
1938: pi_organization_id_from IN cm_cmpt_dtl.organization_id%TYPE,
1939: pi_calendar_code_from IN gmf_period_statuses.calendar_code%TYPE,
1940: pi_period_code_from IN gmf_period_statuses.period_code%TYPE,
1941: pi_cost_type_id_from IN cm_cmpt_dtl.cost_type_id%TYPE,
1942: pi_organization_id_to IN cm_cmpt_dtl.organization_id%TYPE,
1943: pi_calendar_code_to IN gmf_period_statuses.calendar_code%TYPE,
1944: pi_period_code_to IN gmf_period_statuses.period_code%TYPE,
1945: pi_cost_type_id_to IN cm_cmpt_dtl.cost_type_id%TYPE,

Line 1942: pi_organization_id_to IN cm_cmpt_dtl.organization_id%TYPE,

1938: pi_organization_id_from IN cm_cmpt_dtl.organization_id%TYPE,
1939: pi_calendar_code_from IN gmf_period_statuses.calendar_code%TYPE,
1940: pi_period_code_from IN gmf_period_statuses.period_code%TYPE,
1941: pi_cost_type_id_from IN cm_cmpt_dtl.cost_type_id%TYPE,
1942: pi_organization_id_to IN cm_cmpt_dtl.organization_id%TYPE,
1943: pi_calendar_code_to IN gmf_period_statuses.calendar_code%TYPE,
1944: pi_period_code_to IN gmf_period_statuses.period_code%TYPE,
1945: pi_cost_type_id_to IN cm_cmpt_dtl.cost_type_id%TYPE,
1946: pi_range_type IN NUMBER,

Line 1945: pi_cost_type_id_to IN cm_cmpt_dtl.cost_type_id%TYPE,

1941: pi_cost_type_id_from IN cm_cmpt_dtl.cost_type_id%TYPE,
1942: pi_organization_id_to IN cm_cmpt_dtl.organization_id%TYPE,
1943: pi_calendar_code_to IN gmf_period_statuses.calendar_code%TYPE,
1944: pi_period_code_to IN gmf_period_statuses.period_code%TYPE,
1945: pi_cost_type_id_to IN cm_cmpt_dtl.cost_type_id%TYPE,
1946: pi_range_type IN NUMBER,
1947: pi_from_range IN VARCHAR2,
1948: pi_to_range IN VARCHAR2,
1949: pi_rem_repl IN NUMBER,

Line 1991: l_organization_id_to cm_cmpt_dtl.organization_id%TYPE;

1987: l_brdn_rows NUMBER;
1988: l_brdn_rows_upd NUMBER;
1989: l_brdn_rows_ins NUMBER;
1990:
1991: l_organization_id_to cm_cmpt_dtl.organization_id%TYPE;
1992:
1993: pi_period_id_to NUMBER;
1994: pi_period_id_from NUMBER;
1995: l_sql_stmt VARCHAR2(2000);

Line 2497: pi_organization_id IN cm_cmpt_dtl.organization_id%TYPE,

2493: *
2494: ******************************************************************************/
2495:
2496: PROCEDURE delete_burden_costs(
2497: pi_organization_id IN cm_cmpt_dtl.organization_id%TYPE,
2498: pi_period_id IN gmf_period_statuses.period_id%TYPE,
2499: pi_cost_type_id IN cm_cmpt_dtl.cost_type_id%TYPE,
2500: pi_range_type IN NUMBER,
2501: pi_from_range IN VARCHAR2,

Line 2499: pi_cost_type_id IN cm_cmpt_dtl.cost_type_id%TYPE,

2495:
2496: PROCEDURE delete_burden_costs(
2497: pi_organization_id IN cm_cmpt_dtl.organization_id%TYPE,
2498: pi_period_id IN gmf_period_statuses.period_id%TYPE,
2499: pi_cost_type_id IN cm_cmpt_dtl.cost_type_id%TYPE,
2500: pi_range_type IN NUMBER,
2501: pi_from_range IN VARCHAR2,
2502: pi_to_range IN VARCHAR2
2503: )

Line 2588: pi_inventory_item_id IN cm_cmpt_dtl.inventory_item_id%TYPE,

2584: *
2585: ******************************************************************************/
2586:
2587: FUNCTION verify_item_assigned_to_org(
2588: pi_inventory_item_id IN cm_cmpt_dtl.inventory_item_id%TYPE,
2589: pi_organization_id IN cm_cmpt_dtl.organization_id%TYPE
2590: )
2591: RETURN NUMBER IS
2592: l_assigned_ind NUMBER;

Line 2589: pi_organization_id IN cm_cmpt_dtl.organization_id%TYPE

2585: ******************************************************************************/
2586:
2587: FUNCTION verify_item_assigned_to_org(
2588: pi_inventory_item_id IN cm_cmpt_dtl.inventory_item_id%TYPE,
2589: pi_organization_id IN cm_cmpt_dtl.organization_id%TYPE
2590: )
2591: RETURN NUMBER IS
2592: l_assigned_ind NUMBER;
2593: BEGIN