193: IF l_requestor_type = 'FND_USER/EMPLOYEE'
194: THEN
195: /* Not Sure of the Source since p_request_type is passed as NULL
196: In that case first check the requestor ID, if its passed as -1
197: or NULL then take the FND_GLOBAL.USER_ID and set the request
198: type as FND_USER.
199:
200: If the Requestor ID is not NULL or <> -1 then check if the
201: Requestor is an Employee
204:
205: IF l_requestor_id IS NULL OR l_requestor_id = -1
206: THEN
207: debug('p_requestor_type is passed as NULL, p_requestor_id is NULL or -1, use FND USER');
208: l_requestor_id := FND_GLOBAL.USER_ID;
209: l_requestor_type := 'FND_USER';
210: debug('p_requestor_type is passed as NULL, l_requestor_id:'||
211: l_requestor_id||' l_requestor_type :'||l_requestor_type);
212: ELSE
479:
480: -- Now upadate the records
481: UPDATE ar_cmgt_case_folders
482: SET STATUS = 'REFRESH',
483: last_updated_by = fnd_global.user_id,
484: last_update_date = sysdate,
485: last_updated = sysdate
486: WHERE case_folder_id = l_case_folder_id
487: AND status NOT IN ('SUBMITTED','CLOSED');
750: )
751: VALUES
752: (l_credit_request_id,
753: sysdate,
754: fnd_global.user_id,
755: sysdate,
756: fnd_global.user_id,
757: fnd_global.login_id,
758: l_application_number,
752: (l_credit_request_id,
753: sysdate,
754: fnd_global.user_id,
755: sysdate,
756: fnd_global.user_id,
757: fnd_global.login_id,
758: l_application_number,
759: l_application_date,
760: l_requestor_type,
753: sysdate,
754: fnd_global.user_id,
755: sysdate,
756: fnd_global.user_id,
757: fnd_global.login_id,
758: l_application_number,
759: l_application_date,
760: l_requestor_type,
761: l_requestor_id,
789: p_source_column1,
790: p_source_column2,
791: p_source_column3,
792: p_notes,
793: fnd_global.conc_request_id,
794: p_parent_credit_request_id,
795: l_credit_request_type,
796: p_reco
797: );
1013: VALUES (AR_CMGT_HOLD_DTL_S.NEXTVAL,
1014: l_credit_request_id,
1015: 'REASON',
1016: l_hold_reason_rec(rec),
1017: fnd_global.user_id,
1018: SYSDATE,
1019: fnd_global.user_id,
1020: SYSDATE,
1021: fnd_global.login_id);
1015: 'REASON',
1016: l_hold_reason_rec(rec),
1017: fnd_global.user_id,
1018: SYSDATE,
1019: fnd_global.user_id,
1020: SYSDATE,
1021: fnd_global.login_id);
1022:
1023: END LOOP;
1017: fnd_global.user_id,
1018: SYSDATE,
1019: fnd_global.user_id,
1020: SYSDATE,
1021: fnd_global.login_id);
1022:
1023: END LOOP;
1024: END IF;
1025: