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_APPRAISAL_WORKFLOW_SS dependencies on PER_APPRAISALS

Line 68: l_system_params per_appraisals.system_params%type;

64: ,funmode in varchar2
65: ,result in out nocopy varchar2) is
66: --local variables
67: ln_appraisal_id number;
68: l_system_params per_appraisals.system_params%type;
69: begin
70: -- Do nothing in cancel or timeout mode
71: if (funmode <> wf_engine.eng_run) then
72: result := wf_engine.eng_null;

Line 79: -- get the system params from per_appraisals

75: ln_appraisal_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'APPRAISAL_ID',true);
76: if(ln_appraisal_id is null) then
77: raise g_invalid_appraisal_id;
78: else
79: -- get the system params from per_appraisals
80: begin
81: select system_params
82: into l_system_params
83: from per_appraisals

Line 83: from per_appraisals

79: -- get the system params from per_appraisals
80: begin
81: select system_params
82: into l_system_params
83: from per_appraisals
84: where appraisal_id=ln_appraisal_id;
85:
86: -- add the itemkey to the system params
87: l_system_params := l_system_params ||'&pItemKey='||itemkey;

Line 91: update per_appraisals

87: l_system_params := l_system_params ||'&pItemKey='||itemkey;
88:
89:
90: -- update the itemkey value for the current transaction
91: update per_appraisals
92: set
93: system_params = l_system_params
94: where appraisal_id = ln_appraisal_id;
95: exception

Line 164: ,p_transaction_ref_table=>'PER_APPRAISALS'

160: ,p_login_person_id=>ln_login_person_id
161: ,p_product_code=>'PER'
162: ,p_status=>'W'
163: ,p_function_id=>''
164: ,p_transaction_ref_table=>'PER_APPRAISALS'
165: ,p_transaction_ref_id=>ln_appraisal_id
166: ,p_transaction_type=>'#WF'
167: ,p_assignment_id=>ln_assignment_id
168: ,p_selected_person_id=>ln_selected_person_id

Line 188: l_appraisal_id per_appraisals.appraisal_id%type;

184: , p_result in out nocopy varchar2
185: )
186: is
187: -- local variables
188: l_appraisal_id per_appraisals.appraisal_id%type;
189: l_main_appraiser_id per_appraisals.main_appraiser_id%type;
190: l_appraiser_person_id per_appraisals.appraiser_person_id%type;
191: l_appraisee_person_id per_appraisals.appraisee_person_id%type;
192: l_system_params per_appraisals.system_params%type;

Line 189: l_main_appraiser_id per_appraisals.main_appraiser_id%type;

185: )
186: is
187: -- local variables
188: l_appraisal_id per_appraisals.appraisal_id%type;
189: l_main_appraiser_id per_appraisals.main_appraiser_id%type;
190: l_appraiser_person_id per_appraisals.appraiser_person_id%type;
191: l_appraisee_person_id per_appraisals.appraisee_person_id%type;
192: l_system_params per_appraisals.system_params%type;
193: l_system_type per_appraisals.system_type%type;

Line 190: l_appraiser_person_id per_appraisals.appraiser_person_id%type;

186: is
187: -- local variables
188: l_appraisal_id per_appraisals.appraisal_id%type;
189: l_main_appraiser_id per_appraisals.main_appraiser_id%type;
190: l_appraiser_person_id per_appraisals.appraiser_person_id%type;
191: l_appraisee_person_id per_appraisals.appraisee_person_id%type;
192: l_system_params per_appraisals.system_params%type;
193: l_system_type per_appraisals.system_type%type;
194: l_assignment_id per_appraisals.assignment_id%type;

Line 191: l_appraisee_person_id per_appraisals.appraisee_person_id%type;

187: -- local variables
188: l_appraisal_id per_appraisals.appraisal_id%type;
189: l_main_appraiser_id per_appraisals.main_appraiser_id%type;
190: l_appraiser_person_id per_appraisals.appraiser_person_id%type;
191: l_appraisee_person_id per_appraisals.appraisee_person_id%type;
192: l_system_params per_appraisals.system_params%type;
193: l_system_type per_appraisals.system_type%type;
194: l_assignment_id per_appraisals.assignment_id%type;
195: l_username wf_users.name%type;

Line 192: l_system_params per_appraisals.system_params%type;

188: l_appraisal_id per_appraisals.appraisal_id%type;
189: l_main_appraiser_id per_appraisals.main_appraiser_id%type;
190: l_appraiser_person_id per_appraisals.appraiser_person_id%type;
191: l_appraisee_person_id per_appraisals.appraisee_person_id%type;
192: l_system_params per_appraisals.system_params%type;
193: l_system_type per_appraisals.system_type%type;
194: l_assignment_id per_appraisals.assignment_id%type;
195: l_username wf_users.name%type;
196: l_appraisee_user_name wf_users.name%type;

Line 193: l_system_type per_appraisals.system_type%type;

189: l_main_appraiser_id per_appraisals.main_appraiser_id%type;
190: l_appraiser_person_id per_appraisals.appraiser_person_id%type;
191: l_appraisee_person_id per_appraisals.appraisee_person_id%type;
192: l_system_params per_appraisals.system_params%type;
193: l_system_type per_appraisals.system_type%type;
194: l_assignment_id per_appraisals.assignment_id%type;
195: l_username wf_users.name%type;
196: l_appraisee_user_name wf_users.name%type;
197: l_supervisor_user_name wf_users.name%type;

Line 194: l_assignment_id per_appraisals.assignment_id%type;

190: l_appraiser_person_id per_appraisals.appraiser_person_id%type;
191: l_appraisee_person_id per_appraisals.appraisee_person_id%type;
192: l_system_params per_appraisals.system_params%type;
193: l_system_type per_appraisals.system_type%type;
194: l_assignment_id per_appraisals.assignment_id%type;
195: l_username wf_users.name%type;
196: l_appraisee_user_name wf_users.name%type;
197: l_supervisor_user_name wf_users.name%type;
198: l_main_appraiser_user_name wf_users.name%type;

Line 208: -- query the other details from per_appraisals for the given l_appraisal_id

204: l_appraisal_id:= wf_engine.GetItemAttrNumber (itemtype => p_itemtype ,
205: itemkey => p_itemkey ,
206: aname => 'APPRAISAL_ID',
207: ignore_notfound=>true);
208: -- query the other details from per_appraisals for the given l_appraisal_id
209: -- check if l_appraisal_id is null, if null throw an error
210: if(l_appraisal_id is not null) then
211: select APPRAISAL_ID, MAIN_APPRAISER_ID,APPRAISER_PERSON_ID,
212: APPRAISEE_PERSON_ID,SYSTEM_PARAMS,system_type,assignment_id

Line 215: from per_appraisals

211: select APPRAISAL_ID, MAIN_APPRAISER_ID,APPRAISER_PERSON_ID,
212: APPRAISEE_PERSON_ID,SYSTEM_PARAMS,system_type,assignment_id
213: into l_appraisal_id,l_main_appraiser_id, l_appraiser_person_id,
214: l_appraisee_person_id,l_system_params,l_system_type,l_assignment_id
215: from per_appraisals
216: where APPRAISAL_ID=l_appraisal_id;
217: else
218: raise g_invalid_appraisal_id;
219: end if;

Line 870: l_appraisal_id per_appraisals.appraisal_id%type;

866: , p_result in out nocopy varchar2
867: )
868: is
869: -- local variables
870: l_appraisal_id per_appraisals.appraisal_id%type;
871: l_main_appraiser_id per_appraisals.main_appraiser_id%type;
872: l_role_name varchar2(320);
873: l_role_displayname varchar2(360);
874:

Line 871: l_main_appraiser_id per_appraisals.main_appraiser_id%type;

867: )
868: is
869: -- local variables
870: l_appraisal_id per_appraisals.appraisal_id%type;
871: l_main_appraiser_id per_appraisals.main_appraiser_id%type;
872: l_role_name varchar2(320);
873: l_role_displayname varchar2(360);
874:
875: begin

Line 882: -- query the other details from per_appraisals for the given l_appraisal_id

878: l_appraisal_id:= wf_engine.GetItemAttrNumber (itemtype => p_itemtype ,
879: itemkey => p_itemkey ,
880: aname => 'APPRAISAL_ID',
881: ignore_notfound=>true);
882: -- query the other details from per_appraisals for the given l_appraisal_id
883: -- check if l_appraisal_id is null, if null throw an error
884: if(l_appraisal_id is not null) then
885: select MAIN_APPRAISER_ID
886: into l_main_appraiser_id

Line 887: from per_appraisals

883: -- check if l_appraisal_id is null, if null throw an error
884: if(l_appraisal_id is not null) then
885: select MAIN_APPRAISER_ID
886: into l_main_appraiser_id
887: from per_appraisals
888: where APPRAISAL_ID=l_appraisal_id;
889: else
890: raise g_invalid_appraisal_id;
891: end if;

Line 943: l_appraisal_id per_appraisals.appraisal_id%type;

939: , p_result in out nocopy varchar2
940: )
941: is
942: -- local variables
943: l_appraisal_id per_appraisals.appraisal_id%type;
944: lv_result varchar2(3);
945: begin
946: hr_utility.set_location('Entered:'|| gv_package || '.commit_transaction', 1);
947: hr_utility.set_location('calling hr_complete_appraisal_ss.complete_appr', 2);

Line 980: l_appraisal_id per_appraisals.appraisal_id%type;

976: ,p_status in varchar2
977: )
978: is
979: -- local variables
980: l_appraisal_id per_appraisals.appraisal_id%type;
981: l_appraiser_person_id per_appraisals.appraiser_person_id%type;
982: l_object_version_number per_appraisals.object_version_number%type;
983: l_system_params per_appraisals.system_params%type;
984:

Line 981: l_appraiser_person_id per_appraisals.appraiser_person_id%type;

977: )
978: is
979: -- local variables
980: l_appraisal_id per_appraisals.appraisal_id%type;
981: l_appraiser_person_id per_appraisals.appraiser_person_id%type;
982: l_object_version_number per_appraisals.object_version_number%type;
983: l_system_params per_appraisals.system_params%type;
984:
985: begin

Line 982: l_object_version_number per_appraisals.object_version_number%type;

978: is
979: -- local variables
980: l_appraisal_id per_appraisals.appraisal_id%type;
981: l_appraiser_person_id per_appraisals.appraiser_person_id%type;
982: l_object_version_number per_appraisals.object_version_number%type;
983: l_system_params per_appraisals.system_params%type;
984:
985: begin
986: hr_utility.set_location('Entered:'|| gv_package || '.update_appraisal_system_status', 1);

Line 983: l_system_params per_appraisals.system_params%type;

979: -- local variables
980: l_appraisal_id per_appraisals.appraisal_id%type;
981: l_appraiser_person_id per_appraisals.appraiser_person_id%type;
982: l_object_version_number per_appraisals.object_version_number%type;
983: l_system_params per_appraisals.system_params%type;
984:
985: begin
986: hr_utility.set_location('Entered:'|| gv_package || '.update_appraisal_system_status', 1);
987: -- get the appraisal_id from the item attribute , APPRAISAL_ID

Line 997: -- get the required data from the per_appraisals for the update

993: itemkey => p_itemkey ,
994: aname => 'APPRAISAL_ID',
995: ignore_notfound=>true);
996: begin
997: -- get the required data from the per_appraisals for the update
998: select appraiser_person_id, object_version_number,system_params
999: into l_appraiser_person_id,l_object_version_number,l_system_params
1000: from per_appraisals
1001: where appraisal_id=l_appraisal_id;

Line 1000: from per_appraisals

996: begin
997: -- get the required data from the per_appraisals for the update
998: select appraiser_person_id, object_version_number,system_params
999: into l_appraiser_person_id,l_object_version_number,l_system_params
1000: from per_appraisals
1001: where appraisal_id=l_appraisal_id;
1002: l_system_params := replace(l_system_params,'&pItemKey=' || p_itemkey ,'');
1003: exception
1004: when others then

Line 1174: l_provide_feedback PER_APPRAISALS.provide_overall_feedback%TYPE;

1170:
1171: FUNCTION isAppraiseeFeebackAllowed
1172: (p_appraisal_id IN number) RETURN VARCHAR2
1173: IS
1174: l_provide_feedback PER_APPRAISALS.provide_overall_feedback%TYPE;
1175:
1176: BEGIN
1177: SELECT NVL(appr.provide_overall_feedback,'N')
1178: INTO l_provide_feedback

Line 1179: from per_appraisals appr

1175:
1176: BEGIN
1177: SELECT NVL(appr.provide_overall_feedback,'N')
1178: INTO l_provide_feedback
1179: from per_appraisals appr
1180: where appr.appraisal_id = p_appraisal_id;
1181:
1182: RETURN l_provide_feedback;
1183:

Line 1195: l_appraisal_id per_appraisals.appraisal_id%type;

1191: , p_result in out nocopy varchar2
1192: )
1193: is
1194: -- local variables
1195: l_appraisal_id per_appraisals.appraisal_id%type;
1196:
1197: l_log varchar2(4000);
1198: lv_chg_appr_status_log wf_item_attributes.text_default%TYPE;
1199: chg_appr_status varchar2(2);

Line 1247: l_appraisal_id per_appraisals.appraisal_id%type;

1243: , p_result in out nocopy varchar2
1244: )
1245: is
1246: -- local variables
1247: l_appraisal_id per_appraisals.appraisal_id%type;
1248:
1249: l_log varchar2(4000);
1250: lv_chg_appr_status_log wf_item_attributes.text_default%TYPE;
1251: chg_appr_status varchar2(2);