DBA Data[Home] [Help]

APPS.PO_TAX_INTERFACE_PVT dependencies on FND_GLOBAL

Line 853: last_updated_by = fnd_global.user_id,

849: PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE
850: AND zxdist.trx_id = pd.po_release_id))),
851: --Bug 10305728 start
852: last_update_date = sysdate,
853: last_updated_by = fnd_global.user_id,
854: last_update_login = fnd_global.login_id
855: --Bug 10305728 end
856: WHERE pd.po_distribution_id IN
857: (SELECT trx_line_dist_id FROM zx_itm_distributions_gt);

Line 854: last_update_login = fnd_global.login_id

850: AND zxdist.trx_id = pd.po_release_id))),
851: --Bug 10305728 start
852: last_update_date = sysdate,
853: last_updated_by = fnd_global.user_id,
854: last_update_login = fnd_global.login_id
855: --Bug 10305728 end
856: WHERE pd.po_distribution_id IN
857: (SELECT trx_line_dist_id FROM zx_itm_distributions_gt);
858:

Line 1987: last_updated_by = fnd_global.user_id,

1983: AND zxdist.entity_code = PO_CONSTANTS_SV.PO_ENTITY_CODE
1984: AND zxdist.event_class_code = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE),
1985: --Bug 10305728 start
1986: last_update_date = sysdate,
1987: last_updated_by = fnd_global.user_id,
1988: last_update_login = fnd_global.login_id
1989: --Bug 10305728 end
1990: WHERE pd.po_distribution_id IN
1991: (SELECT trx_line_dist_id FROM zx_itm_distributions_gt);

Line 1988: last_update_login = fnd_global.login_id

1984: AND zxdist.event_class_code = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE),
1985: --Bug 10305728 start
1986: last_update_date = sysdate,
1987: last_updated_by = fnd_global.user_id,
1988: last_update_login = fnd_global.login_id
1989: --Bug 10305728 end
1990: WHERE pd.po_distribution_id IN
1991: (SELECT trx_line_dist_id FROM zx_itm_distributions_gt);
1992:

Line 2012: last_updated_by = fnd_global.user_id,

2008: ),
2009: --Bug 10305728 start
2010: tax_attribute_update_code = null,
2011: last_update_date = sysdate,
2012: last_updated_by = fnd_global.user_id,
2013: last_update_login = fnd_global.login_id
2014: --Bug 10305728 end
2015: WHERE
2016: pll.line_location_id IN (SELECT line_location_id FROM po_distributions_all pd,zx_itm_distributions_gt zi WHERE pd.po_distribution_id=zi.trx_line_dist_id);

Line 2013: last_update_login = fnd_global.login_id

2009: --Bug 10305728 start
2010: tax_attribute_update_code = null,
2011: last_update_date = sysdate,
2012: last_updated_by = fnd_global.user_id,
2013: last_update_login = fnd_global.login_id
2014: --Bug 10305728 end
2015: WHERE
2016: pll.line_location_id IN (SELECT line_location_id FROM po_distributions_all pd,zx_itm_distributions_gt zi WHERE pd.po_distribution_id=zi.trx_line_dist_id);
2017: /* Bug 6157632 End */

Line 2025: last_updated_by = fnd_global.user_id,

2021: UPDATE po_distributions_all
2022: SET tax_attribute_update_code = null,
2023: --Bug 10305728 start
2024: last_update_date = sysdate,
2025: last_updated_by = fnd_global.user_id,
2026: last_update_login = fnd_global.login_id
2027: --Bug 10305728 end
2028: WHERE po_distribution_id IN (SELECT trx_line_dist_id
2029: FROM zx_itm_distributions_gt);

Line 2026: last_update_login = fnd_global.login_id

2022: SET tax_attribute_update_code = null,
2023: --Bug 10305728 start
2024: last_update_date = sysdate,
2025: last_updated_by = fnd_global.user_id,
2026: last_update_login = fnd_global.login_id
2027: --Bug 10305728 end
2028: WHERE po_distribution_id IN (SELECT trx_line_dist_id
2029: FROM zx_itm_distributions_gt);
2030:

Line 2986: FND_GLOBAL.session_id)

2982: ,zxldet.document_sub_type --document_sub_type
2983: ,zxldet.default_taxation_country --default_taxation_country
2984: ,DECODE(p_calling_program, --icx_session_id
2985: 'DETERMINE_RECOVERY_REQ', null,
2986: FND_GLOBAL.session_id)
2987: FROM po_requisition_headers_all prh, zx_lines_det_factors zxldet
2988: WHERE prh.requisition_header_id = p_requisition_header_id
2989: -- Conditions for getting Additional Tax Attributes
2990: -- Note that the req_header_id is of current document being processed,