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.PA_SWEEPER dependencies on FND_GLOBAL

Line 848: pb.last_update_login = fnd_global.login_id,

844: --Update the balances if the record exists in pa_bc_balances
845: FORALL i in l_PktIdTab.FIRST..l_PktIdTab.LAST
846: UPDATE pa_bc_balances pb
847: SET pb.last_update_date = sysdate,
848: pb.last_update_login = fnd_global.login_id,
849: pb.last_updated_by = fnd_global.user_id,
850: pb.request_id = fnd_global.conc_request_id,
851: pb.program_id = fnd_global.conc_program_id,
852: pb.program_application_id = fnd_global.prog_appl_id,

Line 849: pb.last_updated_by = fnd_global.user_id,

845: FORALL i in l_PktIdTab.FIRST..l_PktIdTab.LAST
846: UPDATE pa_bc_balances pb
847: SET pb.last_update_date = sysdate,
848: pb.last_update_login = fnd_global.login_id,
849: pb.last_updated_by = fnd_global.user_id,
850: pb.request_id = fnd_global.conc_request_id,
851: pb.program_id = fnd_global.conc_program_id,
852: pb.program_application_id = fnd_global.prog_appl_id,
853: pb.program_update_date = sysdate,

Line 850: pb.request_id = fnd_global.conc_request_id,

846: UPDATE pa_bc_balances pb
847: SET pb.last_update_date = sysdate,
848: pb.last_update_login = fnd_global.login_id,
849: pb.last_updated_by = fnd_global.user_id,
850: pb.request_id = fnd_global.conc_request_id,
851: pb.program_id = fnd_global.conc_program_id,
852: pb.program_application_id = fnd_global.prog_appl_id,
853: pb.program_update_date = sysdate,
854: pb.actual_period_to_date = nvl(pb.actual_period_to_date,0) +

Line 851: pb.program_id = fnd_global.conc_program_id,

847: SET pb.last_update_date = sysdate,
848: pb.last_update_login = fnd_global.login_id,
849: pb.last_updated_by = fnd_global.user_id,
850: pb.request_id = fnd_global.conc_request_id,
851: pb.program_id = fnd_global.conc_program_id,
852: pb.program_application_id = fnd_global.prog_appl_id,
853: pb.program_update_date = sysdate,
854: pb.actual_period_to_date = nvl(pb.actual_period_to_date,0) +
855: (nvl(l_PktAcctDrTab(i),0)- nvl(l_PktAcctCrTab(i),0)) *

Line 852: pb.program_application_id = fnd_global.prog_appl_id,

848: pb.last_update_login = fnd_global.login_id,
849: pb.last_updated_by = fnd_global.user_id,
850: pb.request_id = fnd_global.conc_request_id,
851: pb.program_id = fnd_global.conc_program_id,
852: pb.program_application_id = fnd_global.prog_appl_id,
853: pb.program_update_date = sysdate,
854: pb.actual_period_to_date = nvl(pb.actual_period_to_date,0) +
855: (nvl(l_PktAcctDrTab(i),0)- nvl(l_PktAcctCrTab(i),0)) *
856: decode(l_PktDocTypTab(i),'EXP',1,0),

Line 1031: FND_GLOBAL.USER_ID,

1027: l_PktPrjEncTypIdTab(k),
1028: l_PktOrgIdTab(k),
1029: l_PktCstBurdFlagTab(k),
1030: sysdate,
1031: FND_GLOBAL.USER_ID,
1032: FND_GLOBAL.USER_ID,
1033: sysdate,
1034: FND_GLOBAL.LOGIN_ID,
1035: 'P',

Line 1032: FND_GLOBAL.USER_ID,

1028: l_PktOrgIdTab(k),
1029: l_PktCstBurdFlagTab(k),
1030: sysdate,
1031: FND_GLOBAL.USER_ID,
1032: FND_GLOBAL.USER_ID,
1033: sysdate,
1034: FND_GLOBAL.LOGIN_ID,
1035: 'P',
1036: fnd_global.conc_request_id,

Line 1034: FND_GLOBAL.LOGIN_ID,

1030: sysdate,
1031: FND_GLOBAL.USER_ID,
1032: FND_GLOBAL.USER_ID,
1033: sysdate,
1034: FND_GLOBAL.LOGIN_ID,
1035: 'P',
1036: fnd_global.conc_request_id,
1037: fnd_global.conc_program_id,
1038: fnd_global.prog_appl_id,

Line 1036: fnd_global.conc_request_id,

1032: FND_GLOBAL.USER_ID,
1033: sysdate,
1034: FND_GLOBAL.LOGIN_ID,
1035: 'P',
1036: fnd_global.conc_request_id,
1037: fnd_global.conc_program_id,
1038: fnd_global.prog_appl_id,
1039: sysdate
1040: --PA.M

Line 1037: fnd_global.conc_program_id,

1033: sysdate,
1034: FND_GLOBAL.LOGIN_ID,
1035: 'P',
1036: fnd_global.conc_request_id,
1037: fnd_global.conc_program_id,
1038: fnd_global.prog_appl_id,
1039: sysdate
1040: --PA.M
1041: ,l_PktDocLineIdTab(k)

Line 1038: fnd_global.prog_appl_id,

1034: FND_GLOBAL.LOGIN_ID,
1035: 'P',
1036: fnd_global.conc_request_id,
1037: fnd_global.conc_program_id,
1038: fnd_global.prog_appl_id,
1039: sysdate
1040: --PA.M
1041: ,l_PktDocLineIdTab(k)
1042: ,l_PktCompMultiplierTab(k)

Line 1119: pbc.last_updated_by = fnd_global.user_id,

1115: pbc.bud_task_id = l_PktBdgtTaskTab(j),
1116: pbc.actual_flag = l_PktActFlagTab(j),
1117: pbc.encumbrance_type_id = l_PktEncTypIdTab(j),
1118: pbc.proj_encumbrance_type_id = l_PktPrjEncTypIdTab(j),
1119: pbc.last_updated_by = fnd_global.user_id,
1120: pbc.last_update_date = sysdate,
1121: pbc.last_update_login = fnd_global.login_id,
1122: pbc.request_id = fnd_global.conc_request_id,
1123: pbc.program_id = fnd_global.conc_program_id,

Line 1121: pbc.last_update_login = fnd_global.login_id,

1117: pbc.encumbrance_type_id = l_PktEncTypIdTab(j),
1118: pbc.proj_encumbrance_type_id = l_PktPrjEncTypIdTab(j),
1119: pbc.last_updated_by = fnd_global.user_id,
1120: pbc.last_update_date = sysdate,
1121: pbc.last_update_login = fnd_global.login_id,
1122: pbc.request_id = fnd_global.conc_request_id,
1123: pbc.program_id = fnd_global.conc_program_id,
1124: pbc.program_application_id = fnd_global.prog_appl_id,
1125: pbc.program_update_date = sysdate,

Line 1122: pbc.request_id = fnd_global.conc_request_id,

1118: pbc.proj_encumbrance_type_id = l_PktPrjEncTypIdTab(j),
1119: pbc.last_updated_by = fnd_global.user_id,
1120: pbc.last_update_date = sysdate,
1121: pbc.last_update_login = fnd_global.login_id,
1122: pbc.request_id = fnd_global.conc_request_id,
1123: pbc.program_id = fnd_global.conc_program_id,
1124: pbc.program_application_id = fnd_global.prog_appl_id,
1125: pbc.program_update_date = sysdate,
1126: pbc.budget_line_id = l_PktBudgetLineIdTab(j)

Line 1123: pbc.program_id = fnd_global.conc_program_id,

1119: pbc.last_updated_by = fnd_global.user_id,
1120: pbc.last_update_date = sysdate,
1121: pbc.last_update_login = fnd_global.login_id,
1122: pbc.request_id = fnd_global.conc_request_id,
1123: pbc.program_id = fnd_global.conc_program_id,
1124: pbc.program_application_id = fnd_global.prog_appl_id,
1125: pbc.program_update_date = sysdate,
1126: pbc.budget_line_id = l_PktBudgetLineIdTab(j)
1127: where ((pbc.bc_commitment_id = l_PktBcCommTab(j))

Line 1124: pbc.program_application_id = fnd_global.prog_appl_id,

1120: pbc.last_update_date = sysdate,
1121: pbc.last_update_login = fnd_global.login_id,
1122: pbc.request_id = fnd_global.conc_request_id,
1123: pbc.program_id = fnd_global.conc_program_id,
1124: pbc.program_application_id = fnd_global.prog_appl_id,
1125: pbc.program_update_date = sysdate,
1126: pbc.budget_line_id = l_PktBudgetLineIdTab(j)
1127: where ((pbc.bc_commitment_id = l_PktBcCommTab(j))
1128: or (l_PktBcCommTab(j) is null

Line 1190: pbc.last_update_login = fnd_global.login_id,

1186: UPDATE pa_bc_packets pbc
1187: SET pbc.status_code = 'X',
1188: pbc.balance_posted_flag = 'Y',
1189: pbc.last_update_date = sysdate,
1190: pbc.last_update_login = fnd_global.login_id,
1191: pbc.last_updated_by = fnd_global.user_id
1192: WHERE pbc.status_code = 'A'
1193: AND pbc.packet_id = l_StsUpdPktIdTab(m)
1194: AND pbc.bc_packet_id = l_StsUpdBcPktIdTab(m)

Line 1191: pbc.last_updated_by = fnd_global.user_id

1187: SET pbc.status_code = 'X',
1188: pbc.balance_posted_flag = 'Y',
1189: pbc.last_update_date = sysdate,
1190: pbc.last_update_login = fnd_global.login_id,
1191: pbc.last_updated_by = fnd_global.user_id
1192: WHERE pbc.status_code = 'A'
1193: AND pbc.packet_id = l_StsUpdPktIdTab(m)
1194: AND pbc.bc_packet_id = l_StsUpdBcPktIdTab(m)
1195: AND pbc.balance_posted_flag = 'N'

Line 1337: FND_GLOBAL.USER_ID,

1333: l_InsSobTab(p),
1334: l_InsBdgtVerTab(p),
1335: l_InsDocTypTab(p),
1336: sysdate,
1337: FND_GLOBAL.USER_ID,
1338: FND_GLOBAL.USER_ID,
1339: sysdate,
1340: FND_GLOBAL.LOGIN_ID,
1341: --GetBCBalStartDate(l_InsTPCTab(p),l_InsProjectTab(p),l_InsEiDateTab(p),

Line 1338: FND_GLOBAL.USER_ID,

1334: l_InsBdgtVerTab(p),
1335: l_InsDocTypTab(p),
1336: sysdate,
1337: FND_GLOBAL.USER_ID,
1338: FND_GLOBAL.USER_ID,
1339: sysdate,
1340: FND_GLOBAL.LOGIN_ID,
1341: --GetBCBalStartDate(l_InsTPCTab(p),l_InsProjectTab(p),l_InsEiDateTab(p),
1342: -- l_InsBdgtVerTab(p),l_InsSobTab(p),l_InsOrgIdTab(p)),

Line 1340: FND_GLOBAL.LOGIN_ID,

1336: sysdate,
1337: FND_GLOBAL.USER_ID,
1338: FND_GLOBAL.USER_ID,
1339: sysdate,
1340: FND_GLOBAL.LOGIN_ID,
1341: --GetBCBalStartDate(l_InsTPCTab(p),l_InsProjectTab(p),l_InsEiDateTab(p),
1342: -- l_InsBdgtVerTab(p),l_InsSobTab(p),l_InsOrgIdTab(p)),
1343: --GetBCBalEndDate(l_InsTPCTab(p),l_InsProjectTab(p),l_InsEiDateTab(p),
1344: -- l_InsBdgtVerTab(p),l_InsSobTab(p),l_InsOrgIdTab(p)),

Line 1351: fnd_global.conc_request_id,

1347: l_InsParResTab(p),
1348: 0,
1349: l_InsActPTDTab(p),
1350: l_InsEncPTDTab(p),
1351: fnd_global.conc_request_id,
1352: fnd_global.conc_program_id,
1353: fnd_global.prog_appl_id,
1354: sysdate
1355: from dual where l_InsDocTypTab(p) in ('EXP', 'AP','PO','REQ','CC_C_CO','CC_P_CO','CC_C_PAY','CC_P_PAY');

Line 1352: fnd_global.conc_program_id,

1348: 0,
1349: l_InsActPTDTab(p),
1350: l_InsEncPTDTab(p),
1351: fnd_global.conc_request_id,
1352: fnd_global.conc_program_id,
1353: fnd_global.prog_appl_id,
1354: sysdate
1355: from dual where l_InsDocTypTab(p) in ('EXP', 'AP','PO','REQ','CC_C_CO','CC_P_CO','CC_C_PAY','CC_P_PAY');
1356:

Line 1353: fnd_global.prog_appl_id,

1349: l_InsActPTDTab(p),
1350: l_InsEncPTDTab(p),
1351: fnd_global.conc_request_id,
1352: fnd_global.conc_program_id,
1353: fnd_global.prog_appl_id,
1354: sysdate
1355: from dual where l_InsDocTypTab(p) in ('EXP', 'AP','PO','REQ','CC_C_CO','CC_P_CO','CC_C_PAY','CC_P_PAY');
1356:
1357: IF l_debug_mode = 'Y' THEN /* added for bug#2672653 */

Line 1373: pbc.last_update_login = fnd_global.login_id,

1369: UPDATE pa_bc_packets pbc
1370: SET pbc.status_code = 'X',
1371: pbc.balance_posted_flag = 'Y',
1372: pbc.last_update_date = sysdate,
1373: pbc.last_update_login = fnd_global.login_id,
1374: pbc.last_updated_by = fnd_global.user_id
1375: WHERE pbc.status_code = 'A'
1376: AND pbc.project_id = l_InsProjectTab(m)
1377: AND pbc.task_id = l_InsTaskTab(m)

Line 1374: pbc.last_updated_by = fnd_global.user_id

1370: SET pbc.status_code = 'X',
1371: pbc.balance_posted_flag = 'Y',
1372: pbc.last_update_date = sysdate,
1373: pbc.last_update_login = fnd_global.login_id,
1374: pbc.last_updated_by = fnd_global.user_id
1375: WHERE pbc.status_code = 'A'
1376: AND pbc.project_id = l_InsProjectTab(m)
1377: AND pbc.task_id = l_InsTaskTab(m)
1378: AND pbc.balance_posted_flag = 'N'