DBA Data[Home] [Help]

APPS.IBY_FD_EXTRACT_GEN_PVT dependencies on FND_GLOBAL

Line 3024: l_conc_invalid_chars :=l_conc_invalid_chars||fnd_global.local_chr(i-1);

3020: END IF;
3021: /* Preparing the concatinated strings of invalid characters
3022: and corresponding replacement characters. Bug 7292070 */
3023: FOR i in 1..32 LOOP
3024: l_conc_invalid_chars :=l_conc_invalid_chars||fnd_global.local_chr(i-1);
3025: l_conc_replacement_chars :=l_conc_replacement_chars||' ';
3026: END LOOP;
3027:
3028: OPEN l_docline_csr (p_document_payable_id,l_conc_invalid_chars,l_conc_replacement_chars);

Line 3625: last_updated_by = fnd_global.user_id,

3621: remit_advice_delivery_method = 'PRINTED',
3622: remit_advice_email = null,
3623: remit_advice_fax = null,
3624: object_version_number = object_version_number + 1,
3625: last_updated_by = fnd_global.user_id,
3626: last_update_date = SYSDATE,
3627: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)
3628: WHERE
3629: payment_id = l_payment.payment_id;

Line 3627: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)

3623: remit_advice_fax = null,
3624: object_version_number = object_version_number + 1,
3625: last_updated_by = fnd_global.user_id,
3626: last_update_date = SYSDATE,
3627: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)
3628: WHERE
3629: payment_id = l_payment.payment_id;
3630:
3631: END LOOP;

Line 3655: last_updated_by = fnd_global.user_id,

3651: remit_advice_delivery_method = p_delivery_method,
3652: remit_advice_email = p_recipient_email,
3653: remit_advice_fax = null,
3654: object_version_number = object_version_number + 1,
3655: last_updated_by = fnd_global.user_id,
3656: last_update_date = SYSDATE,
3657: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)
3658: WHERE payment_id = p_payment_id;
3659: ELSIF p_delivery_method = 'FAX' THEN

Line 3657: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)

3653: remit_advice_fax = null,
3654: object_version_number = object_version_number + 1,
3655: last_updated_by = fnd_global.user_id,
3656: last_update_date = SYSDATE,
3657: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)
3658: WHERE payment_id = p_payment_id;
3659: ELSIF p_delivery_method = 'FAX' THEN
3660: UPDATE
3661: iby_payments_all

Line 3667: last_updated_by = fnd_global.user_id,

3663: remit_advice_delivery_method = p_delivery_method,
3664: remit_advice_email = null,
3665: remit_advice_fax = p_recipient_fax,
3666: object_version_number = object_version_number + 1,
3667: last_updated_by = fnd_global.user_id,
3668: last_update_date = SYSDATE,
3669: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)
3670: WHERE payment_id = p_payment_id;
3671: END IF;

Line 3669: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)

3665: remit_advice_fax = p_recipient_fax,
3666: object_version_number = object_version_number + 1,
3667: last_updated_by = fnd_global.user_id,
3668: last_update_date = SYSDATE,
3669: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)
3670: WHERE payment_id = p_payment_id;
3671: END IF;
3672: END Update_Pmt_SRA_Attr_Ele;
3673:

Line 3966: l_conc_invalid_chars :=l_conc_invalid_chars||fnd_global.local_chr(i-1);

3962:
3963: /* Preparing the concatinated strings of invalid characters
3964: and corresponding replacement characters. Bug 7292070 */
3965: FOR i in 1..32 LOOP
3966: l_conc_invalid_chars :=l_conc_invalid_chars||fnd_global.local_chr(i-1);
3967: l_conc_replacement_chars :=l_conc_replacement_chars||' ';
3968: END LOOP;
3969:
3970: l_modified := TRANSLATE(p_base_string, l_conc_invalid_chars, l_conc_replacement_chars);