DBA Data[Home] [Help]

APPS.IBY_FD_EXTRACT_GEN_PVT dependencies on FND_GLOBAL

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

4120: /* Preparing the concatinated strings of invalid characters
4121: and corresponding replacement characters. Bug 7292070 */
4122: /*
4123: FOR i in 1..32 LOOP
4124: l_conc_invalid_chars :=l_conc_invalid_chars||fnd_global.local_chr(i-1);
4125: l_conc_replacement_chars :=l_conc_replacement_chars||' ';
4126: END LOOP;
4127: */
4128: OPEN l_docline_csr (p_document_payable_id,l_conc_invalid_chars,l_conc_replacement_chars);

Line 4864: last_updated_by = fnd_global.user_id,

4860: remit_advice_delivery_method = 'PRINTED',
4861: remit_advice_email = null,
4862: remit_advice_fax = null,
4863: object_version_number = object_version_number + 1,
4864: last_updated_by = fnd_global.user_id,
4865: last_update_date = SYSDATE,
4866: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)
4867: WHERE
4868: payment_id = l_payment.payment_id;

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

4862: remit_advice_fax = null,
4863: object_version_number = object_version_number + 1,
4864: last_updated_by = fnd_global.user_id,
4865: last_update_date = SYSDATE,
4866: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)
4867: WHERE
4868: payment_id = l_payment.payment_id;
4869:
4870: END LOOP;

Line 4894: last_updated_by = fnd_global.user_id,

4890: remit_advice_delivery_method = p_delivery_method,
4891: remit_advice_email = p_recipient_email,
4892: remit_advice_fax = null,
4893: object_version_number = object_version_number + 1,
4894: last_updated_by = fnd_global.user_id,
4895: last_update_date = SYSDATE,
4896: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)
4897: WHERE payment_id = p_payment_id;
4898: ELSIF p_delivery_method = 'FAX' THEN

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

4892: remit_advice_fax = null,
4893: object_version_number = object_version_number + 1,
4894: last_updated_by = fnd_global.user_id,
4895: last_update_date = SYSDATE,
4896: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)
4897: WHERE payment_id = p_payment_id;
4898: ELSIF p_delivery_method = 'FAX' THEN
4899: UPDATE
4900: iby_payments_all

Line 4906: last_updated_by = fnd_global.user_id,

4902: remit_advice_delivery_method = p_delivery_method,
4903: remit_advice_email = null,
4904: remit_advice_fax = p_recipient_fax,
4905: object_version_number = object_version_number + 1,
4906: last_updated_by = fnd_global.user_id,
4907: last_update_date = SYSDATE,
4908: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)
4909: WHERE payment_id = p_payment_id;
4910: END IF;

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

4904: remit_advice_fax = p_recipient_fax,
4905: object_version_number = object_version_number + 1,
4906: last_updated_by = fnd_global.user_id,
4907: last_update_date = SYSDATE,
4908: last_update_login = nvl(fnd_global.LOGIN_ID, fnd_global.conc_login_id)
4909: WHERE payment_id = p_payment_id;
4910: END IF;
4911: END Update_Pmt_SRA_Attr_Ele;
4912:

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

5637:
5638: /* Preparing the concatinated strings of invalid characters
5639: and corresponding replacement characters. Bug 7292070 */
5640: FOR i in 1..32 LOOP
5641: l_conc_invalid_chars :=l_conc_invalid_chars||fnd_global.local_chr(i-1);
5642: l_conc_replacement_chars :=l_conc_replacement_chars||' ';
5643: END LOOP;
5644:
5645: l_modified := TRANSLATE(p_base_string, l_conc_invalid_chars, l_conc_replacement_chars);

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

5977: END get_PayeeBankAccountAssignment;
5978:
5979: BEGIN
5980: FOR i in 1..32 LOOP
5981: l_conc_invalid_chars :=l_conc_invalid_chars||fnd_global.local_chr(i-1);
5982: l_conc_replacement_chars :=l_conc_replacement_chars||' ';
5983: END LOOP;
5984: END IBY_FD_EXTRACT_GEN_PVT;
5985: