DBA Data[Home] [Help]

PACKAGE: APPS.GMF_COPY_RSRC_COST

Source


1 PACKAGE gmf_copy_rsrc_cost AS
2 /* $Header: gmfcprcs.pls 120.3 2005/09/01 07:20:00 jboppana noship $ */
3 
4 /*****************************************************************************
5  *  PACKAGE
6  *    gmf_copy_rsrc_cost
7  *
8  *  DESCRIPTION
9  *    Copy Resource Costs Package
10  *
11  *  CONTENTS
12  *    FUNCTION	do_costs_exist ( ... )
13  *    PROCEDURE	copy_rsrc_cost ( ... )
14  *
15  *  HISTORY
16  *    11-Oct-1999 Rajesh Seshadri
17  *    21-Nov-2000 Uday Moogala - Bug# 1419482 Copy Cost Enhancement.
18  *      Add last 6 new parameters
19  *    30-OCT-2002  RajaSekhar    Bug#2641405 Added NOCOPY hint.
20  *
21  ******************************************************************************/
22 
23    FUNCTION do_costs_exist
24    (
25    pi_legal_entity_id	   IN             cm_rsrc_dtl.legal_entity_id%TYPE,
26 	pi_organization_id	   IN             cm_rsrc_dtl.organization_id%TYPE,
27 	pi_period_id		      IN             cm_rsrc_dtl.period_id%TYPE,
28 	pi_resource_class	      IN             cr_rsrc_mst.resource_class%TYPE
29 	)
30    RETURN NUMBER;
31 
32 
33    FUNCTION do_costs_exist
34    (
35    pi_legal_entity_id	   IN             cm_rsrc_dtl.legal_entity_id%TYPE,
36    pi_period_id		      IN             cm_rsrc_dtl.period_id%TYPE,
37 	pi_resource_class	      IN             cr_rsrc_mst.resource_class%TYPE
38 	)
39    RETURN NUMBER;
40 
41    PROCEDURE copy_rsrc_cost
42    (
43 	po_errbuf		               OUT NOCOPY  VARCHAR2,
44 	po_retcode		               OUT NOCOPY  VARCHAR2,
45    pi_legal_entity_id_from	   IN             cm_rsrc_dtl.legal_entity_id%TYPE,
46 	pi_organization_id_from	   IN             cm_rsrc_dtl.organization_id%TYPE,
47 	pi_calendar_code_from	   IN             cm_rsrc_dtl.calendar_code%TYPE,
48 	pi_period_code_from	      IN             cm_rsrc_dtl.period_code%TYPE,
49 	pi_cost_type_id_from	      IN             cm_rsrc_dtl.cost_type_id%TYPE,
50    pi_legal_entity_id_to	   IN             cm_rsrc_dtl.legal_entity_id%TYPE,
51 	pi_organization_id_to		IN             cm_rsrc_dtl.organization_id%TYPE,
52 	pi_calendar_code_to	      IN             cm_rsrc_dtl.calendar_code%TYPE,
53 	pi_period_code_to	         IN             cm_rsrc_dtl.period_code%TYPE,
54 	pi_cost_type_id_to	      IN             cm_rsrc_dtl.cost_type_id%TYPE,
55 	pi_resource_class	         IN             cr_rsrc_mst.resource_class%TYPE,
56    pi_all_periods_from        IN             cm_cmpt_dtl.period_code%TYPE,
57    pi_all_periods_to          IN             cm_cmpt_dtl.period_code%TYPE,
58    pi_all_organization_flag   IN             NUMBER
59 	);
60 
61 END gmf_copy_rsrc_cost;