eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMF_COPY_ITEM_COST dependencies on GMF_PERIOD_STATUSES

Line 23: * gmf_period_statuses.calendar_code%TYPE, gmf_period_statuses.period_code%TYPE and gmf_period_statuses.period_id%TYPE respectively.

19: * 30/Oct/2002 R.Sharath Kumar Bug# 2641405
20: * Added NOCOPY hint
21: * 14-Aug-2012 Saptagirish Pabolu - Bug#14291764
22: * Changed cm_cmpt_dtl.calendar_code%TYPE, cm_cmpt_dtl.period_code%TYPE and cm_cmpt_dtl.period_id%TYPE to
23: * gmf_period_statuses.calendar_code%TYPE, gmf_period_statuses.period_code%TYPE and gmf_period_statuses.period_id%TYPE respectively.
24: ******************************************************************************/
25:
26:
27: PROCEDURE end_copy (

Line 34: pi_calendar_code_from IN gmf_period_statuses.calendar_code%TYPE,

30: );
31:
32: PROCEDURE copy_cost_dtl(
33: pi_organization_id_from IN cm_cmpt_dtl.organization_id%TYPE,
34: pi_calendar_code_from IN gmf_period_statuses.calendar_code%TYPE,
35: pi_period_code_from IN gmf_period_statuses.period_code%TYPE,
36: pi_cost_type_id_from IN cm_cmpt_dtl.cost_type_id%TYPE,
37: pi_organization_id_to IN cm_cmpt_dtl.organization_id%TYPE,
38: pi_calendar_code_to IN gmf_period_statuses.calendar_code%TYPE,

Line 35: pi_period_code_from IN gmf_period_statuses.period_code%TYPE,

31:
32: PROCEDURE copy_cost_dtl(
33: pi_organization_id_from IN cm_cmpt_dtl.organization_id%TYPE,
34: pi_calendar_code_from IN gmf_period_statuses.calendar_code%TYPE,
35: pi_period_code_from IN gmf_period_statuses.period_code%TYPE,
36: pi_cost_type_id_from IN cm_cmpt_dtl.cost_type_id%TYPE,
37: pi_organization_id_to IN cm_cmpt_dtl.organization_id%TYPE,
38: pi_calendar_code_to IN gmf_period_statuses.calendar_code%TYPE,
39: pi_period_code_to IN gmf_period_statuses.period_code%TYPE,

Line 38: pi_calendar_code_to IN gmf_period_statuses.calendar_code%TYPE,

34: pi_calendar_code_from IN gmf_period_statuses.calendar_code%TYPE,
35: pi_period_code_from IN gmf_period_statuses.period_code%TYPE,
36: pi_cost_type_id_from IN cm_cmpt_dtl.cost_type_id%TYPE,
37: pi_organization_id_to IN cm_cmpt_dtl.organization_id%TYPE,
38: pi_calendar_code_to IN gmf_period_statuses.calendar_code%TYPE,
39: pi_period_code_to IN gmf_period_statuses.period_code%TYPE,
40: pi_cost_type_id_to IN cm_cmpt_dtl.cost_type_id%TYPE,
41: pi_range_type IN NUMBER,
42: pi_from_range IN VARCHAR2,

Line 39: pi_period_code_to IN gmf_period_statuses.period_code%TYPE,

35: pi_period_code_from IN gmf_period_statuses.period_code%TYPE,
36: pi_cost_type_id_from IN cm_cmpt_dtl.cost_type_id%TYPE,
37: pi_organization_id_to IN cm_cmpt_dtl.organization_id%TYPE,
38: pi_calendar_code_to IN gmf_period_statuses.calendar_code%TYPE,
39: pi_period_code_to IN gmf_period_statuses.period_code%TYPE,
40: pi_cost_type_id_to IN cm_cmpt_dtl.cost_type_id%TYPE,
41: pi_range_type IN NUMBER,
42: pi_from_range IN VARCHAR2,
43: pi_to_range IN VARCHAR2,

Line 47: pi_all_periods_from IN gmf_period_statuses.period_code%TYPE,

43: pi_to_range IN VARCHAR2,
44: pi_incr_pct IN NUMBER,
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: );

Line 48: pi_all_periods_to IN gmf_period_statuses.period_code%TYPE,

44: pi_incr_pct IN NUMBER,
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:

Line 58: pi_calendar_code_from IN gmf_period_statuses.calendar_code%TYPE,

54:
55:
56: PROCEDURE copy_burden_dtl(
57: pi_organization_id_from IN cm_cmpt_dtl.organization_id%TYPE,
58: pi_calendar_code_from IN gmf_period_statuses.calendar_code%TYPE,
59: pi_period_code_from IN gmf_period_statuses.period_code%TYPE,
60: pi_cost_type_id_from IN cm_cmpt_dtl.cost_type_id%TYPE,
61: pi_organization_id_to IN cm_cmpt_dtl.organization_id%TYPE,
62: pi_calendar_code_to IN gmf_period_statuses.calendar_code%TYPE,

Line 59: pi_period_code_from IN gmf_period_statuses.period_code%TYPE,

55:
56: PROCEDURE copy_burden_dtl(
57: pi_organization_id_from IN cm_cmpt_dtl.organization_id%TYPE,
58: pi_calendar_code_from IN gmf_period_statuses.calendar_code%TYPE,
59: pi_period_code_from IN gmf_period_statuses.period_code%TYPE,
60: pi_cost_type_id_from IN cm_cmpt_dtl.cost_type_id%TYPE,
61: pi_organization_id_to IN cm_cmpt_dtl.organization_id%TYPE,
62: pi_calendar_code_to IN gmf_period_statuses.calendar_code%TYPE,
63: pi_period_code_to IN gmf_period_statuses.period_code%TYPE,

Line 62: pi_calendar_code_to IN gmf_period_statuses.calendar_code%TYPE,

58: pi_calendar_code_from IN gmf_period_statuses.calendar_code%TYPE,
59: pi_period_code_from IN gmf_period_statuses.period_code%TYPE,
60: pi_cost_type_id_from IN cm_cmpt_dtl.cost_type_id%TYPE,
61: pi_organization_id_to IN cm_cmpt_dtl.organization_id%TYPE,
62: pi_calendar_code_to IN gmf_period_statuses.calendar_code%TYPE,
63: pi_period_code_to IN gmf_period_statuses.period_code%TYPE,
64: pi_cost_type_id_to IN cm_cmpt_dtl.cost_type_id%TYPE,
65: pi_range_type IN NUMBER,
66: pi_from_range IN VARCHAR2,

Line 63: pi_period_code_to IN gmf_period_statuses.period_code%TYPE,

59: pi_period_code_from IN gmf_period_statuses.period_code%TYPE,
60: pi_cost_type_id_from IN cm_cmpt_dtl.cost_type_id%TYPE,
61: pi_organization_id_to IN cm_cmpt_dtl.organization_id%TYPE,
62: pi_calendar_code_to IN gmf_period_statuses.calendar_code%TYPE,
63: pi_period_code_to IN gmf_period_statuses.period_code%TYPE,
64: pi_cost_type_id_to IN cm_cmpt_dtl.cost_type_id%TYPE,
65: pi_range_type IN NUMBER,
66: pi_from_range IN VARCHAR2,
67: pi_to_range IN VARCHAR2,

Line 69: pi_all_periods_from IN gmf_period_statuses.period_code%TYPE,

65: pi_range_type IN NUMBER,
66: pi_from_range IN VARCHAR2,
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:

Line 70: pi_all_periods_to IN gmf_period_statuses.period_code%TYPE,

66: pi_from_range IN VARCHAR2,
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:

Line 80: pi_calendar_code IN gmf_period_statuses.calendar_code%TYPE,

76:
77: PROCEDURE delete_item_costs(
78: pi_inventory_item_id IN cm_cmpt_dtl.inventory_item_id%TYPE,
79: pi_organization_id IN cm_cmpt_dtl.organization_id%TYPE,
80: pi_calendar_code IN gmf_period_statuses.calendar_code%TYPE,
81: pi_period_id IN gmf_period_statuses.period_id%TYPE,
82: pi_cost_type_id IN cm_cmpt_dtl.cost_type_id%TYPE
83: );
84:

Line 81: pi_period_id IN gmf_period_statuses.period_id%TYPE,

77: PROCEDURE delete_item_costs(
78: pi_inventory_item_id IN cm_cmpt_dtl.inventory_item_id%TYPE,
79: pi_organization_id IN cm_cmpt_dtl.organization_id%TYPE,
80: pi_calendar_code IN gmf_period_statuses.calendar_code%TYPE,
81: pi_period_id IN gmf_period_statuses.period_id%TYPE,
82: pi_cost_type_id IN cm_cmpt_dtl.cost_type_id%TYPE
83: );
84:
85:

Line 89: pi_calendar_code IN gmf_period_statuses.calendar_code%TYPE,

85:
86: FUNCTION verify_frozen_costs(
87: pi_inventory_item_id IN cm_cmpt_dtl.inventory_item_id%TYPE,
88: pi_organization_id IN cm_cmpt_dtl.organization_id%TYPE,
89: pi_calendar_code IN gmf_period_statuses.calendar_code%TYPE,
90: pi_period_id IN gmf_period_statuses.period_id%TYPE,
91: pi_cost_type_id IN cm_cmpt_dtl.cost_type_id%TYPE
92: )
93: RETURN NUMBER;

Line 90: pi_period_id IN gmf_period_statuses.period_id%TYPE,

86: FUNCTION verify_frozen_costs(
87: pi_inventory_item_id IN cm_cmpt_dtl.inventory_item_id%TYPE,
88: pi_organization_id IN cm_cmpt_dtl.organization_id%TYPE,
89: pi_calendar_code IN gmf_period_statuses.calendar_code%TYPE,
90: pi_period_id IN gmf_period_statuses.period_id%TYPE,
91: pi_cost_type_id IN cm_cmpt_dtl.cost_type_id%TYPE
92: )
93: RETURN NUMBER;
94:

Line 96: PROCEDURE verify_frozen_periods (p_period_id IN gmf_period_statuses.period_id%TYPE,

92: )
93: RETURN NUMBER;
94:
95: -- added this procedure as part of bug 5567102
96: PROCEDURE verify_frozen_periods (p_period_id IN gmf_period_statuses.period_id%TYPE,
97: p_period_code OUT NOCOPY gmf_period_statuses.period_code%TYPE,
98: p_period_status OUT NOCOPY gmf_period_statuses.period_status%TYPE );
99:
100: -- Added to check record exists in a frozen period, bug 5672543

Line 97: p_period_code OUT NOCOPY gmf_period_statuses.period_code%TYPE,

93: RETURN NUMBER;
94:
95: -- added this procedure as part of bug 5567102
96: PROCEDURE verify_frozen_periods (p_period_id IN gmf_period_statuses.period_id%TYPE,
97: p_period_code OUT NOCOPY gmf_period_statuses.period_code%TYPE,
98: p_period_status OUT NOCOPY gmf_period_statuses.period_status%TYPE );
99:
100: -- Added to check record exists in a frozen period, bug 5672543
101: FUNCTION check_rec_infrozen_period(p_organization_id cm_cmpt_dtl.organization_id%TYPE,

Line 98: p_period_status OUT NOCOPY gmf_period_statuses.period_status%TYPE );

94:
95: -- added this procedure as part of bug 5567102
96: PROCEDURE verify_frozen_periods (p_period_id IN gmf_period_statuses.period_id%TYPE,
97: p_period_code OUT NOCOPY gmf_period_statuses.period_code%TYPE,
98: p_period_status OUT NOCOPY gmf_period_statuses.period_status%TYPE );
99:
100: -- Added to check record exists in a frozen period, bug 5672543
101: FUNCTION check_rec_infrozen_period(p_organization_id cm_cmpt_dtl.organization_id%TYPE,
102: p_inventory_item_id cm_cmpt_dtl.inventory_item_id%TYPE,

Line 103: p_period_id gmf_period_statuses.period_id%TYPE,

99:
100: -- Added to check record exists in a frozen period, bug 5672543
101: FUNCTION check_rec_infrozen_period(p_organization_id cm_cmpt_dtl.organization_id%TYPE,
102: p_inventory_item_id cm_cmpt_dtl.inventory_item_id%TYPE,
103: p_period_id gmf_period_statuses.period_id%TYPE,
104: p_cost_type_id cm_cmpt_dtl.cost_type_id%TYPE)
105: RETURN BOOLEAN ;
106: FUNCTION verify_item_assigned_to_org(
107: pi_inventory_item_id IN cm_cmpt_dtl.inventory_item_id%TYPE,

Line 114: pi_period_id IN gmf_period_statuses.period_id%TYPE,

110: RETURN NUMBER;
111:
112: PROCEDURE delete_burden_costs(
113: pi_organization_id IN cm_cmpt_dtl.organization_id%TYPE,
114: pi_period_id IN gmf_period_statuses.period_id%TYPE,
115: pi_cost_type_id IN cm_cmpt_dtl.cost_type_id%TYPE,
116: pi_range_type IN NUMBER,
117: pi_from_range IN VARCHAR2,
118: pi_to_range IN VARCHAR2

Line 167: pi_calendar_code_from IN gmf_period_statuses.calendar_code%TYPE,

163: (
164: po_errbuf OUT NOCOPY VARCHAR2,
165: po_retcode OUT NOCOPY VARCHAR2,
166: pi_organization_id_from IN cm_cmpt_dtl.organization_id%TYPE,
167: pi_calendar_code_from IN gmf_period_statuses.calendar_code%TYPE,
168: pi_period_code_from IN gmf_period_statuses.period_code%TYPE,
169: pi_cost_type_id_from IN cm_cmpt_dtl.cost_type_id%TYPE,
170: pi_organization_id_to IN cm_cmpt_dtl.organization_id%TYPE,
171: pi_calendar_code_to IN gmf_period_statuses.calendar_code%TYPE,

Line 168: pi_period_code_from IN gmf_period_statuses.period_code%TYPE,

164: po_errbuf OUT NOCOPY VARCHAR2,
165: po_retcode OUT NOCOPY VARCHAR2,
166: pi_organization_id_from IN cm_cmpt_dtl.organization_id%TYPE,
167: pi_calendar_code_from IN gmf_period_statuses.calendar_code%TYPE,
168: pi_period_code_from IN gmf_period_statuses.period_code%TYPE,
169: pi_cost_type_id_from IN cm_cmpt_dtl.cost_type_id%TYPE,
170: pi_organization_id_to IN cm_cmpt_dtl.organization_id%TYPE,
171: pi_calendar_code_to IN gmf_period_statuses.calendar_code%TYPE,
172: pi_period_code_to IN gmf_period_statuses.period_code%TYPE,

Line 171: pi_calendar_code_to IN gmf_period_statuses.calendar_code%TYPE,

167: pi_calendar_code_from IN gmf_period_statuses.calendar_code%TYPE,
168: pi_period_code_from IN gmf_period_statuses.period_code%TYPE,
169: pi_cost_type_id_from IN cm_cmpt_dtl.cost_type_id%TYPE,
170: pi_organization_id_to IN cm_cmpt_dtl.organization_id%TYPE,
171: pi_calendar_code_to IN gmf_period_statuses.calendar_code%TYPE,
172: pi_period_code_to IN gmf_period_statuses.period_code%TYPE,
173: pi_cost_type_id_to IN cm_cmpt_dtl.cost_type_id%TYPE,
174: pi_item_from IN mtl_system_items_b_kfv.concatenated_segments%TYPE,
175: pi_item_to IN mtl_system_items_b_kfv.concatenated_segments%TYPE,

Line 172: pi_period_code_to IN gmf_period_statuses.period_code%TYPE,

168: pi_period_code_from IN gmf_period_statuses.period_code%TYPE,
169: pi_cost_type_id_from IN cm_cmpt_dtl.cost_type_id%TYPE,
170: pi_organization_id_to IN cm_cmpt_dtl.organization_id%TYPE,
171: pi_calendar_code_to IN gmf_period_statuses.calendar_code%TYPE,
172: pi_period_code_to IN gmf_period_statuses.period_code%TYPE,
173: pi_cost_type_id_to IN cm_cmpt_dtl.cost_type_id%TYPE,
174: pi_item_from IN mtl_system_items_b_kfv.concatenated_segments%TYPE,
175: pi_item_to IN mtl_system_items_b_kfv.concatenated_segments%TYPE,
176: pi_itemcc_from IN mtl_categories_b_kfv.concatenated_segments%TYPE,

Line 181: pi_all_periods_from IN gmf_period_statuses.period_code%TYPE,

177: pi_itemcc_to IN mtl_categories_b_kfv.concatenated_segments%TYPE,
178: pi_incr_pct IN VARCHAR2,
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: )

Line 182: pi_all_periods_to IN gmf_period_statuses.period_code%TYPE,

178: pi_incr_pct IN VARCHAR2,
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

Line 445: pi_calendar_code_from IN gmf_period_statuses.calendar_code%TYPE,

441: ******************************************************************************/
442:
443: PROCEDURE copy_cost_dtl(
444: pi_organization_id_from IN cm_cmpt_dtl.organization_id%TYPE,
445: pi_calendar_code_from IN gmf_period_statuses.calendar_code%TYPE,
446: pi_period_code_from IN gmf_period_statuses.period_code%TYPE,
447: pi_cost_type_id_from IN cm_cmpt_dtl.cost_type_id%TYPE,
448: pi_organization_id_to IN cm_cmpt_dtl.organization_id%TYPE,
449: pi_calendar_code_to IN gmf_period_statuses.calendar_code%TYPE,

Line 446: pi_period_code_from IN gmf_period_statuses.period_code%TYPE,

442:
443: PROCEDURE copy_cost_dtl(
444: pi_organization_id_from IN cm_cmpt_dtl.organization_id%TYPE,
445: pi_calendar_code_from IN gmf_period_statuses.calendar_code%TYPE,
446: pi_period_code_from IN gmf_period_statuses.period_code%TYPE,
447: pi_cost_type_id_from IN cm_cmpt_dtl.cost_type_id%TYPE,
448: pi_organization_id_to IN cm_cmpt_dtl.organization_id%TYPE,
449: pi_calendar_code_to IN gmf_period_statuses.calendar_code%TYPE,
450: pi_period_code_to IN gmf_period_statuses.period_code%TYPE,

Line 449: pi_calendar_code_to IN gmf_period_statuses.calendar_code%TYPE,

445: pi_calendar_code_from IN gmf_period_statuses.calendar_code%TYPE,
446: pi_period_code_from IN gmf_period_statuses.period_code%TYPE,
447: pi_cost_type_id_from IN cm_cmpt_dtl.cost_type_id%TYPE,
448: pi_organization_id_to IN cm_cmpt_dtl.organization_id%TYPE,
449: pi_calendar_code_to IN gmf_period_statuses.calendar_code%TYPE,
450: pi_period_code_to IN gmf_period_statuses.period_code%TYPE,
451: pi_cost_type_id_to IN cm_cmpt_dtl.cost_type_id%TYPE,
452: pi_range_type IN NUMBER,
453: pi_from_range IN VARCHAR2,

Line 450: pi_period_code_to IN gmf_period_statuses.period_code%TYPE,

446: pi_period_code_from IN gmf_period_statuses.period_code%TYPE,
447: pi_cost_type_id_from IN cm_cmpt_dtl.cost_type_id%TYPE,
448: pi_organization_id_to IN cm_cmpt_dtl.organization_id%TYPE,
449: pi_calendar_code_to IN gmf_period_statuses.calendar_code%TYPE,
450: pi_period_code_to IN gmf_period_statuses.period_code%TYPE,
451: pi_cost_type_id_to IN cm_cmpt_dtl.cost_type_id%TYPE,
452: pi_range_type IN NUMBER,
453: pi_from_range IN VARCHAR2,
454: pi_to_range IN VARCHAR2,

Line 458: pi_all_periods_from IN gmf_period_statuses.period_code%TYPE,

454: pi_to_range IN VARCHAR2,
455: pi_incr_pct IN NUMBER,
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: )

Line 459: pi_all_periods_to IN gmf_period_statuses.period_code%TYPE,

455: pi_incr_pct IN NUMBER,
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

Line 530: l_period_id_to gmf_period_statuses.period_id%TYPE;

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;
531:
532: l_from_range VARCHAR2(32767);
533: l_to_range VARCHAR2(32767);
534:

Line 541: l_curr_period_code gmf_period_statuses.period_code%TYPE;

537: l_incr_decr_cost NUMBER;
538:
539: l_curr_inventory_item_id cm_cmpt_dtl.inventory_item_id%TYPE;
540: l_curr_organization_id cm_cmpt_dtl.organization_id%TYPE;
541: l_curr_period_code gmf_period_statuses.period_code%TYPE;
542: l_frozen_flag NUMBER;
543: l_assigned_flag NUMBER;
544:
545: l_curr_inventory_item_id2 cm_cmpt_dtl.inventory_item_id%TYPE;

Line 547: l_curr_period_code2 gmf_period_statuses.period_code%TYPE;

543: l_assigned_flag NUMBER;
544:
545: l_curr_inventory_item_id2 cm_cmpt_dtl.inventory_item_id%TYPE;
546: l_curr_organization_id2 cm_cmpt_dtl.organization_id%TYPE;
547: l_curr_period_code2 gmf_period_statuses.period_code%TYPE;
548:
549: l_cost_rows NUMBER;
550: l_cost_rows_upd NUMBER;
551: l_cost_rows_ins NUMBER;

Line 554: l_period_code gmf_period_statuses.period_code%TYPE;

550: l_cost_rows_upd NUMBER;
551: l_cost_rows_ins NUMBER;
552: l_cost_rows_skip NUMBER;
553: -- bug 5567102
554: l_period_code gmf_period_statuses.period_code%TYPE;
555: l_period_status gmf_period_statuses.period_status%TYPE;
556:
557: l_copy_to_upper_lvl NUMBER;
558:

Line 555: l_period_status gmf_period_statuses.period_status%TYPE;

551: l_cost_rows_ins NUMBER;
552: l_cost_rows_skip NUMBER;
553: -- bug 5567102
554: l_period_code gmf_period_statuses.period_code%TYPE;
555: l_period_status gmf_period_statuses.period_status%TYPE;
556:
557: l_copy_to_upper_lvl NUMBER;
558:
559: pi_period_id_to NUMBER;

Line 578: FROM gmf_period_statuses gps, hr_organization_information org

574: if(pi_period_code_to is not null) then
575: if(pi_organization_id_to is not null) then
576: SELECT gps.period_id
577: INTO pi_period_id_to
578: FROM gmf_period_statuses gps, hr_organization_information org
579: WHERE gps.PERIOD_CODE = pi_period_code_to
580: AND gps.CALENDAR_CODE = pi_calendar_code_to
581: AND gps.legal_entity_id = org.org_information2
582: AND org.organization_id = pi_organization_id_to

Line 588: FROM gmf_period_statuses

584: AND gps.cost_type_id = pi_cost_type_id_to;
585: else
586: SELECT period_id
587: INTO pi_period_id_to
588: FROM gmf_period_statuses
589: WHERE PERIOD_CODE = pi_period_code_to
590: AND CALENDAR_CODE = pi_calendar_code_to
591: AND legal_entity_id = pi_all_org_id
592: AND cost_type_id = pi_cost_type_id_to;

Line 600: FROM gmf_period_statuses gps, hr_organization_information org

596: end if;
597:
598: SELECT gps.period_id
599: INTO pi_period_id_from
600: FROM gmf_period_statuses gps, hr_organization_information org
601: WHERE gps.PERIOD_CODE = pi_period_code_from
602: AND gps.CALENDAR_CODE = pi_calendar_code_from
603: AND gps.legal_entity_id = org.org_information2
604: AND org.organization_id = pi_organization_id_from

Line 783: 'gmf_period_statuses c3, gmf_period_statuses c2, gmf_period_statuses c1, hr_organization_information d ' ||

779: if(pi_organization_id_to is not null) then
780: l_sql_periods := 'SELECT ' ||
781: 'c3.period_id ' ||
782: 'FROM ' ||
783: 'gmf_period_statuses c3, gmf_period_statuses c2, gmf_period_statuses c1, hr_organization_information d ' ||
784: 'WHERE ' ||
785: 'd.organization_id = :pi_organization_id_to AND '||
786: 'd.org_information_context = ''Accounting Information'' AND '||
787: 'c1.calendar_code = :pi_calendar_code_to AND ' ||

Line 805: 'gmf_period_statuses c3, gmf_period_statuses c2, gmf_period_statuses c1 ' ||

801: else
802: l_sql_periods := 'SELECT ' ||
803: 'c3.period_id ' ||
804: 'FROM ' ||
805: 'gmf_period_statuses c3, gmf_period_statuses c2, gmf_period_statuses c1 ' ||
806: 'WHERE ' ||
807: 'c1.calendar_code = :pi_calendar_code_to AND ' ||
808: 'c1.period_code = :pi_all_periods_from AND ' ||
809: 'c2.calendar_code = :pi_calendar_code_to AND ' ||

Line 1082: p_calendar_code IN gmf_period_statuses.calendar_code%TYPE,

1078: THEN
1079: <>
1080: DECLARE
1081: CURSOR c_updins_cc_id(
1082: p_calendar_code IN gmf_period_statuses.calendar_code%TYPE,
1083: p_period_id IN gmf_period_statuses.period_id%TYPE,
1084: p_cost_type_id IN cm_cmpt_dtl.cost_type_id%TYPE,
1085: p_organization_id IN cm_cmpt_dtl.organization_id%TYPE,
1086: p_inventory_item_id IN cm_cmpt_dtl.inventory_item_id%TYPE,

Line 1083: p_period_id IN gmf_period_statuses.period_id%TYPE,

1079: <>
1080: DECLARE
1081: CURSOR c_updins_cc_id(
1082: p_calendar_code IN gmf_period_statuses.calendar_code%TYPE,
1083: p_period_id IN gmf_period_statuses.period_id%TYPE,
1084: p_cost_type_id IN cm_cmpt_dtl.cost_type_id%TYPE,
1085: p_organization_id IN cm_cmpt_dtl.organization_id%TYPE,
1086: p_inventory_item_id IN cm_cmpt_dtl.inventory_item_id%TYPE,
1087: p_cost_cmpntcls_id IN cm_cmpt_dtl.cost_cmpntcls_id%TYPE,

Line 1515: pi_calendar_code IN gmf_period_statuses.calendar_code%TYPE,

1511:
1512: PROCEDURE delete_item_costs(
1513: pi_inventory_item_id IN cm_cmpt_dtl.inventory_item_id%TYPE,
1514: pi_organization_id IN cm_cmpt_dtl.organization_id%TYPE,
1515: pi_calendar_code IN gmf_period_statuses.calendar_code%TYPE,
1516: pi_period_id IN gmf_period_statuses.period_id%TYPE,
1517: pi_cost_type_id IN cm_cmpt_dtl.cost_type_id%TYPE
1518: )
1519: IS

Line 1516: pi_period_id IN gmf_period_statuses.period_id%TYPE,

1512: PROCEDURE delete_item_costs(
1513: pi_inventory_item_id IN cm_cmpt_dtl.inventory_item_id%TYPE,
1514: pi_organization_id IN cm_cmpt_dtl.organization_id%TYPE,
1515: pi_calendar_code IN gmf_period_statuses.calendar_code%TYPE,
1516: pi_period_id IN gmf_period_statuses.period_id%TYPE,
1517: pi_cost_type_id IN cm_cmpt_dtl.cost_type_id%TYPE
1518: )
1519: IS
1520: CURSOR c_cc_id(

Line 1523: p_calendar_code IN gmf_period_statuses.calendar_code%TYPE,

1519: IS
1520: CURSOR c_cc_id(
1521: p_inventory_item_id IN cm_cmpt_dtl.inventory_item_id%TYPE,
1522: p_organization_id IN cm_cmpt_dtl.organization_id%TYPE,
1523: p_calendar_code IN gmf_period_statuses.calendar_code%TYPE,
1524: p_period_id IN gmf_period_statuses.period_id%TYPE,
1525: p_cost_type_id IN cm_cmpt_dtl.cost_type_id%TYPE
1526: )
1527: IS

Line 1524: p_period_id IN gmf_period_statuses.period_id%TYPE,

1520: CURSOR c_cc_id(
1521: p_inventory_item_id IN cm_cmpt_dtl.inventory_item_id%TYPE,
1522: p_organization_id IN cm_cmpt_dtl.organization_id%TYPE,
1523: p_calendar_code IN gmf_period_statuses.calendar_code%TYPE,
1524: p_period_id IN gmf_period_statuses.period_id%TYPE,
1525: p_cost_type_id IN cm_cmpt_dtl.cost_type_id%TYPE
1526: )
1527: IS
1528: SELECT

Line 1610: pi_calendar_code IN gmf_period_statuses.calendar_code%TYPE,

1606:
1607: FUNCTION verify_frozen_costs(
1608: pi_inventory_item_id IN cm_cmpt_dtl.inventory_item_id%TYPE,
1609: pi_organization_id IN cm_cmpt_dtl.organization_id%TYPE,
1610: pi_calendar_code IN gmf_period_statuses.calendar_code%TYPE,
1611: pi_period_id IN gmf_period_statuses.period_id%TYPE,
1612: pi_cost_type_id IN cm_cmpt_dtl.cost_type_id%TYPE
1613: )
1614: RETURN NUMBER IS

Line 1611: pi_period_id IN gmf_period_statuses.period_id%TYPE,

1607: FUNCTION verify_frozen_costs(
1608: pi_inventory_item_id IN cm_cmpt_dtl.inventory_item_id%TYPE,
1609: pi_organization_id IN cm_cmpt_dtl.organization_id%TYPE,
1610: pi_calendar_code IN gmf_period_statuses.calendar_code%TYPE,
1611: pi_period_id IN gmf_period_statuses.period_id%TYPE,
1612: pi_cost_type_id IN cm_cmpt_dtl.cost_type_id%TYPE
1613: )
1614: RETURN NUMBER IS
1615:

Line 1647: PROCEDURE verify_frozen_periods (p_period_id IN gmf_period_statuses.period_id%TYPE,

1643: * HISTORY
1644: * 12-Oct-2006 pmarada, created for bug 5567102
1645: *
1646: ******************************************************************************/
1647: PROCEDURE verify_frozen_periods (p_period_id IN gmf_period_statuses.period_id%TYPE,
1648: p_period_code OUT NOCOPY gmf_period_statuses.period_code%TYPE,
1649: p_period_status OUT NOCOPY gmf_period_statuses.period_status%TYPE )
1650: IS
1651:

Line 1648: p_period_code OUT NOCOPY gmf_period_statuses.period_code%TYPE,

1644: * 12-Oct-2006 pmarada, created for bug 5567102
1645: *
1646: ******************************************************************************/
1647: PROCEDURE verify_frozen_periods (p_period_id IN gmf_period_statuses.period_id%TYPE,
1648: p_period_code OUT NOCOPY gmf_period_statuses.period_code%TYPE,
1649: p_period_status OUT NOCOPY gmf_period_statuses.period_status%TYPE )
1650: IS
1651:
1652: CURSOR cur_froz_periods (cp_period_id gmf_period_statuses.period_id%TYPE) IS

Line 1649: p_period_status OUT NOCOPY gmf_period_statuses.period_status%TYPE )

1645: *
1646: ******************************************************************************/
1647: PROCEDURE verify_frozen_periods (p_period_id IN gmf_period_statuses.period_id%TYPE,
1648: p_period_code OUT NOCOPY gmf_period_statuses.period_code%TYPE,
1649: p_period_status OUT NOCOPY gmf_period_statuses.period_status%TYPE )
1650: IS
1651:
1652: CURSOR cur_froz_periods (cp_period_id gmf_period_statuses.period_id%TYPE) IS
1653: SELECT period_code, period_status FROM gmf_period_statuses

Line 1652: CURSOR cur_froz_periods (cp_period_id gmf_period_statuses.period_id%TYPE) IS

1648: p_period_code OUT NOCOPY gmf_period_statuses.period_code%TYPE,
1649: p_period_status OUT NOCOPY gmf_period_statuses.period_status%TYPE )
1650: IS
1651:
1652: CURSOR cur_froz_periods (cp_period_id gmf_period_statuses.period_id%TYPE) IS
1653: SELECT period_code, period_status FROM gmf_period_statuses
1654: WHERE period_id = cp_period_id;
1655:
1656: l_per_code gmf_period_statuses.period_code%TYPE;

Line 1653: SELECT period_code, period_status FROM gmf_period_statuses

1649: p_period_status OUT NOCOPY gmf_period_statuses.period_status%TYPE )
1650: IS
1651:
1652: CURSOR cur_froz_periods (cp_period_id gmf_period_statuses.period_id%TYPE) IS
1653: SELECT period_code, period_status FROM gmf_period_statuses
1654: WHERE period_id = cp_period_id;
1655:
1656: l_per_code gmf_period_statuses.period_code%TYPE;
1657: l_per_status gmf_period_statuses.period_status%TYPE;

Line 1656: l_per_code gmf_period_statuses.period_code%TYPE;

1652: CURSOR cur_froz_periods (cp_period_id gmf_period_statuses.period_id%TYPE) IS
1653: SELECT period_code, period_status FROM gmf_period_statuses
1654: WHERE period_id = cp_period_id;
1655:
1656: l_per_code gmf_period_statuses.period_code%TYPE;
1657: l_per_status gmf_period_statuses.period_status%TYPE;
1658:
1659: BEGIN
1660: gmf_util.trace( 'Entering verify_frozen_periods', 0 );

Line 1657: l_per_status gmf_period_statuses.period_status%TYPE;

1653: SELECT period_code, period_status FROM gmf_period_statuses
1654: WHERE period_id = cp_period_id;
1655:
1656: l_per_code gmf_period_statuses.period_code%TYPE;
1657: l_per_status gmf_period_statuses.period_status%TYPE;
1658:
1659: BEGIN
1660: gmf_util.trace( 'Entering verify_frozen_periods', 0 );
1661: OPEN cur_froz_periods (p_period_id);

Line 1688: p_period_id gmf_period_statuses.period_id%TYPE,

1684: *
1685: ******************************************************************************/
1686: FUNCTION check_rec_infrozen_period(p_organization_id cm_cmpt_dtl.organization_id%TYPE,
1687: p_inventory_item_id cm_cmpt_dtl.inventory_item_id%TYPE,
1688: p_period_id gmf_period_statuses.period_id%TYPE,
1689: p_cost_type_id cm_cmpt_dtl.cost_type_id%TYPE
1690: )
1691: RETURN BOOLEAN IS
1692:

Line 1695: cp_period_id gmf_period_statuses.period_id%TYPE,

1691: RETURN BOOLEAN IS
1692:
1693: CURSOR cur_check_rec (cp_organization_id cm_cmpt_dtl.organization_id%TYPE,
1694: cp_inventory_item_id cm_cmpt_dtl.inventory_item_id%TYPE,
1695: cp_period_id gmf_period_statuses.period_id%TYPE,
1696: cp_cost_type_id cm_cmpt_dtl.cost_type_id%TYPE) IS
1697: SELECT 'x' FROM cm_cmpt_dtl
1698: WHERE organization_id = cp_organization_id
1699: AND inventory_item_id = cp_inventory_item_id

Line 1751: pi_calendar_code_from IN gmf_period_statuses.calendar_code%TYPE,

1747: (
1748: po_errbuf OUT NOCOPY VARCHAR2,
1749: po_retcode OUT NOCOPY VARCHAR2,
1750: pi_organization_id_from IN cm_cmpt_dtl.organization_id%TYPE,
1751: pi_calendar_code_from IN gmf_period_statuses.calendar_code%TYPE,
1752: pi_period_code_from IN gmf_period_statuses.period_code%TYPE,
1753: pi_cost_type_id_from IN cm_cmpt_dtl.cost_type_id%TYPE,
1754: pi_organization_id_to IN cm_cmpt_dtl.organization_id%TYPE,
1755: pi_calendar_code_to IN gmf_period_statuses.calendar_code%TYPE,

Line 1752: pi_period_code_from IN gmf_period_statuses.period_code%TYPE,

1748: po_errbuf OUT NOCOPY VARCHAR2,
1749: po_retcode OUT NOCOPY VARCHAR2,
1750: pi_organization_id_from IN cm_cmpt_dtl.organization_id%TYPE,
1751: pi_calendar_code_from IN gmf_period_statuses.calendar_code%TYPE,
1752: pi_period_code_from IN gmf_period_statuses.period_code%TYPE,
1753: pi_cost_type_id_from IN cm_cmpt_dtl.cost_type_id%TYPE,
1754: pi_organization_id_to IN cm_cmpt_dtl.organization_id%TYPE,
1755: pi_calendar_code_to IN gmf_period_statuses.calendar_code%TYPE,
1756: pi_period_code_to IN gmf_period_statuses.period_code%TYPE,

Line 1755: pi_calendar_code_to IN gmf_period_statuses.calendar_code%TYPE,

1751: pi_calendar_code_from IN gmf_period_statuses.calendar_code%TYPE,
1752: pi_period_code_from IN gmf_period_statuses.period_code%TYPE,
1753: pi_cost_type_id_from IN cm_cmpt_dtl.cost_type_id%TYPE,
1754: pi_organization_id_to IN cm_cmpt_dtl.organization_id%TYPE,
1755: pi_calendar_code_to IN gmf_period_statuses.calendar_code%TYPE,
1756: pi_period_code_to IN gmf_period_statuses.period_code%TYPE,
1757: pi_cost_type_id_to IN cm_cmpt_dtl.cost_type_id%TYPE,
1758: pi_item_from IN mtl_item_flexfields.item_number%TYPE,
1759: pi_item_to IN mtl_item_flexfields.item_number%TYPE,

Line 1756: pi_period_code_to IN gmf_period_statuses.period_code%TYPE,

1752: pi_period_code_from IN gmf_period_statuses.period_code%TYPE,
1753: pi_cost_type_id_from IN cm_cmpt_dtl.cost_type_id%TYPE,
1754: pi_organization_id_to IN cm_cmpt_dtl.organization_id%TYPE,
1755: pi_calendar_code_to IN gmf_period_statuses.calendar_code%TYPE,
1756: pi_period_code_to IN gmf_period_statuses.period_code%TYPE,
1757: pi_cost_type_id_to IN cm_cmpt_dtl.cost_type_id%TYPE,
1758: pi_item_from IN mtl_item_flexfields.item_number%TYPE,
1759: pi_item_to IN mtl_item_flexfields.item_number%TYPE,
1760: pi_itemcc_from IN mtl_categories_b_kfv.concatenated_segments%TYPE,

Line 1763: pi_all_periods_from IN gmf_period_statuses.period_code%TYPE,

1759: pi_item_to IN mtl_item_flexfields.item_number%TYPE,
1760: pi_itemcc_from IN mtl_categories_b_kfv.concatenated_segments%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:

Line 1764: pi_all_periods_to IN gmf_period_statuses.period_code%TYPE,

1760: pi_itemcc_from IN mtl_categories_b_kfv.concatenated_segments%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

Line 1939: pi_calendar_code_from IN gmf_period_statuses.calendar_code%TYPE,

1935:
1936:
1937: PROCEDURE copy_burden_dtl(
1938: pi_organization_id_from IN cm_cmpt_dtl.organization_id%TYPE,
1939: pi_calendar_code_from IN gmf_period_statuses.calendar_code%TYPE,
1940: pi_period_code_from IN gmf_period_statuses.period_code%TYPE,
1941: pi_cost_type_id_from IN cm_cmpt_dtl.cost_type_id%TYPE,
1942: pi_organization_id_to IN cm_cmpt_dtl.organization_id%TYPE,
1943: pi_calendar_code_to IN gmf_period_statuses.calendar_code%TYPE,

Line 1940: pi_period_code_from IN gmf_period_statuses.period_code%TYPE,

1936:
1937: PROCEDURE copy_burden_dtl(
1938: pi_organization_id_from IN cm_cmpt_dtl.organization_id%TYPE,
1939: pi_calendar_code_from IN gmf_period_statuses.calendar_code%TYPE,
1940: pi_period_code_from IN gmf_period_statuses.period_code%TYPE,
1941: pi_cost_type_id_from IN cm_cmpt_dtl.cost_type_id%TYPE,
1942: pi_organization_id_to IN cm_cmpt_dtl.organization_id%TYPE,
1943: pi_calendar_code_to IN gmf_period_statuses.calendar_code%TYPE,
1944: pi_period_code_to IN gmf_period_statuses.period_code%TYPE,

Line 1943: pi_calendar_code_to IN gmf_period_statuses.calendar_code%TYPE,

1939: pi_calendar_code_from IN gmf_period_statuses.calendar_code%TYPE,
1940: pi_period_code_from IN gmf_period_statuses.period_code%TYPE,
1941: pi_cost_type_id_from IN cm_cmpt_dtl.cost_type_id%TYPE,
1942: pi_organization_id_to IN cm_cmpt_dtl.organization_id%TYPE,
1943: pi_calendar_code_to IN gmf_period_statuses.calendar_code%TYPE,
1944: pi_period_code_to IN gmf_period_statuses.period_code%TYPE,
1945: pi_cost_type_id_to IN cm_cmpt_dtl.cost_type_id%TYPE,
1946: pi_range_type IN NUMBER,
1947: pi_from_range IN VARCHAR2,

Line 1944: pi_period_code_to IN gmf_period_statuses.period_code%TYPE,

1940: pi_period_code_from IN gmf_period_statuses.period_code%TYPE,
1941: pi_cost_type_id_from IN cm_cmpt_dtl.cost_type_id%TYPE,
1942: pi_organization_id_to IN cm_cmpt_dtl.organization_id%TYPE,
1943: pi_calendar_code_to IN gmf_period_statuses.calendar_code%TYPE,
1944: pi_period_code_to IN gmf_period_statuses.period_code%TYPE,
1945: pi_cost_type_id_to IN cm_cmpt_dtl.cost_type_id%TYPE,
1946: pi_range_type IN NUMBER,
1947: pi_from_range IN VARCHAR2,
1948: pi_to_range IN VARCHAR2,

Line 1950: pi_all_periods_from IN gmf_period_statuses.period_code%TYPE,

1946: pi_range_type IN NUMBER,
1947: pi_from_range IN VARCHAR2,
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:

Line 1951: pi_all_periods_to IN gmf_period_statuses.period_code%TYPE,

1947: pi_from_range IN VARCHAR2,
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

Line 1986: l_period_id_to gmf_period_statuses.period_id%TYPE ;

1982: l_sql_org_b VARCHAR2(2000);
1983: l_sql_periods_b VARCHAR2(2000);
1984: l_org_id mtl_organizations.organization_id%TYPE ;
1985:
1986: l_period_id_to gmf_period_statuses.period_id%TYPE ;
1987: l_brdn_rows NUMBER;
1988: l_brdn_rows_upd NUMBER;
1989: l_brdn_rows_ins NUMBER;
1990:

Line 2008: FROM gmf_period_statuses gps, hr_organization_information org

2004: if(pi_period_code_to is not null) then
2005: if(pi_organization_id_to is not null) then
2006: SELECT gps.period_id
2007: INTO pi_period_id_to
2008: FROM gmf_period_statuses gps, hr_organization_information org
2009: WHERE gps.PERIOD_CODE = pi_period_code_to
2010: AND gps.CALENDAR_CODE = pi_calendar_code_to
2011: AND gps.legal_entity_id = org.org_information2
2012: AND org.organization_id = pi_organization_id_to

Line 2018: FROM gmf_period_statuses

2014: AND gps.cost_type_id = pi_cost_type_id_to;
2015: else
2016: SELECT period_id
2017: INTO pi_period_id_to
2018: FROM gmf_period_statuses
2019: WHERE PERIOD_CODE = pi_period_code_to
2020: AND CALENDAR_CODE = pi_calendar_code_to
2021: AND legal_entity_id = pi_all_org_id
2022: AND cost_type_id = pi_cost_type_id_to;

Line 2030: FROM gmf_period_statuses gps, hr_organization_information org

2026: end if;
2027:
2028: SELECT gps.period_id
2029: INTO pi_period_id_from
2030: FROM gmf_period_statuses gps, hr_organization_information org
2031: WHERE gps.PERIOD_CODE = pi_period_code_from
2032: AND gps.CALENDAR_CODE = pi_calendar_code_from
2033: AND gps.legal_entity_id = org.org_information2
2034: and org.organization_id = pi_organization_id_from

Line 2161: 'gmf_period_statuses c3, gmf_period_statuses c2, gmf_period_statuses c1, hr_organization_information d ' ||

2157: if(pi_organization_id_to is not null) then
2158: l_sql_periods_b := 'SELECT ' ||
2159: 'c3.period_id ' ||
2160: 'FROM ' ||
2161: 'gmf_period_statuses c3, gmf_period_statuses c2, gmf_period_statuses c1, hr_organization_information d ' ||
2162: 'WHERE ' ||
2163: 'd.organization_id = :pi_organization_id_to AND '||
2164: 'd.org_information_context = ''Accounting Information'' AND '||
2165: 'c1.calendar_code = :pi_calendar_code_to AND ' ||

Line 2183: 'gmf_period_statuses c3, gmf_period_statuses c2, gmf_period_statuses c1 ' ||

2179: else
2180: l_sql_periods_b := 'SELECT ' ||
2181: 'c3.period_id ' ||
2182: 'FROM ' ||
2183: 'gmf_period_statuses c3, gmf_period_statuses c2, gmf_period_statuses c1 ' ||
2184: 'WHERE ' ||
2185: 'c1.calendar_code = :pi_calendar_code_to AND ' ||
2186: 'c1.period_code = :pi_all_periods_from AND ' ||
2187: 'c2.calendar_code = :pi_calendar_code_to AND ' ||

Line 2498: pi_period_id IN gmf_period_statuses.period_id%TYPE,

2494: ******************************************************************************/
2495:
2496: PROCEDURE delete_burden_costs(
2497: pi_organization_id IN cm_cmpt_dtl.organization_id%TYPE,
2498: pi_period_id IN gmf_period_statuses.period_id%TYPE,
2499: pi_cost_type_id IN cm_cmpt_dtl.cost_type_id%TYPE,
2500: pi_range_type IN NUMBER,
2501: pi_from_range IN VARCHAR2,
2502: pi_to_range IN VARCHAR2