DBA Data[Home] [Help]

PACKAGE: APPS.GMF_COPY_ITEM_COST

Source


1 PACKAGE gmf_copy_item_cost AS
2 /* $Header: gmfcpics.pls 120.1.12000000.1 2007/01/17 16:56:06 appldev 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  ******************************************************************************/
23 
24 
25 PROCEDURE copy_item_cost
26 (
27 po_errbuf				      OUT 	NOCOPY 	VARCHAR2,
28 po_retcode			         OUT 	NOCOPY 	VARCHAR2,
29 pi_organization_id_from    IN 		      cm_cmpt_dtl.organization_id%TYPE,
30 pi_calendar_code_from		IN 		      cm_cmpt_dtl.calendar_code%TYPE,
31 pi_period_code_from		   IN 		      cm_cmpt_dtl.period_code%TYPE,
32 pi_cost_type_id_from		   IN 		      cm_cmpt_dtl.cost_type_id%TYPE,
33 pi_organization_id_to		IN 		      cm_cmpt_dtl.organization_id%TYPE,
34 pi_calendar_code_to		   IN 		      cm_cmpt_dtl.calendar_code%TYPE,
35 pi_period_code_to			   IN 		      cm_cmpt_dtl.period_code%TYPE,
36 pi_cost_type_id_to		   IN 		      cm_cmpt_dtl.cost_type_id%TYPE,
37 pi_item_from			      IN 		      mtl_system_items_b_kfv.concatenated_segments%TYPE,
38 pi_item_to			         IN 		      mtl_system_items_b_kfv.concatenated_segments%TYPE,
39 pi_itemcc_from			      IN 		      mtl_categories_b_kfv.concatenated_segments%TYPE,
40 pi_itemcc_to			      IN 		      mtl_categories_b_kfv.concatenated_segments%TYPE,
41 pi_incr_pct			         IN 		      VARCHAR2,
42 pi_incr_decr_cost			   IN 		      VARCHAR2,
43 pi_rem_repl			         IN 		      VARCHAR2,
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 		      VARCHAR2
48 );
49 
50 
51 PROCEDURE copy_burden_cost
52 (
53 po_errbuf				         OUT 	NOCOPY 	VARCHAR2,
54 po_retcode			            OUT 	NOCOPY 	VARCHAR2,
55 pi_organization_id_from		   IN 		cm_cmpt_dtl.organization_id%TYPE,
56 pi_calendar_code_from		   IN 		cm_cmpt_dtl.calendar_code%TYPE,
57 pi_period_code_from		      IN 		cm_cmpt_dtl.period_code%TYPE,
58 pi_cost_type_id_from		      IN 		cm_cmpt_dtl.cost_type_id%TYPE,
59 pi_organization_id_to		   IN 		cm_cmpt_dtl.organization_id%TYPE,
60 pi_calendar_code_to		      IN 		cm_cmpt_dtl.calendar_code%TYPE,
61 pi_period_code_to		         IN 		cm_cmpt_dtl.period_code%TYPE,
62 pi_cost_type_id_to		      IN 		cm_cmpt_dtl.cost_type_id%TYPE,
63 pi_item_from			         IN 		mtl_item_flexfields.item_number%TYPE,
64 pi_item_to			            IN 		mtl_item_flexfields.item_number%TYPE,
65 pi_itemcc_from			         IN 		mtl_categories_b_kfv.concatenated_segments%TYPE,
66 pi_itemcc_to			         IN 		mtl_categories_b_kfv.concatenated_segments%TYPE,
67 pi_rem_repl			            IN 		VARCHAR2,
68 pi_all_periods_from		      IN 		cm_cmpt_dtl.period_code%TYPE,
69 pi_all_periods_to		         IN 		cm_cmpt_dtl.period_code%TYPE,
70 pi_all_org_id			         IN 		gmf_legal_entities.legal_entity_id%TYPE
71 );
72 
73 END gmf_copy_item_cost;