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.ARP_AAH_PKG dependencies on AR_APPROVAL_ACTION_HISTORY

Line 48: | p_aah_rec - ar_approval_action_history record |

44: | arp_util.debug |
45: | |
46: | ARGUMENTS : IN: |
47: | p_update_cursor - ID of the update cursor |
48: | p_aah_rec - ar_approval_action_history record |
49: | OUT: |
50: | None |
51: | |
52: | RETURNS : NONE |

Line 63: p_aah_rec IN ar_approval_action_history%rowtype)

59: +===========================================================================*/
60:
61:
62: PROCEDURE bind_aah_variables(p_update_cursor IN integer,
63: p_aah_rec IN ar_approval_action_history%rowtype)
64: IS
65:
66: BEGIN
67:

Line 231: 'UPDATE ar_approval_action_history

227: BEGIN
228: arp_util.debug('arp_aah_pkg.construct_aah_update_stmt()+');
229:
230: update_text :=
231: 'UPDATE ar_approval_action_history
232: SET approval_action_history_id =
233: DECODE(:approval_action_history_id,
234: :ar_number_dummy, approval_action_history_id,
235: :approval_action_history_id),

Line 352: | This procedure Updates records in ar_approval_action_history |

348: | PROCEDURE |
349: | generic_update |
350: | |
351: | DESCRIPTION |
352: | This procedure Updates records in ar_approval_action_history |
353: | identified by the where clause that is passed in as a parameter. Only |
354: | those columns in the aah record parameter that do not contain the |
355: | special dummy values are updated. |
356: | |

Line 386: p_aah_rec IN ar_approval_action_history%rowtype) IS

382:
383: PROCEDURE generic_update(p_update_cursor IN OUT NOCOPY integer,
384: p_where_clause IN varchar2,
385: p_where1 IN number,
386: p_aah_rec IN ar_approval_action_history%rowtype) IS
387:
388: l_count number;
389: l_update_statement varchar2(25000);
390:

Line 490: PROCEDURE set_to_dummy( p_aah_rec OUT NOCOPY ar_approval_action_history%rowtype) IS

486: | 28-JUN-95 Charlie Tomberg Created |
487: | |
488: +===========================================================================*/
489:
490: PROCEDURE set_to_dummy( p_aah_rec OUT NOCOPY ar_approval_action_history%rowtype) IS
491:
492: BEGIN
493:
494: arp_util.debug('arp_aah_pkg.set_to_dummy()+');

Line 538: | This procedure locks the ar_approval_action_history row identified by |

534: | PROCEDURE |
535: | lock_p |
536: | |
537: | DESCRIPTION |
538: | This procedure locks the ar_approval_action_history row identified by |
539: | p_approval_action_history_id parameter. |
540: | |
541: | SCOPE - PUBLIC |
542: | |

Line 561: IN ar_approval_action_history.approval_action_history_id%type

557: | |
558: +===========================================================================*/
559:
560: PROCEDURE lock_p( p_approval_action_history_id
561: IN ar_approval_action_history.approval_action_history_id%type
562: )
563: IS
564:
565: l_approval_action_history_id

Line 566: ar_approval_action_history.approval_action_history_id%type;

562: )
563: IS
564:
565: l_approval_action_history_id
566: ar_approval_action_history.approval_action_history_id%type;
567:
568: BEGIN
569: arp_util.debug('arp_aah_pkg.lock_p()+');
570:

Line 574: FROM ar_approval_action_history

570:
571:
572: SELECT approval_action_history_id
573: INTO l_approval_action_history_id
574: FROM ar_approval_action_history
575: WHERE approval_action_history_id = p_approval_action_history_id
576: FOR UPDATE OF approval_action_history_id NOWAIT;
577:
578: arp_util.debug('arp_aah_pkg.lock_p()-');

Line 591: | This procedure locks the ar_approval_action_history rows identified by |

587: | PROCEDURE |
588: | lock_f_adj_id |
589: | |
590: | DESCRIPTION |
591: | This procedure locks the ar_approval_action_history rows identified by |
592: | p_adjustment_id parameter. |
593: | |
594: | SCOPE - PUBLIC |
595: | |

Line 619: FROM ar_approval_action_history

615: IS
616:
617: CURSOR LOCK_C IS
618: SELECT approval_action_history_id
619: FROM ar_approval_action_history
620: WHERE adjustment_id = p_adjustment_id
621: FOR UPDATE OF approval_action_history_id NOWAIT;
622:
623:

Line 644: | This procedure locks the ar_approval_action_history row identified |

640: | PROCEDURE |
641: | lock_fetch_p |
642: | |
643: | DESCRIPTION |
644: | This procedure locks the ar_approval_action_history row identified |
645: | by the p_approval_action_history_id parameter and populates the |
646: | p_aah_rec parameter with the row that was locked. |
647: | |
648: | SCOPE - PUBLIC |

Line 667: PROCEDURE lock_fetch_p( p_aah_rec IN OUT NOCOPY ar_approval_action_history%rowtype,

663: | 28-JUN-95 Charlie Tomberg Created |
664: | |
665: +===========================================================================*/
666:
667: PROCEDURE lock_fetch_p( p_aah_rec IN OUT NOCOPY ar_approval_action_history%rowtype,
668: p_approval_action_history_id IN
669: ar_approval_action_history.approval_action_history_id%type) IS
670:
671: BEGIN

Line 669: ar_approval_action_history.approval_action_history_id%type) IS

665: +===========================================================================*/
666:
667: PROCEDURE lock_fetch_p( p_aah_rec IN OUT NOCOPY ar_approval_action_history%rowtype,
668: p_approval_action_history_id IN
669: ar_approval_action_history.approval_action_history_id%type) IS
670:
671: BEGIN
672: arp_util.debug('arp_aah_pkg.lock_fetch_p()+');
673:

Line 676: FROM ar_approval_action_history

672: arp_util.debug('arp_aah_pkg.lock_fetch_p()+');
673:
674: SELECT *
675: INTO p_aah_rec
676: FROM ar_approval_action_history
677: WHERE approval_action_history_id = p_approval_action_history_id
678: FOR UPDATE OF approval_action_history_id NOWAIT;
679:
680: arp_util.debug('arp_aah_pkg.lock_fetch_p()-');

Line 693: | This procedure locks the ar_approval_action_history row identified |

689: | PROCEDURE |
690: | lock_compare_p |
691: | |
692: | DESCRIPTION |
693: | This procedure locks the ar_approval_action_history row identified |
694: | by the p_approval_action_history_id parameter only if no columns in |
695: | that row have changed from when they were first selected in the form. |
696: | |
697: | SCOPE - PUBLIC |

Line 719: ar_approval_action_history.approval_action_history_id%type,

715: +===========================================================================*/
716:
717: PROCEDURE lock_compare_p(
718: p_approval_action_history_id IN
719: ar_approval_action_history.approval_action_history_id%type,
720: p_aah_rec IN ar_approval_action_history%rowtype) IS
721:
722: l_dummy_aah_rec ar_approval_action_history%rowtype;
723:

Line 720: p_aah_rec IN ar_approval_action_history%rowtype) IS

716:
717: PROCEDURE lock_compare_p(
718: p_approval_action_history_id IN
719: ar_approval_action_history.approval_action_history_id%type,
720: p_aah_rec IN ar_approval_action_history%rowtype) IS
721:
722: l_dummy_aah_rec ar_approval_action_history%rowtype;
723:
724: BEGIN

Line 722: l_dummy_aah_rec ar_approval_action_history%rowtype;

718: p_approval_action_history_id IN
719: ar_approval_action_history.approval_action_history_id%type,
720: p_aah_rec IN ar_approval_action_history%rowtype) IS
721:
722: l_dummy_aah_rec ar_approval_action_history%rowtype;
723:
724: BEGIN
725: arp_util.debug('arp_aah_pkg.lock_compare_p()+');
726:

Line 729: FROM ar_approval_action_history aah

725: arp_util.debug('arp_aah_pkg.lock_compare_p()+');
726:
727: SELECT *
728: INTO l_dummy_aah_rec
729: FROM ar_approval_action_history aah
730: WHERE approval_action_history_id = p_approval_action_history_id
731: AND NOT
732: (
733: NVL(aah.approval_action_history_id, AR_NUMBER_DUMMY) <>

Line 957: | This procedure fetches a single row from ar_approval_action_history |

953: | PROCEDURE |
954: | fetch_p |
955: | |
956: | DESCRIPTION |
957: | This procedure fetches a single row from ar_approval_action_history |
958: | into a variable specified as a parameter based on the table's primary |
959: | key, approval_action_history_id |
960: | |
961: | SCOPE - PUBLIC |

Line 980: PROCEDURE fetch_p( p_aah_rec OUT NOCOPY ar_approval_action_history%rowtype,

976: | 28-JUN-95 Charlie Tomberg Created |
977: | |
978: +===========================================================================*/
979:
980: PROCEDURE fetch_p( p_aah_rec OUT NOCOPY ar_approval_action_history%rowtype,
981: p_approval_action_history_id IN
982: ar_approval_action_history.approval_action_history_id%type)
983: IS
984:

Line 982: ar_approval_action_history.approval_action_history_id%type)

978: +===========================================================================*/
979:
980: PROCEDURE fetch_p( p_aah_rec OUT NOCOPY ar_approval_action_history%rowtype,
981: p_approval_action_history_id IN
982: ar_approval_action_history.approval_action_history_id%type)
983: IS
984:
985: BEGIN
986: arp_util.debug('arp_aah_pkg.fetch_p()+');

Line 990: FROM ar_approval_action_history

986: arp_util.debug('arp_aah_pkg.fetch_p()+');
987:
988: SELECT *
989: INTO p_aah_rec
990: FROM ar_approval_action_history
991: WHERE approval_action_history_id = p_approval_action_history_id;
992:
993: arp_util.debug('arp_aah_pkg.fetch_p()-');
994:

Line 1006: | This procedure deletes the ar_approval_action_history row identified |

1002: | PROCEDURE |
1003: | delete_p |
1004: | |
1005: | DESCRIPTION |
1006: | This procedure deletes the ar_approval_action_history row identified |
1007: | by the p_approval_action_history_id parameter. |
1008: | |
1009: | SCOPE - PUBLIC |
1010: | |

Line 1029: IN ar_approval_action_history.approval_action_history_id%type)

1025: | |
1026: +===========================================================================*/
1027:
1028: procedure delete_p( p_approval_action_history_id
1029: IN ar_approval_action_history.approval_action_history_id%type)
1030: IS
1031:
1032:
1033: BEGIN

Line 1038: DELETE FROM ar_approval_action_history

1034:
1035:
1036: arp_util.debug('arp_aah_pkg.delete_p()+');
1037:
1038: DELETE FROM ar_approval_action_history
1039: WHERE approval_action_history_id = p_approval_action_history_id;
1040:
1041: arp_util.debug('arp_aah_pkg.delete_p()-');
1042:

Line 1056: | This procedure deletes the ar_approval_action_history rows identified |

1052: | PROCEDURE |
1053: | delete_f_adj_id |
1054: | |
1055: | DESCRIPTION |
1056: | This procedure deletes the ar_approval_action_history rows identified |
1057: | by the p_adjustment_id parameter . |
1058: | |
1059: | SCOPE - PUBLIC |
1060: | |

Line 1088: DELETE FROM ar_approval_action_history

1084:
1085:
1086: arp_util.debug('arp_aah_pkg.delete_f_adj_id()+');
1087:
1088: DELETE FROM ar_approval_action_history
1089: WHERE adjustment_id = p_adjustment_id;
1090:
1091: arp_util.debug('arp_aah_pkg.delete_f_adj_id()-');
1092:

Line 1107: | This procedure updates the ar_approval_action_history row identified |

1103: | PROCEDURE |
1104: | update_p |
1105: | |
1106: | DESCRIPTION |
1107: | This procedure updates the ar_approval_action_history row identified |
1108: | by the p_approval_action_history_id parameter. |
1109: | |
1110: | SCOPE - PUBLIC |
1111: | |

Line 1132: PROCEDURE update_p( p_aah_rec IN ar_approval_action_history%rowtype,

1128: | 28-JUN-95 Charlie Tomberg Created |
1129: | |
1130: +===========================================================================*/
1131:
1132: PROCEDURE update_p( p_aah_rec IN ar_approval_action_history%rowtype,
1133: p_approval_action_history_id IN
1134: ar_approval_action_history.approval_action_history_id%type)
1135: IS
1136:

Line 1134: ar_approval_action_history.approval_action_history_id%type)

1130: +===========================================================================*/
1131:
1132: PROCEDURE update_p( p_aah_rec IN ar_approval_action_history%rowtype,
1133: p_approval_action_history_id IN
1134: ar_approval_action_history.approval_action_history_id%type)
1135: IS
1136:
1137:
1138: BEGIN

Line 1164: | This procedure updates the ar_approval_action_history rows identified |

1160: | PROCEDURE |
1161: | update_f_adj_id |
1162: | |
1163: | DESCRIPTION |
1164: | This procedure updates the ar_approval_action_history rows identified |
1165: | by the p_adjustment_id parameter. |
1166: | |
1167: | SCOPE - PUBLIC |
1168: | |

Line 1189: PROCEDURE update_f_adj_id( p_aah_rec IN ar_approval_action_history%rowtype,

1185: | 28-JUN-95 Charlie Tomberg Created |
1186: | |
1187: +===========================================================================*/
1188:
1189: PROCEDURE update_f_adj_id( p_aah_rec IN ar_approval_action_history%rowtype,
1190: p_adjustment_id IN ar_adjustments.adjustment_id%type)
1191: IS
1192:
1193:

Line 1220: | This procedure inserts a row into ar_approval_action_history that |

1216: | PROCEDURE |
1217: | insert_p |
1218: | |
1219: | DESCRIPTION |
1220: | This procedure inserts a row into ar_approval_action_history that |
1221: | contains the column values specified in the p_aah_rec parameter. |
1222: | |
1223: | SCOPE - PUBLIC |
1224: | |

Line 1243: p_aah_rec IN ar_approval_action_history%rowtype,

1239: | |
1240: +===========================================================================*/
1241:
1242: PROCEDURE insert_p(
1243: p_aah_rec IN ar_approval_action_history%rowtype,
1244: p_approval_action_history_id
1245: OUT NOCOPY ar_approval_action_history.approval_action_history_id%type
1246: ) IS
1247:

Line 1245: OUT NOCOPY ar_approval_action_history.approval_action_history_id%type

1241:
1242: PROCEDURE insert_p(
1243: p_aah_rec IN ar_approval_action_history%rowtype,
1244: p_approval_action_history_id
1245: OUT NOCOPY ar_approval_action_history.approval_action_history_id%type
1246: ) IS
1247:
1248:
1249: l_approval_action_history_id

Line 1250: ar_approval_action_history.approval_action_history_id%type;

1246: ) IS
1247:
1248:
1249: l_approval_action_history_id
1250: ar_approval_action_history.approval_action_history_id%type;
1251:
1252:
1253: BEGIN
1254:

Line 1263: SELECT AR_APPROVAL_ACTION_HISTORY_S.NEXTVAL

1259: /*---------------------------*
1260: | Get the unique identifier |
1261: *---------------------------*/
1262:
1263: SELECT AR_APPROVAL_ACTION_HISTORY_S.NEXTVAL
1264: INTO l_approval_action_history_id
1265: FROM DUAL;
1266:
1267:

Line 1272: INSERT INTO ar_approval_action_history

1268: /*-------------------*
1269: | Insert the record |
1270: *-------------------*/
1271:
1272: INSERT INTO ar_approval_action_history
1273: (
1274: approval_action_history_id,
1275: action_name,
1276: adjustment_id,

Line 1372: p_aah_rec IN ar_approval_action_history%rowtype) IS

1368: | |
1369: +===========================================================================*/
1370:
1371: PROCEDURE display_aah_rec(
1372: p_aah_rec IN ar_approval_action_history%rowtype) IS
1373:
1374: BEGIN
1375: arp_util.debug('arp_aah_pkg.display_aah_rec()+');
1376:

Line 1377: arp_util.debug('******** Dump of ar_approval_action_history record ' ||

1373:
1374: BEGIN
1375: arp_util.debug('arp_aah_pkg.display_aah_rec()+');
1376:
1377: arp_util.debug('******** Dump of ar_approval_action_history record ' ||
1378: '*********');
1379:
1380: arp_util.debug('approval_action_history_id : '||
1381: p_aah_rec.approval_action_history_id);

Line 1463: ar_approval_action_history.approval_action_history_id%type) IS

1459: | |
1460: +===========================================================================*/
1461: PROCEDURE display_aah_p(
1462: p_approval_action_history_id IN
1463: ar_approval_action_history.approval_action_history_id%type) IS
1464:
1465: l_aah_rec ar_approval_action_history%rowtype;
1466: BEGIN
1467: arp_util.debug('arp_aah_pkg.display_aah_p()+');

Line 1465: l_aah_rec ar_approval_action_history%rowtype;

1461: PROCEDURE display_aah_p(
1462: p_approval_action_history_id IN
1463: ar_approval_action_history.approval_action_history_id%type) IS
1464:
1465: l_aah_rec ar_approval_action_history%rowtype;
1466: BEGIN
1467: arp_util.debug('arp_aah_pkg.display_aah_p()+');
1468:
1469: arp_aah_pkg.fetch_p(l_aah_rec, p_approval_action_history_id);

Line 1523: FROM ar_approval_action_history

1519: IS
1520:
1521: CURSOR aah_cursor IS
1522: SELECT approval_action_history_id
1523: FROM ar_approval_action_history
1524: WHERE adjustment_id = p_adjustment_id
1525: ORDER BY approval_action_history_id;
1526:
1527: BEGIN

Line 1534: ' Dump of ar_approval_action_history records for adj_id: '||

1530:
1531: arp_util.debug('=====================================================' ||
1532: '==========================');
1533: arp_util.debug('======= ' ||
1534: ' Dump of ar_approval_action_history records for adj_id: '||
1535: to_char( p_adjustment_id ) || ' ' ||
1536: '======');
1537:
1538: FOR l_aah_rec IN aah_cursor LOOP

Line 1543: ' Dump of ar_approval_action_history records for adj_id: '||

1539: display_aah_p(l_aah_rec.approval_action_history_id);
1540: END LOOP;
1541:
1542: arp_util.debug('==== End ' ||
1543: ' Dump of ar_approval_action_history records for adj_id: '||
1544: to_char( p_adjustment_id ) || ' ' ||
1545: '=====');
1546: arp_util.debug('=====================================================' ||
1547: '==========================');