DBA Data[Home] [Help]

APPS.JAI_AR_MATCH_TAX_PKG dependencies on FND_PROFILE

Line 32: --| (1) --|oved the reference to fnd_profile.value('ORG_ID'); |

28: --| VAT/Excise invoice numbers |
29: --| |
30: --| HISTORY |
31: --| Bug 5243532. Added by Lakshmi Gopalsami |
32: --| (1) --|oved the reference to fnd_profile.value('ORG_ID'); |
33: --| (2) --|oved the cursor ORG_CUR_UPD as it is same as ORG_CUR |
34: --| (3) --|oved the reference to hr_operating_units and |
35: --| Implemented using caching logic. |
36: --| |

Line 638: --|oved the reference to fnd_profile.value('ORG_ID')

634: ja_in_ar_rec_prc_val_b.pls 115.0 Aiyer 21/10/2004
635: ja_ar_rec_process_validate.val_revrec_records
636: -------------------------------------------------------------------------------------------------------------------------------------------------------------------------*/
637: /* Bug 5243532. Added by Lakshmi Gopalsami
638: --|oved the reference to fnd_profile.value('ORG_ID')
639: v_org_id := FND_PROFILE.VALUE('ORG_ID');
640: */
641: lv_debug := nvl(p_debug,'N');
642: lv_debug := 'Y';

Line 639: v_org_id := FND_PROFILE.VALUE('ORG_ID');

635: ja_ar_rec_process_validate.val_revrec_records
636: -------------------------------------------------------------------------------------------------------------------------------------------------------------------------*/
637: /* Bug 5243532. Added by Lakshmi Gopalsami
638: --|oved the reference to fnd_profile.value('ORG_ID')
639: v_org_id := FND_PROFILE.VALUE('ORG_ID');
640: */
641: lv_debug := nvl(p_debug,'N');
642: lv_debug := 'Y';
643: fnd_file.put_line(FND_FILE.LOG,' Entering Procedure - jai_ar_match_tax_pkg.process_batch');

Line 930: lv_display_flag := FND_PROFILE.VALUE('JAI_DISP_VAT_EXC_INV_AR_TRX_REF');

926: INTO lv_vat_invoice_no;
927: CLOSE get_vat_inv_no_cur;
928: END IF;
929:
930: lv_display_flag := FND_PROFILE.VALUE('JAI_DISP_VAT_EXC_INV_AR_TRX_REF');
931:
932: FND_FILE.put_line(FND_FILE.LOG,
933: 'JAI:Include Excise and VAT Invoice Number in AR transactions - Referencde is set to ' ||
934: lv_display_flag);

Line 1175: ln_last_updated_by := TO_NUMBER(fnd_profile.value('USER_ID'));

1171: p_process_status := jai_constants.successful;
1172: p_process_message := NULL;
1173:
1174: --set the values for WHO columns
1175: ln_last_updated_by := TO_NUMBER(fnd_profile.value('USER_ID'));
1176: ld_last_update_date := SYSDATE;
1177: ln_last_update_login := TO_NUMBER(fnd_profile.value('LOGIN_ID'));
1178:
1179: --In case of operation_type = 'UPDATE', the parameter p_payment_audit_id shall have a value

Line 1177: ln_last_update_login := TO_NUMBER(fnd_profile.value('LOGIN_ID'));

1173:
1174: --set the values for WHO columns
1175: ln_last_updated_by := TO_NUMBER(fnd_profile.value('USER_ID'));
1176: ld_last_update_date := SYSDATE;
1177: ln_last_update_login := TO_NUMBER(fnd_profile.value('LOGIN_ID'));
1178:
1179: --In case of operation_type = 'UPDATE', the parameter p_payment_audit_id shall have a value
1180: --In case of 'INSERT', the value for parameter p_payment_audit_id shall be null
1181: IF p_rec_appl_audit_id IS NULL THEN

Line 1293: ln_last_updated_by := TO_NUMBER(fnd_profile.value('USER_ID'));

1289: p_process_status := jai_constants.successful;
1290: p_process_message := NULL;
1291:
1292: --set the values for WHO columns
1293: ln_last_updated_by := TO_NUMBER(fnd_profile.value('USER_ID'));
1294: ld_last_update_date := SYSDATE;
1295: ln_last_update_login := TO_NUMBER(fnd_profile.value('LOGIN_ID'));
1296:
1297: --In case of operation_type = 'UPDATE', the parameter p_payment_audit_id shall have a value

Line 1295: ln_last_update_login := TO_NUMBER(fnd_profile.value('LOGIN_ID'));

1291:
1292: --set the values for WHO columns
1293: ln_last_updated_by := TO_NUMBER(fnd_profile.value('USER_ID'));
1294: ld_last_update_date := SYSDATE;
1295: ln_last_update_login := TO_NUMBER(fnd_profile.value('LOGIN_ID'));
1296:
1297: --In case of operation_type = 'UPDATE', the parameter p_payment_audit_id shall have a value
1298: --In case of 'INSERT', the value for parameter p_payment_audit_id shall be null
1299: IF p_payment_audit_id IS NULL THEN

Line 5098: , TO_NUMBER(fnd_profile.value('USER_ID')) -- standard who column

5094: , 'Register India' -- je category name 'Register India'
5095: , ld_gl_date -- accounting date (GL date of the invoice)
5096: , lv_currency_code -- currency code
5097: , sysdate -- standard who column
5098: , TO_NUMBER(fnd_profile.value('USER_ID')) -- standard who column
5099: , 'A' -- actual flag, hard coded value
5100: --, inclu_tax_csr.tax_amount -- credit amt, inclusive tax amount
5101: , ln_amount -- modified by Xiao for bug#11936390.
5102: , null -- debit amt

Line 5331: , TO_NUMBER(fnd_profile.value('USER_ID')) -- standard who column

5327: , 'Register India' -- je category name 'Register India'
5328: , ld_gl_date -- accounting date (GL date of the invoice)
5329: , lv_currency_code -- currency code
5330: , sysdate -- standard who column
5331: , TO_NUMBER(fnd_profile.value('USER_ID')) -- standard who column
5332: , 'A' -- actual flag, hard coded value
5333: --, inclu_tax_csr.tax_amount -- credit amt, inclusive tax amount
5334: , ln_amount -- modified by Xiao for bug#11936390
5335: , null -- debit amt

Line 5412: , TO_NUMBER(fnd_profile.value('USER_ID')) -- standard who column

5408: , 'Register India' -- je category name 'Register India'
5409: , ld_gl_date -- accounting date (GL date of the invoice)
5410: , lv_currency_code -- currency code
5411: , sysdate -- standard who column
5412: , TO_NUMBER(fnd_profile.value('USER_ID')) -- standard who column
5413: , 'A' -- actual flag, hard coded value
5414: , null -- credit amt, inclusive tax amount
5415: , ln_total_inclu_tax_amt -- debit amt
5416: , sysdate -- invoice date