DBA Data[Home] [Help]

APPS.GMF_COPY_ITEM_COST dependencies on GMF_PERIOD_STATUSES

Line 24: * gmf_period_statuses.calendar_code%TYPE, gmf_period_statuses.period_code%TYPE respectively.

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

Line 33: pi_calendar_code_from IN gmf_period_statuses.calendar_code%TYPE,

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,

Line 34: pi_period_code_from IN gmf_period_statuses.period_code%TYPE,

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,

Line 37: pi_calendar_code_to IN gmf_period_statuses.calendar_code%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,

Line 38: pi_period_code_to IN gmf_period_statuses.period_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,

Line 47: pi_all_periods_from IN gmf_period_statuses.period_code%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: );

Line 48: pi_all_periods_to IN gmf_period_statuses.period_code%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:

Line 59: pi_calendar_code_from IN gmf_period_statuses.calendar_code%TYPE,

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,

Line 60: pi_period_code_from IN gmf_period_statuses.period_code%TYPE,

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,

Line 63: pi_calendar_code_to IN gmf_period_statuses.calendar_code%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,

Line 64: pi_period_code_to IN gmf_period_statuses.period_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,

Line 71: pi_all_periods_from IN gmf_period_statuses.period_code%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:

Line 72: pi_all_periods_to IN gmf_period_statuses.period_code%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;