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.AP_WORKFLOW_PKG dependencies on FND_PROFILE

Line 276: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);

272: l_hist_rec.ITERATION := l_iteration;
273: l_hist_rec.RESPONSE := 'SENT';
274: l_hist_rec.APPROVER_ID := l_next_approver.person_id;
275: l_hist_rec.APPROVER_NAME:= l_display_name;
276: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
277: l_hist_rec.CREATION_DATE:= sysdate;
278: l_hist_rec.LAST_UPDATE_DATE := sysdate;
279: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
280: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);

Line 279: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);

275: l_hist_rec.APPROVER_NAME:= l_display_name;
276: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
277: l_hist_rec.CREATION_DATE:= sysdate;
278: l_hist_rec.LAST_UPDATE_DATE := sysdate;
279: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
280: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);
281: l_hist_rec.ORG_ID := l_org_id;
282: l_hist_rec.AMOUNT_APPROVED := 0;
283: l_hist_rec.HOLD_ID := l_hold_id;

Line 280: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);

276: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
277: l_hist_rec.CREATION_DATE:= sysdate;
278: l_hist_rec.LAST_UPDATE_DATE := sysdate;
279: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
280: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);
281: l_hist_rec.ORG_ID := l_org_id;
282: l_hist_rec.AMOUNT_APPROVED := 0;
283: l_hist_rec.HOLD_ID := l_hold_id;
284: l_hist_rec.NOTIFICATION_ORDER := l_notf_iteration;

Line 427: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);

423: l_hist_rec.NOTIFICATION_ORDER := l_notf_iteration;
424: l_hist_rec.RESPONSE := 'ACKNOWLEDGE';
425: l_hist_rec.APPROVER_ID := l_approver_id;
426: l_hist_rec.APPROVER_NAME:= l_display_name;
427: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
428: l_hist_rec.CREATION_DATE:= sysdate;
429: l_hist_rec.LAST_UPDATE_DATE := sysdate;
430: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
431: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);

Line 430: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);

426: l_hist_rec.APPROVER_NAME:= l_display_name;
427: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
428: l_hist_rec.CREATION_DATE:= sysdate;
429: l_hist_rec.LAST_UPDATE_DATE := sysdate;
430: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
431: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);
432: l_hist_rec.ORG_ID := l_org_id;
433: l_hist_rec.AMOUNT_APPROVED := null;
434: l_hist_rec.HOLD_ID := l_hold_id;

Line 431: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);

427: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
428: l_hist_rec.CREATION_DATE:= sysdate;
429: l_hist_rec.LAST_UPDATE_DATE := sysdate;
430: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
431: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);
432: l_hist_rec.ORG_ID := l_org_id;
433: l_hist_rec.AMOUNT_APPROVED := null;
434: l_hist_rec.HOLD_ID := l_hold_id;
435:

Line 520: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);

516: l_hist_rec.NOTIFICATION_ORDER := l_notf_iteration;
517: l_hist_rec.RESPONSE := 'RELEASE';
518: l_hist_rec.APPROVER_ID := l_approver_id;
519: l_hist_rec.APPROVER_NAME:= l_display_name;
520: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
521: l_hist_rec.CREATION_DATE:= sysdate;
522: l_hist_rec.LAST_UPDATE_DATE := sysdate;
523: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
524: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);

Line 523: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);

519: l_hist_rec.APPROVER_NAME:= l_display_name;
520: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
521: l_hist_rec.CREATION_DATE:= sysdate;
522: l_hist_rec.LAST_UPDATE_DATE := sysdate;
523: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
524: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);
525: l_hist_rec.ORG_ID := l_org_id;
526: l_hist_rec.AMOUNT_APPROVED := null;
527: l_hist_rec.HOLD_ID := l_hold_id;

Line 524: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);

520: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
521: l_hist_rec.CREATION_DATE:= sysdate;
522: l_hist_rec.LAST_UPDATE_DATE := sysdate;
523: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
524: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);
525: l_hist_rec.ORG_ID := l_org_id;
526: l_hist_rec.AMOUNT_APPROVED := null;
527: l_hist_rec.HOLD_ID := l_hold_id;
528:

Line 624: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);

620: l_hist_rec.NOTIFICATION_ORDER := l_notf_iteration;
621: l_hist_rec.RESPONSE := 'ACKNOWLEDGE';
622: l_hist_rec.APPROVER_ID := l_approver_id;
623: l_hist_rec.APPROVER_NAME:= l_display_name;
624: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
625: l_hist_rec.CREATION_DATE:= sysdate;
626: l_hist_rec.LAST_UPDATE_DATE := sysdate;
627: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
628: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);

Line 627: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);

623: l_hist_rec.APPROVER_NAME:= l_display_name;
624: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
625: l_hist_rec.CREATION_DATE:= sysdate;
626: l_hist_rec.LAST_UPDATE_DATE := sysdate;
627: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
628: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);
629: l_hist_rec.ORG_ID := l_org_id;
630: l_hist_rec.AMOUNT_APPROVED := null;
631: l_hist_rec.HOLD_ID := l_hold_id;

Line 628: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);

624: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
625: l_hist_rec.CREATION_DATE:= sysdate;
626: l_hist_rec.LAST_UPDATE_DATE := sysdate;
627: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
628: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);
629: l_hist_rec.ORG_ID := l_org_id;
630: l_hist_rec.AMOUNT_APPROVED := null;
631: l_hist_rec.HOLD_ID := l_hold_id;
632:

Line 716: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);

712: l_hist_rec.NOTIFICATION_ORDER := l_notf_iteration;
713: l_hist_rec.RESPONSE := 'RELEASE';
714: l_hist_rec.APPROVER_ID := l_approver_id;
715: l_hist_rec.APPROVER_NAME:= l_display_name;
716: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
717: l_hist_rec.CREATION_DATE:= sysdate;
718: l_hist_rec.LAST_UPDATE_DATE := sysdate;
719: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
720: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);

Line 719: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);

715: l_hist_rec.APPROVER_NAME:= l_display_name;
716: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
717: l_hist_rec.CREATION_DATE:= sysdate;
718: l_hist_rec.LAST_UPDATE_DATE := sysdate;
719: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
720: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);
721: l_hist_rec.ORG_ID := l_org_id;
722: l_hist_rec.AMOUNT_APPROVED := null;
723: l_hist_rec.HOLD_ID := l_hold_id;

Line 720: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);

716: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
717: l_hist_rec.CREATION_DATE:= sysdate;
718: l_hist_rec.LAST_UPDATE_DATE := sysdate;
719: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
720: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);
721: l_hist_rec.ORG_ID := l_org_id;
722: l_hist_rec.AMOUNT_APPROVED := null;
723: l_hist_rec.HOLD_ID := l_hold_id;
724:

Line 880: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);

876: l_hist_rec.NOTIFICATION_ORDER := l_notf_iteration;
877: l_hist_rec.RESPONSE := 'ACCEPT';
878: l_hist_rec.APPROVER_ID := l_approver_id;
879: l_hist_rec.APPROVER_NAME:= l_display_name;
880: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
881: l_hist_rec.CREATION_DATE:= sysdate;
882: l_hist_rec.LAST_UPDATE_DATE := sysdate;
883: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
884: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);

Line 883: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);

879: l_hist_rec.APPROVER_NAME:= l_display_name;
880: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
881: l_hist_rec.CREATION_DATE:= sysdate;
882: l_hist_rec.LAST_UPDATE_DATE := sysdate;
883: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
884: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);
885: l_hist_rec.ORG_ID := l_org_id;
886: l_hist_rec.AMOUNT_APPROVED := null;
887: l_hist_rec.HOLD_ID := l_hold_id;

Line 884: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);

880: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
881: l_hist_rec.CREATION_DATE:= sysdate;
882: l_hist_rec.LAST_UPDATE_DATE := sysdate;
883: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
884: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);
885: l_hist_rec.ORG_ID := l_org_id;
886: l_hist_rec.AMOUNT_APPROVED := null;
887: l_hist_rec.HOLD_ID := l_hold_id;
888:

Line 1047: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);

1043: l_hist_rec.NOTIFICATION_ORDER := l_notf_iteration;
1044: l_hist_rec.RESPONSE := 'CANCEL';
1045: l_hist_rec.APPROVER_ID := l_approver_id;
1046: l_hist_rec.APPROVER_NAME:= l_display_name;
1047: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
1048: l_hist_rec.CREATION_DATE:= sysdate;
1049: l_hist_rec.LAST_UPDATE_DATE := sysdate;
1050: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
1051: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);

Line 1050: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);

1046: l_hist_rec.APPROVER_NAME:= l_display_name;
1047: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
1048: l_hist_rec.CREATION_DATE:= sysdate;
1049: l_hist_rec.LAST_UPDATE_DATE := sysdate;
1050: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
1051: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);
1052: l_hist_rec.ORG_ID := l_org_id;
1053: l_hist_rec.AMOUNT_APPROVED := null;
1054: l_hist_rec.HOLD_ID := l_hold_id;

Line 1051: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);

1047: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
1048: l_hist_rec.CREATION_DATE:= sysdate;
1049: l_hist_rec.LAST_UPDATE_DATE := sysdate;
1050: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
1051: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);
1052: l_hist_rec.ORG_ID := l_org_id;
1053: l_hist_rec.AMOUNT_APPROVED := null;
1054: l_hist_rec.HOLD_ID := l_hold_id;
1055: l_debug_info := 'Before Ap_Cancel_Single_Invoice';

Line 1194: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);

1190: l_hist_rec.NOTIFICATION_ORDER := l_notf_iteration;
1191: l_hist_rec.RESPONSE := 'ACCEPT';
1192: l_hist_rec.APPROVER_ID := l_approver_id;
1193: l_hist_rec.APPROVER_NAME:= l_display_name;
1194: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
1195: l_hist_rec.CREATION_DATE:= sysdate;
1196: l_hist_rec.LAST_UPDATE_DATE := sysdate;
1197: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
1198: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);

Line 1197: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);

1193: l_hist_rec.APPROVER_NAME:= l_display_name;
1194: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
1195: l_hist_rec.CREATION_DATE:= sysdate;
1196: l_hist_rec.LAST_UPDATE_DATE := sysdate;
1197: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
1198: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);
1199: l_hist_rec.ORG_ID := l_org_id;
1200: l_hist_rec.AMOUNT_APPROVED := null;
1201: l_hist_rec.HOLD_ID := l_hold_id;

Line 1198: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);

1194: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
1195: l_hist_rec.CREATION_DATE:= sysdate;
1196: l_hist_rec.LAST_UPDATE_DATE := sysdate;
1197: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
1198: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);
1199: l_hist_rec.ORG_ID := l_org_id;
1200: l_hist_rec.AMOUNT_APPROVED := null;
1201: l_hist_rec.HOLD_ID := l_hold_id;
1202:

Line 1378: FND_PROFILE.VALUE('AP_IAW_USER');

1374: l_hist_rec.iteration := l_iteration;
1375: l_hist_rec.response := 'APPROVED';
1376: l_hist_rec.approver_comments := l_tr_reason;
1377: l_hist_rec.approver_id :=
1378: FND_PROFILE.VALUE('AP_IAW_USER');
1379: l_hist_rec.org_id := l_org_id;
1380: l_hist_rec.created_by :=
1381: FND_PROFILE.VALUE('AP_IAW_USER');
1382: l_hist_rec.creation_date := sysdate;

Line 1381: FND_PROFILE.VALUE('AP_IAW_USER');

1377: l_hist_rec.approver_id :=
1378: FND_PROFILE.VALUE('AP_IAW_USER');
1379: l_hist_rec.org_id := l_org_id;
1380: l_hist_rec.created_by :=
1381: FND_PROFILE.VALUE('AP_IAW_USER');
1382: l_hist_rec.creation_date := sysdate;
1383: l_hist_rec.last_update_date := sysdate;
1384: l_hist_rec.last_updated_by :=
1385: FND_PROFILE.VALUE('AP_IAW_USER');

Line 1385: FND_PROFILE.VALUE('AP_IAW_USER');

1381: FND_PROFILE.VALUE('AP_IAW_USER');
1382: l_hist_rec.creation_date := sysdate;
1383: l_hist_rec.last_update_date := sysdate;
1384: l_hist_rec.last_updated_by :=
1385: FND_PROFILE.VALUE('AP_IAW_USER');
1386: l_hist_rec.last_update_login := -1;
1387: l_hist_rec.amount_approved := l_amount;
1388: l_hist_rec.history_type := 'DOCUMENTAPPROVAL';
1389:

Line 1461: FND_PROFILE.VALUE('AP_IAW_USER');

1457: l_hist_rec.iteration := l_iteration;
1458: l_hist_rec.response := 'REJECTED';
1459: l_hist_rec.approver_comments := l_tr_reason;
1460: l_hist_rec.approver_id :=
1461: FND_PROFILE.VALUE('AP_IAW_USER');
1462: l_hist_rec.org_id := l_org_id;
1463: l_hist_rec.created_by :=
1464: FND_PROFILE.VALUE('AP_IAW_USER');
1465: l_hist_rec.creation_date := sysdate;

Line 1464: FND_PROFILE.VALUE('AP_IAW_USER');

1460: l_hist_rec.approver_id :=
1461: FND_PROFILE.VALUE('AP_IAW_USER');
1462: l_hist_rec.org_id := l_org_id;
1463: l_hist_rec.created_by :=
1464: FND_PROFILE.VALUE('AP_IAW_USER');
1465: l_hist_rec.creation_date := sysdate;
1466: l_hist_rec.last_update_date := sysdate;
1467: l_hist_rec.last_updated_by :=
1468: FND_PROFILE.VALUE('AP_IAW_USER');

Line 1468: FND_PROFILE.VALUE('AP_IAW_USER');

1464: FND_PROFILE.VALUE('AP_IAW_USER');
1465: l_hist_rec.creation_date := sysdate;
1466: l_hist_rec.last_update_date := sysdate;
1467: l_hist_rec.last_updated_by :=
1468: FND_PROFILE.VALUE('AP_IAW_USER');
1469: l_hist_rec.last_update_login := -1;
1470: l_hist_rec.amount_approved := l_amount;
1471: l_hist_rec.history_type := 'DOCUMENTAPPROVAL';
1472:

Line 1644: FND_PROFILE.VALUE('AP_IAW_USER');

1640: l_l_hist.iteration := l_iteration;
1641: l_l_hist.response := 'APPROVED';
1642: l_l_hist.approver_comments := l_tr_reason;
1643: l_l_hist.approver_id :=
1644: FND_PROFILE.VALUE('AP_IAW_USER');
1645: l_l_hist.org_id := l_org_id;
1646: l_l_hist.line_number := l_line_number;
1647: l_l_hist.amount_approved :=
1648: l_amount;

Line 1650: FND_PROFILE.VALUE('AP_IAW_USER');

1646: l_l_hist.line_number := l_line_number;
1647: l_l_hist.amount_approved :=
1648: l_amount;
1649: l_l_hist.created_by :=
1650: FND_PROFILE.VALUE('AP_IAW_USER');
1651: l_l_hist.creation_date := sysdate;
1652: l_l_hist.last_updated_by :=
1653: FND_PROFILE.VALUE('AP_IAW_USER');
1654: l_l_hist.last_update_date := sysdate;

Line 1653: FND_PROFILE.VALUE('AP_IAW_USER');

1649: l_l_hist.created_by :=
1650: FND_PROFILE.VALUE('AP_IAW_USER');
1651: l_l_hist.creation_date := sysdate;
1652: l_l_hist.last_updated_by :=
1653: FND_PROFILE.VALUE('AP_IAW_USER');
1654: l_l_hist.last_update_date := sysdate;
1655: l_l_hist.last_update_login := -1;
1656: l_l_hist.item_class := 'APINV';
1657: l_l_hist.item_id := l_invoice_id;

Line 1993: nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1),

1989: l_next_approver.ACTION_TYPE_ORDER_NUMBER,
1990: l_next_approver.GROUP_OR_CHAIN_ORDER_NUMBER,
1991: l_next_approver.MEMBER_ORDER_NUMBER,
1992: l_next_approver.APPROVER_ORDER_NUMBER,
1993: nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1),
1994: sysdate,
1995: nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
1996: -1),
1997: nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1),

Line 1995: nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),

1991: l_next_approver.MEMBER_ORDER_NUMBER,
1992: l_next_approver.APPROVER_ORDER_NUMBER,
1993: nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1),
1994: sysdate,
1995: nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
1996: -1),
1997: nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1),
1998: sysdate,
1999: 200,

Line 1997: nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1),

1993: nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1),
1994: sysdate,
1995: nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
1996: -1),
1997: nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1),
1998: sysdate,
1999: 200,
2000: 0,
2001: sysdate,

Line 2024: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);

2020: l_hist_rec.ITERATION := l_iteration;
2021: l_hist_rec.RESPONSE := 'SENT';
2022: l_hist_rec.APPROVER_ID := l_next_approver.ORIG_SYSTEM_ID;
2023: l_hist_rec.APPROVER_NAME:= l_next_approver.DISPLAY_NAME;
2024: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
2025: l_hist_rec.CREATION_DATE:= sysdate;
2026: l_hist_rec.LAST_UPDATE_DATE := sysdate;
2027: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
2028: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);

Line 2027: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);

2023: l_hist_rec.APPROVER_NAME:= l_next_approver.DISPLAY_NAME;
2024: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
2025: l_hist_rec.CREATION_DATE:= sysdate;
2026: l_hist_rec.LAST_UPDATE_DATE := sysdate;
2027: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
2028: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);
2029: l_hist_rec.ORG_ID := l_org_id;
2030:
2031:

Line 2028: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);

2024: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
2025: l_hist_rec.CREATION_DATE:= sysdate;
2026: l_hist_rec.LAST_UPDATE_DATE := sysdate;
2027: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
2028: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);
2029: l_hist_rec.ORG_ID := l_org_id;
2030:
2031:
2032: insert_history_table(p_hist_rec => l_hist_rec);

Line 2161: nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1),

2157: l_next_approver.ACTION_TYPE_ORDER_NUMBER,
2158: l_next_approver.GROUP_OR_CHAIN_ORDER_NUMBER,
2159: l_next_approver.MEMBER_ORDER_NUMBER,
2160: l_next_approver.APPROVER_ORDER_NUMBER,
2161: nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1),
2162: sysdate,
2163: nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
2164: -1),
2165: nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1),

Line 2163: nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),

2159: l_next_approver.MEMBER_ORDER_NUMBER,
2160: l_next_approver.APPROVER_ORDER_NUMBER,
2161: nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1),
2162: sysdate,
2163: nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
2164: -1),
2165: nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1),
2166: sysdate,
2167: 200,

Line 2165: nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1),

2161: nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1),
2162: sysdate,
2163: nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
2164: -1),
2165: nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1),
2166: sysdate,
2167: 200,
2168: 0,
2169: sysdate,

Line 2186: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID

2182: l_hist_rec.ITERATION := l_iteration;
2183: l_hist_rec.RESPONSE := 'SENT';
2184: l_hist_rec.APPROVER_ID := l_next_approver.ORIG_SYSTEM_ID;
2185: l_hist_rec.APPROVER_NAME:= l_next_approver.DISPLAY_NAME;
2186: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID
2187: ')),-1);
2188: l_hist_rec.CREATION_DATE:= sysdate;
2189: l_hist_rec.LAST_UPDATE_DATE := sysdate;
2190: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USE

Line 2190: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USE

2186: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID
2187: ')),-1);
2188: l_hist_rec.CREATION_DATE:= sysdate;
2189: l_hist_rec.LAST_UPDATE_DATE := sysdate;
2190: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USE
2191: R_ID')),-1);
2192: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LO
2193: GIN_ID')),-1);
2194: l_hist_rec.ORG_ID := l_org_id;

Line 2192: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LO

2188: l_hist_rec.CREATION_DATE:= sysdate;
2189: l_hist_rec.LAST_UPDATE_DATE := sysdate;
2190: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USE
2191: R_ID')),-1);
2192: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LO
2193: GIN_ID')),-1);
2194: l_hist_rec.ORG_ID := l_org_id;
2195:
2196:

Line 2928: l_user_id := nvl(to_number(fnd_profile.value('USER_ID')),-1);

2924: itemkey,
2925: 'ITERATION');
2926:
2927:
2928: l_user_id := nvl(to_number(fnd_profile.value('USER_ID')),-1);
2929: l_login_id := nvl(to_number(fnd_profile.value('LOGIN_ID')),-1);
2930: IF nvl(l_esc_flag,'N') = 'N' THEN
2931: l_role := l_document_approver;
2932: ELSE

Line 2929: l_login_id := nvl(to_number(fnd_profile.value('LOGIN_ID')),-1);

2925: 'ITERATION');
2926:
2927:
2928: l_user_id := nvl(to_number(fnd_profile.value('USER_ID')),-1);
2929: l_login_id := nvl(to_number(fnd_profile.value('LOGIN_ID')),-1);
2930: IF nvl(l_esc_flag,'N') = 'N' THEN
2931: l_role := l_document_approver;
2932: ELSE
2933: l_role := l_esc_role_name;

Line 2963: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);

2959: ELSE
2960: l_hist_rec.APPROVER_ID := l_esc_approver_id;
2961: l_hist_rec.APPROVER_NAME:= l_esc_approver_name;
2962: END IF;
2963: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
2964: l_hist_rec.CREATION_DATE:= sysdate;
2965: l_hist_rec.LAST_UPDATE_DATE := sysdate;
2966: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
2967: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);

Line 2966: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);

2962: END IF;
2963: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
2964: l_hist_rec.CREATION_DATE:= sysdate;
2965: l_hist_rec.LAST_UPDATE_DATE := sysdate;
2966: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
2967: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);
2968: l_hist_rec.ORG_ID := l_org_id;
2969: l_hist_rec.AMOUNT_APPROVED := l_invoice_total;
2970:

Line 2967: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);

2963: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
2964: l_hist_rec.CREATION_DATE:= sysdate;
2965: l_hist_rec.LAST_UPDATE_DATE := sysdate;
2966: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
2967: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);
2968: l_hist_rec.ORG_ID := l_org_id;
2969: l_hist_rec.AMOUNT_APPROVED := l_invoice_total;
2970:
2971: l_debug_info := 'Before calling insert_history_table';

Line 3100: l_user_id := nvl(to_number(fnd_profile.value('USER_ID')),-1);

3096: l_esc_role_actual := WF_ENGINE.GetItemAttrText(itemtype,
3097: itemkey,
3098: 'ESC_ROLE_ACTUAL');
3099: -- added for the delegation enhancement
3100: l_user_id := nvl(to_number(fnd_profile.value('USER_ID')),-1);
3101: l_login_id := nvl(to_number(fnd_profile.value('LOGIN_ID')),-1);
3102: IF nvl(l_esc_flag,'N') = 'N' THEN
3103: l_role := l_role_name; -- added for the delegation enhancement
3104: --l_role := l_document_approver;

Line 3101: l_login_id := nvl(to_number(fnd_profile.value('LOGIN_ID')),-1);

3097: itemkey,
3098: 'ESC_ROLE_ACTUAL');
3099: -- added for the delegation enhancement
3100: l_user_id := nvl(to_number(fnd_profile.value('USER_ID')),-1);
3101: l_login_id := nvl(to_number(fnd_profile.value('LOGIN_ID')),-1);
3102: IF nvl(l_esc_flag,'N') = 'N' THEN
3103: l_role := l_role_name; -- added for the delegation enhancement
3104: --l_role := l_document_approver;
3105: ELSE

Line 3137: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);

3133: ELSE
3134: l_hist_rec.APPROVER_ID := l_esc_approver_id;
3135: l_hist_rec.APPROVER_NAME:= l_esc_approver_name;
3136: END IF;
3137: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
3138: l_hist_rec.CREATION_DATE:= sysdate;
3139: l_hist_rec.LAST_UPDATE_DATE := sysdate;
3140: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
3141: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);

Line 3140: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);

3136: END IF;
3137: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
3138: l_hist_rec.CREATION_DATE:= sysdate;
3139: l_hist_rec.LAST_UPDATE_DATE := sysdate;
3140: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
3141: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);
3142: l_hist_rec.ORG_ID := l_org_id;
3143: l_hist_rec.AMOUNT_APPROVED := l_invoice_total;
3144: l_hist_rec.APPROVER_COMMENTS := l_comments;

Line 3141: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);

3137: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
3138: l_hist_rec.CREATION_DATE:= sysdate;
3139: l_hist_rec.LAST_UPDATE_DATE := sysdate;
3140: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
3141: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);
3142: l_hist_rec.ORG_ID := l_org_id;
3143: l_hist_rec.AMOUNT_APPROVED := l_invoice_total;
3144: l_hist_rec.APPROVER_COMMENTS := l_comments;
3145:

Line 3288: l_user_id := nvl(to_number(fnd_profile.value('USER_ID')),-1);

3284: l_notf_iteration := WF_ENGINE.GETITEMATTRNumber(itemtype,
3285: itemkey,
3286: 'NOTF_ITERATION');
3287:
3288: l_user_id := nvl(to_number(fnd_profile.value('USER_ID')),-1);
3289: l_login_id := nvl(to_number(fnd_profile.value('LOGIN_ID')),-1);
3290: IF nvl(l_esc_flag,'N') = 'N' THEN
3291: l_role := l_role_name;
3292: ELSE

Line 3289: l_login_id := nvl(to_number(fnd_profile.value('LOGIN_ID')),-1);

3285: itemkey,
3286: 'NOTF_ITERATION');
3287:
3288: l_user_id := nvl(to_number(fnd_profile.value('USER_ID')),-1);
3289: l_login_id := nvl(to_number(fnd_profile.value('LOGIN_ID')),-1);
3290: IF nvl(l_esc_flag,'N') = 'N' THEN
3291: l_role := l_role_name;
3292: ELSE
3293: l_role := l_esc_role_name;

Line 3322: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);

3318: l_hist_rec.APPROVER_ID := l_esc_approver_id;
3319: l_hist_rec.APPROVER_NAME:= l_esc_approver_name;
3320: END IF;
3321: l_hist_rec.APPROVER_COMMENTS := l_comments;
3322: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
3323: l_hist_rec.CREATION_DATE:= sysdate;
3324: l_hist_rec.LAST_UPDATE_DATE := sysdate;
3325: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
3326: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);

Line 3325: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);

3321: l_hist_rec.APPROVER_COMMENTS := l_comments;
3322: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
3323: l_hist_rec.CREATION_DATE:= sysdate;
3324: l_hist_rec.LAST_UPDATE_DATE := sysdate;
3325: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
3326: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);
3327: l_hist_rec.ORG_ID := l_org_id;
3328: --update AME status
3329: --For Future check with ame as to when updateApprovalStatuses will be

Line 3326: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);

3322: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
3323: l_hist_rec.CREATION_DATE:= sysdate;
3324: l_hist_rec.LAST_UPDATE_DATE := sysdate;
3325: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
3326: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);
3327: l_hist_rec.ORG_ID := l_org_id;
3328: --update AME status
3329: --For Future check with ame as to when updateApprovalStatuses will be
3330: --available so there will not be a need to loop.

Line 3361: l_user_id := nvl(to_number(fnd_profile.value('USER_ID')),-1);

3357: END LOOP;
3358: CLOSE Items_Cur;
3359:
3360:
3361: l_user_id := nvl(to_number(fnd_profile.value('USER_ID')),-1);
3362: l_login_id := nvl(to_number(fnd_profile.value('LOGIN_ID')),-1);
3363: UPDATE AP_INVOICE_LINES
3364: SET wfapproval_status = 'REJECTED'
3365: ,Last_Update_Date = sysdate

Line 3362: l_login_id := nvl(to_number(fnd_profile.value('LOGIN_ID')),-1);

3358: CLOSE Items_Cur;
3359:
3360:
3361: l_user_id := nvl(to_number(fnd_profile.value('USER_ID')),-1);
3362: l_login_id := nvl(to_number(fnd_profile.value('LOGIN_ID')),-1);
3363: UPDATE AP_INVOICE_LINES
3364: SET wfapproval_status = 'REJECTED'
3365: ,Last_Update_Date = sysdate
3366: ,Last_Updated_By = l_user_id

Line 3524: l_user_id := nvl(to_number(fnd_profile.value('USER_ID')),-1);

3520: itemkey,
3521: 'ESC_ROLE_ACTUAL');
3522: -- added for the delegation enhancement
3523:
3524: l_user_id := nvl(to_number(fnd_profile.value('USER_ID')),-1);
3525: l_login_id := nvl(to_number(fnd_profile.value('LOGIN_ID')),-1);
3526: IF nvl(l_esc_flag,'N') = 'N' THEN
3527: l_role := l_role_name; -- added for the delegation enhancement
3528: --l_role := l_document_approver;

Line 3525: l_login_id := nvl(to_number(fnd_profile.value('LOGIN_ID')),-1);

3521: 'ESC_ROLE_ACTUAL');
3522: -- added for the delegation enhancement
3523:
3524: l_user_id := nvl(to_number(fnd_profile.value('USER_ID')),-1);
3525: l_login_id := nvl(to_number(fnd_profile.value('LOGIN_ID')),-1);
3526: IF nvl(l_esc_flag,'N') = 'N' THEN
3527: l_role := l_role_name; -- added for the delegation enhancement
3528: --l_role := l_document_approver;
3529: ELSE

Line 3534: l_user_id := nvl(to_number(fnd_profile.value('USER_ID')),-1);

3530: l_role := l_esc_role_actual ;
3531: --l_role := l_esc_role_name;
3532: END IF; */
3533:
3534: l_user_id := nvl(to_number(fnd_profile.value('USER_ID')),-1);
3535: l_login_id := nvl(to_number(fnd_profile.value('LOGIN_ID')),-1);
3536: IF nvl(l_esc_flag,'N') = 'N' THEN
3537: l_role := l_role_name;
3538: ELSE

Line 3535: l_login_id := nvl(to_number(fnd_profile.value('LOGIN_ID')),-1);

3531: --l_role := l_esc_role_name;
3532: END IF; */
3533:
3534: l_user_id := nvl(to_number(fnd_profile.value('USER_ID')),-1);
3535: l_login_id := nvl(to_number(fnd_profile.value('LOGIN_ID')),-1);
3536: IF nvl(l_esc_flag,'N') = 'N' THEN
3537: l_role := l_role_name;
3538: ELSE
3539: l_role := l_esc_role_name;

Line 3567: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);

3563: ELSE
3564: l_hist_rec.APPROVER_ID := l_esc_approver_id;
3565: l_hist_rec.APPROVER_NAME:= l_esc_approver_name;
3566: END IF;
3567: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
3568: l_hist_rec.CREATION_DATE:= sysdate;
3569: l_hist_rec.LAST_UPDATE_DATE := sysdate;
3570: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
3571: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);

Line 3570: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);

3566: END IF;
3567: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
3568: l_hist_rec.CREATION_DATE:= sysdate;
3569: l_hist_rec.LAST_UPDATE_DATE := sysdate;
3570: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
3571: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);
3572: l_hist_rec.ORG_ID := l_org_id;
3573: --update AME status
3574: --For Future check with ame as to when updateApprovalStatuses will be

Line 3571: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);

3567: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
3568: l_hist_rec.CREATION_DATE:= sysdate;
3569: l_hist_rec.LAST_UPDATE_DATE := sysdate;
3570: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
3571: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);
3572: l_hist_rec.ORG_ID := l_org_id;
3573: --update AME status
3574: --For Future check with ame as to when updateApprovalStatuses will be
3575: --available so there will not be a need to loop.

Line 3606: l_user_id := nvl(to_number(fnd_profile.value('USER_ID')),-1);

3602: END LOOP;
3603: CLOSE Items_Cur;
3604:
3605:
3606: l_user_id := nvl(to_number(fnd_profile.value('USER_ID')),-1);
3607: l_login_id := nvl(to_number(fnd_profile.value('LOGIN_ID')),-1);
3608: BEGIN
3609:
3610: SELECT invoice_key

Line 3607: l_login_id := nvl(to_number(fnd_profile.value('LOGIN_ID')),-1);

3603: CLOSE Items_Cur;
3604:
3605:
3606: l_user_id := nvl(to_number(fnd_profile.value('USER_ID')),-1);
3607: l_login_id := nvl(to_number(fnd_profile.value('LOGIN_ID')),-1);
3608: BEGIN
3609:
3610: SELECT invoice_key
3611: INTO l_invoice_key

Line 3822: l_user_id := nvl(to_number(fnd_profile.value('USER_ID')),-1);

3818: itemkey,
3819: 'NOTF_ITERATION');
3820:
3821:
3822: l_user_id := nvl(to_number(fnd_profile.value('USER_ID')),-1);
3823: l_login_id := nvl(to_number(fnd_profile.value('LOGIN_ID')),-1);
3824:
3825:
3826: l_hist_rec.HISTORY_TYPE := 'DOCUMENTAPPROVAL';

Line 3823: l_login_id := nvl(to_number(fnd_profile.value('LOGIN_ID')),-1);

3819: 'NOTF_ITERATION');
3820:
3821:
3822: l_user_id := nvl(to_number(fnd_profile.value('USER_ID')),-1);
3823: l_login_id := nvl(to_number(fnd_profile.value('LOGIN_ID')),-1);
3824:
3825:
3826: l_hist_rec.HISTORY_TYPE := 'DOCUMENTAPPROVAL';
3827: l_hist_rec.INVOICE_ID := l_invoice_id;

Line 3834: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);

3830: l_hist_rec.APPROVER_COMMENTS := l_comments;
3831: l_hist_rec.RESPONSE := 'ACCEPT';
3832: l_hist_rec.APPROVER_ID := l_supplier_person_id;
3833: l_hist_rec.APPROVER_NAME:= l_supplier_name;
3834: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
3835: l_hist_rec.CREATION_DATE:= sysdate;
3836: l_hist_rec.LAST_UPDATE_DATE := sysdate;
3837: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
3838: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);

Line 3837: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);

3833: l_hist_rec.APPROVER_NAME:= l_supplier_name;
3834: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
3835: l_hist_rec.CREATION_DATE:= sysdate;
3836: l_hist_rec.LAST_UPDATE_DATE := sysdate;
3837: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
3838: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);
3839: l_hist_rec.ORG_ID := l_org_id;
3840: --update AME status
3841: --For Future check with ame as to when updateApprovalStatuses will be

Line 3838: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);

3834: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
3835: l_hist_rec.CREATION_DATE:= sysdate;
3836: l_hist_rec.LAST_UPDATE_DATE := sysdate;
3837: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
3838: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);
3839: l_hist_rec.ORG_ID := l_org_id;
3840: --update AME status
3841: --For Future check with ame as to when updateApprovalStatuses will be
3842: --available so there will not be a need to loop.

Line 3997: l_user_id := nvl(to_number(fnd_profile.value('USER_ID')),-1);

3993: itemkey,
3994: 'NOTF_ITERATION');
3995:
3996:
3997: l_user_id := nvl(to_number(fnd_profile.value('USER_ID')),-1);
3998: l_login_id := nvl(to_number(fnd_profile.value('LOGIN_ID')),-1);
3999:
4000: l_hist_rec.HISTORY_TYPE := 'DOCUMENTAPPROVAL';
4001: l_hist_rec.INVOICE_ID := l_invoice_id;

Line 3998: l_login_id := nvl(to_number(fnd_profile.value('LOGIN_ID')),-1);

3994: 'NOTF_ITERATION');
3995:
3996:
3997: l_user_id := nvl(to_number(fnd_profile.value('USER_ID')),-1);
3998: l_login_id := nvl(to_number(fnd_profile.value('LOGIN_ID')),-1);
3999:
4000: l_hist_rec.HISTORY_TYPE := 'DOCUMENTAPPROVAL';
4001: l_hist_rec.INVOICE_ID := l_invoice_id;
4002: l_hist_rec.ITERATION := l_iteration;

Line 4008: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);

4004: l_hist_rec.APPROVER_COMMENTS := l_comments;
4005: l_hist_rec.RESPONSE := 'ACCEPT';
4006: l_hist_rec.APPROVER_ID := l_approver_id;
4007: l_hist_rec.APPROVER_NAME:= l_approver_name;
4008: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
4009: l_hist_rec.CREATION_DATE:= sysdate;
4010: l_hist_rec.LAST_UPDATE_DATE := sysdate;
4011: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
4012: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);

Line 4011: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);

4007: l_hist_rec.APPROVER_NAME:= l_approver_name;
4008: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
4009: l_hist_rec.CREATION_DATE:= sysdate;
4010: l_hist_rec.LAST_UPDATE_DATE := sysdate;
4011: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
4012: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);
4013: l_hist_rec.ORG_ID := l_org_id;
4014: --update AME status
4015: --For Future check with ame as to when updateApprovalStatuses will be

Line 4012: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);

4008: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
4009: l_hist_rec.CREATION_DATE:= sysdate;
4010: l_hist_rec.LAST_UPDATE_DATE := sysdate;
4011: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
4012: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);
4013: l_hist_rec.ORG_ID := l_org_id;
4014: --update AME status
4015: --For Future check with ame as to when updateApprovalStatuses will be
4016: --available so there will not be a need to loop.

Line 4179: l_user_id := nvl(to_number(fnd_profile.value('USER_ID')),-1);

4175: itemkey,
4176: 'NOTF_ITERATION');
4177:
4178:
4179: l_user_id := nvl(to_number(fnd_profile.value('USER_ID')),-1);
4180: l_login_id := nvl(to_number(fnd_profile.value('LOGIN_ID')),-1);
4181:
4182: l_debug_info := 'Before Update Approvers table';
4183: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 4180: l_login_id := nvl(to_number(fnd_profile.value('LOGIN_ID')),-1);

4176: 'NOTF_ITERATION');
4177:
4178:
4179: l_user_id := nvl(to_number(fnd_profile.value('USER_ID')),-1);
4180: l_login_id := nvl(to_number(fnd_profile.value('LOGIN_ID')),-1);
4181:
4182: l_debug_info := 'Before Update Approvers table';
4183: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4184: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||

Line 4203: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);

4199: l_hist_rec.APPROVER_COMMENTS := l_comments;
4200: l_hist_rec.RESPONSE := 'CANCEL';
4201: l_hist_rec.APPROVER_ID := l_approver_id;
4202: l_hist_rec.APPROVER_NAME:= l_approver_name;
4203: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
4204: l_hist_rec.CREATION_DATE:= sysdate;
4205: l_hist_rec.LAST_UPDATE_DATE := sysdate;
4206: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
4207: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);

Line 4206: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);

4202: l_hist_rec.APPROVER_NAME:= l_approver_name;
4203: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
4204: l_hist_rec.CREATION_DATE:= sysdate;
4205: l_hist_rec.LAST_UPDATE_DATE := sysdate;
4206: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
4207: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);
4208: l_hist_rec.ORG_ID := l_org_id;
4209: --update AME status
4210: --For Future check with ame as to when updateApprovalStatuses will be

Line 4207: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);

4203: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
4204: l_hist_rec.CREATION_DATE:= sysdate;
4205: l_hist_rec.LAST_UPDATE_DATE := sysdate;
4206: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
4207: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);
4208: l_hist_rec.ORG_ID := l_org_id;
4209: --update AME status
4210: --For Future check with ame as to when updateApprovalStatuses will be
4211: --available so there will not be a need to loop.

Line 4528: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);

4524: l_hist_rec.NOTIFICATION_ORDER := l_notf_iteration;
4525: l_hist_rec.RESPONSE := 'SENT';
4526: l_hist_rec.APPROVER_ID := l_person_id;
4527: l_hist_rec.APPROVER_NAME:= l_display_name;
4528: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
4529: l_hist_rec.CREATION_DATE:= sysdate;
4530: l_hist_rec.LAST_UPDATE_DATE := sysdate;
4531: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
4532: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);

Line 4531: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);

4527: l_hist_rec.APPROVER_NAME:= l_display_name;
4528: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
4529: l_hist_rec.CREATION_DATE:= sysdate;
4530: l_hist_rec.LAST_UPDATE_DATE := sysdate;
4531: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
4532: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);
4533: l_hist_rec.ORG_ID := l_org_id;
4534: l_hist_rec.AMOUNT_APPROVED := 0;
4535: l_hist_rec.HOLD_ID := p_hold_id;

Line 4532: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);

4528: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
4529: l_hist_rec.CREATION_DATE:= sysdate;
4530: l_hist_rec.LAST_UPDATE_DATE := sysdate;
4531: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
4532: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);
4533: l_hist_rec.ORG_ID := l_org_id;
4534: l_hist_rec.AMOUNT_APPROVED := 0;
4535: l_hist_rec.HOLD_ID := p_hold_id;
4536:

Line 4910: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);

4906: l_hist_rec.RESPONSE := 'SENT';
4907: l_hist_rec.APPROVER_ID := l_next_approver.ORIG_SYSTEM_ID;
4908: /********** POTENTIAL BUG ABOVE********************/
4909: l_hist_rec.APPROVER_NAME:= l_display_name;
4910: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
4911: l_hist_rec.CREATION_DATE:= sysdate;
4912: l_hist_rec.LAST_UPDATE_DATE := sysdate;
4913: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
4914: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);

Line 4913: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);

4909: l_hist_rec.APPROVER_NAME:= l_display_name;
4910: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
4911: l_hist_rec.CREATION_DATE:= sysdate;
4912: l_hist_rec.LAST_UPDATE_DATE := sysdate;
4913: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
4914: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);
4915: l_hist_rec.ORG_ID := l_org_id;
4916: l_hist_rec.AMOUNT_APPROVED := 0;
4917:

Line 4914: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);

4910: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
4911: l_hist_rec.CREATION_DATE:= sysdate;
4912: l_hist_rec.LAST_UPDATE_DATE := sysdate;
4913: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
4914: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);
4915: l_hist_rec.ORG_ID := l_org_id;
4916: l_hist_rec.AMOUNT_APPROVED := 0;
4917:
4918: insert_history_table(p_hist_rec => l_hist_rec);

Line 5092: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);

5088: l_hist_rec.NOTIFICATION_ORDER := l_notf_iteration;
5089: l_hist_rec.RESPONSE := 'ESCALATED';
5090: l_hist_rec.APPROVER_ID := l_esc_approver_id;
5091: l_hist_rec.APPROVER_NAME:= l_esc_approver_name;
5092: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
5093: l_hist_rec.CREATION_DATE:= sysdate;
5094: l_hist_rec.LAST_UPDATE_DATE := sysdate;
5095: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
5096: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);

Line 5095: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);

5091: l_hist_rec.APPROVER_NAME:= l_esc_approver_name;
5092: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
5093: l_hist_rec.CREATION_DATE:= sysdate;
5094: l_hist_rec.LAST_UPDATE_DATE := sysdate;
5095: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
5096: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);
5097: l_hist_rec.ORG_ID := l_org_id;
5098: l_hist_rec.AMOUNT_APPROVED := l_invoice_total;
5099:

Line 5096: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);

5092: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
5093: l_hist_rec.CREATION_DATE:= sysdate;
5094: l_hist_rec.LAST_UPDATE_DATE := sysdate;
5095: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
5096: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);
5097: l_hist_rec.ORG_ID := l_org_id;
5098: l_hist_rec.AMOUNT_APPROVED := l_invoice_total;
5099:
5100: l_debug_info := 'Before insert_history_table';

Line 5232: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);

5228: l_hist_rec.APPROVER_COMMENTS := l_comments;
5229: l_hist_rec.RESPONSE := 'ESCALATED';
5230: l_hist_rec.APPROVER_ID := l_esc_approver_id;
5231: l_hist_rec.APPROVER_NAME:= l_esc_approver_name;
5232: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
5233: l_hist_rec.CREATION_DATE:= sysdate;
5234: l_hist_rec.LAST_UPDATE_DATE := sysdate;
5235: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
5236: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);

Line 5235: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);

5231: l_hist_rec.APPROVER_NAME:= l_esc_approver_name;
5232: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
5233: l_hist_rec.CREATION_DATE:= sysdate;
5234: l_hist_rec.LAST_UPDATE_DATE := sysdate;
5235: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
5236: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);
5237: l_hist_rec.ORG_ID := l_org_id;
5238: --update AME status
5239: --For Future check with ame as to when updateApprovalStatuses will be

Line 5236: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);

5232: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
5233: l_hist_rec.CREATION_DATE:= sysdate;
5234: l_hist_rec.LAST_UPDATE_DATE := sysdate;
5235: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
5236: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);
5237: l_hist_rec.ORG_ID := l_org_id;
5238: --update AME status
5239: --For Future check with ame as to when updateApprovalStatuses will be
5240: --available so there will not be a need to loop.

Line 6104: l_user_id := nvl(to_number(fnd_profile.value('USER_ID')),-1);

6100: l_esc_approver_id := WF_ENGINE.GETITEMATTRNumber('APINVAPR',
6101: p_itemkey,
6102: 'ESC_APPROVER_ID');
6103:
6104: l_user_id := nvl(to_number(fnd_profile.value('USER_ID')),-1);
6105: l_login_id := nvl(to_number(fnd_profile.value('LOGIN_ID')),-1);
6106: IF nvl(l_esc_flag,'N') = 'N' THEN
6107: l_role := l_role_name;
6108: ELSE

Line 6105: l_login_id := nvl(to_number(fnd_profile.value('LOGIN_ID')),-1);

6101: p_itemkey,
6102: 'ESC_APPROVER_ID');
6103:
6104: l_user_id := nvl(to_number(fnd_profile.value('USER_ID')),-1);
6105: l_login_id := nvl(to_number(fnd_profile.value('LOGIN_ID')),-1);
6106: IF nvl(l_esc_flag,'N') = 'N' THEN
6107: l_role := l_role_name;
6108: ELSE
6109: l_role := l_esc_role_name;

Line 6141: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);

6137: ELSE
6138: l_hist_rec.APPROVER_ID := l_esc_approver_id;
6139: l_hist_rec.APPROVER_NAME:= l_esc_approver_name;
6140: END IF;
6141: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
6142: l_hist_rec.CREATION_DATE:= sysdate;
6143: l_hist_rec.LAST_UPDATE_DATE := sysdate;
6144: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
6145: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);

Line 6144: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);

6140: END IF;
6141: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
6142: l_hist_rec.CREATION_DATE:= sysdate;
6143: l_hist_rec.LAST_UPDATE_DATE := sysdate;
6144: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
6145: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);
6146: l_hist_rec.ORG_ID := l_org_id;
6147: --update AME status
6148: --For Future check with ame as to when updateApprovalStatuses will be

Line 6145: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);

6141: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
6142: l_hist_rec.CREATION_DATE:= sysdate;
6143: l_hist_rec.LAST_UPDATE_DATE := sysdate;
6144: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
6145: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);
6146: l_hist_rec.ORG_ID := l_org_id;
6147: --update AME status
6148: --For Future check with ame as to when updateApprovalStatuses will be
6149: --available so there will not be a need to loop.

Line 6186: l_user_id := nvl(to_number(fnd_profile.value('USER_ID')),-1);

6182: insert_history_table(p_hist_rec => l_hist_rec);
6183: CLOSE Items_Cur;
6184:
6185:
6186: l_user_id := nvl(to_number(fnd_profile.value('USER_ID')),-1);
6187: l_login_id := nvl(to_number(fnd_profile.value('LOGIN_ID')),-1);
6188:
6189: IF l_response = 'REJECTED' THEN
6190: UPDATE AP_INVOICE_LINES_ALL

Line 6187: l_login_id := nvl(to_number(fnd_profile.value('LOGIN_ID')),-1);

6183: CLOSE Items_Cur;
6184:
6185:
6186: l_user_id := nvl(to_number(fnd_profile.value('USER_ID')),-1);
6187: l_login_id := nvl(to_number(fnd_profile.value('LOGIN_ID')),-1);
6188:
6189: IF l_response = 'REJECTED' THEN
6190: UPDATE AP_INVOICE_LINES_ALL
6191: SET wfapproval_status = 'REJECTED'

Line 7714: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);

7710:
7711: l_hist_rec.APPROVER_ID := l_orig_sys_id;
7712: l_hist_rec.APPROVER_NAME := l_display_name;
7713:
7714: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
7715: l_hist_rec.CREATION_DATE := sysdate;
7716: l_hist_rec.LAST_UPDATE_DATE := sysdate;
7717: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
7718: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);

Line 7717: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);

7713:
7714: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
7715: l_hist_rec.CREATION_DATE := sysdate;
7716: l_hist_rec.LAST_UPDATE_DATE := sysdate;
7717: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
7718: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);
7719: l_hist_rec.ORG_ID := l_org_id;
7720: l_hist_rec.AMOUNT_APPROVED := l_invoice_total;--0;
7721: l_hist_rec.NOTIFICATION_ORDER := l_notf_iteration;

Line 7718: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);

7714: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
7715: l_hist_rec.CREATION_DATE := sysdate;
7716: l_hist_rec.LAST_UPDATE_DATE := sysdate;
7717: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
7718: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);
7719: l_hist_rec.ORG_ID := l_org_id;
7720: l_hist_rec.AMOUNT_APPROVED := l_invoice_total;--0;
7721: l_hist_rec.NOTIFICATION_ORDER := l_notf_iteration;
7722: l_hist_rec.APPROVER_COMMENTS := l_comments;

Line 8071: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);

8067: l_hist_rec.ITERATION := l_iteration;
8068: l_hist_rec.RESPONSE := l_status;
8069: l_hist_rec.APPROVER_ID := l_orig_sys_id;
8070: l_hist_rec.APPROVER_NAME := l_display_name;
8071: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
8072: l_hist_rec.CREATION_DATE := sysdate;
8073: l_hist_rec.LAST_UPDATE_DATE := sysdate;
8074: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
8075: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);

Line 8074: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);

8070: l_hist_rec.APPROVER_NAME := l_display_name;
8071: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
8072: l_hist_rec.CREATION_DATE := sysdate;
8073: l_hist_rec.LAST_UPDATE_DATE := sysdate;
8074: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
8075: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);
8076: l_hist_rec.ORG_ID := l_org_id;
8077: l_hist_rec.AMOUNT_APPROVED := 0;
8078: l_hist_rec.NOTIFICATION_ORDER := l_notf_iteration;

Line 8075: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);

8071: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
8072: l_hist_rec.CREATION_DATE := sysdate;
8073: l_hist_rec.LAST_UPDATE_DATE := sysdate;
8074: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
8075: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);
8076: l_hist_rec.ORG_ID := l_org_id;
8077: l_hist_rec.AMOUNT_APPROVED := 0;
8078: l_hist_rec.NOTIFICATION_ORDER := l_notf_iteration;
8079: l_hist_rec.APPROVER_COMMENTS := l_comments;