APPS.GMS_FC_SYS dependencies on GMS_ENCUMBRANCE_ITEMS_ALL

Line 77: from gms_encumbrance_items_all gei,

73: gei.acct_raw_cost,
74: adl.capitalizable_flag,
75: adl.bill_hold_flag,
76: adl.billable_flag
77: from gms_encumbrance_items_all gei,
78: gms_encumbrances_all ge,
79: gms_award_distributions adl
80: where gei.encumbrance_id = ge.encumbrance_id
81: and gei.encumbrance_item_id = adl.expenditure_item_id

Line 124: from gms_encumbrance_items_all gei,

120: gei.acct_raw_cost,
121: adl.capitalizable_flag,
122: adl.bill_hold_flag,
123: adl.billable_flag
124: from gms_encumbrance_items_all gei,
125: gms_award_distributions adl
126: where gei.encumbrance_item_id = adl.expenditure_item_id
127: and adl.adl_status = 'A'
128: and adl.document_type = 'ENC'

Line 255: gms_encumbrance_items_all gei

251: pa_expenditure_types pet,
252: gms_award_distributions adl,
253: -- gms_encumbrance_groups_all geg, -- Bug 9191719
254: gms_encumbrances_all ge,
255: gms_encumbrance_items_all gei
256: where gei.request_id = p_request_id
257: -- and ge.encumbrance_group = geg.encumbrance_group -- Bug 9191719
258: and ge.encumbrance_id = gei.encumbrance_id
259: and adl.project_id = nvl(p_project_id, adl.project_id) -- Bug 9191719

Line 496: gms_encumbrance_items_all gei

492: pa_expenditure_types pet,
493: gms_award_distributions adl,
494: -- gms_encumbrance_groups_all geg, -- Bug 9191719
495: gms_encumbrances_all ge,
496: gms_encumbrance_items_all gei
497: where gei.request_id = p_request_id
498: -- and ge.encumbrance_group = geg.encumbrance_group -- Bug 9191719
499: and ge.encumbrance_id = gei.encumbrance_id
500: and adl.project_id = nvl(p_project_id, adl.project_id) -- Bug 9191719

Line 562: /* ---------------- Update of Requset Id on gms_encumbrance_items_all --------------------- */ --1472753

558: where packet_id = x_packet_id;
559:
560: BEGIN
561:
562: /* ---------------- Update of Requset Id on gms_encumbrance_items_all --------------------- */ --1472753
563:
564: if p_enc_group is null then -- added for bug:8232859
565:
566: update gms_encumbrance_items_all

Line 566: update gms_encumbrance_items_all

562: /* ---------------- Update of Requset Id on gms_encumbrance_items_all --------------------- */ --1472753
563:
564: if p_enc_group is null then -- added for bug:8232859
565:
566: update gms_encumbrance_items_all
567: set request_id = l_request_id
568: where encumbrance_item_id in (
569: select gei.encumbrance_item_id
570: from

Line 576: gms_encumbrance_items_all gei

572: -- gms_project_types gpt, -- Bug 9191719
573: gms_award_distributions adl,
574: gms_encumbrance_groups_all geg,
575: gms_encumbrances_all ge,
576: gms_encumbrance_items_all gei
577: where /*geg.encumbrance_group = nvl(p_enc_group,geg.encumbrance_group) -- Bug:8232859
578: and */geg.encumbrance_group_status_code = 'RELEASED' -- Bug Fix 1364085
579: and ge.encumbrance_group = geg.encumbrance_group
580: and ge.encumbrance_id = gei.encumbrance_id

Line 594: update gms_encumbrance_items_all

590: -- and gpt.sponsored_flag = 'Y' -- Bug 9191719 : no need to check this as all tables in context are Grants tables
591: and nvl(adl.adl_status,'A')= 'A');
592:
593: else
594: update gms_encumbrance_items_all
595: set request_id = l_request_id
596: where encumbrance_item_id in (
597: select gei.encumbrance_item_id
598: from

Line 604: gms_encumbrance_items_all gei

600: -- gms_project_types gpt, -- Bug 9191719
601: gms_award_distributions adl,
602: gms_encumbrance_groups_all geg,
603: gms_encumbrances_all ge,
604: gms_encumbrance_items_all gei
605: where geg.encumbrance_group = p_enc_group -- Bug:8232859
606: and geg.encumbrance_group_status_code = 'RELEASED' -- Bug Fix 1364085
607: and ge.encumbrance_group = geg.encumbrance_group
608: and ge.encumbrance_id = gei.encumbrance_id

Line 622: /* ---------------- Update of Requset Id on gms_encumbrance_items_all --------------------- */ --1472753

618: -- and gpt.sponsored_flag = 'Y' -- Bug 9191719 : no need to check this as all tables in context are Grants tables
619: and nvl(adl.adl_status,'A')= 'A');
620:
621: end if;
622: /* ---------------- Update of Requset Id on gms_encumbrance_items_all --------------------- */ --1472753
623:
624: select gl_bc_packets_s.nextval into x_packet_id from dual;
625:
626: insert into gms_bc_packets (

Line 721: gms_encumbrance_items_all gei

717: pa_expenditure_types pet,
718: gms_award_distributions adl,
719: -- gms_encumbrance_groups_all geg, -- Bug 9191719
720: gms_encumbrances_all ge,
721: gms_encumbrance_items_all gei
722: where gei.request_id=l_request_id
723: -- and ge.encumbrance_group = geg.encumbrance_group
724: and ge.encumbrance_id = gei.encumbrance_id
725: and adl.project_id = nvl(p_project_id, adl.project_id) -- Bug 9191719