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