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.GMS_SWEEPER dependencies on GMS_BC_PACKETS

Line 15: Type Fail_Rec is RECORD(resource_list_id gms_bc_packets.resource_list_member_id%type,

11: Task_Id gms_event_attribute.actual_task_id%type,
12: Amount gms_event_attribute.bill_amount%type,
13: Reason Varchar2(200));
14:
15: Type Fail_Rec is RECORD(resource_list_id gms_bc_packets.resource_list_member_id%type,
16: person_id pa_expenditures_all.incurred_by_person_id%type,
17: job_id pa_expenditure_items_all.job_id%type,
18: org_id pa_expenditures_all.incurred_by_organization_id%type,
19: expenditure_type pa_expenditure_items_all.expenditure_type%type,

Line 26: bvid gms_bc_packets.budget_version_id%type,

22: rev_category pa_expenditure_types.revenue_category_code%type,
23: nlr_org_id pa_expenditure_items_all.organization_id%type,
24: sys_link pa_expenditure_items_all.system_linkage_function%type,
25: exp_date pa_expenditure_items_all.expenditure_item_date%type,
26: bvid gms_bc_packets.budget_version_id%type,
27: bud_task gms_bc_packets.bud_task_id%type,
28: cat_code pa_budget_entry_methods.categorization_code%type,
29: tp_code pa_budget_entry_methods.time_phased_type_code%type);
30:

Line 27: bud_task gms_bc_packets.bud_task_id%type,

23: nlr_org_id pa_expenditure_items_all.organization_id%type,
24: sys_link pa_expenditure_items_all.system_linkage_function%type,
25: exp_date pa_expenditure_items_all.expenditure_item_date%type,
26: bvid gms_bc_packets.budget_version_id%type,
27: bud_task gms_bc_packets.bud_task_id%type,
28: cat_code pa_budget_entry_methods.categorization_code%type,
29: tp_code pa_budget_entry_methods.time_phased_type_code%type);
30:
31: Type Err_Bal_Tab is table of Bal_Rec

Line 391: x_project_id IN gms_bc_packets.project_id%TYPE,

387: ----------------------------------------------------------------------------------------
388: -- Procedure to calculate start and end date for all amount type and boundary code combinations
389:
390: PROCEDURE setup_start_end_date (
391: x_project_id IN gms_bc_packets.project_id%TYPE,
392: x_award_id IN gms_bc_packets.award_id%TYPE,
393: x_bud_task_id IN gms_bc_packets.bud_task_id%TYPE, -- Bug 2673200
394: x_budget_version_id IN gms_bc_packets.budget_version_id%TYPE,
395: x_time_phased_type_code IN pa_budget_entry_methods.time_phased_type_code%TYPE,

Line 392: x_award_id IN gms_bc_packets.award_id%TYPE,

388: -- Procedure to calculate start and end date for all amount type and boundary code combinations
389:
390: PROCEDURE setup_start_end_date (
391: x_project_id IN gms_bc_packets.project_id%TYPE,
392: x_award_id IN gms_bc_packets.award_id%TYPE,
393: x_bud_task_id IN gms_bc_packets.bud_task_id%TYPE, -- Bug 2673200
394: x_budget_version_id IN gms_bc_packets.budget_version_id%TYPE,
395: x_time_phased_type_code IN pa_budget_entry_methods.time_phased_type_code%TYPE,
396: x_entry_level_code IN pa_budget_entry_methods.entry_level_code%TYPE, --Bug 2673200

Line 393: x_bud_task_id IN gms_bc_packets.bud_task_id%TYPE, -- Bug 2673200

389:
390: PROCEDURE setup_start_end_date (
391: x_project_id IN gms_bc_packets.project_id%TYPE,
392: x_award_id IN gms_bc_packets.award_id%TYPE,
393: x_bud_task_id IN gms_bc_packets.bud_task_id%TYPE, -- Bug 2673200
394: x_budget_version_id IN gms_bc_packets.budget_version_id%TYPE,
395: x_time_phased_type_code IN pa_budget_entry_methods.time_phased_type_code%TYPE,
396: x_entry_level_code IN pa_budget_entry_methods.entry_level_code%TYPE, --Bug 2673200
397: x_expenditure_item_date IN DATE,

Line 394: x_budget_version_id IN gms_bc_packets.budget_version_id%TYPE,

390: PROCEDURE setup_start_end_date (
391: x_project_id IN gms_bc_packets.project_id%TYPE,
392: x_award_id IN gms_bc_packets.award_id%TYPE,
393: x_bud_task_id IN gms_bc_packets.bud_task_id%TYPE, -- Bug 2673200
394: x_budget_version_id IN gms_bc_packets.budget_version_id%TYPE,
395: x_time_phased_type_code IN pa_budget_entry_methods.time_phased_type_code%TYPE,
396: x_entry_level_code IN pa_budget_entry_methods.entry_level_code%TYPE, --Bug 2673200
397: x_expenditure_item_date IN DATE,
398: x_amount_type IN gms_awards.amount_type%TYPE,

Line 400: x_set_of_books_id IN gms_bc_packets.set_of_books_id%TYPE,

396: x_entry_level_code IN pa_budget_entry_methods.entry_level_code%TYPE, --Bug 2673200
397: x_expenditure_item_date IN DATE,
398: x_amount_type IN gms_awards.amount_type%TYPE,
399: x_boundary_code IN gms_awards.boundary_code%TYPE,
400: x_set_of_books_id IN gms_bc_packets.set_of_books_id%TYPE,
401: x_start_date OUT NOCOPY DATE,
402: x_end_date OUT NOCOPY DATE,
403: x_err_code OUT NOCOPY NUMBER,
404: x_err_buff OUT NOCOPY VARCHAR2 ) IS

Line 566: , gms_bc_packets gbc

562: , gbc.expenditure_type
563: , nvl(gbc.burden_adjustment_flag,'N') burden_adjustment_flag
564: , gbc.rowid
565: from gms_budget_versions gbv
566: , gms_bc_packets gbc
567: , pa_budget_entry_methods pbm
568: , gms_awards_all ga
569: where gbc.status_code = x_status_code --Bug 2138376 : Replaced 'A' with x_status_code
570: and gbc.packet_id = nvl(x_packet_id, packet_id)

Line 1542: --## Records would be deleted from gms_bc_packets only in normal 'U' mode

1538:
1539:
1540: -- Bug 3487431... moved revenue posting from here to after actuals posting.
1541:
1542: --## Records would be deleted from gms_bc_packets only in normal 'U' mode
1543: If x_mode <> 'B' then
1544:
1545:
1546: ---------------------------------------------------------------------------------- +

Line 1547: x_stage := '100'; -- Delete old records from gms_bc_packets

1543: If x_mode <> 'B' then
1544:
1545:
1546: ---------------------------------------------------------------------------------- +
1547: x_stage := '100'; -- Delete old records from gms_bc_packets
1548: IF L_DEBUG = 'Y' THEN
1549: gms_error_pkg.gms_debug('Deleting old records from GMS','C');
1550: END IF;
1551:

Line 1553: delete from gms_bc_packets

1549: gms_error_pkg.gms_debug('Deleting old records from GMS','C');
1550: END IF;
1551:
1552: -- Bug 2155790 : Removed the trunc function and replaced 3 with l_offset_days
1553: delete from gms_bc_packets
1554: where status_code IN ('R', 'T', 'S', 'F','C','I','P','E','X')
1555: and (sysdate - creation_date) >= l_offset_days;
1556:
1557: --R12 Fundscheck Management uptake: Logic added to delete records in P status associated with inactive session.

Line 1558: delete from gms_bc_packets gms

1554: where status_code IN ('R', 'T', 'S', 'F','C','I','P','E','X')
1555: and (sysdate - creation_date) >= l_offset_days;
1556:
1557: --R12 Fundscheck Management uptake: Logic added to delete records in P status associated with inactive session.
1558: delete from gms_bc_packets gms
1559: where status_code IN ('P')
1560: and NOT EXISTS (SELECT 'x'
1561: FROM v$session
1562: WHERE audsid = gms.session_id

Line 1574: FROM gms_bc_packets

1570:
1571: DELETE gms_bc_packet_arrival_order ao
1572: WHERE NOT EXISTS (
1573: SELECT 1
1574: FROM gms_bc_packets
1575: WHERE packet_id = ao.packet_id
1576: );
1577:
1578: COMMIT;

Line 1622: -- * Update gms_bc_packets

1618: -- Else
1619: -- * Record burden
1620: -- * Update balance (Not changed)
1621: -- * Update ADL (Not changed)
1622: -- * Update gms_bc_packets
1623: ---------------------------------------------------------------------------------- +
1624: x_stage := '325';
1625: IF L_DEBUG = 'Y' THEN
1626: gms_error_pkg.gms_debug('Check if burden to be posted','C');

Line 1952: update gms_bc_packets set status_code = 'X'

1948:
1949: END IF; -- sql%notfound
1950:
1951: x_stage := '900'; -- Update gms_bc_packet record status to 'X'
1952: update gms_bc_packets set status_code = 'X'
1953: WHERE rowid=rec_gms_packets.rowid;
1954:
1955: -- Changed to rowid criteria, bug 4053891
1956: