DBA Data[Home] [Help]

APPS.INL_TAX_PVT dependencies on FND_GLOBAL

Line 490: fnd_global.user_id , /* 17 */

486: l_tax_ln_tbl(i).currency_conversion_type, /* 13 */
487: l_tax_ln_tbl(i).currency_conversion_date, /* 14 */
488: l_tax_ln_tbl(i).currency_conversion_rate, /* 15 */
489: l_tax_ln_tbl(i).tax_amt_included_flag , /* 16 */
490: fnd_global.user_id , /* 17 */
491: SYSDATE , /* 18 */
492: fnd_global.user_id , /* 19 */
493: SYSDATE , /* 20 */
494: fnd_global.login_id /* 21 */

Line 492: fnd_global.user_id , /* 19 */

488: l_tax_ln_tbl(i).currency_conversion_rate, /* 15 */
489: l_tax_ln_tbl(i).tax_amt_included_flag , /* 16 */
490: fnd_global.user_id , /* 17 */
491: SYSDATE , /* 18 */
492: fnd_global.user_id , /* 19 */
493: SYSDATE , /* 20 */
494: fnd_global.login_id /* 21 */
495: );
496: --Inserting record in INL_ASSOCIATIONS

Line 494: fnd_global.login_id /* 21 */

490: fnd_global.user_id , /* 17 */
491: SYSDATE , /* 18 */
492: fnd_global.user_id , /* 19 */
493: SYSDATE , /* 20 */
494: fnd_global.login_id /* 21 */
495: );
496: --Inserting record in INL_ASSOCIATIONS
497: l_debug_info := 'Inserting record in INL_ASSOCIATIONS';
498: INL_LOGGING_PVT.Log_Statement (

Line 529: fnd_global.user_id , /* 09 */

525: l_tax_ln_tbl(i).to_parent_table_name , /* 05 */
526: l_tax_ln_tbl(i).to_parent_table_id , /* 06 */
527: 'VALUE' , /* 07 */
528: null , /* 08 */
529: fnd_global.user_id , /* 09 */
530: SYSDATE , /* 10 */
531: fnd_global.user_id , /* 11 */
532: SYSDATE , /* 12 */
533: fnd_global.login_id /* 13 */

Line 531: fnd_global.user_id , /* 11 */

527: 'VALUE' , /* 07 */
528: null , /* 08 */
529: fnd_global.user_id , /* 09 */
530: SYSDATE , /* 10 */
531: fnd_global.user_id , /* 11 */
532: SYSDATE , /* 12 */
533: fnd_global.login_id /* 13 */
534: );
535: ELSE

Line 533: fnd_global.login_id /* 13 */

529: fnd_global.user_id , /* 09 */
530: SYSDATE , /* 10 */
531: fnd_global.user_id , /* 11 */
532: SYSDATE , /* 12 */
533: fnd_global.login_id /* 13 */
534: );
535: ELSE
536: --Updating record in INL_TAX_LINES
537: l_debug_info := 'Updating record in INL_TAX_LINES';

Line 551: last_updated_by = fnd_global.user_id ,

547: currency_conversion_type= l_tax_ln_tbl(i).currency_conversion_type,
548: currency_conversion_date= l_tax_ln_tbl(i).currency_conversion_date,
549: currency_conversion_rate= l_tax_ln_tbl(i).currency_conversion_rate,
550: tax_amt_included_flag = l_tax_ln_tbl(i).tax_amt_included_flag ,
551: last_updated_by = fnd_global.user_id ,
552: last_update_date = SYSDATE ,
553: last_update_login = fnd_global.login_id
554: WHERE
555: tax_line_id = l_tax_ln_tbl(i).tax_line_id

Line 553: last_update_login = fnd_global.login_id

549: currency_conversion_rate= l_tax_ln_tbl(i).currency_conversion_rate,
550: tax_amt_included_flag = l_tax_ln_tbl(i).tax_amt_included_flag ,
551: last_updated_by = fnd_global.user_id ,
552: last_update_date = SYSDATE ,
553: last_update_login = fnd_global.login_id
554: WHERE
555: tax_line_id = l_tax_ln_tbl(i).tax_line_id
556: ;
557: END IF;

Line 1579: ,fnd_global.user_id

1575: ,curTax.tax_currency_conversion_type
1576: ,curTax.tax_currency_conversion_date
1577: ,curTax.tax_currency_conversion_rate
1578: ,curTax.tax_amt_included_flag
1579: ,fnd_global.user_id
1580: ,SYSDATE
1581: ,fnd_global.user_id
1582: ,SYSDATE
1583: ,fnd_global.login_id);

Line 1581: ,fnd_global.user_id

1577: ,curTax.tax_currency_conversion_rate
1578: ,curTax.tax_amt_included_flag
1579: ,fnd_global.user_id
1580: ,SYSDATE
1581: ,fnd_global.user_id
1582: ,SYSDATE
1583: ,fnd_global.login_id);
1584: -----------------------------------------------------------------
1585: l_debug_info := 'Step 6b: Persisting zl.tax_code(Associations): '||curTax.tax_code||' zl.tax_line_id:'||curTax.tax_line_id;

Line 1583: ,fnd_global.login_id);

1579: ,fnd_global.user_id
1580: ,SYSDATE
1581: ,fnd_global.user_id
1582: ,SYSDATE
1583: ,fnd_global.login_id);
1584: -----------------------------------------------------------------
1585: l_debug_info := 'Step 6b: Persisting zl.tax_code(Associations): '||curTax.tax_code||' zl.tax_line_id:'||curTax.tax_line_id;
1586: -- logging message
1587: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,

Line 1615: ,fnd_global.user_id /* 09 */

1611: ,curTax.source /* 05 */
1612: ,curTax.trx_line_id /* 06 */
1613: ,l_allocation_basis /* 07 */
1614: ,l_allocation_uom_code /* 08 */
1615: ,fnd_global.user_id /* 09 */
1616: ,SYSDATE /* 10 */
1617: ,fnd_global.user_id /* 11 */
1618: ,SYSDATE /* 12 */
1619: ,fnd_global.login_id); /* 13 */

Line 1617: ,fnd_global.user_id /* 11 */

1613: ,l_allocation_basis /* 07 */
1614: ,l_allocation_uom_code /* 08 */
1615: ,fnd_global.user_id /* 09 */
1616: ,SYSDATE /* 10 */
1617: ,fnd_global.user_id /* 11 */
1618: ,SYSDATE /* 12 */
1619: ,fnd_global.login_id); /* 13 */
1620: END LOOP;
1621: UPDATE inl_ship_lines

Line 1619: ,fnd_global.login_id); /* 13 */

1615: ,fnd_global.user_id /* 09 */
1616: ,SYSDATE /* 10 */
1617: ,fnd_global.user_id /* 11 */
1618: ,SYSDATE /* 12 */
1619: ,fnd_global.login_id); /* 13 */
1620: END LOOP;
1621: UPDATE inl_ship_lines
1622: SET tax_already_calculated_flag = 'Y',
1623: last_updated_by = fnd_global.user_id,

Line 1623: last_updated_by = fnd_global.user_id,

1619: ,fnd_global.login_id); /* 13 */
1620: END LOOP;
1621: UPDATE inl_ship_lines
1622: SET tax_already_calculated_flag = 'Y',
1623: last_updated_by = fnd_global.user_id,
1624: last_update_date = SYSDATE
1625: WHERE ship_header_id = p_ship_header_Id;
1626:
1627: UPDATE inl_charge_lines

Line 1629: last_updated_by = fnd_global.user_id,

1625: WHERE ship_header_id = p_ship_header_Id;
1626:
1627: UPDATE inl_charge_lines
1628: SET tax_already_calculated_flag = 'Y',
1629: last_updated_by = fnd_global.user_id,
1630: last_update_date = SYSDATE
1631: WHERE NVL(parent_charge_line_id,charge_line_id) IN (SELECT assoc.from_parent_table_id
1632: FROM inl_associations assoc
1633: WHERE assoc.from_parent_table_name = 'INL_CHARGE_LINES'