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_FUNDS_CONTROL_PKG dependencies on GMS_BC_PACKETS_SUMMARY

Line 6050: -- Following Insert statement inserts records in gms_bc_packets_summary.

6046: -- ==============================================================================
6047: -- ********************* RESOURCE LEVEL SUMMARY UPDATE ************************
6048: -- ==============================================================================
6049: -- Bug 2092791
6050: -- Following Insert statement inserts records in gms_bc_packets_summary.
6051: -- Records in this table will later be used to summarize amount at
6052: -- resource,task and Award Level for previous and currne packet.
6053: IF g_debug = 'Y' THEN
6054: gms_error_pkg.gms_debug ('RESOURCE LEVEL - SUMMARY INSERT ', 'C');

Line 6079: INSERT INTO gms_bc_packets_summary

6075: LOCK_BUDGET_VERSIONS(x_packetid);
6076: End If;
6077:
6078: -- Bug 2605070, Replaced bud_resource_list_member_id with resource_list_member_id
6079: INSERT INTO gms_bc_packets_summary
6080: (packet_id,
6081: creation_date,
6082: budget_version_id,
6083: top_task_id,

Line 6198: FROM gms_bc_packets_summary gmsbcs

6194: SUM(actual_approved), --Bug 2490381 : Added SUM
6195: SUM(actual_pending), --Bug 2490381 : Added SUM
6196: SUM(enc_approved), --Bug 2490381 : Added SUM
6197: SUM(enc_pending) --Bug 2490381 : Added SUM
6198: FROM gms_bc_packets_summary gmsbcs
6199: WHERE gmsbcs.packet_id = x_packetid
6200: AND gmsbcs.bud_task_id = bp.bud_task_id
6201: AND gmsbcs.budget_version_id = bp.budget_version_id
6202: AND gmsbcs.resource_list_member_id =

Line 6391: INSERT INTO gms_bc_packets_summary

6387: --===============================================================================
6388: -- RESOURCE LEVEL : INSERT NEGATIVE IN SUMMARY FOR FAILED TRANSACTIONS
6389: --===============================================================================
6390: g_error_stage := 'FC PR : RES INSERT NEG';
6391: INSERT INTO gms_bc_packets_summary
6392: (packet_id,
6393: creation_date,
6394: budget_version_id,
6395: top_task_id,

Line 6495: FROM gms_bc_packets_summary gmsbcs

6491: SUM(actual_approved),
6492: SUM(actual_pending),
6493: SUM(enc_approved),
6494: SUM(enc_pending)
6495: FROM gms_bc_packets_summary gmsbcs
6496: WHERE gmsbcs.packet_id = x_packetid
6497: AND gmsbcs.bud_task_id = bp.bud_task_id
6498: AND gmsbcs.budget_version_id = bp.budget_version_id
6499: AND gmsbcs.parent_resource_id = bp.parent_resource_id

Line 6685: INSERT INTO gms_bc_packets_summary

6681: --===============================================================================
6682: -- RESOURCE GROUP LEVEL : INSERT NEGATIVE IN SUMMARY FOR FAILED TRANSACTIONS
6683: --===============================================================================
6684: g_error_stage := 'FC PR : RESG IN NEG';
6685: INSERT INTO gms_bc_packets_summary
6686: (packet_id,
6687: creation_date,
6688: budget_version_id,
6689: top_task_id,

Line 6772: FROM gms_bc_packets_summary gmsbcs

6768: SUM (actual_approved),
6769: SUM (actual_pending),
6770: SUM (enc_approved),
6771: SUM (enc_pending)
6772: FROM gms_bc_packets_summary gmsbcs
6773: WHERE gmsbcs.packet_id = x_packetid
6774: AND gmsbcs.budget_version_id = bp.budget_version_id
6775: AND gmsbcs.bud_task_id = bp.bud_task_id
6776: --Bug 2490381 : Changed "=" to "<=" to consider all the

Line 6954: INSERT INTO gms_bc_packets_summary

6950: --==========================================================================
6951: -- TASK LEVEL : INSERT NEGATIVE IN SUMMARY FOR FAILED TRANSACTIONS
6952: --==========================================================================
6953: g_error_stage := 'FC PR : TASK IN NEG';
6954: INSERT INTO gms_bc_packets_summary
6955: (packet_id,
6956: creation_date,
6957: budget_version_id,
6958: top_task_id,

Line 7041: FROM gms_bc_packets_summary gmsbcs

7037: SUM (actual_approved),
7038: SUM (actual_pending),
7039: SUM (enc_approved),
7040: SUM (enc_pending)
7041: FROM gms_bc_packets_summary gmsbcs
7042: WHERE gmsbcs.packet_id = x_packetid
7043: AND gmsbcs.budget_version_id = bp.budget_version_id
7044: AND gmsbcs.top_task_id = bp.top_task_id
7045: --Bug 2490381 : Changed "=" to "<=" to consider all the

Line 7222: INSERT INTO gms_bc_packets_summary

7218: End if;
7219: End If;
7220:
7221: g_error_stage := 'FC PR : TTASK IN NEG';
7222: INSERT INTO gms_bc_packets_summary
7223: (packet_id,
7224: creation_date,
7225: budget_version_id,
7226: budget_period_start_date,

Line 7302: FROM gms_bc_packets_summary gmsbcs

7298: SUM (actual_approved),
7299: SUM (actual_pending),
7300: SUM (enc_approved),
7301: SUM (enc_pending)
7302: FROM gms_bc_packets_summary gmsbcs
7303: WHERE gmsbcs.packet_id = x_packetid
7304: AND gmsbcs.budget_version_id = bp.budget_version_id
7305: --Bug 2490381 : Changed "=" to "<=" to consider all the
7306: -- records from summary table which fall

Line 7498: DELETE gms_bc_packets_summary

7494: --================================================================================--
7495: -- Data clean up code from summary tables after Amount calculation
7496: --================================================================================--
7497: g_error_stage := 'FC PR : DELETE';
7498: DELETE gms_bc_packets_summary
7499: WHERE packet_id = x_packetid;
7500: DELETE gms_bc_packets_bvid
7501: WHERE packet_id = x_packetid;
7502: