DBA Data[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 791: p_last_updated_by => fnd_global.user_id,

787: csf_debrief_lines_pkg.update_row(
788: p_debrief_line_id => l_debrief_line_id,
789: p_error_text => substr(l_msg_data,1,2000),
790: p_charge_upload_status => l_charges_interface_status,
791: p_last_updated_by => fnd_global.user_id,
792: p_last_update_date => sysdate,
793: p_last_update_login => fnd_global.login_id);
794: else
795:

Line 793: p_last_update_login => fnd_global.login_id);

789: p_error_text => substr(l_msg_data,1,2000),
790: p_charge_upload_status => l_charges_interface_status,
791: p_last_updated_by => fnd_global.user_id,
792: p_last_update_date => sysdate,
793: p_last_update_login => fnd_global.login_id);
794: else
795:
796: if l_charges_interface_status = 'SUCCEEDED' Then --it means we tried to update Charges and it was succ
797:

Line 802: p_last_updated_by => fnd_global.user_id,

798: csf_debrief_lines_pkg.update_row(
799: p_debrief_line_id => l_debrief_line_id,
800: p_error_text => null,
801: p_charge_upload_status => l_charges_interface_status,
802: p_last_updated_by => fnd_global.user_id,
803: p_last_update_date => sysdate,
804: p_last_update_login => fnd_global.login_id);
805: end if;
806: end if;

Line 804: p_last_update_login => fnd_global.login_id);

800: p_error_text => null,
801: p_charge_upload_status => l_charges_interface_status,
802: p_last_updated_by => fnd_global.user_id,
803: p_last_update_date => sysdate,
804: p_last_update_login => fnd_global.login_id);
805: end if;
806: end if;
807: --------------------------------------------------------------------------
808: -- END UPDATE CHARGES UPLOAD STATUS COLUMN ----------------------------

Line 896: p_last_updated_by => fnd_global.user_id,

892: p_debrief_line_id => l_debrief_line_id,
893: p_error_text => substr(l_msg_data,1,2000),
894: p_charge_upload_status => l_charges_interface_status,
895: p_ib_update_status => l_ib_interface_status,
896: p_last_updated_by => fnd_global.user_id,
897: p_last_update_date => sysdate,
898: p_last_update_login => fnd_global.login_id);
899: else
900: if nvl(l_ib_update_status,' ') <> 'SUCCEEDED' and l_billing_type='M' and l_trackable='Y'

Line 898: p_last_update_login => fnd_global.login_id);

894: p_charge_upload_status => l_charges_interface_status,
895: p_ib_update_status => l_ib_interface_status,
896: p_last_updated_by => fnd_global.user_id,
897: p_last_update_date => sysdate,
898: p_last_update_login => fnd_global.login_id);
899: else
900: if nvl(l_ib_update_status,' ') <> 'SUCCEEDED' and l_billing_type='M' and l_trackable='Y'
901: and (l_charges_interface_status= 'SUCCEEDED' or l_charge_upload_status='SUCCEEDED') --we tried to update IB for this line
902: Then

Line 912: p_last_updated_by => fnd_global.user_id,

908: p_debrief_line_id => l_debrief_line_id,
909: p_error_text => null,
910: p_instance_id => l_instance_id,
911: p_ib_update_status => l_ib_interface_status,
912: p_last_updated_by => fnd_global.user_id,
913: p_last_update_date => sysdate,
914: p_last_update_login => fnd_global.login_id);
915: end if;
916: end if;

Line 914: p_last_update_login => fnd_global.login_id);

910: p_instance_id => l_instance_id,
911: p_ib_update_status => l_ib_interface_status,
912: p_last_updated_by => fnd_global.user_id,
913: p_last_update_date => sysdate,
914: p_last_update_login => fnd_global.login_id);
915: end if;
916: end if;
917:
918: ------------------------------------------------------------------------------------------------------

Line 1051: p_last_updated_by => fnd_global.user_id,

1047: csf_debrief_lines_pkg.update_row(
1048: p_debrief_line_id => l_debrief_line_id,
1049: p_error_text => substr(l_msg_data,1,2000),
1050: p_charge_upload_status => l_charges_interface_status,
1051: p_last_updated_by => fnd_global.user_id,
1052: p_last_update_date => sysdate,
1053: p_last_update_login => fnd_global.login_id);
1054: elsif l_RETURN_STATUS ='E' or l_RETURN_STATUS = 'U' then --Expected Error
1055: retcode := 1;

Line 1053: p_last_update_login => fnd_global.login_id);

1049: p_error_text => substr(l_msg_data,1,2000),
1050: p_charge_upload_status => l_charges_interface_status,
1051: p_last_updated_by => fnd_global.user_id,
1052: p_last_update_date => sysdate,
1053: p_last_update_login => fnd_global.login_id);
1054: elsif l_RETURN_STATUS ='E' or l_RETURN_STATUS = 'U' then --Expected Error
1055: retcode := 1;
1056: l_processed_flag := 'COMPLETED W/ERRORS';
1057: if l_msg_count > 0 then

Line 1089: p_last_updated_by => fnd_global.user_id,

1085: p_error_text => substr(l_msg_data,1,2000),
1086: p_charge_upload_status => l_charges_interface_status,
1087: p_ib_update_status => l_ib_interface_status,
1088: p_spare_update_status => l_inv_interface_status,
1089: p_last_updated_by => fnd_global.user_id,
1090: p_last_update_date => sysdate,
1091: p_last_update_login => fnd_global.login_id);
1092:
1093: else

Line 1091: p_last_update_login => fnd_global.login_id);

1087: p_ib_update_status => l_ib_interface_status,
1088: p_spare_update_status => l_inv_interface_status,
1089: p_last_updated_by => fnd_global.user_id,
1090: p_last_update_date => sysdate,
1091: p_last_update_login => fnd_global.login_id);
1092:
1093: else
1094: if nvl(l_spare_update_status,' ') <> 'SUCCEEDED' and l_billing_type='M'
1095: and (l_charges_interface_status= 'SUCCEEDED' or l_charge_upload_status='SUCCEEDED')

Line 1104: p_last_updated_by => fnd_global.user_id,

1100: csf_debrief_lines_pkg.update_row(
1101: p_debrief_line_id => l_debrief_line_id,
1102: p_error_text => null,
1103: p_spare_update_status => l_inv_interface_status,
1104: p_last_updated_by => fnd_global.user_id,
1105: p_last_update_date => sysdate,
1106: p_last_update_login => fnd_global.login_id);
1107:
1108: end if;

Line 1106: p_last_update_login => fnd_global.login_id);

1102: p_error_text => null,
1103: p_spare_update_status => l_inv_interface_status,
1104: p_last_updated_by => fnd_global.user_id,
1105: p_last_update_date => sysdate,
1106: p_last_update_login => fnd_global.login_id);
1107:
1108: end if;
1109: end if;
1110: