[Home] [Help]
PACKAGE: APPS.GMF_COPY_ITEM_COST
Source
1 PACKAGE gmf_copy_item_cost AUTHID CURRENT_USER AS
2 /* $Header: gmfcpics.pls 120.1.12020000.2 2012/08/14 09:43:13 spabolu ship $ */
3
4 /*****************************************************************************
5 * PACKAGE
6 * gmf_copy_item_cost
7 *
8 * DESCRIPTION
9 * Copy Item Costs Package
10 *
11 * CONTENTS
12 * PROCEDURE copy_item_cost ( ... )
13 *
14 * HISTORY
15 * 13-Oct-1999 Rajesh Seshadri
16 * 21-Nov-2000 Uday Moogala - Bug# 1419482 Copy Cost Enhancement.
17 * Add last 6 new parameters.
18 * 24-Jan-2002 Chetan Nagar - B2198228 Added paramter copy_to_upper_lvl
19 * for enhancement fix related to cost rollup (Ref. Bug 2116142).
20 * 30/Oct/2002 R.Sharath Kumar Bug# 2641405
21 * Added NOCOPY hint
22 * 14-Aug-2012 Saptagirish Pabolu - Bug#14291764
23 * Changed cm_cmpt_dtl.calendar_code%TYPE, cm_cmpt_dtl.period_code%TYPE to
24 * gmf_period_statuses.calendar_code%TYPE, gmf_period_statuses.period_code%TYPE respectively.
25 ******************************************************************************/
26
27
28 PROCEDURE copy_item_cost
29 (
30 po_errbuf OUT NOCOPY VARCHAR2,
31 po_retcode OUT NOCOPY VARCHAR2,
32 pi_organization_id_from IN cm_cmpt_dtl.organization_id%TYPE,
33 pi_calendar_code_from IN gmf_period_statuses.calendar_code%TYPE,
34 pi_period_code_from IN gmf_period_statuses.period_code%TYPE,
35 pi_cost_type_id_from IN cm_cmpt_dtl.cost_type_id%TYPE,
36 pi_organization_id_to IN cm_cmpt_dtl.organization_id%TYPE,
37 pi_calendar_code_to IN gmf_period_statuses.calendar_code%TYPE,
38 pi_period_code_to IN gmf_period_statuses.period_code%TYPE,
39 pi_cost_type_id_to IN cm_cmpt_dtl.cost_type_id%TYPE,
40 pi_item_from IN mtl_system_items_b_kfv.concatenated_segments%TYPE,
41 pi_item_to IN mtl_system_items_b_kfv.concatenated_segments%TYPE,
42 pi_itemcc_from IN mtl_categories_b_kfv.concatenated_segments%TYPE,
43 pi_itemcc_to IN mtl_categories_b_kfv.concatenated_segments%TYPE,
44 pi_incr_pct IN VARCHAR2,
45 pi_incr_decr_cost IN VARCHAR2,
46 pi_rem_repl IN VARCHAR2,
47 pi_all_periods_from IN gmf_period_statuses.period_code%TYPE,
48 pi_all_periods_to IN gmf_period_statuses.period_code%TYPE,
49 pi_all_org_id IN gmf_legal_entities.legal_entity_id%TYPE,
50 pi_copy_to_upper_lvl IN VARCHAR2
51 );
52
53
54 PROCEDURE copy_burden_cost
55 (
56 po_errbuf OUT NOCOPY VARCHAR2,
57 po_retcode OUT NOCOPY VARCHAR2,
58 pi_organization_id_from IN cm_cmpt_dtl.organization_id%TYPE,
59 pi_calendar_code_from IN gmf_period_statuses.calendar_code%TYPE,
60 pi_period_code_from IN gmf_period_statuses.period_code%TYPE,
61 pi_cost_type_id_from IN cm_cmpt_dtl.cost_type_id%TYPE,
62 pi_organization_id_to IN cm_cmpt_dtl.organization_id%TYPE,
63 pi_calendar_code_to IN gmf_period_statuses.calendar_code%TYPE,
64 pi_period_code_to IN gmf_period_statuses.period_code%TYPE,
65 pi_cost_type_id_to IN cm_cmpt_dtl.cost_type_id%TYPE,
66 pi_item_from IN mtl_item_flexfields.item_number%TYPE,
67 pi_item_to IN mtl_item_flexfields.item_number%TYPE,
68 pi_itemcc_from IN mtl_categories_b_kfv.concatenated_segments%TYPE,
69 pi_itemcc_to IN mtl_categories_b_kfv.concatenated_segments%TYPE,
70 pi_rem_repl IN VARCHAR2,
71 pi_all_periods_from IN gmf_period_statuses.period_code%TYPE,
72 pi_all_periods_to IN gmf_period_statuses.period_code%TYPE,
73 pi_all_org_id IN gmf_legal_entities.legal_entity_id%TYPE
74 );
75
76 END gmf_copy_item_cost;