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

Line 995: last_updated_by = NVL(FND_GLOBAL.user_id,-1),

991: payment_status = null,
992: payment_reference_id = DECODE(payment_method,'RMA',null,payment_reference_id),
993: payment_reference_date = null,
994: payment_reference_number = DECODE(payment_method,'RMA',null,payment_reference_number),
995: last_updated_by = NVL(FND_GLOBAL.user_id,-1),
996: last_update_login = NVL(FND_GLOBAL.conc_login_id,-1),
997: last_update_date = l_sys_date,
998: settled_date = null,
999: settled_by = null

Line 996: last_update_login = NVL(FND_GLOBAL.conc_login_id,-1),

992: payment_reference_id = DECODE(payment_method,'RMA',null,payment_reference_id),
993: payment_reference_date = null,
994: payment_reference_number = DECODE(payment_method,'RMA',null,payment_reference_number),
995: last_updated_by = NVL(FND_GLOBAL.user_id,-1),
996: last_update_login = NVL(FND_GLOBAL.conc_login_id,-1),
997: last_update_date = l_sys_date,
998: settled_date = null,
999: settled_by = null
1000: WHERE claim_id = p_claim_id;

Line 1048: last_updated_by = NVL(FND_GLOBAL.user_id,-1),

1044: and lkp.lookup_code IN (select status_lookup_code
1045: FROM ap_invoice_payments pay, ap_checks chk
1046: WHERE pay.check_id = chk.check_id
1047: AND pay.invoice_payment_id = stlmnt_docs.settlement_id)),
1048: last_updated_by = NVL(FND_GLOBAL.user_id,-1),
1049: last_update_login = NVL(FND_GLOBAL.conc_login_id,-1),
1050: last_update_date = l_sys_date
1051: WHERE claim_id = p_claim_id;
1052: END IF;

Line 1049: last_update_login = NVL(FND_GLOBAL.conc_login_id,-1),

1045: FROM ap_invoice_payments pay, ap_checks chk
1046: WHERE pay.check_id = chk.check_id
1047: AND pay.invoice_payment_id = stlmnt_docs.settlement_id)),
1048: last_updated_by = NVL(FND_GLOBAL.user_id,-1),
1049: last_update_login = NVL(FND_GLOBAL.conc_login_id,-1),
1050: last_update_date = l_sys_date
1051: WHERE claim_id = p_claim_id;
1052: END IF;
1053:

Line 1094: ,p_entered_by => FND_GLOBAL.user_id

1090: ,p_source_object_id => p_claim_id
1091: ,p_source_object_code => 'AMS_CLAM'
1092: ,p_notes => l_notif_body
1093: ,p_note_status => NULL
1094: ,p_entered_by => FND_GLOBAL.user_id
1095: ,p_entered_date => SYSDATE
1096: ,p_last_updated_by => FND_GLOBAL.user_id
1097: ,x_jtf_note_id => l_note_id
1098: ,p_note_type => 'AMS_JUSTIFICATION'

Line 1096: ,p_last_updated_by => FND_GLOBAL.user_id

1092: ,p_notes => l_notif_body
1093: ,p_note_status => NULL
1094: ,p_entered_by => FND_GLOBAL.user_id
1095: ,p_entered_date => SYSDATE
1096: ,p_last_updated_by => FND_GLOBAL.user_id
1097: ,x_jtf_note_id => l_note_id
1098: ,p_note_type => 'AMS_JUSTIFICATION'
1099: ,p_last_update_date => l_sys_date
1100: ,p_creation_date => l_sys_date);

Line 4933: l_created_by := NVL(FND_GLOBAL.user_id,-1);

4929: END IF;
4930:
4931: x_return_status := FND_API.g_ret_sts_success;
4932:
4933: l_created_by := NVL(FND_GLOBAL.user_id,-1);
4934: l_updated_by := NVL(FND_GLOBAL.user_id,-1);
4935: l_last_update_login := NVL(FND_GLOBAL.conc_login_id,-1);
4936: l_settlement_doc_rec.object_version_number := 1;
4937:

Line 4934: l_updated_by := NVL(FND_GLOBAL.user_id,-1);

4930:
4931: x_return_status := FND_API.g_ret_sts_success;
4932:
4933: l_created_by := NVL(FND_GLOBAL.user_id,-1);
4934: l_updated_by := NVL(FND_GLOBAL.user_id,-1);
4935: l_last_update_login := NVL(FND_GLOBAL.conc_login_id,-1);
4936: l_settlement_doc_rec.object_version_number := 1;
4937:
4938: --------------------- validate -----------------------

Line 4935: l_last_update_login := NVL(FND_GLOBAL.conc_login_id,-1);

4931: x_return_status := FND_API.g_ret_sts_success;
4932:
4933: l_created_by := NVL(FND_GLOBAL.user_id,-1);
4934: l_updated_by := NVL(FND_GLOBAL.user_id,-1);
4935: l_last_update_login := NVL(FND_GLOBAL.conc_login_id,-1);
4936: l_settlement_doc_rec.object_version_number := 1;
4937:
4938: --------------------- validate -----------------------
4939: -- Validate Environment

Line 4940: IF FND_GLOBAL.user_Id IS NULL THEN

4936: l_settlement_doc_rec.object_version_number := 1;
4937:
4938: --------------------- validate -----------------------
4939: -- Validate Environment
4940: IF FND_GLOBAL.user_Id IS NULL THEN
4941: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_USER_PROFILE_MISSING');
4942: RAISE FND_API.G_EXC_ERROR;
4943: END IF;
4944:

Line 5017: p_last_updated_by => FND_GLOBAL.USER_ID,

5013: OZF_SETTLEMENT_DOCS_PKG.Insert_Row(
5014: px_settlement_doc_id => l_settlement_doc_rec.settlement_doc_id,
5015: px_object_version_number => l_settlement_doc_rec.object_version_number,
5016: p_last_update_date => SYSDATE,
5017: p_last_updated_by => FND_GLOBAL.USER_ID,
5018: p_creation_date => SYSDATE,
5019: p_created_by => FND_GLOBAL.USER_ID,
5020: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
5021: p_request_id => FND_GLOBAL.CONC_REQUEST_ID,

Line 5019: p_created_by => FND_GLOBAL.USER_ID,

5015: px_object_version_number => l_settlement_doc_rec.object_version_number,
5016: p_last_update_date => SYSDATE,
5017: p_last_updated_by => FND_GLOBAL.USER_ID,
5018: p_creation_date => SYSDATE,
5019: p_created_by => FND_GLOBAL.USER_ID,
5020: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
5021: p_request_id => FND_GLOBAL.CONC_REQUEST_ID,
5022: p_program_application_id => FND_GLOBAL.PROG_APPL_ID,
5023: p_program_update_date => SYSDATE,

Line 5020: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,

5016: p_last_update_date => SYSDATE,
5017: p_last_updated_by => FND_GLOBAL.USER_ID,
5018: p_creation_date => SYSDATE,
5019: p_created_by => FND_GLOBAL.USER_ID,
5020: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
5021: p_request_id => FND_GLOBAL.CONC_REQUEST_ID,
5022: p_program_application_id => FND_GLOBAL.PROG_APPL_ID,
5023: p_program_update_date => SYSDATE,
5024: p_program_id => FND_GLOBAL.CONC_PROGRAM_ID,

Line 5021: p_request_id => FND_GLOBAL.CONC_REQUEST_ID,

5017: p_last_updated_by => FND_GLOBAL.USER_ID,
5018: p_creation_date => SYSDATE,
5019: p_created_by => FND_GLOBAL.USER_ID,
5020: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
5021: p_request_id => FND_GLOBAL.CONC_REQUEST_ID,
5022: p_program_application_id => FND_GLOBAL.PROG_APPL_ID,
5023: p_program_update_date => SYSDATE,
5024: p_program_id => FND_GLOBAL.CONC_PROGRAM_ID,
5025: p_created_from => l_settlement_doc_rec.created_from,

Line 5022: p_program_application_id => FND_GLOBAL.PROG_APPL_ID,

5018: p_creation_date => SYSDATE,
5019: p_created_by => FND_GLOBAL.USER_ID,
5020: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
5021: p_request_id => FND_GLOBAL.CONC_REQUEST_ID,
5022: p_program_application_id => FND_GLOBAL.PROG_APPL_ID,
5023: p_program_update_date => SYSDATE,
5024: p_program_id => FND_GLOBAL.CONC_PROGRAM_ID,
5025: p_created_from => l_settlement_doc_rec.created_from,
5026: p_claim_id => l_settlement_doc_rec.claim_id,

Line 5024: p_program_id => FND_GLOBAL.CONC_PROGRAM_ID,

5020: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
5021: p_request_id => FND_GLOBAL.CONC_REQUEST_ID,
5022: p_program_application_id => FND_GLOBAL.PROG_APPL_ID,
5023: p_program_update_date => SYSDATE,
5024: p_program_id => FND_GLOBAL.CONC_PROGRAM_ID,
5025: p_created_from => l_settlement_doc_rec.created_from,
5026: p_claim_id => l_settlement_doc_rec.claim_id,
5027: p_claim_line_id => l_settlement_doc_rec.claim_line_id,
5028: p_payment_method => l_settlement_doc_rec.payment_method,

Line 5199: l_last_updated_by := NVL(FND_GLOBAL.user_id,-1);

5195:
5196: x_return_status := FND_API.g_ret_sts_success;
5197:
5198:
5199: l_last_updated_by := NVL(FND_GLOBAL.user_id,-1);
5200: l_last_update_login := NVL(FND_GLOBAL.conc_login_id,-1);
5201:
5202:
5203: ----------------------- validate ----------------------

Line 5200: l_last_update_login := NVL(FND_GLOBAL.conc_login_id,-1);

5196: x_return_status := FND_API.g_ret_sts_success;
5197:
5198:
5199: l_last_updated_by := NVL(FND_GLOBAL.user_id,-1);
5200: l_last_update_login := NVL(FND_GLOBAL.conc_login_id,-1);
5201:
5202:
5203: ----------------------- validate ----------------------
5204: -- Varify object_version_number

Line 5297: p_last_updated_by => FND_GLOBAL.USER_ID,

5293: OZF_SETTLEMENT_DOCS_PKG.Update_Row(
5294: p_settlement_doc_id => l_complete_doc_rec.settlement_doc_id,
5295: p_object_version_number => l_object_version_number,
5296: p_last_update_date => SYSDATE,
5297: p_last_updated_by => FND_GLOBAL.USER_ID,
5298: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
5299: p_request_id => l_complete_doc_rec.request_id,
5300: p_program_application_id => l_complete_doc_rec.program_application_id,
5301: p_program_update_date => l_complete_doc_rec.program_update_date,

Line 5298: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,

5294: p_settlement_doc_id => l_complete_doc_rec.settlement_doc_id,
5295: p_object_version_number => l_object_version_number,
5296: p_last_update_date => SYSDATE,
5297: p_last_updated_by => FND_GLOBAL.USER_ID,
5298: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
5299: p_request_id => l_complete_doc_rec.request_id,
5300: p_program_application_id => l_complete_doc_rec.program_application_id,
5301: p_program_update_date => l_complete_doc_rec.program_update_date,
5302: p_program_id => l_complete_doc_rec.program_id,

Line 5355: request_id = FND_GLOBAL.CONC_REQUEST_ID,

5351: object_version_number = l_object_version_number,
5352: last_update_date = SYSDATE,
5353: last_updated_by = l_last_updated_by,
5354: last_update_login = l_last_update_login,
5355: request_id = FND_GLOBAL.CONC_REQUEST_ID,
5356: program_application_id = FND_GLOBAL.PROG_APPL_ID,
5357: program_update_date = SYSDATE,
5358: program_id = FND_GLOBAL.CONC_PROGRAM_ID,
5359: created_from = l_complete_doc_rec.created_from,

Line 5356: program_application_id = FND_GLOBAL.PROG_APPL_ID,

5352: last_update_date = SYSDATE,
5353: last_updated_by = l_last_updated_by,
5354: last_update_login = l_last_update_login,
5355: request_id = FND_GLOBAL.CONC_REQUEST_ID,
5356: program_application_id = FND_GLOBAL.PROG_APPL_ID,
5357: program_update_date = SYSDATE,
5358: program_id = FND_GLOBAL.CONC_PROGRAM_ID,
5359: created_from = l_complete_doc_rec.created_from,
5360: claim_id = l_complete_doc_rec.claim_id,

Line 5358: program_id = FND_GLOBAL.CONC_PROGRAM_ID,

5354: last_update_login = l_last_update_login,
5355: request_id = FND_GLOBAL.CONC_REQUEST_ID,
5356: program_application_id = FND_GLOBAL.PROG_APPL_ID,
5357: program_update_date = SYSDATE,
5358: program_id = FND_GLOBAL.CONC_PROGRAM_ID,
5359: created_from = l_complete_doc_rec.created_from,
5360: claim_id = l_complete_doc_rec.claim_id,
5361: claim_line_id = l_complete_doc_rec.claim_line_id,
5362: payment_method = l_complete_doc_rec.payment_method,