DBA Data[Home] [Help]

APPS.JAI_AP_TDS_GENERATION_PKG dependencies on FND_GLOBAL

Line 1590: p_last_updated_by => fnd_global.user_id,

1586: p_exchange_date => null,
1587: p_terms_id => ln_terms_id,
1588: p_description => lv_invoice_to_tds_num,
1589: p_last_update_date => sysdate,
1590: p_last_updated_by => fnd_global.user_id,
1591: p_last_update_login => fnd_global.login_id,
1592: p_creation_date => sysdate,
1593: p_created_by => fnd_global.user_id,
1594: p_source => lv_source,

Line 1591: p_last_update_login => fnd_global.login_id,

1587: p_terms_id => ln_terms_id,
1588: p_description => lv_invoice_to_tds_num,
1589: p_last_update_date => sysdate,
1590: p_last_updated_by => fnd_global.user_id,
1591: p_last_update_login => fnd_global.login_id,
1592: p_creation_date => sysdate,
1593: p_created_by => fnd_global.user_id,
1594: p_source => lv_source,
1595: p_voucher_num => lv_invoice_to_tds_num,

Line 1593: p_created_by => fnd_global.user_id,

1589: p_last_update_date => sysdate,
1590: p_last_updated_by => fnd_global.user_id,
1591: p_last_update_login => fnd_global.login_id,
1592: p_creation_date => sysdate,
1593: p_created_by => fnd_global.user_id,
1594: p_source => lv_source,
1595: p_voucher_num => lv_invoice_to_tds_num,
1596: --p_payment_method_lookup_code => lv_payment_method_lookup_code,
1597: --commented by Sanjikum for Bug#4482462

Line 1619: p_last_updated_by => fnd_global.user_id,

1615: p_accounting_date => ld_accounting_date,
1616: p_description => lv_invoice_to_tds_num,
1617: p_dist_code_combination_id => r_ja_in_tax_codes.tax_account_id,
1618: p_last_update_date => sysdate,
1619: p_last_updated_by => fnd_global.user_id,
1620: p_last_update_login => fnd_global.login_id,
1621: p_creation_date => sysdate,
1622: p_created_by => fnd_global.user_id
1623: );

Line 1620: p_last_update_login => fnd_global.login_id,

1616: p_description => lv_invoice_to_tds_num,
1617: p_dist_code_combination_id => r_ja_in_tax_codes.tax_account_id,
1618: p_last_update_date => sysdate,
1619: p_last_updated_by => fnd_global.user_id,
1620: p_last_update_login => fnd_global.login_id,
1621: p_creation_date => sysdate,
1622: p_created_by => fnd_global.user_id
1623: );
1624:

Line 1622: p_created_by => fnd_global.user_id

1618: p_last_update_date => sysdate,
1619: p_last_updated_by => fnd_global.user_id,
1620: p_last_update_login => fnd_global.login_id,
1621: p_creation_date => sysdate,
1622: p_created_by => fnd_global.user_id
1623: );
1624:
1625: end if; /* Invoice to TDS authority */
1626:

Line 1688: p_last_updated_by => fnd_global.user_id,

1684: p_exchange_date => r_ap_invoices_all.exchange_date,
1685: p_terms_id => r_ap_invoices_all.terms_id,
1686: p_description => lv_invoice_to_vendor_num,
1687: p_last_update_date => sysdate,
1688: p_last_updated_by => fnd_global.user_id,
1689: p_last_update_login => fnd_global.login_id,
1690: p_creation_date => sysdate,
1691: p_created_by => fnd_global.user_id,
1692: p_source => lv_source,

Line 1689: p_last_update_login => fnd_global.login_id,

1685: p_terms_id => r_ap_invoices_all.terms_id,
1686: p_description => lv_invoice_to_vendor_num,
1687: p_last_update_date => sysdate,
1688: p_last_updated_by => fnd_global.user_id,
1689: p_last_update_login => fnd_global.login_id,
1690: p_creation_date => sysdate,
1691: p_created_by => fnd_global.user_id,
1692: p_source => lv_source,
1693: p_voucher_num => lv_invoice_to_vendor_num,

Line 1691: p_created_by => fnd_global.user_id,

1687: p_last_update_date => sysdate,
1688: p_last_updated_by => fnd_global.user_id,
1689: p_last_update_login => fnd_global.login_id,
1690: p_creation_date => sysdate,
1691: p_created_by => fnd_global.user_id,
1692: p_source => lv_source,
1693: p_voucher_num => lv_invoice_to_vendor_num,
1694: -- Bug 7109056. Added by Lakshmi Gopalsami
1695: p_payment_method_code => r_ap_invoices_all.payment_method_code,

Line 1720: p_last_updated_by => fnd_global.user_id,

1716: p_accounting_date => ld_accounting_date,
1717: p_description => lv_invoice_to_vendor_num,
1718: p_dist_code_combination_id => r_ja_in_tax_codes.tax_account_id,
1719: p_last_update_date => sysdate,
1720: p_last_updated_by => fnd_global.user_id,
1721: p_last_update_login => fnd_global.login_id,
1722: p_creation_date => sysdate,
1723: p_created_by => fnd_global.user_id
1724: );

Line 1721: p_last_update_login => fnd_global.login_id,

1717: p_description => lv_invoice_to_vendor_num,
1718: p_dist_code_combination_id => r_ja_in_tax_codes.tax_account_id,
1719: p_last_update_date => sysdate,
1720: p_last_updated_by => fnd_global.user_id,
1721: p_last_update_login => fnd_global.login_id,
1722: p_creation_date => sysdate,
1723: p_created_by => fnd_global.user_id
1724: );
1725:

Line 1723: p_created_by => fnd_global.user_id

1719: p_last_update_date => sysdate,
1720: p_last_updated_by => fnd_global.user_id,
1721: p_last_update_login => fnd_global.login_id,
1722: p_creation_date => sysdate,
1723: p_created_by => fnd_global.user_id
1724: );
1725:
1726: end if;
1727: end if; /* Invoice to Supplier */

Line 1806: fnd_global.user_id ,

1802: --r_ap_invoices_all.org_id,
1803: r_ap_invoices_all.org_id,
1804: lv_source_attribute, --rchandan for bug#4428980
1805: /* Ramananda for bug#4560109 during R12 Sanity Testing. Added the WHO columns */
1806: fnd_global.user_id ,
1807: sysdate ,
1808: fnd_global.user_id ,
1809: sysdate ,
1810: fnd_global.login_id

Line 1808: fnd_global.user_id ,

1804: lv_source_attribute, --rchandan for bug#4428980
1805: /* Ramananda for bug#4560109 during R12 Sanity Testing. Added the WHO columns */
1806: fnd_global.user_id ,
1807: sysdate ,
1808: fnd_global.user_id ,
1809: sysdate ,
1810: fnd_global.login_id
1811: );
1812: end if;

Line 1810: fnd_global.login_id

1806: fnd_global.user_id ,
1807: sysdate ,
1808: fnd_global.user_id ,
1809: sysdate ,
1810: fnd_global.login_id
1811: );
1812: end if;
1813: end if; /* Only for validate event as done in earlier regime */
1814:

Line 1904: fnd_global.user_id ,

1900: r_ap_invoices_all.invoice_currency_code ,
1901: ln_invoice_to_vendor_amount ,
1902: r_ap_payment_schedules_all.payment_priority ,
1903: r_ap_invoices_all.exchange_rate ,
1904: fnd_global.user_id ,
1905: sysdate ,
1906: fnd_global.user_id ,
1907: sysdate ,
1908: fnd_global.login_id ,

Line 1906: fnd_global.user_id ,

1902: r_ap_payment_schedules_all.payment_priority ,
1903: r_ap_invoices_all.exchange_rate ,
1904: fnd_global.user_id ,
1905: sysdate ,
1906: fnd_global.user_id ,
1907: sysdate ,
1908: fnd_global.login_id ,
1909: ln_tds_rnding_factor -- Bug 5722028. Added by csahoo
1910: )

Line 1908: fnd_global.login_id ,

1904: fnd_global.user_id ,
1905: sysdate ,
1906: fnd_global.user_id ,
1907: sysdate ,
1908: fnd_global.login_id ,
1909: ln_tds_rnding_factor -- Bug 5722028. Added by csahoo
1910: )
1911: returning threshold_trx_id into pn_threshold_trx_id;
1912:

Line 2157: fnd_global.user_id,

2153: 'N',
2154: 'N',
2155: 'N',
2156: 1000,
2157: fnd_global.user_id,
2158: fnd_global.login_id
2159: );
2160:
2161: /* Get vendor and site for the invoice */

Line 2158: fnd_global.login_id

2154: 'N',
2155: 'N',
2156: 1000,
2157: fnd_global.user_id,
2158: fnd_global.login_id
2159: );
2160:
2161: /* Get vendor and site for the invoice */
2162: open c_ap_invoices_all(p_invoice_id);

Line 2328: IF (FND_GLOBAL.CONC_REQUEST_ID is NULL) THEN

2324:
2325: fnd_file.put_line(FND_FILE.LOG, ' Check for the TDS authority invoice ');
2326:
2327: /*Added by nprashar for bug # 6720018*/
2328: IF (FND_GLOBAL.CONC_REQUEST_ID is NULL) THEN
2329: lv_conc_flag := 'N';
2330: ELSE
2331: lv_conc_flag := 'Y';
2332: END IF;

Line 2386: p_conc_request_id => FND_GLOBAL.CONC_REQUEST_ID,

2382: p_pay_group => NULL,
2383: p_invoice_id => cur_rec.invoice_to_tds_authority_id,
2384: p_entered_by => NULL,
2385: p_debug_switch => 'N',
2386: p_conc_request_id => FND_GLOBAL.CONC_REQUEST_ID,
2387: p_commit_size => 1000,
2388: p_org_id => ln_org_id,
2389: p_report_holds_count => ln_holds_count
2390: ) THEN

Line 2459: p_conc_request_id => FND_GLOBAL.CONC_REQUEST_ID,

2455: p_pay_group => NULL,
2456: p_invoice_id => cur_rec.invoice_to_vendor_id,
2457: p_entered_by => NULL,
2458: p_debug_switch => 'N',
2459: p_conc_request_id => FND_GLOBAL.CONC_REQUEST_ID,
2460: p_commit_size => 1000,
2461: p_org_id => ln_org_id,
2462: p_report_holds_count => ln_holds_count1
2463: ) THEN

Line 2745: fnd_global.user_id ,

2741: p_vendor_pan_num ,
2742: p_section_type ,
2743: p_section_code ,
2744: p_fin_year ,
2745: fnd_global.user_id ,
2746: sysdate ,
2747: fnd_global.user_id ,
2748: sysdate ,
2749: fnd_global.login_id

Line 2747: fnd_global.user_id ,

2743: p_section_code ,
2744: p_fin_year ,
2745: fnd_global.user_id ,
2746: sysdate ,
2747: fnd_global.user_id ,
2748: sysdate ,
2749: fnd_global.login_id
2750: )
2751: returning threshold_grp_id into ln_threshold_grp_id;

Line 2749: fnd_global.login_id

2745: fnd_global.user_id ,
2746: sysdate ,
2747: fnd_global.user_id ,
2748: sysdate ,
2749: fnd_global.login_id
2750: )
2751: returning threshold_grp_id into ln_threshold_grp_id;
2752:
2753: p_threshold_grp_id := ln_threshold_grp_id;

Line 2906: fnd_global.user_id ,

2902: p_invoice_id ,
2903: p_invoice_line_number ,
2904: p_invoice_distribution_id ,
2905: p_remarks ,
2906: fnd_global.user_id ,
2907: sysdate ,
2908: fnd_global.user_id ,
2909: sysdate ,
2910: fnd_global.login_id

Line 2908: fnd_global.user_id ,

2904: p_invoice_distribution_id ,
2905: p_remarks ,
2906: fnd_global.user_id ,
2907: sysdate ,
2908: fnd_global.user_id ,
2909: sysdate ,
2910: fnd_global.login_id
2911: )
2912: returning threshold_grp_audit_id into p_threshold_grp_audit_id;

Line 2910: fnd_global.login_id

2906: fnd_global.user_id ,
2907: sysdate ,
2908: fnd_global.user_id ,
2909: sysdate ,
2910: fnd_global.login_id
2911: )
2912: returning threshold_grp_audit_id into p_threshold_grp_audit_id;
2913: p_codepath := jai_general_pkg.plot_codepath(10, p_codepath); /* 10 */
2914: <>

Line 3015: fnd_global.user_id ,

3011: p_invoice_vendor_amt ,
3012: p_invoice_vendor_id ,
3013: p_parent_inv_payment_priority ,
3014: p_parent_inv_exchange_rate ,
3015: fnd_global.user_id ,
3016: sysdate ,
3017: fnd_global.user_id ,
3018: sysdate ,
3019: fnd_global.login_id

Line 3017: fnd_global.user_id ,

3013: p_parent_inv_payment_priority ,
3014: p_parent_inv_exchange_rate ,
3015: fnd_global.user_id ,
3016: sysdate ,
3017: fnd_global.user_id ,
3018: sysdate ,
3019: fnd_global.login_id
3020: );
3021:

Line 3019: fnd_global.login_id

3015: fnd_global.user_id ,
3016: sysdate ,
3017: fnd_global.user_id ,
3018: sysdate ,
3019: fnd_global.login_id
3020: );
3021:
3022: fnd_file.put_line(FND_FILE.LOG, ' Done Insert -> insert_tds_thhold_trxs ');
3023: end insert_tds_thhold_trxs;