eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_EXCEPTION_ENGINE_PKG dependencies on PA_PERF_TRANSACTIONS

Line 29: l_perf_txn_set_id pa_perf_transactions.perf_txn_id%TYPE;

25: p_perf_txn_set_id IN VARCHAR2 DEFAULT 'N') IS
26:
27: l_project_list PA_PLSQL_DATATYPES.IdTabTyp;
28: l_bz_event_code pa_perf_bz_measures.bz_event_code%TYPE;
29: l_perf_txn_set_id pa_perf_transactions.perf_txn_id%TYPE;
30: l_proj NUMBER;
31: l_no_params_err_msg VARCHAR2(2000);
32:
33: /* This cursor is for perf_txn_set_id is not null

Line 316: l_period_name pa_perf_transactions.period_name%TYPE;

312: l_rule_id pa_perf_object_rules.rule_id%TYPE;
313: l_object_type pa_perf_object_rules.object_type%TYPE;
314: l_period_type pa_perf_rules.period_type%TYPE;
315: l_currency_type pa_perf_rules.currency_type%TYPE;
316: l_period_name pa_perf_transactions.period_name%TYPE;
317:
318: l_object_list PA_PLSQL_DATATYPES.IdTabTyp;
319: l_rule_list PA_PLSQL_DATATYPES.IdTabTyp;
320: l_measure_list PA_PLSQL_DATATYPES.IdTabTyp;

Line 550: UPDATE pa_perf_transactions

546: END IF;
547: -- Since there are no performance rules associated to the project there should not be
548: -- any current transaction record for the project. So marking all the transaction for the
549: -- project as History
550: UPDATE pa_perf_transactions
551: SET current_flag = 'N'
552: WHERE perf_txn_obj_type = 'PA_PROJECTS'
553: AND perf_txn_obj_id = p_project_list(i)
554: AND current_flag = 'Y';

Line 687: UPDATE pa_perf_transactions

683: /* Marking the transaction to be not current */
684: -- IF business event is not passed in, mark to be not current all
685: -- the transaction for a given project
686: IF p_business_event_code = 'N' THEN
687: UPDATE pa_perf_transactions
688: SET current_flag = 'N'
689: -- WHERE project_id = l_object_list(i) --Modified for Bug 3639490
690: WHERE perf_txn_obj_type = 'PA_PROJECTS'
691: AND perf_txn_obj_id = l_object_list(i)

Line 700: FROM pa_perf_transactions

696: ELSE
697: --Check if there are records to be updated
698: SELECT count(*) INTO l_count FROM dual where EXISTS
699: (SELECT project_id
700: FROM pa_perf_transactions
701: --WHERE project_id = l_object_list(i) --Modified for Bug3639490
702: WHERE perf_txn_obj_type = 'PA_PROJECTS'
703: AND perf_txn_obj_id = l_object_list(i)
704: AND measure_id in (SELECT measure_id

Line 711: UPDATE pa_perf_transactions

707: AND current_flag = 'Y');
708: IF l_count = 0 THEN
709: null;
710: ELSE
711: UPDATE pa_perf_transactions
712: SET current_flag = 'N'
713: --WHERE project_id = l_object_list(i) --Modified for bug 3639490
714: WHERE perf_txn_obj_type = 'PA_PROJECTS'
715: AND perf_txn_obj_id = l_object_list(i)

Line 915: -- inserting the record into pa_perf_transactions table ELSE do nothing

911: pa_debug.write_file('LOG','Get Threshold for Measure Value : '||l_measure_value);
912: END IF;
913: -- Check whether the measure value is between the threshold from
914: -- and threshold to. If l_retcode = 1 then there is a match . . hence
915: -- inserting the record into pa_perf_transactions table ELSE do nothing
916: PA_EXCEPTION_ENGINE_PKG.GET_THRESHOLD(
917: l_rule_list(k)
918: ,l_rule_type
919: ,l_measure_value

Line 932: -- Insert new record into PA_PERF_TRANSACTIONS table

928:
929: IF l_retcode = '0' THEN
930: pa_debug.write_file('LOG','No matching threshold');
931: ELSE
932: -- Insert new record into PA_PERF_TRANSACTIONS table
933: IF P_PA_DEBUG_MODE = 'Y' THEN
934: pa_debug.write_file('LOG','Inserting record into PA_PERF_TRANSACTIONS');
935: END IF;
936: INSERT INTO pa_perf_transactions

Line 934: pa_debug.write_file('LOG','Inserting record into PA_PERF_TRANSACTIONS');

930: pa_debug.write_file('LOG','No matching threshold');
931: ELSE
932: -- Insert new record into PA_PERF_TRANSACTIONS table
933: IF P_PA_DEBUG_MODE = 'Y' THEN
934: pa_debug.write_file('LOG','Inserting record into PA_PERF_TRANSACTIONS');
935: END IF;
936: INSERT INTO pa_perf_transactions
937: ( perf_txn_id
938: ,perf_txn_obj_type

Line 936: INSERT INTO pa_perf_transactions

932: -- Insert new record into PA_PERF_TRANSACTIONS table
933: IF P_PA_DEBUG_MODE = 'Y' THEN
934: pa_debug.write_file('LOG','Inserting record into PA_PERF_TRANSACTIONS');
935: END IF;
936: INSERT INTO pa_perf_transactions
937: ( perf_txn_id
938: ,perf_txn_obj_type
939: ,perf_txn_obj_id
940: ,object_rule_id

Line 969: VALUES ( pa_perf_transactions_s1.nextval

965: ,last_update_date
966: ,last_updated_by
967: ,last_update_login
968: )
969: VALUES ( pa_perf_transactions_s1.nextval
970: ,'PA_PROJECTS'
971: ,l_object_list(i)
972: ,l_object_rule_id
973: ,null

Line 1011: PA_DEBUG.write_file('LOG', 'End of Step 3 . . Inserting into PA_PERF_TRANSACTIONS table');

1007: END LOOP; --end loop for l_object_list
1008: END IF; --end if for l_object_list.count is 0
1009:
1010: IF P_PA_DEBUG_MODE = 'Y' THEN
1011: PA_DEBUG.write_file('LOG', 'End of Step 3 . . Inserting into PA_PERF_TRANSACTIONS table');
1012: END IF;
1013: -- End of Step 3 --
1014:
1015: -- Remove the data in temp table

Line 1183: -- PA_PERF_TRANSACTIONS table.

1179: END generate_notification;
1180:
1181: -- Procedure purge_transaction
1182: -- Purpose This procedure will call logic to cleanup data in the
1183: -- PA_PERF_TRANSACTIONS table.
1184:
1185: PROCEDURE purge_transaction( p_project_list IN PA_PLSQL_DATATYPES.IdTabTyp,
1186: p_days_old IN NUMBER,
1187: x_errbuf OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 1215: FROM pa_perf_transactions

1211:
1212: /*** clean up the comments transaction table based on project_id and purge_date ***/
1213: DELETE from pa_perf_comments
1214: WHERE perf_txn_id in (SELECT perf_txn_id
1215: FROM pa_perf_transactions
1216: WHERE perf_txn_obj_type = 'PA_PROJECTS'
1217: AND perf_txn_obj_id = p_project_list(i)
1218: AND trunc(creation_date) < trunc(sysdate - p_days_old)
1219: AND current_flag = 'N');

Line 1224: FROM pa_perf_transactions

1220:
1221: /*** clean up the the KPA Scoring Summary ***/
1222: DELETE from pa_perf_kpa_trans
1223: WHERE perf_txn_id in (SELECT perf_txn_id
1224: FROM pa_perf_transactions
1225: WHERE perf_txn_obj_type = 'PA_PROJECTS'
1226: AND perf_txn_obj_id = p_project_list(i)
1227: AND trunc(creation_date) < trunc(sysdate - p_days_old)
1228: AND current_flag = 'N');

Line 1248: DELETE from pa_perf_transactions

1244: AND trunc(creation_date) < trunc(sysdate - p_days_old)
1245: AND current_flag = 'N';
1246:
1247: /*** clean up the transaction table based on project_id and purge_date ***/
1248: DELETE from pa_perf_transactions
1249: WHERE perf_txn_obj_type = 'PA_PROJECTS'
1250: AND perf_txn_obj_id = p_project_list(i)
1251: AND trunc(creation_date) < trunc(sysdate - p_days_old)
1252: AND current_flag = 'N';

Line 1430: from pa_perf_transactions ppem ,

1426: CURSOR get_kpa_score_rule (l_proj_id IN number, l_kpa_code IN varchar2)
1427: IS
1428: select Nvl(sum(ppem.weighting), 0),
1429: MIN (ppor.rule_id), COUNT(ppem.perf_txn_id)
1430: from pa_perf_transactions ppem ,
1431: pa_perf_rules ppr, pa_perf_object_rules ppor
1432: where ppem.current_flag = 'Y'
1433: and ppem.perf_txn_obj_type = 'PA_PROJECTS'
1434: and ppem.perf_txn_obj_id = l_proj_id

Line 1453: from pa_perf_transactions ppem ,

1449: IS
1450: select
1451: COUNT(ppem.perf_txn_id),
1452: Nvl(sum(ppem.weighting), 0)
1453: from pa_perf_transactions ppem ,
1454: pa_perf_rules ppr, pa_perf_object_rules ppor
1455: where ppem.current_flag = 'Y'
1456: and ppem.perf_txn_obj_type = 'PA_PROJECTS'
1457: and ppem.perf_txn_obj_id = l_proj_id

Line 1776: FROM pa_perf_transactions

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)
1780: AND current_flag = 'Y'

Line 1786: UPDATE pa_perf_transactions

1782: ;
1783:
1784: --- update the transaction to be as included in the last scoring
1785:
1786: UPDATE pa_perf_transactions
1787: SET included_in_scoring = 'Y'
1788: WHERE perf_txn_obj_type = 'PA_PROJECTS'
1789: AND perf_txn_obj_id = p_project_list(i)
1790: AND kpa_code = l_kpas(j)

Line 1904: FROM pa_perf_transactions

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)
1908: AND current_flag = 'Y'

Line 1914: UPDATE pa_perf_transactions

1910: ;
1911:
1912: --- update the transaction to be as included in the last scoring
1913:
1914: UPDATE pa_perf_transactions
1915: SET included_in_scoring = 'Y'
1916: WHERE perf_txn_obj_type = 'PA_PROJECTS'
1917: AND perf_txn_obj_id = p_project_list(i)
1918: AND kpa_code = l_kpas(j)

Line 2044: UPDATE pa_perf_transactions

2040:
2041: );
2042:
2043: --- update the included in scoring flag for all other transactions
2044: UPDATE pa_perf_transactions
2045: SET included_in_scoring = 'N'
2046: WHERE perf_txn_obj_type = 'PA_PROJECTS'
2047: AND perf_txn_obj_id = p_project_list(i)
2048: AND Nvl(exception_flag, 'Y') = 'Y'