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 284: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);

280: l_hist_rec.ITERATION := l_iteration;
281: l_hist_rec.RESPONSE := 'SENT';
282: l_hist_rec.APPROVER_ID := l_next_approver.person_id;
283: l_hist_rec.APPROVER_NAME:= l_display_name;
284: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
285: l_hist_rec.CREATION_DATE:= sysdate;
286: l_hist_rec.LAST_UPDATE_DATE := sysdate;
287: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
288: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);

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

283: l_hist_rec.APPROVER_NAME:= l_display_name;
284: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
285: l_hist_rec.CREATION_DATE:= sysdate;
286: l_hist_rec.LAST_UPDATE_DATE := sysdate;
287: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
288: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);
289: l_hist_rec.ORG_ID := l_org_id;
290: l_hist_rec.AMOUNT_APPROVED := 0;
291: l_hist_rec.HOLD_ID := l_hold_id;

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

284: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
285: l_hist_rec.CREATION_DATE:= sysdate;
286: l_hist_rec.LAST_UPDATE_DATE := sysdate;
287: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
288: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);
289: l_hist_rec.ORG_ID := l_org_id;
290: l_hist_rec.AMOUNT_APPROVED := 0;
291: l_hist_rec.HOLD_ID := l_hold_id;
292: l_hist_rec.NOTIFICATION_ORDER := l_notf_iteration;

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

437: l_hist_rec.NOTIFICATION_ORDER := l_notf_iteration;
438: l_hist_rec.RESPONSE := 'ACKNOWLEDGE';
439: l_hist_rec.APPROVER_ID := l_approver_id;
440: l_hist_rec.APPROVER_NAME:= l_display_name;
441: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
442: l_hist_rec.CREATION_DATE:= sysdate;
443: l_hist_rec.LAST_UPDATE_DATE := sysdate;
444: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
445: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);

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

440: l_hist_rec.APPROVER_NAME:= l_display_name;
441: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
442: l_hist_rec.CREATION_DATE:= sysdate;
443: l_hist_rec.LAST_UPDATE_DATE := sysdate;
444: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
445: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);
446: l_hist_rec.ORG_ID := l_org_id;
447: l_hist_rec.AMOUNT_APPROVED := null;
448: l_hist_rec.HOLD_ID := l_hold_id;

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

441: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
442: l_hist_rec.CREATION_DATE:= sysdate;
443: l_hist_rec.LAST_UPDATE_DATE := sysdate;
444: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
445: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);
446: l_hist_rec.ORG_ID := l_org_id;
447: l_hist_rec.AMOUNT_APPROVED := null;
448: l_hist_rec.HOLD_ID := l_hold_id;
449: -- bug 8940578

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

535: l_hist_rec.NOTIFICATION_ORDER := l_notf_iteration;
536: l_hist_rec.RESPONSE := 'RELEASE';
537: l_hist_rec.APPROVER_ID := l_approver_id;
538: l_hist_rec.APPROVER_NAME:= l_display_name;
539: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
540: l_hist_rec.CREATION_DATE:= sysdate;
541: l_hist_rec.LAST_UPDATE_DATE := sysdate;
542: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
543: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);

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

538: l_hist_rec.APPROVER_NAME:= l_display_name;
539: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
540: l_hist_rec.CREATION_DATE:= sysdate;
541: l_hist_rec.LAST_UPDATE_DATE := sysdate;
542: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
543: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);
544: l_hist_rec.ORG_ID := l_org_id;
545: l_hist_rec.AMOUNT_APPROVED := null;
546: l_hist_rec.HOLD_ID := l_hold_id;

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

539: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
540: l_hist_rec.CREATION_DATE:= sysdate;
541: l_hist_rec.LAST_UPDATE_DATE := sysdate;
542: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
543: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);
544: l_hist_rec.ORG_ID := l_org_id;
545: l_hist_rec.AMOUNT_APPROVED := null;
546: l_hist_rec.HOLD_ID := l_hold_id;
547: l_hist_rec.APPROVER_COMMENTS := l_comments; --Bug9069200

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

646: l_hist_rec.NOTIFICATION_ORDER := l_notf_iteration;
647: l_hist_rec.RESPONSE := 'ACKNOWLEDGE';
648: l_hist_rec.APPROVER_ID := l_approver_id;
649: l_hist_rec.APPROVER_NAME:= l_display_name;
650: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
651: l_hist_rec.CREATION_DATE:= sysdate;
652: l_hist_rec.LAST_UPDATE_DATE := sysdate;
653: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
654: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);

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

649: l_hist_rec.APPROVER_NAME:= l_display_name;
650: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
651: l_hist_rec.CREATION_DATE:= sysdate;
652: l_hist_rec.LAST_UPDATE_DATE := sysdate;
653: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
654: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);
655: l_hist_rec.ORG_ID := l_org_id;
656: l_hist_rec.AMOUNT_APPROVED := null;
657: l_hist_rec.HOLD_ID := l_hold_id;

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

650: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
651: l_hist_rec.CREATION_DATE:= sysdate;
652: l_hist_rec.LAST_UPDATE_DATE := sysdate;
653: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
654: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);
655: l_hist_rec.ORG_ID := l_org_id;
656: l_hist_rec.AMOUNT_APPROVED := null;
657: l_hist_rec.HOLD_ID := l_hold_id;
658: l_hist_rec.APPROVER_COMMENTS := l_comments; -- bug 8940578

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

743: l_hist_rec.NOTIFICATION_ORDER := l_notf_iteration;
744: l_hist_rec.RESPONSE := 'RELEASE';
745: l_hist_rec.APPROVER_ID := l_approver_id;
746: l_hist_rec.APPROVER_NAME:= l_display_name;
747: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
748: l_hist_rec.CREATION_DATE:= sysdate;
749: l_hist_rec.LAST_UPDATE_DATE := sysdate;
750: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
751: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);

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

746: l_hist_rec.APPROVER_NAME:= l_display_name;
747: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
748: l_hist_rec.CREATION_DATE:= sysdate;
749: l_hist_rec.LAST_UPDATE_DATE := sysdate;
750: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
751: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);
752: l_hist_rec.ORG_ID := l_org_id;
753: l_hist_rec.AMOUNT_APPROVED := null;
754: l_hist_rec.HOLD_ID := l_hold_id;

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

747: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
748: l_hist_rec.CREATION_DATE:= sysdate;
749: l_hist_rec.LAST_UPDATE_DATE := sysdate;
750: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
751: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);
752: l_hist_rec.ORG_ID := l_org_id;
753: l_hist_rec.AMOUNT_APPROVED := null;
754: l_hist_rec.HOLD_ID := l_hold_id;
755: l_hist_rec.APPROVER_COMMENTS := l_comments; --Bug9069200

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

908: l_hist_rec.NOTIFICATION_ORDER := l_notf_iteration;
909: l_hist_rec.RESPONSE := 'ACCEPT';
910: l_hist_rec.APPROVER_ID := l_approver_id;
911: l_hist_rec.APPROVER_NAME:= l_display_name;
912: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
913: l_hist_rec.CREATION_DATE:= sysdate;
914: l_hist_rec.LAST_UPDATE_DATE := sysdate;
915: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
916: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);

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

911: l_hist_rec.APPROVER_NAME:= l_display_name;
912: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
913: l_hist_rec.CREATION_DATE:= sysdate;
914: l_hist_rec.LAST_UPDATE_DATE := sysdate;
915: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
916: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);
917: l_hist_rec.ORG_ID := l_org_id;
918: l_hist_rec.AMOUNT_APPROVED := null;
919: l_hist_rec.HOLD_ID := l_hold_id;

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

912: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
913: l_hist_rec.CREATION_DATE:= sysdate;
914: l_hist_rec.LAST_UPDATE_DATE := sysdate;
915: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
916: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);
917: l_hist_rec.ORG_ID := l_org_id;
918: l_hist_rec.AMOUNT_APPROVED := null;
919: l_hist_rec.HOLD_ID := l_hold_id;
920:

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

1075: l_hist_rec.NOTIFICATION_ORDER := l_notf_iteration;
1076: l_hist_rec.RESPONSE := 'CANCEL';
1077: l_hist_rec.APPROVER_ID := l_approver_id;
1078: l_hist_rec.APPROVER_NAME:= l_display_name;
1079: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
1080: l_hist_rec.CREATION_DATE:= sysdate;
1081: l_hist_rec.LAST_UPDATE_DATE := sysdate;
1082: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
1083: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);

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

1078: l_hist_rec.APPROVER_NAME:= l_display_name;
1079: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
1080: l_hist_rec.CREATION_DATE:= sysdate;
1081: l_hist_rec.LAST_UPDATE_DATE := sysdate;
1082: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
1083: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);
1084: l_hist_rec.ORG_ID := l_org_id;
1085: l_hist_rec.AMOUNT_APPROVED := null;
1086: l_hist_rec.HOLD_ID := l_hold_id;

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

1079: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
1080: l_hist_rec.CREATION_DATE:= sysdate;
1081: l_hist_rec.LAST_UPDATE_DATE := sysdate;
1082: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
1083: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);
1084: l_hist_rec.ORG_ID := l_org_id;
1085: l_hist_rec.AMOUNT_APPROVED := null;
1086: l_hist_rec.HOLD_ID := l_hold_id;
1087: l_debug_info := 'Before Ap_Cancel_Single_Invoice';

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

1222: l_hist_rec.NOTIFICATION_ORDER := l_notf_iteration;
1223: l_hist_rec.RESPONSE := 'ACCEPT';
1224: l_hist_rec.APPROVER_ID := l_approver_id;
1225: l_hist_rec.APPROVER_NAME:= l_display_name;
1226: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
1227: l_hist_rec.CREATION_DATE:= sysdate;
1228: l_hist_rec.LAST_UPDATE_DATE := sysdate;
1229: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
1230: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);

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

1225: l_hist_rec.APPROVER_NAME:= l_display_name;
1226: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
1227: l_hist_rec.CREATION_DATE:= sysdate;
1228: l_hist_rec.LAST_UPDATE_DATE := sysdate;
1229: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
1230: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);
1231: l_hist_rec.ORG_ID := l_org_id;
1232: l_hist_rec.AMOUNT_APPROVED := null;
1233: l_hist_rec.HOLD_ID := l_hold_id;

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

1226: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
1227: l_hist_rec.CREATION_DATE:= sysdate;
1228: l_hist_rec.LAST_UPDATE_DATE := sysdate;
1229: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
1230: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);
1231: l_hist_rec.ORG_ID := l_org_id;
1232: l_hist_rec.AMOUNT_APPROVED := null;
1233: l_hist_rec.HOLD_ID := l_hold_id;
1234:

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

1406: l_hist_rec.iteration := l_iteration;
1407: l_hist_rec.response := 'APPROVED';
1408: l_hist_rec.approver_comments := l_tr_reason;
1409: l_hist_rec.approver_id :=
1410: FND_PROFILE.VALUE('AP_IAW_USER');
1411: l_hist_rec.org_id := l_org_id;
1412: l_hist_rec.created_by :=
1413: FND_PROFILE.VALUE('AP_IAW_USER');
1414: l_hist_rec.creation_date := sysdate;

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

1409: l_hist_rec.approver_id :=
1410: FND_PROFILE.VALUE('AP_IAW_USER');
1411: l_hist_rec.org_id := l_org_id;
1412: l_hist_rec.created_by :=
1413: FND_PROFILE.VALUE('AP_IAW_USER');
1414: l_hist_rec.creation_date := sysdate;
1415: l_hist_rec.last_update_date := sysdate;
1416: l_hist_rec.last_updated_by :=
1417: FND_PROFILE.VALUE('AP_IAW_USER');

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

1413: FND_PROFILE.VALUE('AP_IAW_USER');
1414: l_hist_rec.creation_date := sysdate;
1415: l_hist_rec.last_update_date := sysdate;
1416: l_hist_rec.last_updated_by :=
1417: FND_PROFILE.VALUE('AP_IAW_USER');
1418: l_hist_rec.last_update_login := -1;
1419: l_hist_rec.amount_approved := l_amount;
1420: l_hist_rec.history_type := 'DOCUMENTAPPROVAL';
1421:

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

1489: l_hist_rec.iteration := l_iteration;
1490: l_hist_rec.response := 'REJECTED';
1491: l_hist_rec.approver_comments := l_tr_reason;
1492: l_hist_rec.approver_id :=
1493: FND_PROFILE.VALUE('AP_IAW_USER');
1494: l_hist_rec.org_id := l_org_id;
1495: l_hist_rec.created_by :=
1496: FND_PROFILE.VALUE('AP_IAW_USER');
1497: l_hist_rec.creation_date := sysdate;

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

1492: l_hist_rec.approver_id :=
1493: FND_PROFILE.VALUE('AP_IAW_USER');
1494: l_hist_rec.org_id := l_org_id;
1495: l_hist_rec.created_by :=
1496: FND_PROFILE.VALUE('AP_IAW_USER');
1497: l_hist_rec.creation_date := sysdate;
1498: l_hist_rec.last_update_date := sysdate;
1499: l_hist_rec.last_updated_by :=
1500: FND_PROFILE.VALUE('AP_IAW_USER');

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

1496: FND_PROFILE.VALUE('AP_IAW_USER');
1497: l_hist_rec.creation_date := sysdate;
1498: l_hist_rec.last_update_date := sysdate;
1499: l_hist_rec.last_updated_by :=
1500: FND_PROFILE.VALUE('AP_IAW_USER');
1501: l_hist_rec.last_update_login := -1;
1502: l_hist_rec.amount_approved := l_amount;
1503: l_hist_rec.history_type := 'DOCUMENTAPPROVAL';
1504:

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

1672: l_l_hist.iteration := l_iteration;
1673: l_l_hist.response := 'APPROVED';
1674: l_l_hist.approver_comments := l_tr_reason;
1675: l_l_hist.approver_id :=
1676: FND_PROFILE.VALUE('AP_IAW_USER');
1677: l_l_hist.org_id := l_org_id;
1678: l_l_hist.line_number := l_line_number;
1679: l_l_hist.amount_approved :=
1680: l_amount;

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

1678: l_l_hist.line_number := l_line_number;
1679: l_l_hist.amount_approved :=
1680: l_amount;
1681: l_l_hist.created_by :=
1682: FND_PROFILE.VALUE('AP_IAW_USER');
1683: l_l_hist.creation_date := sysdate;
1684: l_l_hist.last_updated_by :=
1685: FND_PROFILE.VALUE('AP_IAW_USER');
1686: l_l_hist.last_update_date := sysdate;

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

1681: l_l_hist.created_by :=
1682: FND_PROFILE.VALUE('AP_IAW_USER');
1683: l_l_hist.creation_date := sysdate;
1684: l_l_hist.last_updated_by :=
1685: FND_PROFILE.VALUE('AP_IAW_USER');
1686: l_l_hist.last_update_date := sysdate;
1687: l_l_hist.last_update_login := -1;
1688: l_l_hist.item_class := 'APINV';
1689: l_l_hist.item_id := l_invoice_id;

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

2060: l_next_approver.ACTION_TYPE_ORDER_NUMBER,
2061: l_next_approver.GROUP_OR_CHAIN_ORDER_NUMBER,
2062: l_next_approver.MEMBER_ORDER_NUMBER,
2063: l_next_approver.APPROVER_ORDER_NUMBER,
2064: nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1),
2065: sysdate,
2066: nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
2067: -1),
2068: nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1),

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

2062: l_next_approver.MEMBER_ORDER_NUMBER,
2063: l_next_approver.APPROVER_ORDER_NUMBER,
2064: nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1),
2065: sysdate,
2066: nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
2067: -1),
2068: nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1),
2069: sysdate,
2070: 200,

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

2064: nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1),
2065: sysdate,
2066: nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
2067: -1),
2068: nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1),
2069: sysdate,
2070: 200,
2071: 0,
2072: sysdate,

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

2091: l_hist_rec.ITERATION := l_iteration;
2092: l_hist_rec.RESPONSE := 'SENT';
2093: l_hist_rec.APPROVER_ID := l_next_approver.ORIG_SYSTEM_ID;
2094: l_hist_rec.APPROVER_NAME:= l_next_approver.DISPLAY_NAME;
2095: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
2096: l_hist_rec.CREATION_DATE:= sysdate;
2097: l_hist_rec.LAST_UPDATE_DATE := sysdate;
2098: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
2099: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);

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

2094: l_hist_rec.APPROVER_NAME:= l_next_approver.DISPLAY_NAME;
2095: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
2096: l_hist_rec.CREATION_DATE:= sysdate;
2097: l_hist_rec.LAST_UPDATE_DATE := sysdate;
2098: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
2099: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);
2100: l_hist_rec.ORG_ID := l_org_id;
2101:
2102:

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

2095: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
2096: l_hist_rec.CREATION_DATE:= sysdate;
2097: l_hist_rec.LAST_UPDATE_DATE := sysdate;
2098: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
2099: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);
2100: l_hist_rec.ORG_ID := l_org_id;
2101:
2102:
2103: insert_history_table(p_hist_rec => l_hist_rec);

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

2255: l_next_approver.ACTION_TYPE_ORDER_NUMBER,
2256: l_next_approver.GROUP_OR_CHAIN_ORDER_NUMBER,
2257: l_next_approver.MEMBER_ORDER_NUMBER,
2258: l_next_approver.APPROVER_ORDER_NUMBER,
2259: nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1),
2260: sysdate,
2261: nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
2262: -1),
2263: nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1),

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

2257: l_next_approver.MEMBER_ORDER_NUMBER,
2258: l_next_approver.APPROVER_ORDER_NUMBER,
2259: nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1),
2260: sysdate,
2261: nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
2262: -1),
2263: nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1),
2264: sysdate,
2265: 200,

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

2259: nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1),
2260: sysdate,
2261: nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
2262: -1),
2263: nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1),
2264: sysdate,
2265: 200,
2266: 0,
2267: sysdate,

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

2280: l_hist_rec.ITERATION := l_iteration;
2281: l_hist_rec.RESPONSE := 'SENT';
2282: l_hist_rec.APPROVER_ID := l_next_approver.ORIG_SYSTEM_ID;
2283: l_hist_rec.APPROVER_NAME:= l_next_approver.DISPLAY_NAME;
2284: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID
2285: ')),-1);
2286: l_hist_rec.CREATION_DATE:= sysdate;
2287: l_hist_rec.LAST_UPDATE_DATE := sysdate;
2288: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USE

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

2284: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID
2285: ')),-1);
2286: l_hist_rec.CREATION_DATE:= sysdate;
2287: l_hist_rec.LAST_UPDATE_DATE := sysdate;
2288: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USE
2289: R_ID')),-1);
2290: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LO
2291: GIN_ID')),-1);
2292: l_hist_rec.ORG_ID := l_org_id;

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

2286: l_hist_rec.CREATION_DATE:= sysdate;
2287: l_hist_rec.LAST_UPDATE_DATE := sysdate;
2288: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USE
2289: R_ID')),-1);
2290: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LO
2291: GIN_ID')),-1);
2292: l_hist_rec.ORG_ID := l_org_id;
2293:
2294:

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

3023: itemkey,
3024: 'ITERATION');
3025:
3026:
3027: l_user_id := nvl(to_number(fnd_profile.value('USER_ID')),-1);
3028: l_login_id := nvl(to_number(fnd_profile.value('LOGIN_ID')),-1);
3029: IF nvl(l_esc_flag,'N') = 'N' THEN
3030: l_role := l_document_approver;
3031: ELSE

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

3024: 'ITERATION');
3025:
3026:
3027: l_user_id := nvl(to_number(fnd_profile.value('USER_ID')),-1);
3028: l_login_id := nvl(to_number(fnd_profile.value('LOGIN_ID')),-1);
3029: IF nvl(l_esc_flag,'N') = 'N' THEN
3030: l_role := l_document_approver;
3031: ELSE
3032: l_role := l_esc_role_name;

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

3058: ELSE
3059: l_hist_rec.APPROVER_ID := l_esc_approver_id;
3060: l_hist_rec.APPROVER_NAME:= l_esc_approver_name;
3061: END IF;
3062: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
3063: l_hist_rec.CREATION_DATE:= sysdate;
3064: l_hist_rec.LAST_UPDATE_DATE := sysdate;
3065: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
3066: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);

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

3061: END IF;
3062: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
3063: l_hist_rec.CREATION_DATE:= sysdate;
3064: l_hist_rec.LAST_UPDATE_DATE := sysdate;
3065: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
3066: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);
3067: l_hist_rec.ORG_ID := l_org_id;
3068: l_hist_rec.AMOUNT_APPROVED := l_invoice_total;
3069:

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

3062: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
3063: l_hist_rec.CREATION_DATE:= sysdate;
3064: l_hist_rec.LAST_UPDATE_DATE := sysdate;
3065: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
3066: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);
3067: l_hist_rec.ORG_ID := l_org_id;
3068: l_hist_rec.AMOUNT_APPROVED := l_invoice_total;
3069:
3070: l_debug_info := 'Before calling insert_history_table';

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

3197: l_esc_role_actual := WF_ENGINE.GetItemAttrText(itemtype,
3198: itemkey,
3199: 'ESC_ROLE_ACTUAL');
3200: -- added for the delegation enhancement
3201: l_user_id := nvl(to_number(fnd_profile.value('USER_ID')),-1);
3202: l_login_id := nvl(to_number(fnd_profile.value('LOGIN_ID')),-1);
3203: IF nvl(l_esc_flag,'N') = 'N' THEN
3204: l_role := l_role_name; -- added for the delegation enhancement
3205: --l_role := l_document_approver;

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

3198: itemkey,
3199: 'ESC_ROLE_ACTUAL');
3200: -- added for the delegation enhancement
3201: l_user_id := nvl(to_number(fnd_profile.value('USER_ID')),-1);
3202: l_login_id := nvl(to_number(fnd_profile.value('LOGIN_ID')),-1);
3203: IF nvl(l_esc_flag,'N') = 'N' THEN
3204: l_role := l_role_name; -- added for the delegation enhancement
3205: --l_role := l_document_approver;
3206: ELSE

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

3234: ELSE
3235: l_hist_rec.APPROVER_ID := l_esc_approver_id;
3236: l_hist_rec.APPROVER_NAME:= l_esc_approver_name;
3237: END IF;
3238: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
3239: l_hist_rec.CREATION_DATE:= sysdate;
3240: l_hist_rec.LAST_UPDATE_DATE := sysdate;
3241: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
3242: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);

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

3237: END IF;
3238: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
3239: l_hist_rec.CREATION_DATE:= sysdate;
3240: l_hist_rec.LAST_UPDATE_DATE := sysdate;
3241: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
3242: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);
3243: l_hist_rec.ORG_ID := l_org_id;
3244: l_hist_rec.AMOUNT_APPROVED := l_invoice_total;
3245: l_hist_rec.APPROVER_COMMENTS := l_comments;

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

3238: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
3239: l_hist_rec.CREATION_DATE:= sysdate;
3240: l_hist_rec.LAST_UPDATE_DATE := sysdate;
3241: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
3242: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);
3243: l_hist_rec.ORG_ID := l_org_id;
3244: l_hist_rec.AMOUNT_APPROVED := l_invoice_total;
3245: l_hist_rec.APPROVER_COMMENTS := l_comments;
3246:

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

3391: l_notf_iteration := WF_ENGINE.GETITEMATTRNumber(itemtype,
3392: itemkey,
3393: 'NOTF_ITERATION');
3394:
3395: l_user_id := nvl(to_number(fnd_profile.value('USER_ID')),-1);
3396: l_login_id := nvl(to_number(fnd_profile.value('LOGIN_ID')),-1);
3397: IF nvl(l_esc_flag,'N') = 'N' THEN
3398: l_role := l_role_name;
3399: ELSE

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

3392: itemkey,
3393: 'NOTF_ITERATION');
3394:
3395: l_user_id := nvl(to_number(fnd_profile.value('USER_ID')),-1);
3396: l_login_id := nvl(to_number(fnd_profile.value('LOGIN_ID')),-1);
3397: IF nvl(l_esc_flag,'N') = 'N' THEN
3398: l_role := l_role_name;
3399: ELSE
3400: l_role := l_esc_role_name;

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

3425: l_hist_rec.APPROVER_ID := l_esc_approver_id;
3426: l_hist_rec.APPROVER_NAME:= l_esc_approver_name;
3427: END IF;
3428: l_hist_rec.APPROVER_COMMENTS := l_comments;
3429: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
3430: l_hist_rec.CREATION_DATE:= sysdate;
3431: l_hist_rec.LAST_UPDATE_DATE := sysdate;
3432: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
3433: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);

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

3428: l_hist_rec.APPROVER_COMMENTS := l_comments;
3429: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
3430: l_hist_rec.CREATION_DATE:= sysdate;
3431: l_hist_rec.LAST_UPDATE_DATE := sysdate;
3432: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
3433: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);
3434: l_hist_rec.ORG_ID := l_org_id;
3435: --update AME status
3436: --For Future check with ame as to when updateApprovalStatuses will be

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

3429: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
3430: l_hist_rec.CREATION_DATE:= sysdate;
3431: l_hist_rec.LAST_UPDATE_DATE := sysdate;
3432: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
3433: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);
3434: l_hist_rec.ORG_ID := l_org_id;
3435: --update AME status
3436: --For Future check with ame as to when updateApprovalStatuses will be
3437: --available so there will not be a need to loop.

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

3464: END LOOP;
3465: CLOSE Items_Cur;
3466:
3467:
3468: l_user_id := nvl(to_number(fnd_profile.value('USER_ID')),-1);
3469: l_login_id := nvl(to_number(fnd_profile.value('LOGIN_ID')),-1);
3470: UPDATE AP_INVOICE_LINES_ALL -- Bug 9388962
3471: SET wfapproval_status = 'REJECTED'
3472: ,Last_Update_Date = sysdate

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

3465: CLOSE Items_Cur;
3466:
3467:
3468: l_user_id := nvl(to_number(fnd_profile.value('USER_ID')),-1);
3469: l_login_id := nvl(to_number(fnd_profile.value('LOGIN_ID')),-1);
3470: UPDATE AP_INVOICE_LINES_ALL -- Bug 9388962
3471: SET wfapproval_status = 'REJECTED'
3472: ,Last_Update_Date = sysdate
3473: ,Last_Updated_By = l_user_id

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

3633: itemkey,
3634: 'ESC_ROLE_ACTUAL');
3635: -- added for the delegation enhancement
3636:
3637: l_user_id := nvl(to_number(fnd_profile.value('USER_ID')),-1);
3638: l_login_id := nvl(to_number(fnd_profile.value('LOGIN_ID')),-1);
3639: IF nvl(l_esc_flag,'N') = 'N' THEN
3640: l_role := l_role_name; -- added for the delegation enhancement
3641: --l_role := l_document_approver;

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

3634: 'ESC_ROLE_ACTUAL');
3635: -- added for the delegation enhancement
3636:
3637: l_user_id := nvl(to_number(fnd_profile.value('USER_ID')),-1);
3638: l_login_id := nvl(to_number(fnd_profile.value('LOGIN_ID')),-1);
3639: IF nvl(l_esc_flag,'N') = 'N' THEN
3640: l_role := l_role_name; -- added for the delegation enhancement
3641: --l_role := l_document_approver;
3642: ELSE

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

3643: l_role := l_esc_role_actual ;
3644: --l_role := l_esc_role_name;
3645: END IF; */
3646:
3647: l_user_id := nvl(to_number(fnd_profile.value('USER_ID')),-1);
3648: l_login_id := nvl(to_number(fnd_profile.value('LOGIN_ID')),-1);
3649: IF nvl(l_esc_flag,'N') = 'N' THEN
3650: l_role := l_role_name;
3651: ELSE

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

3644: --l_role := l_esc_role_name;
3645: END IF; */
3646:
3647: l_user_id := nvl(to_number(fnd_profile.value('USER_ID')),-1);
3648: l_login_id := nvl(to_number(fnd_profile.value('LOGIN_ID')),-1);
3649: IF nvl(l_esc_flag,'N') = 'N' THEN
3650: l_role := l_role_name;
3651: ELSE
3652: l_role := l_esc_role_name;

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

3676: ELSE
3677: l_hist_rec.APPROVER_ID := l_esc_approver_id;
3678: l_hist_rec.APPROVER_NAME:= l_esc_approver_name;
3679: END IF;
3680: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
3681: l_hist_rec.CREATION_DATE:= sysdate;
3682: l_hist_rec.LAST_UPDATE_DATE := sysdate;
3683: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
3684: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);

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

3679: END IF;
3680: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
3681: l_hist_rec.CREATION_DATE:= sysdate;
3682: l_hist_rec.LAST_UPDATE_DATE := sysdate;
3683: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
3684: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);
3685: l_hist_rec.ORG_ID := l_org_id;
3686: --update AME status
3687: --For Future check with ame as to when updateApprovalStatuses will be

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

3680: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
3681: l_hist_rec.CREATION_DATE:= sysdate;
3682: l_hist_rec.LAST_UPDATE_DATE := sysdate;
3683: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
3684: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);
3685: l_hist_rec.ORG_ID := l_org_id;
3686: --update AME status
3687: --For Future check with ame as to when updateApprovalStatuses will be
3688: --available so there will not be a need to loop.

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

3729: END LOOP;
3730: CLOSE Items_Cur;
3731:
3732:
3733: l_user_id := nvl(to_number(fnd_profile.value('USER_ID')),-1);
3734: l_login_id := nvl(to_number(fnd_profile.value('LOGIN_ID')),-1);
3735: BEGIN
3736:
3737: SELECT invoice_key

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

3730: CLOSE Items_Cur;
3731:
3732:
3733: l_user_id := nvl(to_number(fnd_profile.value('USER_ID')),-1);
3734: l_login_id := nvl(to_number(fnd_profile.value('LOGIN_ID')),-1);
3735: BEGIN
3736:
3737: SELECT invoice_key
3738: INTO l_invoice_key

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

3945: itemkey,
3946: 'NOTF_ITERATION');
3947:
3948:
3949: l_user_id := nvl(to_number(fnd_profile.value('USER_ID')),-1);
3950: l_login_id := nvl(to_number(fnd_profile.value('LOGIN_ID')),-1);
3951:
3952:
3953: l_hist_rec.HISTORY_TYPE := 'DOCUMENTAPPROVAL';

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

3946: 'NOTF_ITERATION');
3947:
3948:
3949: l_user_id := nvl(to_number(fnd_profile.value('USER_ID')),-1);
3950: l_login_id := nvl(to_number(fnd_profile.value('LOGIN_ID')),-1);
3951:
3952:
3953: l_hist_rec.HISTORY_TYPE := 'DOCUMENTAPPROVAL';
3954: l_hist_rec.INVOICE_ID := l_invoice_id;

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

3957: l_hist_rec.APPROVER_COMMENTS := l_comments;
3958: l_hist_rec.RESPONSE := 'ACCEPT';
3959: l_hist_rec.APPROVER_ID := l_supplier_person_id;
3960: l_hist_rec.APPROVER_NAME:= l_supplier_name;
3961: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
3962: l_hist_rec.CREATION_DATE:= sysdate;
3963: l_hist_rec.LAST_UPDATE_DATE := sysdate;
3964: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
3965: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);

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

3960: l_hist_rec.APPROVER_NAME:= l_supplier_name;
3961: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
3962: l_hist_rec.CREATION_DATE:= sysdate;
3963: l_hist_rec.LAST_UPDATE_DATE := sysdate;
3964: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
3965: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);
3966: l_hist_rec.ORG_ID := l_org_id;
3967: --update AME status
3968: --For Future check with ame as to when updateApprovalStatuses will be

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

3961: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
3962: l_hist_rec.CREATION_DATE:= sysdate;
3963: l_hist_rec.LAST_UPDATE_DATE := sysdate;
3964: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
3965: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);
3966: l_hist_rec.ORG_ID := l_org_id;
3967: --update AME status
3968: --For Future check with ame as to when updateApprovalStatuses will be
3969: --available so there will not be a need to loop.

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

4120: itemkey,
4121: 'NOTF_ITERATION');
4122:
4123:
4124: l_user_id := nvl(to_number(fnd_profile.value('USER_ID')),-1);
4125: l_login_id := nvl(to_number(fnd_profile.value('LOGIN_ID')),-1);
4126:
4127: l_hist_rec.HISTORY_TYPE := 'DOCUMENTAPPROVAL';
4128: l_hist_rec.INVOICE_ID := l_invoice_id;

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

4121: 'NOTF_ITERATION');
4122:
4123:
4124: l_user_id := nvl(to_number(fnd_profile.value('USER_ID')),-1);
4125: l_login_id := nvl(to_number(fnd_profile.value('LOGIN_ID')),-1);
4126:
4127: l_hist_rec.HISTORY_TYPE := 'DOCUMENTAPPROVAL';
4128: l_hist_rec.INVOICE_ID := l_invoice_id;
4129: l_hist_rec.ITERATION := l_iteration;

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

4131: l_hist_rec.APPROVER_COMMENTS := l_comments;
4132: l_hist_rec.RESPONSE := 'ACCEPT';
4133: l_hist_rec.APPROVER_ID := l_approver_id;
4134: l_hist_rec.APPROVER_NAME:= l_approver_name;
4135: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
4136: l_hist_rec.CREATION_DATE:= sysdate;
4137: l_hist_rec.LAST_UPDATE_DATE := sysdate;
4138: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
4139: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);

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

4134: l_hist_rec.APPROVER_NAME:= l_approver_name;
4135: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
4136: l_hist_rec.CREATION_DATE:= sysdate;
4137: l_hist_rec.LAST_UPDATE_DATE := sysdate;
4138: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
4139: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);
4140: l_hist_rec.ORG_ID := l_org_id;
4141: --update AME status
4142: --For Future check with ame as to when updateApprovalStatuses will be

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

4135: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
4136: l_hist_rec.CREATION_DATE:= sysdate;
4137: l_hist_rec.LAST_UPDATE_DATE := sysdate;
4138: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
4139: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);
4140: l_hist_rec.ORG_ID := l_org_id;
4141: --update AME status
4142: --For Future check with ame as to when updateApprovalStatuses will be
4143: --available so there will not be a need to loop.

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

4302: itemkey,
4303: 'NOTF_ITERATION');
4304:
4305:
4306: l_user_id := nvl(to_number(fnd_profile.value('USER_ID')),-1);
4307: l_login_id := nvl(to_number(fnd_profile.value('LOGIN_ID')),-1);
4308:
4309: l_debug_info := 'Before Update Approvers table';
4310: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

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

4303: 'NOTF_ITERATION');
4304:
4305:
4306: l_user_id := nvl(to_number(fnd_profile.value('USER_ID')),-1);
4307: l_login_id := nvl(to_number(fnd_profile.value('LOGIN_ID')),-1);
4308:
4309: l_debug_info := 'Before Update Approvers table';
4310: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4311: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||

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

4326: l_hist_rec.APPROVER_COMMENTS := l_comments;
4327: l_hist_rec.RESPONSE := 'CANCEL';
4328: l_hist_rec.APPROVER_ID := l_approver_id;
4329: l_hist_rec.APPROVER_NAME:= l_approver_name;
4330: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
4331: l_hist_rec.CREATION_DATE:= sysdate;
4332: l_hist_rec.LAST_UPDATE_DATE := sysdate;
4333: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
4334: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);

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

4329: l_hist_rec.APPROVER_NAME:= l_approver_name;
4330: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
4331: l_hist_rec.CREATION_DATE:= sysdate;
4332: l_hist_rec.LAST_UPDATE_DATE := sysdate;
4333: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
4334: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);
4335: l_hist_rec.ORG_ID := l_org_id;
4336: --update AME status
4337: --For Future check with ame as to when updateApprovalStatuses will be

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

4330: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
4331: l_hist_rec.CREATION_DATE:= sysdate;
4332: l_hist_rec.LAST_UPDATE_DATE := sysdate;
4333: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
4334: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);
4335: l_hist_rec.ORG_ID := l_org_id;
4336: --update AME status
4337: --For Future check with ame as to when updateApprovalStatuses will be
4338: --available so there will not be a need to loop.

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

4656: l_hist_rec.NOTIFICATION_ORDER := l_notf_iteration;
4657: l_hist_rec.RESPONSE := 'SENT';
4658: l_hist_rec.APPROVER_ID := l_person_id;
4659: l_hist_rec.APPROVER_NAME:= l_display_name;
4660: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
4661: l_hist_rec.CREATION_DATE:= sysdate;
4662: l_hist_rec.LAST_UPDATE_DATE := sysdate;
4663: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
4664: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);

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

4659: l_hist_rec.APPROVER_NAME:= l_display_name;
4660: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
4661: l_hist_rec.CREATION_DATE:= sysdate;
4662: l_hist_rec.LAST_UPDATE_DATE := sysdate;
4663: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
4664: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);
4665: l_hist_rec.ORG_ID := l_org_id;
4666: l_hist_rec.AMOUNT_APPROVED := 0;
4667: l_hist_rec.HOLD_ID := p_hold_id;

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

4660: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
4661: l_hist_rec.CREATION_DATE:= sysdate;
4662: l_hist_rec.LAST_UPDATE_DATE := sysdate;
4663: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
4664: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);
4665: l_hist_rec.ORG_ID := l_org_id;
4666: l_hist_rec.AMOUNT_APPROVED := 0;
4667: l_hist_rec.HOLD_ID := p_hold_id;
4668:

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

5066: l_hist_rec.RESPONSE := 'SENT';
5067: l_hist_rec.APPROVER_ID := l_next_approver.ORIG_SYSTEM_ID;
5068: /********** POTENTIAL BUG ABOVE********************/
5069: l_hist_rec.APPROVER_NAME:= l_display_name;
5070: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
5071: l_hist_rec.CREATION_DATE:= sysdate;
5072: l_hist_rec.LAST_UPDATE_DATE := sysdate;
5073: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
5074: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);

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

5069: l_hist_rec.APPROVER_NAME:= l_display_name;
5070: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
5071: l_hist_rec.CREATION_DATE:= sysdate;
5072: l_hist_rec.LAST_UPDATE_DATE := sysdate;
5073: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
5074: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);
5075: l_hist_rec.ORG_ID := l_org_id;
5076: l_hist_rec.AMOUNT_APPROVED := 0;
5077:

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

5070: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
5071: l_hist_rec.CREATION_DATE:= sysdate;
5072: l_hist_rec.LAST_UPDATE_DATE := sysdate;
5073: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
5074: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);
5075: l_hist_rec.ORG_ID := l_org_id;
5076: l_hist_rec.AMOUNT_APPROVED := 0;
5077:
5078: insert_history_table(p_hist_rec => l_hist_rec);

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

5276: l_hist_rec.NOTIFICATION_ORDER := l_notf_iteration;
5277: l_hist_rec.RESPONSE := 'ESCALATED';
5278: l_hist_rec.APPROVER_ID := l_esc_approver_id;
5279: l_hist_rec.APPROVER_NAME:= l_esc_approver_name;
5280: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
5281: l_hist_rec.CREATION_DATE:= sysdate;
5282: l_hist_rec.LAST_UPDATE_DATE := sysdate;
5283: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
5284: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);

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

5279: l_hist_rec.APPROVER_NAME:= l_esc_approver_name;
5280: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
5281: l_hist_rec.CREATION_DATE:= sysdate;
5282: l_hist_rec.LAST_UPDATE_DATE := sysdate;
5283: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
5284: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);
5285: l_hist_rec.ORG_ID := l_org_id;
5286: l_hist_rec.AMOUNT_APPROVED := l_invoice_total;
5287:

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

5280: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
5281: l_hist_rec.CREATION_DATE:= sysdate;
5282: l_hist_rec.LAST_UPDATE_DATE := sysdate;
5283: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
5284: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);
5285: l_hist_rec.ORG_ID := l_org_id;
5286: l_hist_rec.AMOUNT_APPROVED := l_invoice_total;
5287:
5288: l_debug_info := 'Before insert_history_table';

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

5447: l_hist_rec.APPROVER_COMMENTS := l_comments;
5448: l_hist_rec.RESPONSE := 'ESCALATED';
5449: l_hist_rec.APPROVER_ID := l_esc_approver_id;
5450: l_hist_rec.APPROVER_NAME:= l_esc_approver_name;
5451: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
5452: l_hist_rec.CREATION_DATE:= sysdate;
5453: l_hist_rec.LAST_UPDATE_DATE := sysdate;
5454: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
5455: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);

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

5450: l_hist_rec.APPROVER_NAME:= l_esc_approver_name;
5451: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
5452: l_hist_rec.CREATION_DATE:= sysdate;
5453: l_hist_rec.LAST_UPDATE_DATE := sysdate;
5454: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
5455: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);
5456: l_hist_rec.ORG_ID := l_org_id;
5457: --update AME status
5458: --For Future check with ame as to when updateApprovalStatuses will be

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

5451: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
5452: l_hist_rec.CREATION_DATE:= sysdate;
5453: l_hist_rec.LAST_UPDATE_DATE := sysdate;
5454: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
5455: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);
5456: l_hist_rec.ORG_ID := l_org_id;
5457: --update AME status
5458: --For Future check with ame as to when updateApprovalStatuses will be
5459: --available so there will not be a need to loop.

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

6367: l_esc_approver_id := WF_ENGINE.GETITEMATTRNumber('APINVAPR',
6368: p_itemkey,
6369: 'ESC_APPROVER_ID');
6370:
6371: l_user_id := nvl(to_number(fnd_profile.value('USER_ID')),-1);
6372: l_login_id := nvl(to_number(fnd_profile.value('LOGIN_ID')),-1);
6373: IF nvl(l_esc_flag,'N') = 'N' THEN
6374: l_role := l_role_name;
6375: ELSE

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

6368: p_itemkey,
6369: 'ESC_APPROVER_ID');
6370:
6371: l_user_id := nvl(to_number(fnd_profile.value('USER_ID')),-1);
6372: l_login_id := nvl(to_number(fnd_profile.value('LOGIN_ID')),-1);
6373: IF nvl(l_esc_flag,'N') = 'N' THEN
6374: l_role := l_role_name;
6375: ELSE
6376: l_role := l_esc_role_name;

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

6404: ELSE
6405: l_hist_rec.APPROVER_ID := l_esc_approver_id;
6406: l_hist_rec.APPROVER_NAME:= l_esc_approver_name;
6407: END IF;
6408: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
6409: l_hist_rec.CREATION_DATE:= sysdate;
6410: l_hist_rec.LAST_UPDATE_DATE := sysdate;
6411: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
6412: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);

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

6407: END IF;
6408: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
6409: l_hist_rec.CREATION_DATE:= sysdate;
6410: l_hist_rec.LAST_UPDATE_DATE := sysdate;
6411: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
6412: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);
6413: l_hist_rec.ORG_ID := l_org_id;
6414: --update AME status
6415: --For Future check with ame as to when updateApprovalStatuses will be

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

6408: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
6409: l_hist_rec.CREATION_DATE:= sysdate;
6410: l_hist_rec.LAST_UPDATE_DATE := sysdate;
6411: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
6412: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);
6413: l_hist_rec.ORG_ID := l_org_id;
6414: --update AME status
6415: --For Future check with ame as to when updateApprovalStatuses will be
6416: --available so there will not be a need to loop.

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

6449: insert_history_table(p_hist_rec => l_hist_rec);
6450: CLOSE Items_Cur;
6451:
6452:
6453: l_user_id := nvl(to_number(fnd_profile.value('USER_ID')),-1);
6454: l_login_id := nvl(to_number(fnd_profile.value('LOGIN_ID')),-1);
6455:
6456: IF l_response = 'REJECTED' THEN
6457: UPDATE AP_INVOICE_LINES_ALL

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

6450: CLOSE Items_Cur;
6451:
6452:
6453: l_user_id := nvl(to_number(fnd_profile.value('USER_ID')),-1);
6454: l_login_id := nvl(to_number(fnd_profile.value('LOGIN_ID')),-1);
6455:
6456: IF l_response = 'REJECTED' THEN
6457: UPDATE AP_INVOICE_LINES_ALL
6458: SET wfapproval_status = 'REJECTED'

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

8082:
8083: l_hist_rec.APPROVER_ID := l_orig_sys_id;
8084: l_hist_rec.APPROVER_NAME := l_display_name;
8085:
8086: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
8087: l_hist_rec.CREATION_DATE := sysdate;
8088: l_hist_rec.LAST_UPDATE_DATE := sysdate;
8089: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
8090: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);

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

8085:
8086: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
8087: l_hist_rec.CREATION_DATE := sysdate;
8088: l_hist_rec.LAST_UPDATE_DATE := sysdate;
8089: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
8090: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);
8091: l_hist_rec.ORG_ID := l_org_id;
8092: l_hist_rec.AMOUNT_APPROVED := l_invoice_total;--0;
8093: l_hist_rec.NOTIFICATION_ORDER := l_notf_iteration;

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

8086: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
8087: l_hist_rec.CREATION_DATE := sysdate;
8088: l_hist_rec.LAST_UPDATE_DATE := sysdate;
8089: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
8090: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);
8091: l_hist_rec.ORG_ID := l_org_id;
8092: l_hist_rec.AMOUNT_APPROVED := l_invoice_total;--0;
8093: l_hist_rec.NOTIFICATION_ORDER := l_notf_iteration;
8094: l_hist_rec.APPROVER_COMMENTS := l_comments;

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

8446: l_hist_rec.ITERATION := l_iteration;
8447: l_hist_rec.RESPONSE := l_status;
8448: l_hist_rec.APPROVER_ID := l_orig_sys_id;
8449: l_hist_rec.APPROVER_NAME := l_display_name;
8450: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
8451: l_hist_rec.CREATION_DATE := sysdate;
8452: l_hist_rec.LAST_UPDATE_DATE := sysdate;
8453: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
8454: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);

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

8449: l_hist_rec.APPROVER_NAME := l_display_name;
8450: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
8451: l_hist_rec.CREATION_DATE := sysdate;
8452: l_hist_rec.LAST_UPDATE_DATE := sysdate;
8453: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
8454: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);
8455: l_hist_rec.ORG_ID := l_org_id;
8456: l_hist_rec.AMOUNT_APPROVED := 0;
8457: l_hist_rec.NOTIFICATION_ORDER := l_notf_iteration;

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

8450: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
8451: l_hist_rec.CREATION_DATE := sysdate;
8452: l_hist_rec.LAST_UPDATE_DATE := sysdate;
8453: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
8454: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);
8455: l_hist_rec.ORG_ID := l_org_id;
8456: l_hist_rec.AMOUNT_APPROVED := 0;
8457: l_hist_rec.NOTIFICATION_ORDER := l_notf_iteration;
8458: l_hist_rec.APPROVER_COMMENTS := l_comments;

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

8896: l_hist_rec.ITERATION := l_iteration;
8897: l_hist_rec.RESPONSE := 'TRANSFERRED';
8898:
8899: l_hist_rec.APPROVER_ID := l_orig_sys_id;
8900: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
8901: l_hist_rec.CREATION_DATE := sysdate;
8902: l_hist_rec.LAST_UPDATE_DATE := sysdate;
8903: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
8904: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);

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

8899: l_hist_rec.APPROVER_ID := l_orig_sys_id;
8900: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
8901: l_hist_rec.CREATION_DATE := sysdate;
8902: l_hist_rec.LAST_UPDATE_DATE := sysdate;
8903: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
8904: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);
8905: l_hist_rec.ORG_ID := l_org_id;
8906: l_hist_rec.NOTIFICATION_ORDER := l_notf_iteration;
8907:

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

8900: l_hist_rec.CREATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
8901: l_hist_rec.CREATION_DATE := sysdate;
8902: l_hist_rec.LAST_UPDATE_DATE := sysdate;
8903: l_hist_rec.LAST_UPDATED_BY := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
8904: l_hist_rec.LAST_UPDATE_LOGIN := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1);
8905: l_hist_rec.ORG_ID := l_org_id;
8906: l_hist_rec.NOTIFICATION_ORDER := l_notf_iteration;
8907:
8908: