[Home] [Help]
45: pi_incr_decr_cost IN NUMBER,
46: pi_rem_repl IN NUMBER,
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 NUMBER
51: );
52:
53:
67: pi_to_range IN VARCHAR2,
68: pi_rem_repl IN NUMBER,
69: pi_all_periods_from IN gmf_period_statuses.period_code%TYPE,
70: pi_all_periods_to IN gmf_period_statuses.period_code%TYPE,
71: pi_all_org_id IN gmf_legal_entities.legal_entity_id%TYPE
72: );
73:
74:
75:
179: pi_incr_decr_cost IN VARCHAR2,
180: pi_rem_repl IN VARCHAR2,
181: pi_all_periods_from IN gmf_period_statuses.period_code%TYPE,
182: pi_all_periods_to IN gmf_period_statuses.period_code%TYPE,
183: pi_all_org_id IN gmf_legal_entities.legal_entity_id%TYPE,
184: pi_copy_to_upper_lvl IN VARCHAR2
185: )
186: IS
187:
456: pi_incr_decr_cost IN NUMBER,
457: pi_rem_repl IN NUMBER,
458: pi_all_periods_from IN gmf_period_statuses.period_code%TYPE,
459: pi_all_periods_to IN gmf_period_statuses.period_code%TYPE,
460: pi_all_org_id IN gmf_legal_entities.legal_entity_id%TYPE,
461: pi_copy_to_upper_lvl IN NUMBER
462: )
463: IS
464:
522:
523: l_sql_stmt VARCHAR2(2000);
524: l_sql_org VARCHAR2(2000) ;
525: l_sql_periods VARCHAR2(2000) ;
526: l_org_id gmf_legal_entities.legal_entity_id%TYPE ;
527: l_organization_id_from cm_cmpt_dtl.organization_id%TYPE;
528: l_organization_id_to cm_cmpt_dtl.organization_id%TYPE;
529:
530: l_period_id_to gmf_period_statuses.period_id%TYPE;
1761: pi_itemcc_to IN mtl_categories_b_kfv.concatenated_segments%TYPE,
1762: pi_rem_repl IN VARCHAR2,
1763: pi_all_periods_from IN gmf_period_statuses.period_code%TYPE,
1764: pi_all_periods_to IN gmf_period_statuses.period_code%TYPE,
1765: pi_all_org_id IN gmf_legal_entities.legal_entity_id%TYPE
1766: )
1767:
1768: IS
1769:
1948: pi_to_range IN VARCHAR2,
1949: pi_rem_repl IN NUMBER,
1950: pi_all_periods_from IN gmf_period_statuses.period_code%TYPE,
1951: pi_all_periods_to IN gmf_period_statuses.period_code%TYPE,
1952: pi_all_org_id IN gmf_legal_entities.legal_entity_id%TYPE
1953: )
1954:
1955: IS
1956: