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'
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: );
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
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
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: );
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:
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:
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:
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:
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
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
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)
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)
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: );
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
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
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
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)
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)
2032: l_summary_table(5).score,
2033: l_summary_table(5).thres_from,
2034: l_summary_table(5).thres_to,
2035: Sysdate,
2036: fnd_global.user_id,
2037: Sysdate,
2038: fnd_global.user_id,
2039: fnd_global.login_id
2040:
2034: l_summary_table(5).thres_to,
2035: Sysdate,
2036: fnd_global.user_id,
2037: Sysdate,
2038: fnd_global.user_id,
2039: fnd_global.login_id
2040:
2041: );
2042:
2035: Sysdate,
2036: fnd_global.user_id,
2037: Sysdate,
2038: fnd_global.user_id,
2039: fnd_global.login_id
2040:
2041: );
2042:
2043: --- update the included in scoring flag for all other transactions