DBA Data[Home] [Help]

APPS.JAI_AR_RCTLA_TRIGGER_PKG dependencies on FND_GLOBAL

Line 2175: fnd_global.user_id ,

2171: lv_appl_src, /*'JA_IN_OE_AR_LINES_INSERT_TRG', Ramananda for removal of SQL LITERALs */
2172: lv_err_msg, /* 'Default Location is not setup for Inventory Organization ' || pr_new.warehouse_id , */
2173: lv_addl_msg, /* 'Please setup the Default Location in Organization Additional Information Screen for Trx id : ' || pr_new.customer_trx_id , */
2174: sysdate,
2175: fnd_global.user_id ,
2176: -- added, Harshita for Bug 4866533
2177: fnd_global.user_id,
2178: sysdate
2179: );

Line 2177: fnd_global.user_id,

2173: lv_addl_msg, /* 'Please setup the Default Location in Organization Additional Information Screen for Trx id : ' || pr_new.customer_trx_id , */
2174: sysdate,
2175: fnd_global.user_id ,
2176: -- added, Harshita for Bug 4866533
2177: fnd_global.user_id,
2178: sysdate
2179: );
2180: end if;
2181:

Line 2225: fnd_global.user_id ,

2221: 0 ,
2222: lr_trx_rec.trx_number ,
2223: lr_trx_rec.batch_source_id ,
2224: sysdate ,
2225: fnd_global.user_id ,
2226: sysdate ,
2227: fnd_global.user_id ,
2228: fnd_global.login_id ,
2229: lr_trx_rec.set_of_books_id ,

Line 2227: fnd_global.user_id ,

2223: lr_trx_rec.batch_source_id ,
2224: sysdate ,
2225: fnd_global.user_id ,
2226: sysdate ,
2227: fnd_global.user_id ,
2228: fnd_global.login_id ,
2229: lr_trx_rec.set_of_books_id ,
2230: lr_trx_rec.primary_salesrep_id ,
2231: lr_trx_rec.invoice_currency_code ,

Line 2228: fnd_global.login_id ,

2224: sysdate ,
2225: fnd_global.user_id ,
2226: sysdate ,
2227: fnd_global.user_id ,
2228: fnd_global.login_id ,
2229: lr_trx_rec.set_of_books_id ,
2230: lr_trx_rec.primary_salesrep_id ,
2231: lr_trx_rec.invoice_currency_code ,
2232: lr_trx_rec.exchange_rate_type ,

Line 2337: fnd_global.user_id ,

2333: round(tax_rec.tax_amount,2) ,
2334: round(tax_rec.func_tax_amount,2) ,
2335: round(tax_rec.base_tax_amount,2) ,
2336: sysdate ,
2337: fnd_global.user_id ,
2338: sysdate ,
2339: fnd_global.user_id ,
2340: fnd_global.login_id
2341: );

Line 2339: fnd_global.user_id ,

2335: round(tax_rec.base_tax_amount,2) ,
2336: sysdate ,
2337: fnd_global.user_id ,
2338: sysdate ,
2339: fnd_global.user_id ,
2340: fnd_global.login_id
2341: );
2342: end if; /* end if for tax type not in excise .... */
2343: else /* register association is not bond register , so all taxes can flow */

Line 2340: fnd_global.login_id

2336: sysdate ,
2337: fnd_global.user_id ,
2338: sysdate ,
2339: fnd_global.user_id ,
2340: fnd_global.login_id
2341: );
2342: end if; /* end if for tax type not in excise .... */
2343: else /* register association is not bond register , so all taxes can flow */
2344: /* Date 23/02/2006 by sacsethi for bug 5228046

Line 2397: fnd_global.user_id ,

2393: round(tax_rec.tax_amount,2) ,
2394: round(tax_rec.func_tax_amount,2) ,
2395: round(tax_rec.base_tax_amount,2) ,
2396: sysdate ,
2397: fnd_global.user_id ,
2398: sysdate ,
2399: fnd_global.user_id ,
2400: fnd_global.login_id
2401: );

Line 2399: fnd_global.user_id ,

2395: round(tax_rec.base_tax_amount,2) ,
2396: sysdate ,
2397: fnd_global.user_id ,
2398: sysdate ,
2399: fnd_global.user_id ,
2400: fnd_global.login_id
2401: );
2402:
2403: end if;

Line 2400: fnd_global.login_id

2396: sysdate ,
2397: fnd_global.user_id ,
2398: sysdate ,
2399: fnd_global.user_id ,
2400: fnd_global.login_id
2401: );
2402:
2403: end if;
2404: end loop;

Line 2577: fnd_global.user_id ,

2573: round(nvl(rec_so_lines.line_amount,0) +
2574: nvl(ln_ar_tax_amount,0),2) ,
2575: rec_so_lines.assessable_value ,
2576: sysdate ,
2577: fnd_global.user_id ,
2578: sysdate ,
2579: fnd_global.user_id ,
2580: fnd_global.login_id ,
2581: rec_so_lines.excise_exempt_type ,

Line 2579: fnd_global.user_id ,

2575: rec_so_lines.assessable_value ,
2576: sysdate ,
2577: fnd_global.user_id ,
2578: sysdate ,
2579: fnd_global.user_id ,
2580: fnd_global.login_id ,
2581: rec_so_lines.excise_exempt_type ,
2582: rec_so_lines.excise_exempt_refno ,
2583: rec_so_lines.excise_exempt_date ,

Line 2580: fnd_global.login_id ,

2576: sysdate ,
2577: fnd_global.user_id ,
2578: sysdate ,
2579: fnd_global.user_id ,
2580: fnd_global.login_id ,
2581: rec_so_lines.excise_exempt_type ,
2582: rec_so_lines.excise_exempt_refno ,
2583: rec_so_lines.excise_exempt_date ,
2584: NULL ,

Line 4478: fnd_global.user_id,

4474: substr(vsqlerrm,1,200) ,
4475: sysdate ,
4476: user ,
4477: -- added, Harshita for Bug 4866533
4478: fnd_global.user_id,
4479: sysdate
4480: );
4481:
4482: END ARI_T2 ;

Line 4903: fnd_global.user_id ,

4899: lv_appl_src, /*'JA_IN_OE_AR_LINES_INSERT_TRG', Ramananda for removal of SQL LITERALs */
4900: lv_err_msg, /* 'Default Location is not setup for Inventory Organization ' || pr_new.warehouse_id , */
4901: lv_addl_msg, /* 'Please setup the Default Location in Organization Additional Information Screen for Trx id : ' || pr_new.customer_trx_id , */
4902: sysdate,
4903: fnd_global.user_id ,
4904: -- added, Harshita for Bug 4866533
4905: fnd_global.user_id,
4906: sysdate
4907: );

Line 4905: fnd_global.user_id,

4901: lv_addl_msg, /* 'Please setup the Default Location in Organization Additional Information Screen for Trx id : ' || pr_new.customer_trx_id , */
4902: sysdate,
4903: fnd_global.user_id ,
4904: -- added, Harshita for Bug 4866533
4905: fnd_global.user_id,
4906: sysdate
4907: );
4908: end if;
4909: insert into JAI_AR_TRXS -- bill only invoice

Line 4950: fnd_global.user_id ,

4946: 0 ,
4947: lr_trx_rec.trx_number ,
4948: lr_trx_rec.batch_source_id ,
4949: sysdate ,
4950: fnd_global.user_id ,
4951: sysdate ,
4952: fnd_global.user_id ,
4953: fnd_global.login_id ,
4954: lr_trx_rec.set_of_books_id ,

Line 4952: fnd_global.user_id ,

4948: lr_trx_rec.batch_source_id ,
4949: sysdate ,
4950: fnd_global.user_id ,
4951: sysdate ,
4952: fnd_global.user_id ,
4953: fnd_global.login_id ,
4954: lr_trx_rec.set_of_books_id ,
4955: lr_trx_rec.primary_salesrep_id ,
4956: lr_trx_rec.invoice_currency_code ,

Line 4953: fnd_global.login_id ,

4949: sysdate ,
4950: fnd_global.user_id ,
4951: sysdate ,
4952: fnd_global.user_id ,
4953: fnd_global.login_id ,
4954: lr_trx_rec.set_of_books_id ,
4955: lr_trx_rec.primary_salesrep_id ,
4956: lr_trx_rec.invoice_currency_code ,
4957: lr_trx_rec.exchange_rate_type ,

Line 5061: fnd_global.user_id ,

5057: -round(tax_rec.tax_amount,2) ,
5058: -round(tax_rec.func_tax_amount,2) ,
5059: -round(tax_rec.base_tax_amount,2) ,
5060: sysdate ,
5061: fnd_global.user_id ,
5062: sysdate ,
5063: fnd_global.user_id ,
5064: fnd_global.login_id
5065: );

Line 5063: fnd_global.user_id ,

5059: -round(tax_rec.base_tax_amount,2) ,
5060: sysdate ,
5061: fnd_global.user_id ,
5062: sysdate ,
5063: fnd_global.user_id ,
5064: fnd_global.login_id
5065: );
5066: end if; /* end if for tax type not in excise .... */
5067: else /* register association is not bond register , so all taxes can flow */

Line 5064: fnd_global.login_id

5060: sysdate ,
5061: fnd_global.user_id ,
5062: sysdate ,
5063: fnd_global.user_id ,
5064: fnd_global.login_id
5065: );
5066: end if; /* end if for tax type not in excise .... */
5067: else /* register association is not bond register , so all taxes can flow */
5068: /* Date 23/02/2006 by sacsethi for bug 5228046

Line 5121: fnd_global.user_id ,

5117: -round(tax_rec.tax_amount,2) ,
5118: -round(tax_rec.func_tax_amount,2) ,
5119: -round(tax_rec.base_tax_amount,2) ,
5120: sysdate ,
5121: fnd_global.user_id ,
5122: sysdate ,
5123: fnd_global.user_id ,
5124: fnd_global.login_id
5125: );

Line 5123: fnd_global.user_id ,

5119: -round(tax_rec.base_tax_amount,2) ,
5120: sysdate ,
5121: fnd_global.user_id ,
5122: sysdate ,
5123: fnd_global.user_id ,
5124: fnd_global.login_id
5125: );
5126:
5127: end if;

Line 5124: fnd_global.login_id

5120: sysdate ,
5121: fnd_global.user_id ,
5122: sysdate ,
5123: fnd_global.user_id ,
5124: fnd_global.login_id
5125: );
5126:
5127: end if;
5128: end loop;

Line 5286: fnd_global.user_id ,

5282: nvl(ln_ar_tax_amount,0),
5283: NVL(pr_new.quantity_credited * pr_new.unit_selling_price, nvl(pr_new.extended_amount,0)) + nvl(ln_ar_tax_amount,0) ,
5284: rec_so_lines.assessable_value ,
5285: sysdate ,
5286: fnd_global.user_id ,
5287: sysdate ,
5288: fnd_global.user_id ,
5289: fnd_global.login_id ,
5290: rec_so_lines.service_type_code

Line 5288: fnd_global.user_id ,

5284: rec_so_lines.assessable_value ,
5285: sysdate ,
5286: fnd_global.user_id ,
5287: sysdate ,
5288: fnd_global.user_id ,
5289: fnd_global.login_id ,
5290: rec_so_lines.service_type_code
5291: );
5292:

Line 5289: fnd_global.login_id ,

5285: sysdate ,
5286: fnd_global.user_id ,
5287: sysdate ,
5288: fnd_global.user_id ,
5289: fnd_global.login_id ,
5290: rec_so_lines.service_type_code
5291: );
5292:
5293: open c_get_amounts;

Line 6981: fnd_global.user_id,

6977: lv_add_err, /* 'CUSTOMER_TRX_ID = ' || TO_CHAR(pr_new.CUSTOMER_TRX_ID) || ' CUSTOMER_TRX_LINE_ID = ' || TO_CHAR(pr_new.CUSTOMER_TRX_LINE_ID) , */
6978: sysdate,
6979: user ,
6980: -- added, Harshita for Bug 4866533
6981: fnd_global.user_id,
6982: sysdate
6983: );
6984:
6985: END ARIU_T1 ;