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: )
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;
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:
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;
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,
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,
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,
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,
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,
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,
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,
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,
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,
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