DBA Data[Home] [Help]

APPS.PA_EXCEPTION_ENGINE_PKG dependencies on FND_GLOBAL

Line 989: ,fnd_global.CONC_REQUEST_ID

985: ,l_precision
986: ,l_period_type
987: ,l_currency_type
988: ,l_measure_format
989: ,fnd_global.CONC_REQUEST_ID
990: ,sysdate
991: ,l_exception_flag
992: ,'Y'
993: ,'N'

Line 996: ,fnd_global.user_id

992: ,'Y'
993: ,'N'
994: ,1
995: ,sysdate
996: ,fnd_global.user_id
997: ,sysdate
998: ,fnd_global.user_id
999: ,fnd_global.login_id
1000: );

Line 998: ,fnd_global.user_id

994: ,1
995: ,sysdate
996: ,fnd_global.user_id
997: ,sysdate
998: ,fnd_global.user_id
999: ,fnd_global.login_id
1000: );
1001: END IF; --end if of l_retcode = 0
1002: END LOOP; --end loop for l_rule_list from temp table

Line 999: ,fnd_global.login_id

995: ,sysdate
996: ,fnd_global.user_id
997: ,sysdate
998: ,fnd_global.user_id
999: ,fnd_global.login_id
1000: );
1001: END IF; --end if of l_retcode = 0
1002: END LOOP; --end loop for l_rule_list from temp table
1003: END LOOP; --end loop for l_measure_list

Line 1643: fnd_global.user_id,

1639: 0,
1640: 0,
1641: 0,
1642: Sysdate,
1643: fnd_global.user_id,
1644: Sysdate,
1645: fnd_global.user_id,
1646: fnd_global.login_id
1647: );

Line 1645: fnd_global.user_id,

1641: 0,
1642: Sysdate,
1643: fnd_global.user_id,
1644: Sysdate,
1645: fnd_global.user_id,
1646: fnd_global.login_id
1647: );
1648: END IF;
1649:

Line 1646: fnd_global.login_id

1642: Sysdate,
1643: fnd_global.user_id,
1644: Sysdate,
1645: fnd_global.user_id,
1646: fnd_global.login_id
1647: );
1648: END IF;
1649:
1650:

Line 1751: fnd_global.user_id,

1747: l_score_list(4),
1748: l_count_list(5),
1749: l_score_list(5),
1750: Sysdate,
1751: fnd_global.user_id,
1752: Sysdate,
1753: fnd_global.user_id,
1754: fnd_global.login_id
1755:

Line 1753: fnd_global.user_id,

1749: l_score_list(5),
1750: Sysdate,
1751: fnd_global.user_id,
1752: Sysdate,
1753: fnd_global.user_id,
1754: fnd_global.login_id
1755:
1756: );
1757:

Line 1754: fnd_global.login_id

1750: Sysdate,
1751: fnd_global.user_id,
1752: Sysdate,
1753: fnd_global.user_id,
1754: fnd_global.login_id
1755:
1756: );
1757:
1758: --- save the result to PA_PERF_KPA_TRANS table

Line 1772: fnd_global.user_id,

1768: last_update_date,
1769: last_updated_by ,
1770: last_update_login)
1771: SELECT l_summary_det_seq,perf_txn_id, Sysdate,
1772: fnd_global.user_id,
1773: Sysdate,
1774: fnd_global.user_id,
1775: fnd_global.login_id
1776: FROM pa_perf_transactions

Line 1774: fnd_global.user_id,

1770: last_update_login)
1771: SELECT l_summary_det_seq,perf_txn_id, Sysdate,
1772: fnd_global.user_id,
1773: Sysdate,
1774: fnd_global.user_id,
1775: fnd_global.login_id
1776: FROM pa_perf_transactions
1777: WHERE perf_txn_obj_type = 'PA_PROJECTS'
1778: AND perf_txn_obj_id = p_project_list(i)

Line 1775: fnd_global.login_id

1771: SELECT l_summary_det_seq,perf_txn_id, Sysdate,
1772: fnd_global.user_id,
1773: Sysdate,
1774: fnd_global.user_id,
1775: fnd_global.login_id
1776: FROM pa_perf_transactions
1777: WHERE perf_txn_obj_type = 'PA_PROJECTS'
1778: AND perf_txn_obj_id = p_project_list(i)
1779: AND kpa_code = l_kpas(j)

Line 1884: fnd_global.user_id,

1880: l_score_list(4),
1881: l_count_list(5),
1882: l_score_list(5),
1883: Sysdate,
1884: fnd_global.user_id,
1885: Sysdate,
1886: fnd_global.user_id,
1887: fnd_global.login_id
1888: );

Line 1886: fnd_global.user_id,

1882: l_score_list(5),
1883: Sysdate,
1884: fnd_global.user_id,
1885: Sysdate,
1886: fnd_global.user_id,
1887: fnd_global.login_id
1888: );
1889:
1890: --- save the result to PA_PERF_KPA_TRANS table

Line 1887: fnd_global.login_id

1883: Sysdate,
1884: fnd_global.user_id,
1885: Sysdate,
1886: fnd_global.user_id,
1887: fnd_global.login_id
1888: );
1889:
1890: --- save the result to PA_PERF_KPA_TRANS table
1891: INSERT INTO pa_perf_kpa_trans

Line 1900: fnd_global.user_id,

1896: last_update_date,
1897: last_updated_by ,
1898: last_update_login)
1899: SELECT l_summary_det_seq,perf_txn_id, Sysdate,
1900: fnd_global.user_id,
1901: Sysdate,
1902: fnd_global.user_id,
1903: fnd_global.login_id
1904: FROM pa_perf_transactions

Line 1902: fnd_global.user_id,

1898: last_update_login)
1899: SELECT l_summary_det_seq,perf_txn_id, Sysdate,
1900: fnd_global.user_id,
1901: Sysdate,
1902: fnd_global.user_id,
1903: fnd_global.login_id
1904: FROM pa_perf_transactions
1905: WHERE perf_txn_obj_type = 'PA_PROJECTS'
1906: AND perf_txn_obj_id = p_project_list(i)

Line 1903: fnd_global.login_id

1899: SELECT l_summary_det_seq,perf_txn_id, Sysdate,
1900: fnd_global.user_id,
1901: Sysdate,
1902: fnd_global.user_id,
1903: fnd_global.login_id
1904: FROM pa_perf_transactions
1905: WHERE perf_txn_obj_type = 'PA_PROJECTS'
1906: AND perf_txn_obj_id = p_project_list(i)
1907: AND kpa_code = l_kpas(j)

Line 2026: fnd_global.user_id,

2022: l_summary_table(5).score,
2023: l_summary_table(5).thres_from,
2024: l_summary_table(5).thres_to,
2025: Sysdate,
2026: fnd_global.user_id,
2027: Sysdate,
2028: fnd_global.user_id,
2029: fnd_global.login_id
2030:

Line 2028: fnd_global.user_id,

2024: l_summary_table(5).thres_to,
2025: Sysdate,
2026: fnd_global.user_id,
2027: Sysdate,
2028: fnd_global.user_id,
2029: fnd_global.login_id
2030:
2031: );
2032:

Line 2029: fnd_global.login_id

2025: Sysdate,
2026: fnd_global.user_id,
2027: Sysdate,
2028: fnd_global.user_id,
2029: fnd_global.login_id
2030:
2031: );
2032:
2033: --- update the included in scoring flag for all other transactions