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.

[Home] [Help]

APPS.GMS_FUNDS_CONTROL_PKG dependencies on GMS_BC_PACKETS_SUMMARY

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

6402: -- ==============================================================================
6403: -- ********************* RESOURCE LEVEL SUMMARY UPDATE ************************
6404: -- ==============================================================================
6405: -- Bug 2092791
6406: -- Following Insert statement inserts records in gms_bc_packets_summary.
6407: -- Records in this table will later be used to summarize amount at
6408: -- resource,task and Award Level for previous and currne packet.
6409: IF g_debug = 'Y' THEN
6410: gms_error_pkg.gms_debug ('RESOURCE LEVEL - SUMMARY INSERT ', 'C');

Line 6435: INSERT INTO gms_bc_packets_summary

6431: LOCK_BUDGET_VERSIONS(x_packetid);
6432: End If;
6433:
6434: -- Bug 2605070, Replaced bud_resource_list_member_id with resource_list_member_id
6435: INSERT INTO gms_bc_packets_summary
6436: (packet_id,
6437: creation_date,
6438: budget_version_id,
6439: top_task_id,

Line 6554: FROM gms_bc_packets_summary gmsbcs

6550: SUM(actual_approved), --Bug 2490381 : Added SUM
6551: SUM(actual_pending), --Bug 2490381 : Added SUM
6552: SUM(enc_approved), --Bug 2490381 : Added SUM
6553: SUM(enc_pending) --Bug 2490381 : Added SUM
6554: FROM gms_bc_packets_summary gmsbcs
6555: WHERE gmsbcs.packet_id = x_packetid
6556: AND gmsbcs.bud_task_id = bp.bud_task_id
6557: AND gmsbcs.budget_version_id = bp.budget_version_id
6558: AND gmsbcs.resource_list_member_id =

Line 6747: INSERT INTO gms_bc_packets_summary

6743: --===============================================================================
6744: -- RESOURCE LEVEL : INSERT NEGATIVE IN SUMMARY FOR FAILED TRANSACTIONS
6745: --===============================================================================
6746: g_error_stage := 'FC PR : RES INSERT NEG';
6747: INSERT INTO gms_bc_packets_summary
6748: (packet_id,
6749: creation_date,
6750: budget_version_id,
6751: top_task_id,

Line 6851: FROM gms_bc_packets_summary gmsbcs

6847: SUM(actual_approved),
6848: SUM(actual_pending),
6849: SUM(enc_approved),
6850: SUM(enc_pending)
6851: FROM gms_bc_packets_summary gmsbcs
6852: WHERE gmsbcs.packet_id = x_packetid
6853: AND gmsbcs.bud_task_id = bp.bud_task_id
6854: AND gmsbcs.budget_version_id = bp.budget_version_id
6855: AND gmsbcs.parent_resource_id = bp.parent_resource_id

Line 7041: INSERT INTO gms_bc_packets_summary

7037: --===============================================================================
7038: -- RESOURCE GROUP LEVEL : INSERT NEGATIVE IN SUMMARY FOR FAILED TRANSACTIONS
7039: --===============================================================================
7040: g_error_stage := 'FC PR : RESG IN NEG';
7041: INSERT INTO gms_bc_packets_summary
7042: (packet_id,
7043: creation_date,
7044: budget_version_id,
7045: top_task_id,

Line 7128: FROM gms_bc_packets_summary gmsbcs

7124: SUM (actual_approved),
7125: SUM (actual_pending),
7126: SUM (enc_approved),
7127: SUM (enc_pending)
7128: FROM gms_bc_packets_summary gmsbcs
7129: WHERE gmsbcs.packet_id = x_packetid
7130: AND gmsbcs.budget_version_id = bp.budget_version_id
7131: AND gmsbcs.bud_task_id = bp.bud_task_id
7132: --Bug 2490381 : Changed "=" to "<=" to consider all the

Line 7310: INSERT INTO gms_bc_packets_summary

7306: --==========================================================================
7307: -- TASK LEVEL : INSERT NEGATIVE IN SUMMARY FOR FAILED TRANSACTIONS
7308: --==========================================================================
7309: g_error_stage := 'FC PR : TASK IN NEG';
7310: INSERT INTO gms_bc_packets_summary
7311: (packet_id,
7312: creation_date,
7313: budget_version_id,
7314: top_task_id,

Line 7397: FROM gms_bc_packets_summary gmsbcs

7393: SUM (actual_approved),
7394: SUM (actual_pending),
7395: SUM (enc_approved),
7396: SUM (enc_pending)
7397: FROM gms_bc_packets_summary gmsbcs
7398: WHERE gmsbcs.packet_id = x_packetid
7399: AND gmsbcs.budget_version_id = bp.budget_version_id
7400: AND gmsbcs.top_task_id = bp.top_task_id
7401: --Bug 2490381 : Changed "=" to "<=" to consider all the

Line 7578: INSERT INTO gms_bc_packets_summary

7574: End if;
7575: End If;
7576:
7577: g_error_stage := 'FC PR : TTASK IN NEG';
7578: INSERT INTO gms_bc_packets_summary
7579: (packet_id,
7580: creation_date,
7581: budget_version_id,
7582: budget_period_start_date,

Line 7658: FROM gms_bc_packets_summary gmsbcs

7654: SUM (actual_approved),
7655: SUM (actual_pending),
7656: SUM (enc_approved),
7657: SUM (enc_pending)
7658: FROM gms_bc_packets_summary gmsbcs
7659: WHERE gmsbcs.packet_id = x_packetid
7660: AND gmsbcs.budget_version_id = bp.budget_version_id
7661: --Bug 2490381 : Changed "=" to "<=" to consider all the
7662: -- records from summary table which fall

Line 7854: DELETE gms_bc_packets_summary

7850: --================================================================================--
7851: -- Data clean up code from summary tables after Amount calculation
7852: --================================================================================--
7853: g_error_stage := 'FC PR : DELETE';
7854: DELETE gms_bc_packets_summary
7855: WHERE packet_id = x_packetid;
7856: DELETE gms_bc_packets_bvid
7857: WHERE packet_id = x_packetid;
7858: