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.HR_COMP_OUTCOME_PROFILE_SS dependencies on HR_API

Line 38: from hr_api_transaction_values

34: from per_comp_element_outcomes
35: where comp_element_outcome_id = p_comp_element_outcome_id;
36: cursor get_mode(p_transaction_step_id in number) is
37: select varchar2_value
38: from hr_api_transaction_values
39: where transaction_step_id = p_transaction_step_id and name = 'P_CHANGE_MODE';
40: --
41: --
42: -- ------------------------------------------------------------------------

Line 419: ,p_item_type IN hr_api_transaction_steps.item_type%type

415: p_validate in boolean default false
416: ,p_competence_element_id IN number
417: ,p_new_competence_element_id IN number
418: ,p_competence_id IN number
419: ,p_item_type IN hr_api_transaction_steps.item_type%type
420: ,p_item_key IN hr_api_transaction_steps.item_key%type
421: ,p_activity_id IN hr_api_transaction_steps.ACTIVITY_ID%type
422: ,p_person_id IN Number
423: ,p_effective_date IN Date DEFAULT trunc(sysdate)) is

Line 420: ,p_item_key IN hr_api_transaction_steps.item_key%type

416: ,p_competence_element_id IN number
417: ,p_new_competence_element_id IN number
418: ,p_competence_id IN number
419: ,p_item_type IN hr_api_transaction_steps.item_type%type
420: ,p_item_key IN hr_api_transaction_steps.item_key%type
421: ,p_activity_id IN hr_api_transaction_steps.ACTIVITY_ID%type
422: ,p_person_id IN Number
423: ,p_effective_date IN Date DEFAULT trunc(sysdate)) is
424: --

Line 421: ,p_activity_id IN hr_api_transaction_steps.ACTIVITY_ID%type

417: ,p_new_competence_element_id IN number
418: ,p_competence_id IN number
419: ,p_item_type IN hr_api_transaction_steps.item_type%type
420: ,p_item_key IN hr_api_transaction_steps.item_key%type
421: ,p_activity_id IN hr_api_transaction_steps.ACTIVITY_ID%type
422: ,p_person_id IN Number
423: ,p_effective_date IN Date DEFAULT trunc(sysdate)) is
424: --
425: l_transaction_step_id hr_api_transaction_steps.transaction_step_id%type;

Line 425: l_transaction_step_id hr_api_transaction_steps.transaction_step_id%type;

421: ,p_activity_id IN hr_api_transaction_steps.ACTIVITY_ID%type
422: ,p_person_id IN Number
423: ,p_effective_date IN Date DEFAULT trunc(sysdate)) is
424: --
425: l_transaction_step_id hr_api_transaction_steps.transaction_step_id%type;
426: --
427: CURSOR get_txn_step_id (p_comp_id IN number, p_comp_ele_id IN number,
428: p_eff_date IN DATE DEFAULT null, p_person_id IN number) is
429: Select ts.transaction_step_id

Line 430: FROM hr_api_transaction_steps ts,

426: --
427: CURSOR get_txn_step_id (p_comp_id IN number, p_comp_ele_id IN number,
428: p_eff_date IN DATE DEFAULT null, p_person_id IN number) is
429: Select ts.transaction_step_id
430: FROM hr_api_transaction_steps ts,
431: hr_api_transaction_values tv,
432: hr_api_transaction_values tv1,
433: hr_api_transaction_values tv2,
434: hr_api_transaction_values tv3,

Line 431: hr_api_transaction_values tv,

427: CURSOR get_txn_step_id (p_comp_id IN number, p_comp_ele_id IN number,
428: p_eff_date IN DATE DEFAULT null, p_person_id IN number) is
429: Select ts.transaction_step_id
430: FROM hr_api_transaction_steps ts,
431: hr_api_transaction_values tv,
432: hr_api_transaction_values tv1,
433: hr_api_transaction_values tv2,
434: hr_api_transaction_values tv3,
435: hr_api_transaction_values tv4

Line 432: hr_api_transaction_values tv1,

428: p_eff_date IN DATE DEFAULT null, p_person_id IN number) is
429: Select ts.transaction_step_id
430: FROM hr_api_transaction_steps ts,
431: hr_api_transaction_values tv,
432: hr_api_transaction_values tv1,
433: hr_api_transaction_values tv2,
434: hr_api_transaction_values tv3,
435: hr_api_transaction_values tv4
436: Where ts.transaction_step_id = tv.transaction_step_id

Line 433: hr_api_transaction_values tv2,

429: Select ts.transaction_step_id
430: FROM hr_api_transaction_steps ts,
431: hr_api_transaction_values tv,
432: hr_api_transaction_values tv1,
433: hr_api_transaction_values tv2,
434: hr_api_transaction_values tv3,
435: hr_api_transaction_values tv4
436: Where ts.transaction_step_id = tv.transaction_step_id
437: AND ts.item_type = p_item_type

Line 434: hr_api_transaction_values tv3,

430: FROM hr_api_transaction_steps ts,
431: hr_api_transaction_values tv,
432: hr_api_transaction_values tv1,
433: hr_api_transaction_values tv2,
434: hr_api_transaction_values tv3,
435: hr_api_transaction_values tv4
436: Where ts.transaction_step_id = tv.transaction_step_id
437: AND ts.item_type = p_item_type
438: AND ts.item_key = p_item_key

Line 435: hr_api_transaction_values tv4

431: hr_api_transaction_values tv,
432: hr_api_transaction_values tv1,
433: hr_api_transaction_values tv2,
434: hr_api_transaction_values tv3,
435: hr_api_transaction_values tv4
436: Where ts.transaction_step_id = tv.transaction_step_id
437: AND ts.item_type = p_item_type
438: AND ts.item_key = p_item_key
439: AND ts.activity_id = p_activity_id

Line 459: hr_api_transaction_steps ts,

455: Cursor get_enddate_outcome_ids(p_comp_ele_id IN number) is
456: Select ceo.comp_element_outcome_id ,ts.transaction_step_id,ceo.object_version_number
457: FROM
458: per_comp_element_outcomes ceo,
459: hr_api_transaction_steps ts,
460: hr_api_transaction_values tv
461: where
462: ceo.competence_element_id = p_comp_ele_id
463: AND ts.item_type = p_item_type

Line 460: hr_api_transaction_values tv

456: Select ceo.comp_element_outcome_id ,ts.transaction_step_id,ceo.object_version_number
457: FROM
458: per_comp_element_outcomes ceo,
459: hr_api_transaction_steps ts,
460: hr_api_transaction_values tv
461: where
462: ceo.competence_element_id = p_comp_ele_id
463: AND ts.item_type = p_item_type
464: AND ts.item_key = p_item_key

Line 480: AND NOT EXISTS (Select 1 FROM hr_api_transaction_values tv1,

476: From per_Competence_Outcomes co
477: ,Per_comp_element_outcomes ceo
478: Where ceo.COMPETENCE_ELEMENT_ID = p_comp_ele_id
479: AND co.outcome_id = ceo.outcome_id
480: AND NOT EXISTS (Select 1 FROM hr_api_transaction_values tv1,
481: hr_api_transaction_values tv2,
482: hr_api_transaction_values tv3,
483: hr_api_transaction_values tv4,
484: hr_api_transaction_steps s

Line 481: hr_api_transaction_values tv2,

477: ,Per_comp_element_outcomes ceo
478: Where ceo.COMPETENCE_ELEMENT_ID = p_comp_ele_id
479: AND co.outcome_id = ceo.outcome_id
480: AND NOT EXISTS (Select 1 FROM hr_api_transaction_values tv1,
481: hr_api_transaction_values tv2,
482: hr_api_transaction_values tv3,
483: hr_api_transaction_values tv4,
484: hr_api_transaction_steps s
485: WHERE tv1.transaction_step_id = s.transaction_step_id

Line 482: hr_api_transaction_values tv3,

478: Where ceo.COMPETENCE_ELEMENT_ID = p_comp_ele_id
479: AND co.outcome_id = ceo.outcome_id
480: AND NOT EXISTS (Select 1 FROM hr_api_transaction_values tv1,
481: hr_api_transaction_values tv2,
482: hr_api_transaction_values tv3,
483: hr_api_transaction_values tv4,
484: hr_api_transaction_steps s
485: WHERE tv1.transaction_step_id = s.transaction_step_id
486: and s.item_type = p_item_type

Line 483: hr_api_transaction_values tv4,

479: AND co.outcome_id = ceo.outcome_id
480: AND NOT EXISTS (Select 1 FROM hr_api_transaction_values tv1,
481: hr_api_transaction_values tv2,
482: hr_api_transaction_values tv3,
483: hr_api_transaction_values tv4,
484: hr_api_transaction_steps s
485: WHERE tv1.transaction_step_id = s.transaction_step_id
486: and s.item_type = p_item_type
487: and s.item_key = p_item_key

Line 484: hr_api_transaction_steps s

480: AND NOT EXISTS (Select 1 FROM hr_api_transaction_values tv1,
481: hr_api_transaction_values tv2,
482: hr_api_transaction_values tv3,
483: hr_api_transaction_values tv4,
484: hr_api_transaction_steps s
485: WHERE tv1.transaction_step_id = s.transaction_step_id
486: and s.item_type = p_item_type
487: and s.item_key = p_item_key
488: and s.activity_id = nvl(to_number(p_activity_id),s.activity_id)

Line 510: FROM hr_api_transaction_steps S1,

506: and nvl(pco.date_to,to_date('01-01-1001','DD-MM-YYYY')) = nvl(tv3.
507: date_value,to_date('01-01-1001','DD-MM-YYYY')))
508: )
509: And NOT EXISTS (SELECT 1
510: FROM hr_api_transaction_steps S1,
511: hr_api_transaction_values C
512: Where s1.item_type = p_item_type
513: and s1.item_key = p_item_key
514: and s1.activity_id = nvl((p_activity_id),s1.activity_id)

Line 511: hr_api_transaction_values C

507: date_value,to_date('01-01-1001','DD-MM-YYYY')))
508: )
509: And NOT EXISTS (SELECT 1
510: FROM hr_api_transaction_steps S1,
511: hr_api_transaction_values C
512: Where s1.item_type = p_item_type
513: and s1.item_key = p_item_key
514: and s1.activity_id = nvl((p_activity_id),s1.activity_id)
515: and s1.api_name = 'HR_COMP_OUTCOME_PROFILE_SS.DELETE'

Line 685: l_txn_step_id hr_api_transaction_steps.transaction_step_id%type;

681: l_system_generated varchar2(1) default null;
682: l_upgraded_from_rec_id number DEFAULT Null;
683: l_preupd_proficy_lvl_id number default NULL;
684: l_outcome_name per_competence_outcomes_vl.name%type;
685: l_txn_step_id hr_api_transaction_steps.transaction_step_id%type;
686: l_count number;
687: l_proc varchar2(200) ;
688: --
689: Begin

Line 1079: hr_api_transaction_steps S, hr_api_transaction_values C

1075: ceo.date_from <= to_date(p_date_from,g_date_format) and
1076: nvl(ceo.date_to,trunc(sysdate)) >= to_date(p_date_from,g_date_format)
1077: AND NOT exists(
1078: Select 1 FROM
1079: hr_api_transaction_steps S, hr_api_transaction_values C
1080: Where s.item_type = p_item_type
1081: and s.item_key = p_item_key
1082: and s.activity_id = nvl(to_number(p_activity_id),s.activity_id)
1083: and s.api_name = 'HR_COMP_OUTCOME_PROFILE_SS.DELETE'

Line 1103: hr_api_transaction_steps S, hr_api_transaction_values C

1099: and outcome_id = p_outcome_id and
1100: ceo.date_from >= to_date(p_date_from,g_date_format)
1101: AND NOT exists(
1102: Select 1 FROM
1103: hr_api_transaction_steps S, hr_api_transaction_values C
1104: Where s.item_type = p_item_type
1105: and s.item_key = p_item_key
1106: and s.activity_id = nvl(to_number(p_activity_id),s.activity_id)
1107: and s.api_name = 'HR_COMP_OUTCOME_PROFILE_SS.DELETE'

Line 1121: hr_api_transaction_steps S, hr_api_transaction_values C

1117: ceo.date_from >= to_date(p_date_from,g_date_format)
1118: AND ceo.date_from <= to_date(p_date_to,g_date_format)
1119: AND NOT exists(
1120: Select 1 FROM
1121: hr_api_transaction_steps S, hr_api_transaction_values C
1122: Where s.item_type = p_item_type
1123: and s.item_key = p_item_key
1124: and s.activity_id = nvl(to_number(p_activity_id),s.activity_id)
1125: and s.api_name = 'HR_COMP_OUTCOME_PROFILE_SS.DELETE'

Line 1195: from hr_api_transaction_steps step, hr_api_transaction_values val

1191: ,p_step_values out nocopy varchar2
1192: ,p_rows out nocopy number) is
1193: cursor get_add_ids (p_transaction_id number) is
1194: select step.transaction_step_id
1195: from hr_api_transaction_steps step, hr_api_transaction_values val
1196: where step.transaction_id = p_transaction_id
1197: and val.transaction_step_id = step.transaction_step_id
1198: and val.varchar2_value = 'ADD';
1199: l_index number;

Line 1218: from hr_api_transaction_values val, hr_api_transaction_steps steps

1214: /*Procedure del_pen_currupd_ids(p_item_type IN varchar2
1215: ,p_item_key IN varchar2) is
1216: cursor get_upd_ids(p_transaction_id number) is
1217: select steps.transaction_step_id
1218: from hr_api_transaction_values val, hr_api_transaction_steps steps
1219: where steps.transaction_id = p_transaction_id
1220: and steps.transaction_step_id = val.transaction_step_id
1221: and val.name = 'P_CHANGE_MODE'
1222: and val.varchar2_value IN ('UPDATE_APPLY','UPDATE_HIST');

Line 1230: delete from hr_api_transaction_values

1226: l_transaction_id:=hr_transaction_ss.get_transaction_id
1227: (p_item_type => p_item_type
1228: ,p_item_key => p_item_key);
1229: for I in get_upd_ids(l_transaction_id) loop
1230: delete from hr_api_transaction_values
1231: where transaction_step_id = I.transaction_step_id;
1232: delete from hr_api_transaction_steps
1233: where transaction_step_id = I.transaction_step_id;
1234: end loop;

Line 1232: delete from hr_api_transaction_steps

1228: ,p_item_key => p_item_key);
1229: for I in get_upd_ids(l_transaction_id) loop
1230: delete from hr_api_transaction_values
1231: where transaction_step_id = I.transaction_step_id;
1232: delete from hr_api_transaction_steps
1233: where transaction_step_id = I.transaction_step_id;
1234: end loop;
1235: del_add_ids(p_item_type, p_item_key);
1236: commit;

Line 1243: from hr_api_transaction_values val, hr_api_transaction_steps steps

1239: /*Procedure del_add_ids(p_item_type IN varchar2
1240: ,p_item_key IN varchar2) is
1241: cursor get_add_ids(p_transaction_id number) is
1242: select steps.transaction_step_id
1243: from hr_api_transaction_values val, hr_api_transaction_steps steps
1244: where steps.transaction_id = p_transaction_id
1245: and steps.transaction_step_id = val.transaction_step_id
1246: and val.varchar2_value = 'ADD';
1247: l_step_values number ;

Line 1254: delete from hr_api_transaction_values

1250: l_transaction_id:=hr_transaction_ss.get_transaction_id
1251: (p_item_type => p_item_type
1252: ,p_item_key => p_item_key);
1253: for I in get_add_ids(l_transaction_id) loop
1254: delete from hr_api_transaction_values
1255: where transaction_step_id = I.transaction_step_id;
1256: delete from hr_api_transaction_steps
1257: where transaction_id = l_transaction_id
1258: and transaction_step_id = I.transaction_step_id;

Line 1256: delete from hr_api_transaction_steps

1252: ,p_item_key => p_item_key);
1253: for I in get_add_ids(l_transaction_id) loop
1254: delete from hr_api_transaction_values
1255: where transaction_step_id = I.transaction_step_id;
1256: delete from hr_api_transaction_steps
1257: where transaction_id = l_transaction_id
1258: and transaction_step_id = I.transaction_step_id;
1259: end loop ;
1260: end del_add_ids; */

Line 1324: from hr_api_transaction_steps

1320: (p_item_type in varchar2
1321: ,p_item_key in varchar2) is
1322: cursor get_all_ids (p_transaction_id number) is
1323: select transaction_step_id
1324: from hr_api_transaction_steps
1325: where transaction_id = p_transaction_id;
1326: --
1327: l_result number ;
1328: l_transaction_id number ;

Line 1336: delete from hr_api_transaction_values

1332: (p_item_type => p_item_type
1333: ,p_item_key => p_item_key);
1334: --
1335: for l_result in get_all_ids(p_transaction_id => l_transaction_id) loop
1336: delete from hr_api_transaction_values
1337: where transaction_step_id = l_result.transaction_step_id;
1338: --
1339: delete from hr_api_transaction_steps
1340: where transaction_id = l_transaction_id

Line 1339: delete from hr_api_transaction_steps

1335: for l_result in get_all_ids(p_transaction_id => l_transaction_id) loop
1336: delete from hr_api_transaction_values
1337: where transaction_step_id = l_result.transaction_step_id;
1338: --
1339: delete from hr_api_transaction_steps
1340: where transaction_id = l_transaction_id
1341: and transaction_step_id = l_result.transaction_step_id;
1342: end loop ;
1343: commit;

Line 1357: from hr_api_transaction_steps

1353: l_mode varchar2(20) default null;
1354: l_comp_element_outcome_id number default null;
1355: l_transaction_id number;
1356: CURSOR get_txn_step_id IS select transaction_id
1357: from hr_api_transaction_steps
1358: where transaction_step_id = p_transaction_step_id
1359: and rownum = 1;
1360: BEGIN
1361: l_transaction_step_id := p_transaction_step_id;

Line 1365: delete from hr_api_transaction_values where transaction_step_id = l_transaction_step_id ;

1361: l_transaction_step_id := p_transaction_step_id;
1362: --
1363: FOR rec IN get_txn_step_id
1364: loop
1365: delete from hr_api_transaction_values where transaction_step_id = l_transaction_step_id ;
1366: delete from hr_api_transaction_steps where transaction_step_id = l_transaction_step_id ;
1367: END loop;
1368: --
1369: END delete_transaction_step_id;

Line 1366: delete from hr_api_transaction_steps where transaction_step_id = l_transaction_step_id ;

1362: --
1363: FOR rec IN get_txn_step_id
1364: loop
1365: delete from hr_api_transaction_values where transaction_step_id = l_transaction_step_id ;
1366: delete from hr_api_transaction_steps where transaction_step_id = l_transaction_step_id ;
1367: END loop;
1368: --
1369: END delete_transaction_step_id;
1370: --

Line 1507: FROM hr_api_transaction_steps outcome,

1503: (p_transaction_step_id in number) is
1504: --
1505: CURSOR get_step_ids (txn_step_id IN number) is
1506: Select outcome.transaction_step_id
1507: FROM hr_api_transaction_steps outcome,
1508: hr_api_transaction_values ocomp,
1509: hr_api_transaction_values operson,
1510: hr_api_transaction_values ofrom_dt,
1511: hr_api_transaction_values oto_dt,

Line 1508: hr_api_transaction_values ocomp,

1504: --
1505: CURSOR get_step_ids (txn_step_id IN number) is
1506: Select outcome.transaction_step_id
1507: FROM hr_api_transaction_steps outcome,
1508: hr_api_transaction_values ocomp,
1509: hr_api_transaction_values operson,
1510: hr_api_transaction_values ofrom_dt,
1511: hr_api_transaction_values oto_dt,
1512: hr_api_transaction_steps competence,

Line 1509: hr_api_transaction_values operson,

1505: CURSOR get_step_ids (txn_step_id IN number) is
1506: Select outcome.transaction_step_id
1507: FROM hr_api_transaction_steps outcome,
1508: hr_api_transaction_values ocomp,
1509: hr_api_transaction_values operson,
1510: hr_api_transaction_values ofrom_dt,
1511: hr_api_transaction_values oto_dt,
1512: hr_api_transaction_steps competence,
1513: hr_api_transaction_values ccomp,

Line 1510: hr_api_transaction_values ofrom_dt,

1506: Select outcome.transaction_step_id
1507: FROM hr_api_transaction_steps outcome,
1508: hr_api_transaction_values ocomp,
1509: hr_api_transaction_values operson,
1510: hr_api_transaction_values ofrom_dt,
1511: hr_api_transaction_values oto_dt,
1512: hr_api_transaction_steps competence,
1513: hr_api_transaction_values ccomp,
1514: hr_api_transaction_values cperson,

Line 1511: hr_api_transaction_values oto_dt,

1507: FROM hr_api_transaction_steps outcome,
1508: hr_api_transaction_values ocomp,
1509: hr_api_transaction_values operson,
1510: hr_api_transaction_values ofrom_dt,
1511: hr_api_transaction_values oto_dt,
1512: hr_api_transaction_steps competence,
1513: hr_api_transaction_values ccomp,
1514: hr_api_transaction_values cperson,
1515: hr_api_transaction_values cfrom_dt,

Line 1512: hr_api_transaction_steps competence,

1508: hr_api_transaction_values ocomp,
1509: hr_api_transaction_values operson,
1510: hr_api_transaction_values ofrom_dt,
1511: hr_api_transaction_values oto_dt,
1512: hr_api_transaction_steps competence,
1513: hr_api_transaction_values ccomp,
1514: hr_api_transaction_values cperson,
1515: hr_api_transaction_values cfrom_dt,
1516: hr_api_transaction_values cto_dt

Line 1513: hr_api_transaction_values ccomp,

1509: hr_api_transaction_values operson,
1510: hr_api_transaction_values ofrom_dt,
1511: hr_api_transaction_values oto_dt,
1512: hr_api_transaction_steps competence,
1513: hr_api_transaction_values ccomp,
1514: hr_api_transaction_values cperson,
1515: hr_api_transaction_values cfrom_dt,
1516: hr_api_transaction_values cto_dt
1517: Where competence.transaction_step_id = txn_step_id

Line 1514: hr_api_transaction_values cperson,

1510: hr_api_transaction_values ofrom_dt,
1511: hr_api_transaction_values oto_dt,
1512: hr_api_transaction_steps competence,
1513: hr_api_transaction_values ccomp,
1514: hr_api_transaction_values cperson,
1515: hr_api_transaction_values cfrom_dt,
1516: hr_api_transaction_values cto_dt
1517: Where competence.transaction_step_id = txn_step_id
1518: AND ccomp.transaction_step_id = competence.transaction_step_id

Line 1515: hr_api_transaction_values cfrom_dt,

1511: hr_api_transaction_values oto_dt,
1512: hr_api_transaction_steps competence,
1513: hr_api_transaction_values ccomp,
1514: hr_api_transaction_values cperson,
1515: hr_api_transaction_values cfrom_dt,
1516: hr_api_transaction_values cto_dt
1517: Where competence.transaction_step_id = txn_step_id
1518: AND ccomp.transaction_step_id = competence.transaction_step_id
1519: AND cperson.transaction_step_id = competence.transaction_step_id

Line 1516: hr_api_transaction_values cto_dt

1512: hr_api_transaction_steps competence,
1513: hr_api_transaction_values ccomp,
1514: hr_api_transaction_values cperson,
1515: hr_api_transaction_values cfrom_dt,
1516: hr_api_transaction_values cto_dt
1517: Where competence.transaction_step_id = txn_step_id
1518: AND ccomp.transaction_step_id = competence.transaction_step_id
1519: AND cperson.transaction_step_id = competence.transaction_step_id
1520: AND cfrom_dt.transaction_step_id = competence.transaction_step_id

Line 1551: delete from hr_api_transaction_values where transaction_step_id = txnStepIds.transaction_step_id;

1547: hr_utility.set_location(' Entering:' || l_proc,10);
1548: FOR txnStepIds IN get_step_ids(p_transaction_step_id) loop
1549: --
1550: --
1551: delete from hr_api_transaction_values where transaction_step_id = txnStepIds.transaction_step_id;
1552: delete from hr_api_transaction_steps where transaction_step_id = txnStepIds.transaction_step_id;
1553: end loop;
1554: --
1555: commit;

Line 1552: delete from hr_api_transaction_steps where transaction_step_id = txnStepIds.transaction_step_id;

1548: FOR txnStepIds IN get_step_ids(p_transaction_step_id) loop
1549: --
1550: --
1551: delete from hr_api_transaction_values where transaction_step_id = txnStepIds.transaction_step_id;
1552: delete from hr_api_transaction_steps where transaction_step_id = txnStepIds.transaction_step_id;
1553: end loop;
1554: --
1555: commit;
1556: --

Line 1871: l_txn_step_id hr_api_transaction_steps.transaction_step_id%type;

1867: ,p_item_key IN varchar2
1868: ,p_actid IN varchar2
1869: ,p_person_id IN number
1870: ,p_outcome_id IN number) IS
1871: l_txn_step_id hr_api_transaction_steps.transaction_step_id%type;
1872: l_proc varchar2(200);
1873: begin
1874: l_proc := g_package || 'check_delete_rec';
1875: hr_utility.set_location(' Entering:' || l_proc ,10);

Line 1877: FROM hr_api_transaction_steps S,

1873: begin
1874: l_proc := g_package || 'check_delete_rec';
1875: hr_utility.set_location(' Entering:' || l_proc ,10);
1876: SELECT s.transaction_step_id INTO l_txn_step_id
1877: FROM hr_api_transaction_steps S,
1878: hr_api_transaction_values C,
1879: per_comp_element_outcomes ceo,
1880: per_competence_elements pce
1881: Where s.item_type = p_item_type

Line 1878: hr_api_transaction_values C,

1874: l_proc := g_package || 'check_delete_rec';
1875: hr_utility.set_location(' Entering:' || l_proc ,10);
1876: SELECT s.transaction_step_id INTO l_txn_step_id
1877: FROM hr_api_transaction_steps S,
1878: hr_api_transaction_values C,
1879: per_comp_element_outcomes ceo,
1880: per_competence_elements pce
1881: Where s.item_type = p_item_type
1882: and s.item_key = p_item_key

Line 1930: FROM hr_api_transaction_steps s, per_competence_outcomes_vl co,

1926: hr_utility.set_location(' Entering p_pid :' || p_pid ,10);
1927: hr_utility.set_location(' Entering p_competence_element_id :' || p_competence_element_id ,10);
1928: hr_utility.set_location(' Entering p_competence_id :' || p_competence_id ,10);
1929: Select Count(*) INTO l_count
1930: FROM hr_api_transaction_steps s, per_competence_outcomes_vl co,
1931: hr_api_transaction_values a, hr_api_transaction_values b,
1932: hr_api_transaction_values c, hr_api_transaction_values p
1933: Where s.item_type = p_item_type
1934: and s.item_key = p_item_key

Line 1931: hr_api_transaction_values a, hr_api_transaction_values b,

1927: hr_utility.set_location(' Entering p_competence_element_id :' || p_competence_element_id ,10);
1928: hr_utility.set_location(' Entering p_competence_id :' || p_competence_id ,10);
1929: Select Count(*) INTO l_count
1930: FROM hr_api_transaction_steps s, per_competence_outcomes_vl co,
1931: hr_api_transaction_values a, hr_api_transaction_values b,
1932: hr_api_transaction_values c, hr_api_transaction_values p
1933: Where s.item_type = p_item_type
1934: and s.item_key = p_item_key
1935: and s.activity_id = nvl(p_activity_id,s.activity_id)

Line 1932: hr_api_transaction_values c, hr_api_transaction_values p

1928: hr_utility.set_location(' Entering p_competence_id :' || p_competence_id ,10);
1929: Select Count(*) INTO l_count
1930: FROM hr_api_transaction_steps s, per_competence_outcomes_vl co,
1931: hr_api_transaction_values a, hr_api_transaction_values b,
1932: hr_api_transaction_values c, hr_api_transaction_values p
1933: Where s.item_type = p_item_type
1934: and s.item_key = p_item_key
1935: and s.activity_id = nvl(p_activity_id,s.activity_id)
1936: and s.api_name = 'HR_COMP_OUTCOME_PROFILE_SS.PROCESS_API'

Line 1958: FROM hr_api_transaction_steps S,

1954: p_rec_changed := true;
1955: END if;
1956: hr_utility.set_location(' Entering:' || l_proc ,30);
1957: SELECT COUNT(*) INTO l_count
1958: FROM hr_api_transaction_steps S,
1959: hr_api_transaction_values C,
1960: per_comp_element_outcomes ceo
1961: Where s.item_type = p_item_type
1962: and s.item_key = p_item_key

Line 1959: hr_api_transaction_values C,

1955: END if;
1956: hr_utility.set_location(' Entering:' || l_proc ,30);
1957: SELECT COUNT(*) INTO l_count
1958: FROM hr_api_transaction_steps S,
1959: hr_api_transaction_values C,
1960: per_comp_element_outcomes ceo
1961: Where s.item_type = p_item_type
1962: and s.item_key = p_item_key
1963: and s.activity_id = nvl((p_activity_id),s.activity_id)

Line 2003: FROM hr_api_transaction_steps S,

1999: ,p_competence_element_id in number) is
2000:
2001: CURSOR get_del_tsid is
2002: Select DISTINCT s.transaction_step_id
2003: FROM hr_api_transaction_steps S,
2004: hr_api_transaction_values C,
2005: per_comp_element_outcomes ceo
2006: Where s.item_type = p_item_type
2007: and s.item_key = p_item_key

Line 2004: hr_api_transaction_values C,

2000:
2001: CURSOR get_del_tsid is
2002: Select DISTINCT s.transaction_step_id
2003: FROM hr_api_transaction_steps S,
2004: hr_api_transaction_values C,
2005: per_comp_element_outcomes ceo
2006: Where s.item_type = p_item_type
2007: and s.item_key = p_item_key
2008: and s.activity_id = nvl((p_activity_id),s.activity_id)

Line 2017: FROM hr_api_transaction_steps S,

2013: AND ceo.competence_element_id = p_competence_element_id;
2014:
2015: Cursor get_comp_sid is
2016: Select DISTINCT s.transaction_step_id
2017: FROM hr_api_transaction_steps S,
2018: hr_api_transaction_values C
2019: Where s.item_type = p_item_type
2020: and s.item_key = p_item_key
2021: and s.activity_id = nvl((p_activity_id),s.activity_id)

Line 2018: hr_api_transaction_values C

2014:
2015: Cursor get_comp_sid is
2016: Select DISTINCT s.transaction_step_id
2017: FROM hr_api_transaction_steps S,
2018: hr_api_transaction_values C
2019: Where s.item_type = p_item_type
2020: and s.item_key = p_item_key
2021: and s.activity_id = nvl((p_activity_id),s.activity_id)
2022: and s.api_name = 'HR_COMP_PROFILE_SS.PROCESS_API'

Line 2029: FROM hr_api_transaction_steps S,

2025: AND c.number_value = p_competence_element_id;
2026:
2027: Cursor get_out_sid is
2028: Select DISTINCT s.transaction_step_id
2029: FROM hr_api_transaction_steps S,
2030: hr_api_transaction_values C
2031: Where s.item_type = p_item_type
2032: and s.item_key = p_item_key
2033: and s.activity_id = nvl((p_activity_id),s.activity_id)

Line 2030: hr_api_transaction_values C

2026:
2027: Cursor get_out_sid is
2028: Select DISTINCT s.transaction_step_id
2029: FROM hr_api_transaction_steps S,
2030: hr_api_transaction_values C
2031: Where s.item_type = p_item_type
2032: and s.item_key = p_item_key
2033: and s.activity_id = nvl((p_activity_id),s.activity_id)
2034: and s.api_name = 'HR_COMP_OUTCOME_PROFILE_SS.PROCESS_API'