[Home] [Help]
1888: p_vendor_pan_num ,
1889: p_section_type ,
1890: p_section_code ,
1891: p_fin_year ,
1892: fnd_global.user_id ,
1893: sysdate ,
1894: fnd_global.user_id ,
1895: sysdate ,
1896: fnd_global.login_id
1890: p_section_code ,
1891: p_fin_year ,
1892: fnd_global.user_id ,
1893: sysdate ,
1894: fnd_global.user_id ,
1895: sysdate ,
1896: fnd_global.login_id
1897: )
1898: returning threshold_grp_id into ln_threshold_grp_id;
1892: fnd_global.user_id ,
1893: sysdate ,
1894: fnd_global.user_id ,
1895: sysdate ,
1896: fnd_global.login_id
1897: )
1898: returning threshold_grp_id into ln_threshold_grp_id;
1899:
1900: p_threshold_grp_id := ln_threshold_grp_id;
2072: p_invoice_id ,
2073: p_invoice_line_number ,
2074: p_invoice_distribution_id ,
2075: p_remarks ,
2076: fnd_global.user_id ,
2077: sysdate ,
2078: fnd_global.user_id ,
2079: sysdate ,
2080: fnd_global.login_id ,
2074: p_invoice_distribution_id ,
2075: p_remarks ,
2076: fnd_global.user_id ,
2077: sysdate ,
2078: fnd_global.user_id ,
2079: sysdate ,
2080: fnd_global.login_id ,
2081: /*Bug 5751783*/
2082: ln_calc_old_tax_paid ,
2076: fnd_global.user_id ,
2077: sysdate ,
2078: fnd_global.user_id ,
2079: sysdate ,
2080: fnd_global.login_id ,
2081: /*Bug 5751783*/
2082: ln_calc_old_tax_paid ,
2083: ln_calc_trx_tax_paid ,
2084: ln_calc_new_tax_paid
2366: rec_challan.payment_reference_id, --PAYMENT_REFERENCE_ID ,
2367: rec_tds_taxes.tax_amount, --get from jai_ap_tds_inv_taxes,--TAX_AMOUNT ,
2368: rec_tds_taxes.tax_amount, --get from jai_ap_tds_inv_taxes,--BASE_TAX_AMOUNT ,
2369: sysdate,
2370: fnd_global.user_id ,
2371: sysdate ,
2372: fnd_global.login_id ,
2373: fnd_global.user_id
2374:
2368: rec_tds_taxes.tax_amount, --get from jai_ap_tds_inv_taxes,--BASE_TAX_AMOUNT ,
2369: sysdate,
2370: fnd_global.user_id ,
2371: sysdate ,
2372: fnd_global.login_id ,
2373: fnd_global.user_id
2374:
2375: );
2376:
2369: sysdate,
2370: fnd_global.user_id ,
2371: sysdate ,
2372: fnd_global.login_id ,
2373: fnd_global.user_id
2374:
2375: );
2376:
2377: end loop;
3849: null,--Tax amount
3850: null,--Func amount
3851: null,--Base amount
3852: sysdate,
3853: fnd_global.user_id ,
3854: sysdate ,
3855: fnd_global.login_id ,
3856: fnd_global.user_id
3857:
3851: null,--Base amount
3852: sysdate,
3853: fnd_global.user_id ,
3854: sysdate ,
3855: fnd_global.login_id ,
3856: fnd_global.user_id
3857:
3858: );
3859: END LOOP;--loop for category*\
3852: sysdate,
3853: fnd_global.user_id ,
3854: sysdate ,
3855: fnd_global.login_id ,
3856: fnd_global.user_id
3857:
3858: );
3859: END LOOP;--loop for category*\
3860:
3925: p_vendor_id => P_VENDOR_ID,
3926: p_currency => P_INVOICE_CURRENCY_CODE,
3927: p_currency_conv_factor => P_EXCHANGE_RATE,
3928: p_creation_date => SYSDATE,
3929: p_created_by => FND_GLOBAL.USER_ID,
3930: p_last_update_date => SYSDATE,
3931: p_last_updated_by => FND_GLOBAL.USER_ID,
3932: p_last_update_login => FND_GLOBAL.LOGIN_ID,
3933: p_source_trx_type => 'TDS INVOICE',
3927: p_currency_conv_factor => P_EXCHANGE_RATE,
3928: p_creation_date => SYSDATE,
3929: p_created_by => FND_GLOBAL.USER_ID,
3930: p_last_update_date => SYSDATE,
3931: p_last_updated_by => FND_GLOBAL.USER_ID,
3932: p_last_update_login => FND_GLOBAL.LOGIN_ID,
3933: p_source_trx_type => 'TDS INVOICE',
3934: p_action => JAI_CONSTANTS.RECALCULATE_TAXES
3935: );
3928: p_creation_date => SYSDATE,
3929: p_created_by => FND_GLOBAL.USER_ID,
3930: p_last_update_date => SYSDATE,
3931: p_last_updated_by => FND_GLOBAL.USER_ID,
3932: p_last_update_login => FND_GLOBAL.LOGIN_ID,
3933: p_source_trx_type => 'TDS INVOICE',
3934: p_action => JAI_CONSTANTS.RECALCULATE_TAXES
3935: );
3936:
5494: R_TAX_CTG_LINES.TAX_ID,
5495: 'D',
5496: NULL,
5497: 'Q',
5498: FND_GLOBAL.USER_ID,
5499: SYSDATE,
5500: FND_GLOBAL.USER_ID,
5501: SYSDATE,
5502: FND_GLOBAL.LOGIN_ID,
5496: NULL,
5497: 'Q',
5498: FND_GLOBAL.USER_ID,
5499: SYSDATE,
5500: FND_GLOBAL.USER_ID,
5501: SYSDATE,
5502: FND_GLOBAL.LOGIN_ID,
5503: 1,
5504: round(decode(R_TAX_CTG_LINES.LINE_NO, 1, TRAN_TAB(i).AMOUNT, 0),ln_rounding_factor),
5498: FND_GLOBAL.USER_ID,
5499: SYSDATE,
5500: FND_GLOBAL.USER_ID,
5501: SYSDATE,
5502: FND_GLOBAL.LOGIN_ID,
5503: 1,
5504: round(decode(R_TAX_CTG_LINES.LINE_NO, 1, TRAN_TAB(i).AMOUNT, 0),ln_rounding_factor),
5505: 'Y'
5506: );
5523: p_vendor_id => ln_vendor_id,
5524: p_currency => lv_invoice_curr_code,
5525: p_currency_conv_factor => ln_exchange_rate,
5526: p_creation_date => SYSDATE,
5527: p_created_by => FND_GLOBAL.USER_ID,
5528: p_last_update_date => SYSDATE,
5529: p_last_updated_by => FND_GLOBAL.USER_ID,
5530: p_last_update_login => FND_GLOBAL.LOGIN_ID,
5531: p_source_trx_type => 'TDS INVOICE',
5525: p_currency_conv_factor => ln_exchange_rate,
5526: p_creation_date => SYSDATE,
5527: p_created_by => FND_GLOBAL.USER_ID,
5528: p_last_update_date => SYSDATE,
5529: p_last_updated_by => FND_GLOBAL.USER_ID,
5530: p_last_update_login => FND_GLOBAL.LOGIN_ID,
5531: p_source_trx_type => 'TDS INVOICE',
5532: p_action => JAI_CONSTANTS.RECALCULATE_TAXES
5533: );
5526: p_creation_date => SYSDATE,
5527: p_created_by => FND_GLOBAL.USER_ID,
5528: p_last_update_date => SYSDATE,
5529: p_last_updated_by => FND_GLOBAL.USER_ID,
5530: p_last_update_login => FND_GLOBAL.LOGIN_ID,
5531: p_source_trx_type => 'TDS INVOICE',
5532: p_action => JAI_CONSTANTS.RECALCULATE_TAXES
5533: );
5534:
6318: p_exchange_date => null,
6319: p_terms_id => ln_terms_id,
6320: p_description => lv_invoice_to_tds_num,
6321: p_last_update_date => sysdate,
6322: p_last_updated_by => fnd_global.user_id,
6323: p_last_update_login => fnd_global.login_id,
6324: p_creation_date => sysdate,
6325: p_created_by => fnd_global.user_id,
6326: p_source => lv_source,
6319: p_terms_id => ln_terms_id,
6320: p_description => lv_invoice_to_tds_num,
6321: p_last_update_date => sysdate,
6322: p_last_updated_by => fnd_global.user_id,
6323: p_last_update_login => fnd_global.login_id,
6324: p_creation_date => sysdate,
6325: p_created_by => fnd_global.user_id,
6326: p_source => lv_source,
6327: p_voucher_num => lv_invoice_to_tds_num,
6321: p_last_update_date => sysdate,
6322: p_last_updated_by => fnd_global.user_id,
6323: p_last_update_login => fnd_global.login_id,
6324: p_creation_date => sysdate,
6325: p_created_by => fnd_global.user_id,
6326: p_source => lv_source,
6327: p_voucher_num => lv_invoice_to_tds_num,
6328: --p_payment_method_lookup_code => lv_payment_method_lookup_code,
6329: --commented by Sanjikum for Bug#4482462
6349: --p_description => lv_invoice_to_tds_num,
6350: p_description => lv_invoice_to_tds_num||'/'||pv_section_code||'/'||r_ja_in_tax_codes.tax_type||'/'||pn_tax_id||'/'||r_ja_in_tax_codes.tax_rate,--Update by Chong on 20130320
6351: p_dist_code_combination_id => r_ja_in_tax_codes.tax_account_id,
6352: p_last_update_date => sysdate,
6353: p_last_updated_by => fnd_global.user_id,
6354: p_last_update_login => fnd_global.login_id,
6355: p_creation_date => sysdate,
6356: p_created_by => fnd_global.user_id
6357: );
6350: p_description => lv_invoice_to_tds_num||'/'||pv_section_code||'/'||r_ja_in_tax_codes.tax_type||'/'||pn_tax_id||'/'||r_ja_in_tax_codes.tax_rate,--Update by Chong on 20130320
6351: p_dist_code_combination_id => r_ja_in_tax_codes.tax_account_id,
6352: p_last_update_date => sysdate,
6353: p_last_updated_by => fnd_global.user_id,
6354: p_last_update_login => fnd_global.login_id,
6355: p_creation_date => sysdate,
6356: p_created_by => fnd_global.user_id
6357: );
6358:
6352: p_last_update_date => sysdate,
6353: p_last_updated_by => fnd_global.user_id,
6354: p_last_update_login => fnd_global.login_id,
6355: p_creation_date => sysdate,
6356: p_created_by => fnd_global.user_id
6357: );
6358:
6359: end if; /* Invoice to TDS authority */
6360:
6457: p_exchange_date => r_ap_invoices_all.exchange_date,
6458: p_terms_id => r_ap_invoices_all.terms_id,
6459: p_description => lv_invoice_to_vendor_num,
6460: p_last_update_date => sysdate,
6461: p_last_updated_by => fnd_global.user_id,
6462: p_last_update_login => fnd_global.login_id,
6463: p_creation_date => sysdate,
6464: p_created_by => fnd_global.user_id,
6465: p_source => lv_source,
6458: p_terms_id => r_ap_invoices_all.terms_id,
6459: p_description => lv_invoice_to_vendor_num,
6460: p_last_update_date => sysdate,
6461: p_last_updated_by => fnd_global.user_id,
6462: p_last_update_login => fnd_global.login_id,
6463: p_creation_date => sysdate,
6464: p_created_by => fnd_global.user_id,
6465: p_source => lv_source,
6466: p_voucher_num => lv_invoice_to_vendor_num,
6460: p_last_update_date => sysdate,
6461: p_last_updated_by => fnd_global.user_id,
6462: p_last_update_login => fnd_global.login_id,
6463: p_creation_date => sysdate,
6464: p_created_by => fnd_global.user_id,
6465: p_source => lv_source,
6466: p_voucher_num => lv_invoice_to_vendor_num,
6467: -- Bug 7109056. Added by Lakshmi Gopalsami
6468: p_payment_method_code => r_ap_invoices_all.payment_method_code,
6492: --p_description => lv_invoice_to_vendor_num,
6493: p_description => lv_invoice_to_vendor_num||'/'||pv_section_code||'/'||r_ja_in_tax_codes.tax_type||'/'||pn_tax_id||'/'||r_ja_in_tax_codes.tax_rate,--Update by Chong on 20130320
6494: p_dist_code_combination_id => r_ja_in_tax_codes.tax_account_id,
6495: p_last_update_date => sysdate,
6496: p_last_updated_by => fnd_global.user_id,
6497: p_last_update_login => fnd_global.login_id,
6498: p_creation_date => sysdate,
6499: p_created_by => fnd_global.user_id
6500: );
6493: p_description => lv_invoice_to_vendor_num||'/'||pv_section_code||'/'||r_ja_in_tax_codes.tax_type||'/'||pn_tax_id||'/'||r_ja_in_tax_codes.tax_rate,--Update by Chong on 20130320
6494: p_dist_code_combination_id => r_ja_in_tax_codes.tax_account_id,
6495: p_last_update_date => sysdate,
6496: p_last_updated_by => fnd_global.user_id,
6497: p_last_update_login => fnd_global.login_id,
6498: p_creation_date => sysdate,
6499: p_created_by => fnd_global.user_id
6500: );
6501:
6495: p_last_update_date => sysdate,
6496: p_last_updated_by => fnd_global.user_id,
6497: p_last_update_login => fnd_global.login_id,
6498: p_creation_date => sysdate,
6499: p_created_by => fnd_global.user_id
6500: );
6501:
6502: end if;
6503: end if; /* Invoice to Supplier */
6598: --r_ap_invoices_all.org_id,
6599: r_ap_invoices_all.org_id,
6600: lv_source_attribute, --rchandan for bug#4428980
6601: /* Ramananda for bug#4560109 during R12 Sanity Testing. Added the WHO columns */
6602: fnd_global.user_id ,
6603: sysdate ,
6604: fnd_global.user_id ,
6605: sysdate ,
6606: fnd_global.login_id
6600: lv_source_attribute, --rchandan for bug#4428980
6601: /* Ramananda for bug#4560109 during R12 Sanity Testing. Added the WHO columns */
6602: fnd_global.user_id ,
6603: sysdate ,
6604: fnd_global.user_id ,
6605: sysdate ,
6606: fnd_global.login_id
6607: );
6608: end if;
6602: fnd_global.user_id ,
6603: sysdate ,
6604: fnd_global.user_id ,
6605: sysdate ,
6606: fnd_global.login_id
6607: );
6608: end if;
6609: end if; /* Only for validate event as done in earlier regime */
6610:
6716: r_ap_invoices_all.invoice_currency_code ,
6717: ln_invoice_to_vendor_amount ,
6718: r_ap_payment_schedules_all.payment_priority ,
6719: r_ap_invoices_all.exchange_rate ,
6720: fnd_global.user_id ,
6721: sysdate ,
6722: fnd_global.user_id ,
6723: sysdate ,
6724: fnd_global.login_id ,
6718: r_ap_payment_schedules_all.payment_priority ,
6719: r_ap_invoices_all.exchange_rate ,
6720: fnd_global.user_id ,
6721: sysdate ,
6722: fnd_global.user_id ,
6723: sysdate ,
6724: fnd_global.login_id ,
6725: decode ( pv_tds_event, 'PREPAYMENT UNAPPLICATION', pn_calc_tax_amount, pn_tax_amount), /*Added decode condition for bug 12965614 */ /*Bug 5751783*/
6726: ln_tds_rnding_factor -- Bug 5722028. Added by csahoo
6720: fnd_global.user_id ,
6721: sysdate ,
6722: fnd_global.user_id ,
6723: sysdate ,
6724: fnd_global.login_id ,
6725: decode ( pv_tds_event, 'PREPAYMENT UNAPPLICATION', pn_calc_tax_amount, pn_tax_amount), /*Added decode condition for bug 12965614 */ /*Bug 5751783*/
6726: ln_tds_rnding_factor -- Bug 5722028. Added by csahoo
6727: ,pv_section_code --Added by Chong for bug#16414088 20130313
6728: )
7498: p_exchange_date => null,
7499: p_terms_id => ln_terms_id,
7500: p_description => lv_invoice_to_tds_num,
7501: p_last_update_date => sysdate,
7502: p_last_updated_by => fnd_global.user_id,
7503: p_last_update_login => fnd_global.login_id,
7504: p_creation_date => sysdate,
7505: p_created_by => fnd_global.user_id,
7506: p_source => lv_source,
7499: p_terms_id => ln_terms_id,
7500: p_description => lv_invoice_to_tds_num,
7501: p_last_update_date => sysdate,
7502: p_last_updated_by => fnd_global.user_id,
7503: p_last_update_login => fnd_global.login_id,
7504: p_creation_date => sysdate,
7505: p_created_by => fnd_global.user_id,
7506: p_source => lv_source,
7507: p_voucher_num => lv_invoice_to_tds_num,
7501: p_last_update_date => sysdate,
7502: p_last_updated_by => fnd_global.user_id,
7503: p_last_update_login => fnd_global.login_id,
7504: p_creation_date => sysdate,
7505: p_created_by => fnd_global.user_id,
7506: p_source => lv_source,
7507: p_voucher_num => lv_invoice_to_tds_num,
7508: p_pay_group_lookup_code => lv_pay_group_lookup_code,
7509: p_org_id => r_ap_invoices_all.org_id,
7530: p_accounting_date => ld_accounting_date,
7531: p_description => lv_invoice_to_tds_num||'/'||pv_section_type||'/'||pv_section_code||'/'||rec_tax.tax_type||'/'||ln_tax_id_new||'/'||ln_tax_rate,--Update by Zhiwei on 20120104
7532: p_dist_code_combination_id => r_ja_in_tax_codes.tax_account_id,
7533: p_last_update_date => sysdate,
7534: p_last_updated_by => fnd_global.user_id,
7535: p_last_update_login => fnd_global.login_id,
7536: p_creation_date => sysdate,
7537: p_created_by => fnd_global.user_id
7538: );
7531: p_description => lv_invoice_to_tds_num||'/'||pv_section_type||'/'||pv_section_code||'/'||rec_tax.tax_type||'/'||ln_tax_id_new||'/'||ln_tax_rate,--Update by Zhiwei on 20120104
7532: p_dist_code_combination_id => r_ja_in_tax_codes.tax_account_id,
7533: p_last_update_date => sysdate,
7534: p_last_updated_by => fnd_global.user_id,
7535: p_last_update_login => fnd_global.login_id,
7536: p_creation_date => sysdate,
7537: p_created_by => fnd_global.user_id
7538: );
7539:
7533: p_last_update_date => sysdate,
7534: p_last_updated_by => fnd_global.user_id,
7535: p_last_update_login => fnd_global.login_id,
7536: p_creation_date => sysdate,
7537: p_created_by => fnd_global.user_id
7538: );
7539:
7540:
7541: --ln_author_inv_sum_amount := ln_author_inv_sum_amount + ln_tax_amt_for_each;
7580: p_exchange_date => r_ap_invoices_all.exchange_date,
7581: p_terms_id => r_ap_invoices_all.terms_id,
7582: p_description => lv_invoice_to_vendor_num,
7583: p_last_update_date => sysdate,
7584: p_last_updated_by => fnd_global.user_id,
7585: p_last_update_login => fnd_global.login_id,
7586: p_creation_date => sysdate,
7587: p_created_by => fnd_global.user_id,
7588: p_source => lv_source,
7581: p_terms_id => r_ap_invoices_all.terms_id,
7582: p_description => lv_invoice_to_vendor_num,
7583: p_last_update_date => sysdate,
7584: p_last_updated_by => fnd_global.user_id,
7585: p_last_update_login => fnd_global.login_id,
7586: p_creation_date => sysdate,
7587: p_created_by => fnd_global.user_id,
7588: p_source => lv_source,
7589: p_voucher_num => lv_invoice_to_vendor_num,
7583: p_last_update_date => sysdate,
7584: p_last_updated_by => fnd_global.user_id,
7585: p_last_update_login => fnd_global.login_id,
7586: p_creation_date => sysdate,
7587: p_created_by => fnd_global.user_id,
7588: p_source => lv_source,
7589: p_voucher_num => lv_invoice_to_vendor_num,
7590: p_payment_method_code => r_ap_invoices_all.payment_method_code,
7591: p_pay_group_lookup_code => r_ap_invoices_all.pay_group_lookup_code,
7623: p_accounting_date => ld_accounting_date,
7624: p_description => lv_invoice_to_vendor_num||'/'||pv_section_type||'/'||pv_section_code||'/'||rec_tax.tax_type||'/'||ln_tax_id_new||'/'||ln_tax_rate,
7625: p_dist_code_combination_id => r_ja_in_tax_codes.tax_account_id,
7626: p_last_update_date => sysdate,
7627: p_last_updated_by => fnd_global.user_id,
7628: p_last_update_login => fnd_global.login_id,
7629: p_creation_date => sysdate,
7630: p_created_by => fnd_global.user_id
7631: );
7624: p_description => lv_invoice_to_vendor_num||'/'||pv_section_type||'/'||pv_section_code||'/'||rec_tax.tax_type||'/'||ln_tax_id_new||'/'||ln_tax_rate,
7625: p_dist_code_combination_id => r_ja_in_tax_codes.tax_account_id,
7626: p_last_update_date => sysdate,
7627: p_last_updated_by => fnd_global.user_id,
7628: p_last_update_login => fnd_global.login_id,
7629: p_creation_date => sysdate,
7630: p_created_by => fnd_global.user_id
7631: );
7632:
7626: p_last_update_date => sysdate,
7627: p_last_updated_by => fnd_global.user_id,
7628: p_last_update_login => fnd_global.login_id,
7629: p_creation_date => sysdate,
7630: p_created_by => fnd_global.user_id
7631: );
7632:
7633: --ln_vendor_inv_sum_amount := ln_vendor_inv_sum_amount + ln_amt_for_each;
7634:
7800: --r_ap_invoices_all.org_id,
7801: r_ap_invoices_all.org_id,
7802: lv_source_attribute, --rchandan for bug#4428980
7803: /* Ramananda for bug#4560109 during R12 Sanity Testing. Added the WHO columns */
7804: fnd_global.user_id ,
7805: sysdate ,
7806: fnd_global.user_id ,
7807: sysdate ,
7808: fnd_global.login_id
7802: lv_source_attribute, --rchandan for bug#4428980
7803: /* Ramananda for bug#4560109 during R12 Sanity Testing. Added the WHO columns */
7804: fnd_global.user_id ,
7805: sysdate ,
7806: fnd_global.user_id ,
7807: sysdate ,
7808: fnd_global.login_id
7809: );
7810: end if;
7804: fnd_global.user_id ,
7805: sysdate ,
7806: fnd_global.user_id ,
7807: sysdate ,
7808: fnd_global.login_id
7809: );
7810: end if;
7811: end if; /* Only for validate event as done in earlier regime */
7812:
7921: r_ap_invoices_all.invoice_currency_code ,
7922: ln_invoice_to_vendor_amount ,
7923: r_ap_payment_schedules_all.payment_priority ,
7924: r_ap_invoices_all.exchange_rate ,
7925: fnd_global.user_id ,
7926: sysdate ,
7927: fnd_global.user_id ,
7928: sysdate ,
7929: fnd_global.login_id ,
7923: r_ap_payment_schedules_all.payment_priority ,
7924: r_ap_invoices_all.exchange_rate ,
7925: fnd_global.user_id ,
7926: sysdate ,
7927: fnd_global.user_id ,
7928: sysdate ,
7929: fnd_global.login_id ,
7930: decode ( pv_tds_event, 'PREPAYMENT UNAPPLICATION', pn_calc_tax_amount, pn_tax_amount), /*Added decode condition for bug 12965614 */ /*Bug 5751783*/
7931: ln_tds_rnding_factor -- Bug 5722028. Added by csahoo
7925: fnd_global.user_id ,
7926: sysdate ,
7927: fnd_global.user_id ,
7928: sysdate ,
7929: fnd_global.login_id ,
7930: decode ( pv_tds_event, 'PREPAYMENT UNAPPLICATION', pn_calc_tax_amount, pn_tax_amount), /*Added decode condition for bug 12965614 */ /*Bug 5751783*/
7931: ln_tds_rnding_factor -- Bug 5722028. Added by csahoo
7932: ,decode(pv_section_type, G_TDS_SECTION, pv_section_code, NULL) --Update by Chong, not populate TDS section code for WCT/ESSI section.
7933: --,pv_section_code --Add by zhiwei hou on 20120111
8049: 'N',
8050: 'N',
8051: 'N',
8052: 1000,
8053: fnd_global.user_id,
8054: fnd_global.login_id
8055: );
8056:
8057: Comment for bug#15915537 TDS Performance ER on 26-Nov-2012 by Qimeng end*/
8050: 'N',
8051: 'N',
8052: 1000,
8053: fnd_global.user_id,
8054: fnd_global.login_id
8055: );
8056:
8057: Comment for bug#15915537 TDS Performance ER on 26-Nov-2012 by Qimeng end*/
8058:
8084: 'N',
8085: 'N',
8086: 'N',
8087: 1000,
8088: fnd_global.user_id,
8089: fnd_global.login_id
8090: );
8091: --Added for eTDS end by Chong
8092:
8085: 'N',
8086: 'N',
8087: 1000,
8088: fnd_global.user_id,
8089: fnd_global.login_id
8090: );
8091: --Added for eTDS end by Chong
8092:
8093:
8297:
8298: fnd_file.put_line(FND_FILE.LOG, ' Check for the TDS authority invoice ');
8299:
8300: /*Added by nprashar for bug # 6720018*/
8301: IF (FND_GLOBAL.CONC_REQUEST_ID is NULL) THEN
8302: lv_conc_flag := 'N';
8303: ELSE
8304: lv_conc_flag := 'Y';
8305: END IF;
8355: p_pay_group => NULL,
8356: p_invoice_id => cur_rec.invoice_to_tds_authority_id,
8357: p_entered_by => NULL,
8358: p_debug_switch => 'N',
8359: p_conc_request_id => FND_GLOBAL.CONC_REQUEST_ID,
8360: p_commit_size => 1000,
8361: p_org_id => ln_org_id,
8362: p_report_holds_count => ln_holds_count
8363: ) THEN
8428: p_pay_group => NULL,
8429: p_invoice_id => cur_rec.invoice_to_vendor_id,
8430: p_entered_by => NULL,
8431: p_debug_switch => 'N',
8432: p_conc_request_id => FND_GLOBAL.CONC_REQUEST_ID,
8433: p_commit_size => 1000,
8434: p_org_id => ln_org_id,
8435: p_report_holds_count => ln_holds_count1
8436: ) THEN
8676: p_invoice_vendor_amt ,
8677: p_invoice_vendor_id ,
8678: p_parent_inv_payment_priority ,
8679: p_parent_inv_exchange_rate ,
8680: fnd_global.user_id ,
8681: sysdate ,
8682: fnd_global.user_id ,
8683: sysdate ,
8684: fnd_global.login_id
8678: p_parent_inv_payment_priority ,
8679: p_parent_inv_exchange_rate ,
8680: fnd_global.user_id ,
8681: sysdate ,
8682: fnd_global.user_id ,
8683: sysdate ,
8684: fnd_global.login_id
8685: );
8686:
8680: fnd_global.user_id ,
8681: sysdate ,
8682: fnd_global.user_id ,
8683: sysdate ,
8684: fnd_global.login_id
8685: );
8686:
8687: fnd_file.put_line(FND_FILE.LOG, ' Done Insert -> insert_tds_thhold_trxs ');
8688: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.END', G_PKG_NAME || ': '||l_api_name||'()-');
9865:
9866: mo_global.set_policy_context('S', r_ap_invoices_all_au.org_id);
9867:
9868: lb_return_value := ap_cancel_pkg.ap_cancel_single_invoice(P_invoice_id => cur_rec.invoice_to_tds_authority_id,
9869: P_last_updated_by => fnd_global.user_id,
9870: P_last_update_login => fnd_global.login_id,
9871: P_accounting_date => ld_accounting_date,
9872: P_message_name => lv_out_message_name,
9873: P_invoice_amount => ln_out_invoice_amount,
9866: mo_global.set_policy_context('S', r_ap_invoices_all_au.org_id);
9867:
9868: lb_return_value := ap_cancel_pkg.ap_cancel_single_invoice(P_invoice_id => cur_rec.invoice_to_tds_authority_id,
9869: P_last_updated_by => fnd_global.user_id,
9870: P_last_update_login => fnd_global.login_id,
9871: P_accounting_date => ld_accounting_date,
9872: P_message_name => lv_out_message_name,
9873: P_invoice_amount => ln_out_invoice_amount,
9874: P_base_amount => ln_out_base_amount,
9997:
9998: mo_global.set_policy_context('S', r_ap_invoices_all_cm.org_id);
9999:
10000: lb_return_value := ap_cancel_pkg.ap_cancel_single_invoice(P_invoice_id => r_ap_invoices_all_cm.invoice_id,
10001: P_last_updated_by => fnd_global.user_id,
10002: P_last_update_login => fnd_global.login_id,
10003: P_accounting_date => ld_accounting_date,
10004: P_message_name => lv_out_message_name,
10005: P_invoice_amount => ln_out_invoice_amount,
9998: mo_global.set_policy_context('S', r_ap_invoices_all_cm.org_id);
9999:
10000: lb_return_value := ap_cancel_pkg.ap_cancel_single_invoice(P_invoice_id => r_ap_invoices_all_cm.invoice_id,
10001: P_last_updated_by => fnd_global.user_id,
10002: P_last_update_login => fnd_global.login_id,
10003: P_accounting_date => ld_accounting_date,
10004: P_message_name => lv_out_message_name,
10005: P_invoice_amount => ln_out_invoice_amount,
10006: P_base_amount => ln_out_base_amount,
10782: p_exchange_date => null,
10783: p_terms_id => ln_terms_id,
10784: p_description => lv_invoice_to_tds_num,
10785: p_last_update_date => sysdate,
10786: p_last_updated_by => fnd_global.user_id,
10787: p_last_update_login => fnd_global.login_id,
10788: p_creation_date => sysdate,
10789: p_created_by => fnd_global.user_id,
10790: p_source => lv_source,
10783: p_terms_id => ln_terms_id,
10784: p_description => lv_invoice_to_tds_num,
10785: p_last_update_date => sysdate,
10786: p_last_updated_by => fnd_global.user_id,
10787: p_last_update_login => fnd_global.login_id,
10788: p_creation_date => sysdate,
10789: p_created_by => fnd_global.user_id,
10790: p_source => lv_source,
10791: p_voucher_num => lv_invoice_to_tds_num,
10785: p_last_update_date => sysdate,
10786: p_last_updated_by => fnd_global.user_id,
10787: p_last_update_login => fnd_global.login_id,
10788: p_creation_date => sysdate,
10789: p_created_by => fnd_global.user_id,
10790: p_source => lv_source,
10791: p_voucher_num => lv_invoice_to_tds_num,
10792: p_pay_group_lookup_code => lv_pay_group_lookup_code,
10793: p_org_id => r_ap_invoices_all.org_id,
10816: --p_description => lv_invoice_to_tds_num ||'/'||pv_section_type||'/'||pv_section_code||'/'||rec_tax.tax_account_id,
10817: p_description => lv_invoice_to_tds_num ||'/'||pv_section_type||'/'||pv_section_code||'/'||r_ja_in_tax_codes.tax_type||'/'||r_ja_in_tax_codes.tax_id||'/'||r_ja_in_tax_codes.tax_rate,
10818: p_dist_code_combination_id => r_ja_in_tax_codes.tax_account_id, --rec_tax.tax_account_id, --Change by Chong for bug#16414088 20130320
10819: p_last_update_date => sysdate,
10820: p_last_updated_by => fnd_global.user_id,
10821: p_last_update_login => fnd_global.login_id,
10822: p_creation_date => sysdate,
10823: p_created_by => fnd_global.user_id
10824: );
10817: p_description => lv_invoice_to_tds_num ||'/'||pv_section_type||'/'||pv_section_code||'/'||r_ja_in_tax_codes.tax_type||'/'||r_ja_in_tax_codes.tax_id||'/'||r_ja_in_tax_codes.tax_rate,
10818: p_dist_code_combination_id => r_ja_in_tax_codes.tax_account_id, --rec_tax.tax_account_id, --Change by Chong for bug#16414088 20130320
10819: p_last_update_date => sysdate,
10820: p_last_updated_by => fnd_global.user_id,
10821: p_last_update_login => fnd_global.login_id,
10822: p_creation_date => sysdate,
10823: p_created_by => fnd_global.user_id
10824: );
10825:
10819: p_last_update_date => sysdate,
10820: p_last_updated_by => fnd_global.user_id,
10821: p_last_update_login => fnd_global.login_id,
10822: p_creation_date => sysdate,
10823: p_created_by => fnd_global.user_id
10824: );
10825:
10826: --ln_author_inv_sum_amount := ln_author_inv_sum_amount + ln_tax_amt_for_each;
10827: if (ln_count <> 1) then
10886: p_exchange_date => r_ap_invoices_all.exchange_date,
10887: p_terms_id => r_ap_invoices_all.terms_id,
10888: p_description => lv_invoice_to_vendor_num,
10889: p_last_update_date => sysdate,
10890: p_last_updated_by => fnd_global.user_id,
10891: p_last_update_login => fnd_global.login_id,
10892: p_creation_date => sysdate,
10893: p_created_by => fnd_global.user_id,
10894: p_source => lv_source,
10887: p_terms_id => r_ap_invoices_all.terms_id,
10888: p_description => lv_invoice_to_vendor_num,
10889: p_last_update_date => sysdate,
10890: p_last_updated_by => fnd_global.user_id,
10891: p_last_update_login => fnd_global.login_id,
10892: p_creation_date => sysdate,
10893: p_created_by => fnd_global.user_id,
10894: p_source => lv_source,
10895: p_voucher_num => lv_invoice_to_vendor_num,
10889: p_last_update_date => sysdate,
10890: p_last_updated_by => fnd_global.user_id,
10891: p_last_update_login => fnd_global.login_id,
10892: p_creation_date => sysdate,
10893: p_created_by => fnd_global.user_id,
10894: p_source => lv_source,
10895: p_voucher_num => lv_invoice_to_vendor_num,
10896: p_payment_method_code => r_ap_invoices_all.payment_method_code,
10897: p_pay_group_lookup_code => r_ap_invoices_all.pay_group_lookup_code,
10921: --p_description => lv_invoice_to_vendor_num ||'/'||pv_section_type||'/'||pv_section_code||'/'||rec_tax.tax_account_id,
10922: p_description => lv_invoice_to_vendor_num ||'/'||pv_section_type||'/'||pv_section_code||'/'||r_ja_in_tax_codes.tax_type||'/'||r_ja_in_tax_codes.tax_id||'/'||r_ja_in_tax_codes.tax_rate,
10923: p_dist_code_combination_id => r_ja_in_tax_codes.tax_account_id, --rec_tax.tax_account_id, --Change by Chong for bug#16414088 20130320
10924: p_last_update_date => sysdate,
10925: p_last_updated_by => fnd_global.user_id,
10926: p_last_update_login => fnd_global.login_id,
10927: p_creation_date => sysdate,
10928: p_created_by => fnd_global.user_id
10929: );
10922: p_description => lv_invoice_to_vendor_num ||'/'||pv_section_type||'/'||pv_section_code||'/'||r_ja_in_tax_codes.tax_type||'/'||r_ja_in_tax_codes.tax_id||'/'||r_ja_in_tax_codes.tax_rate,
10923: p_dist_code_combination_id => r_ja_in_tax_codes.tax_account_id, --rec_tax.tax_account_id, --Change by Chong for bug#16414088 20130320
10924: p_last_update_date => sysdate,
10925: p_last_updated_by => fnd_global.user_id,
10926: p_last_update_login => fnd_global.login_id,
10927: p_creation_date => sysdate,
10928: p_created_by => fnd_global.user_id
10929: );
10930: --ln_vendor_inv_sum_amount := ln_vendor_inv_sum_amount + ln_amt_for_each;
10924: p_last_update_date => sysdate,
10925: p_last_updated_by => fnd_global.user_id,
10926: p_last_update_login => fnd_global.login_id,
10927: p_creation_date => sysdate,
10928: p_created_by => fnd_global.user_id
10929: );
10930: --ln_vendor_inv_sum_amount := ln_vendor_inv_sum_amount + ln_amt_for_each;
10931:
10932: if (ln_count <> 1) then
11093: r_ap_invoices_all.invoice_currency_code ,
11094: ln_invoice_to_vendor_amount ,
11095: r_ap_payment_schedules_all.payment_priority ,
11096: r_ap_invoices_all.exchange_rate ,
11097: fnd_global.user_id ,
11098: sysdate ,
11099: fnd_global.user_id ,
11100: sysdate ,
11101: fnd_global.login_id ,
11095: r_ap_payment_schedules_all.payment_priority ,
11096: r_ap_invoices_all.exchange_rate ,
11097: fnd_global.user_id ,
11098: sysdate ,
11099: fnd_global.user_id ,
11100: sysdate ,
11101: fnd_global.login_id ,
11102: decode ( pv_tds_event, 'PREPAYMENT UNAPPLICATION', pn_calc_tax_amount, pn_tax_amount), /*Added decode condition for bug 12965614 */ /*Bug 5751783*/
11103: ln_tds_rnding_factor,
11097: fnd_global.user_id ,
11098: sysdate ,
11099: fnd_global.user_id ,
11100: sysdate ,
11101: fnd_global.login_id ,
11102: decode ( pv_tds_event, 'PREPAYMENT UNAPPLICATION', pn_calc_tax_amount, pn_tax_amount), /*Added decode condition for bug 12965614 */ /*Bug 5751783*/
11103: ln_tds_rnding_factor,
11104: pv_section_code
11105: )