[Home] [Help]
178: IF l_requestor_type = 'FND_USER/EMPLOYEE'
179: THEN
180: /* Not Sure of the Source since p_request_type is passed as NULL
181: In that case first check the requestor ID, if its passed as -1
182: or NULL then take the FND_GLOBAL.USER_ID and set the request
183: type as FND_USER.
184:
185: If the Requestor ID is not NULL or <> -1 then check if the
186: Requestor is an Employee
189:
190: IF l_requestor_id IS NULL OR l_requestor_id = -1
191: THEN
192: debug('p_requestor_type is passed as NULL, p_requestor_id is NULL or -1, use FND USER');
193: l_requestor_id := FND_GLOBAL.USER_ID;
194: l_requestor_type := 'FND_USER';
195: debug('p_requestor_type is passed as NULL, l_requestor_id:'||
196: l_requestor_id||' l_requestor_type :'||l_requestor_type);
197: ELSE
464:
465: -- Now upadate the records
466: UPDATE ar_cmgt_case_folders
467: SET STATUS = 'REFRESH',
468: last_updated_by = fnd_global.user_id,
469: last_update_date = sysdate,
470: last_updated = sysdate
471: WHERE case_folder_id = l_case_folder_id
472: AND status NOT IN ('SUBMITTED','CLOSED');
742: )
743: VALUES
744: (l_credit_request_id,
745: sysdate,
746: fnd_global.user_id,
747: sysdate,
748: fnd_global.user_id,
749: fnd_global.login_id,
750: l_application_number,
744: (l_credit_request_id,
745: sysdate,
746: fnd_global.user_id,
747: sysdate,
748: fnd_global.user_id,
749: fnd_global.login_id,
750: l_application_number,
751: l_application_date,
752: l_requestor_type,
745: sysdate,
746: fnd_global.user_id,
747: sysdate,
748: fnd_global.user_id,
749: fnd_global.login_id,
750: l_application_number,
751: l_application_date,
752: l_requestor_type,
753: l_requestor_id,
781: p_source_column1,
782: p_source_column2,
783: p_source_column3,
784: p_notes,
785: fnd_global.conc_request_id,
786: p_parent_credit_request_id,
787: l_credit_request_type,
788: p_reco
789: );