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

Line 13: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;

9: -- End of Comments
10:
11: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSF_DEBRIEF_UPDATE_PKG';
12: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csfuppdb.pls';
13: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
14: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
15: G_UPDATE NUMBER := 1;
16: G_CREATE NUMBER := 2;
17:

Line 14: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

10:
11: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSF_DEBRIEF_UPDATE_PKG';
12: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csfuppdb.pls';
13: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
14: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
15: G_UPDATE NUMBER := 1;
16: G_CREATE NUMBER := 2;
17:
18: RECORD_LOCK_EXCEPTION EXCEPTION ;

Line 451: and fcr.request_id < fnd_global.conc_request_id

447: fnd_concurrent_programs fcp
448: where fcr.concurrent_program_id = fcp.concurrent_program_id
449: and fcp.application_id = 513
450: and fcp.concurrent_program_name = 'CSFUPDATE'
451: and fcr.request_id < fnd_global.conc_request_id
452: and fcr.argument2 = to_char(p_debrief_header_id)
453: and fcr.phase_code in ('P','R');
454:
455: cursor c_intransit (v_frm_org_id number, v_to_org_id number) is

Line 860: p_last_updated_by => fnd_global.user_id,

856: p_debrief_line_id => l_debrief_line_id,
857: p_error_text => null,
858: p_charge_upload_status => l_spare_update_status,
859: p_spare_update_status => l_spare_update_status,
860: p_last_updated_by => fnd_global.user_id,
861: p_last_update_date => sysdate,
862: p_last_update_login => fnd_global.login_id);
863: end if;
864: else

Line 862: p_last_update_login => fnd_global.login_id);

858: p_charge_upload_status => l_spare_update_status,
859: p_spare_update_status => l_spare_update_status,
860: p_last_updated_by => fnd_global.user_id,
861: p_last_update_date => sysdate,
862: p_last_update_login => fnd_global.login_id);
863: end if;
864: else
865: --we use c_trans cursor only when we have item number
866: --hehxx

Line 1107: p_last_updated_by => fnd_global.user_id,

1103: csf_debrief_lines_pkg.update_row(
1104: p_debrief_line_id => l_debrief_line_id,
1105: p_error_text => substr(l_msg_data,1,2000),
1106: p_charge_upload_status => l_charges_interface_status,
1107: p_last_updated_by => fnd_global.user_id,
1108: p_last_update_date => sysdate,
1109: p_last_update_login => fnd_global.login_id);
1110: commit; -- for bug 13979512
1111: savepoint before_fetch;

Line 1109: p_last_update_login => fnd_global.login_id);

1105: p_error_text => substr(l_msg_data,1,2000),
1106: p_charge_upload_status => l_charges_interface_status,
1107: p_last_updated_by => fnd_global.user_id,
1108: p_last_update_date => sysdate,
1109: p_last_update_login => fnd_global.login_id);
1110: commit; -- for bug 13979512
1111: savepoint before_fetch;
1112: else
1113:

Line 1120: p_last_updated_by => fnd_global.user_id,

1116: csf_debrief_lines_pkg.update_row(
1117: p_debrief_line_id => l_debrief_line_id,
1118: p_error_text => null,
1119: p_charge_upload_status => l_charges_interface_status,
1120: p_last_updated_by => fnd_global.user_id,
1121: p_last_update_date => sysdate,
1122: p_last_update_login => fnd_global.login_id);
1123: end if;
1124: end if;

Line 1122: p_last_update_login => fnd_global.login_id);

1118: p_error_text => null,
1119: p_charge_upload_status => l_charges_interface_status,
1120: p_last_updated_by => fnd_global.user_id,
1121: p_last_update_date => sysdate,
1122: p_last_update_login => fnd_global.login_id);
1123: end if;
1124: end if;
1125: --------------------------------------------------------------------------
1126: -- END UPDATE CHARGES UPLOAD STATUS COLUMN ----------------------------

Line 1136: p_last_updated_by => fnd_global.user_id,

1132: csf_debrief_lines_pkg.update_row(
1133: p_debrief_line_id => l_debrief_line_id,
1134: p_error_text => null,
1135: p_charge_upload_status => l_charges_interface_status,
1136: p_last_updated_by => fnd_global.user_id,
1137: p_last_update_date => sysdate,
1138: p_last_update_login => fnd_global.login_id);
1139: end if; --charge_upload_status
1140:

Line 1138: p_last_update_login => fnd_global.login_id);

1134: p_error_text => null,
1135: p_charge_upload_status => l_charges_interface_status,
1136: p_last_updated_by => fnd_global.user_id,
1137: p_last_update_date => sysdate,
1138: p_last_update_login => fnd_global.login_id);
1139: end if; --charge_upload_status
1140:
1141: -------------------------------------------------------------------------
1142: --END UPDATE CHARGE------------------------------------------------------

Line 1230: p_last_updated_by => fnd_global.user_id,

1226: p_debrief_line_id => l_debrief_line_id,
1227: p_error_text => substr(l_msg_data,1,2000),
1228: p_charge_upload_status => l_charges_interface_status,
1229: p_ib_update_status => l_ib_interface_status,
1230: p_last_updated_by => fnd_global.user_id,
1231: p_last_update_date => sysdate,
1232: p_last_update_login => fnd_global.login_id);
1233: commit; -- for bug 13979512
1234: savepoint before_fetch;

Line 1232: p_last_update_login => fnd_global.login_id);

1228: p_charge_upload_status => l_charges_interface_status,
1229: p_ib_update_status => l_ib_interface_status,
1230: p_last_updated_by => fnd_global.user_id,
1231: p_last_update_date => sysdate,
1232: p_last_update_login => fnd_global.login_id);
1233: commit; -- for bug 13979512
1234: savepoint before_fetch;
1235: else
1236: if nvl(l_ib_update_status,' ') <> 'SUCCEEDED'

Line 1251: p_last_updated_by => fnd_global.user_id,

1247: p_debrief_line_id => l_debrief_line_id,
1248: p_error_text => null,
1249: p_instance_id => l_instance_id,
1250: p_ib_update_status => l_ib_interface_status,
1251: p_last_updated_by => fnd_global.user_id,
1252: p_last_update_date => sysdate,
1253: p_last_update_login => fnd_global.login_id);
1254: end if;
1255: end if;

Line 1253: p_last_update_login => fnd_global.login_id);

1249: p_instance_id => l_instance_id,
1250: p_ib_update_status => l_ib_interface_status,
1251: p_last_updated_by => fnd_global.user_id,
1252: p_last_update_date => sysdate,
1253: p_last_update_login => fnd_global.login_id);
1254: end if;
1255: end if;
1256:
1257: ------------------------------------------------------------------------

Line 1343: p_last_updated_by => fnd_global.user_id,

1339: csf_debrief_lines_pkg.update_row(
1340: p_debrief_line_id => l_debrief_line_id,
1341: p_error_text => null,
1342: p_spare_update_status => l_inv_interface_status,
1343: p_last_updated_by => fnd_global.user_id,
1344: p_last_update_date => sysdate,
1345: p_last_update_login => fnd_global.login_id);
1346:
1347: elsif l_RETURN_STATUS ='E' or l_RETURN_STATUS = 'U' then

Line 1345: p_last_update_login => fnd_global.login_id);

1341: p_error_text => null,
1342: p_spare_update_status => l_inv_interface_status,
1343: p_last_updated_by => fnd_global.user_id,
1344: p_last_update_date => sysdate,
1345: p_last_update_login => fnd_global.login_id);
1346:
1347: elsif l_RETURN_STATUS ='E' or l_RETURN_STATUS = 'U' then
1348: retcode := 1;
1349: l_processed_flag := 'COMPLETED W/ERRORS';

Line 1476: p_last_updated_by => fnd_global.user_id,

1472: csf_debrief_lines_pkg.update_row(
1473: p_debrief_line_id => l_debrief_line_id,
1474: p_error_text => substr(l_msg_data,1,2000),
1475: p_charge_upload_status => l_charges_interface_status,
1476: p_last_updated_by => fnd_global.user_id,
1477: p_last_update_date => sysdate,
1478: p_last_update_login => fnd_global.login_id);
1479: elsif l_RETURN_STATUS ='E' or l_RETURN_STATUS = 'U' then
1480: retcode := 1;

Line 1478: p_last_update_login => fnd_global.login_id);

1474: p_error_text => substr(l_msg_data,1,2000),
1475: p_charge_upload_status => l_charges_interface_status,
1476: p_last_updated_by => fnd_global.user_id,
1477: p_last_update_date => sysdate,
1478: p_last_update_login => fnd_global.login_id);
1479: elsif l_RETURN_STATUS ='E' or l_RETURN_STATUS = 'U' then
1480: retcode := 1;
1481: l_processed_flag := 'COMPLETED W/ERRORS';
1482: if l_msg_count > 0 then

Line 1517: p_last_updated_by => fnd_global.user_id,

1513: p_error_text => substr(l_msg_data,1,2000),
1514: p_charge_upload_status => l_charges_interface_status,
1515: p_ib_update_status => l_ib_interface_status,
1516: p_spare_update_status => l_inv_interface_status,
1517: p_last_updated_by => fnd_global.user_id,
1518: p_last_update_date => sysdate,
1519: p_last_update_login => fnd_global.login_id);
1520: commit; -- for bug 13979512
1521: savepoint before_fetch;

Line 1519: p_last_update_login => fnd_global.login_id);

1515: p_ib_update_status => l_ib_interface_status,
1516: p_spare_update_status => l_inv_interface_status,
1517: p_last_updated_by => fnd_global.user_id,
1518: p_last_update_date => sysdate,
1519: p_last_update_login => fnd_global.login_id);
1520: commit; -- for bug 13979512
1521: savepoint before_fetch;
1522:
1523: else

Line 1536: p_last_updated_by => fnd_global.user_id,

1532: csf_debrief_lines_pkg.update_row(
1533: p_debrief_line_id => l_debrief_line_id,
1534: p_error_text => null,
1535: p_spare_update_status => l_inv_interface_status,
1536: p_last_updated_by => fnd_global.user_id,
1537: p_last_update_date => sysdate,
1538: p_last_update_login => fnd_global.login_id);
1539:
1540: end if;

Line 1538: p_last_update_login => fnd_global.login_id);

1534: p_error_text => null,
1535: p_spare_update_status => l_inv_interface_status,
1536: p_last_updated_by => fnd_global.user_id,
1537: p_last_update_date => sysdate,
1538: p_last_update_login => fnd_global.login_id);
1539:
1540: end if;
1541: end if;
1542: