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_CMA_PKG dependencies on AR_CREDIT_MEMO_AMOUNTS

Line 37: | This function compares two ar_credit_memo_amounts records to |

33: | FUNCTION |
34: | compare_cma_records |
35: | |
36: | DESCRIPTION |
37: | This function compares two ar_credit_memo_amounts records to |
38: | determine if any columns in the two records are different. If a |
39: | given column in the p_old_cma_rec record contains the dummy |
40: | constant, that column is not used in the comparison. |
41: | |

Line 64: ar_credit_memo_amounts%rowtype,

60: | |
61: +===========================================================================*/
62:
63: FUNCTION compare_cma_records( p_old_cma_rec IN
64: ar_credit_memo_amounts%rowtype,
65: p_new_cma_rec IN
66: ar_credit_memo_amounts%rowtype)
67: RETURN BOOLEAN IS
68: l_result boolean;

Line 66: ar_credit_memo_amounts%rowtype)

62:
63: FUNCTION compare_cma_records( p_old_cma_rec IN
64: ar_credit_memo_amounts%rowtype,
65: p_new_cma_rec IN
66: ar_credit_memo_amounts%rowtype)
67: RETURN BOOLEAN IS
68: l_result boolean;
69: l_sql_result varchar2(2);
70:

Line 173: | p_cma_rec - ar_credit_memo_amounts record |

169: | arp_util.debug |
170: | |
171: | ARGUMENTS : IN: |
172: | p_update_cursor - ID of the update cursor |
173: | p_cma_rec - ar_credit_memo_amounts record |
174: | OUT: |
175: | None |
176: | |
177: | RETURNS : NONE |

Line 188: p_cma_rec IN ar_credit_memo_amounts%rowtype)

184: +===========================================================================*/
185:
186:
187: PROCEDURE bind_cma_variables(p_update_cursor IN integer,
188: p_cma_rec IN ar_credit_memo_amounts%rowtype)
189: IS
190:
191: BEGIN
192:

Line 313: 'UPDATE ar_credit_memo_amounts

309: BEGIN
310: arp_util.debug('arp_cma_pkg.construct_cma_update_stmt()+');
311:
312: update_text :=
313: 'UPDATE ar_credit_memo_amounts
314: SET credit_memo_amount_id =
315: DECODE(:credit_memo_amount_id,
316: :ar_number_dummy, credit_memo_amount_id,
317: :credit_memo_amount_id),

Line 382: | This procedure Updates records in ar_credit_memo_amounts |

378: | PROCEDURE |
379: | generic_update |
380: | |
381: | DESCRIPTION |
382: | This procedure Updates records in ar_credit_memo_amounts |
383: | identified by the where clause that is passed in as a parameter. Only |
384: | those columns in the cma record parameter that do not contain the |
385: | special dummy values are updated. |
386: | |

Line 416: p_cma_rec IN ar_credit_memo_amounts%rowtype) IS

412:
413: PROCEDURE generic_update(p_update_cursor IN OUT NOCOPY integer,
414: p_where_clause IN varchar2,
415: p_where1 IN number,
416: p_cma_rec IN ar_credit_memo_amounts%rowtype) IS
417:
418: l_count number;
419: l_update_statement varchar2(25000);
420:

Line 519: PROCEDURE set_to_dummy( p_cma_rec OUT NOCOPY ar_credit_memo_amounts%rowtype) IS

515: | 27-JUN-95 Charlie Tomberg Created |
516: | |
517: +===========================================================================*/
518:
519: PROCEDURE set_to_dummy( p_cma_rec OUT NOCOPY ar_credit_memo_amounts%rowtype) IS
520:
521: BEGIN
522:
523: arp_util.debug('arp_cma_pkg.set_to_dummy()+');

Line 554: | This procedure locks the ar_credit_memo_amounts row identified by |

550: | PROCEDURE |
551: | lock_p |
552: | |
553: | DESCRIPTION |
554: | This procedure locks the ar_credit_memo_amounts row identified by |
555: | p_credit_memo_amount_id parameter. |
556: | |
557: | SCOPE - PUBLIC |
558: | |

Line 577: IN ar_credit_memo_amounts.credit_memo_amount_id%type

573: | |
574: +===========================================================================*/
575:
576: PROCEDURE lock_p( p_credit_memo_amount_id
577: IN ar_credit_memo_amounts.credit_memo_amount_id%type
578: )
579: IS
580:
581: l_credit_memo_amount_id

Line 582: ar_credit_memo_amounts.credit_memo_amount_id%type;

578: )
579: IS
580:
581: l_credit_memo_amount_id
582: ar_credit_memo_amounts.credit_memo_amount_id%type;
583:
584: BEGIN
585: arp_util.debug('arp_cma_pkg.lock_p()+');
586:

Line 590: FROM ar_credit_memo_amounts

586:
587:
588: SELECT credit_memo_amount_id
589: INTO l_credit_memo_amount_id
590: FROM ar_credit_memo_amounts
591: WHERE credit_memo_amount_id = p_credit_memo_amount_id
592: FOR UPDATE OF credit_memo_amount_id NOWAIT;
593:
594: arp_util.debug('arp_cma_pkg.lock_p()-');

Line 607: | This procedure locks the ar_credit_memo_amounts rows identified by |

603: | PROCEDURE |
604: | lock_f_ctl_id |
605: | |
606: | DESCRIPTION |
607: | This procedure locks the ar_credit_memo_amounts rows identified by |
608: | p_customer_trx_line_id parameter. |
609: | |
610: | SCOPE - PUBLIC |
611: | |

Line 635: FROM ar_credit_memo_amounts

631: IS
632:
633: CURSOR lock_c IS
634: SELECT credit_memo_amount_id
635: FROM ar_credit_memo_amounts
636: WHERE customer_trx_line_id = p_customer_trx_line_id
637: FOR UPDATE OF credit_memo_amount_id NOWAIT;
638:
639: BEGIN

Line 658: | This procedure locks the ar_credit_memo_amounts row identified |

654: | PROCEDURE |
655: | lock_fetch_p |
656: | |
657: | DESCRIPTION |
658: | This procedure locks the ar_credit_memo_amounts row identified |
659: | by the p_credit_memo_amount_id parameter and populates the |
660: | p_cma_rec parameter with the row that was locked. |
661: | |
662: | SCOPE - PUBLIC |

Line 681: PROCEDURE lock_fetch_p( p_cma_rec IN OUT NOCOPY ar_credit_memo_amounts%rowtype,

677: | 27-JUN-95 Charlie Tomberg Created |
678: | |
679: +===========================================================================*/
680:
681: PROCEDURE lock_fetch_p( p_cma_rec IN OUT NOCOPY ar_credit_memo_amounts%rowtype,
682: p_credit_memo_amount_id IN
683: ar_credit_memo_amounts.credit_memo_amount_id%type) IS
684:
685: BEGIN

Line 683: ar_credit_memo_amounts.credit_memo_amount_id%type) IS

679: +===========================================================================*/
680:
681: PROCEDURE lock_fetch_p( p_cma_rec IN OUT NOCOPY ar_credit_memo_amounts%rowtype,
682: p_credit_memo_amount_id IN
683: ar_credit_memo_amounts.credit_memo_amount_id%type) IS
684:
685: BEGIN
686: arp_util.debug('arp_cma_pkg.lock_fetch_p()+');
687:

Line 690: FROM ar_credit_memo_amounts

686: arp_util.debug('arp_cma_pkg.lock_fetch_p()+');
687:
688: SELECT *
689: INTO p_cma_rec
690: FROM ar_credit_memo_amounts
691: WHERE credit_memo_amount_id = p_credit_memo_amount_id
692: FOR UPDATE OF credit_memo_amount_id NOWAIT;
693:
694: arp_util.debug('arp_cma_pkg.lock_fetch_p()-');

Line 707: | This procedure locks the ar_credit_memo_amounts row identified |

703: | PROCEDURE |
704: | lock_compare_p |
705: | |
706: | DESCRIPTION |
707: | This procedure locks the ar_credit_memo_amounts row identified |
708: | by the p_credit_memo_amount_id parameter only if no columns in |
709: | that row have changed from when they were first selected in the form. |
710: | |
711: | SCOPE - PUBLIC |

Line 731: PROCEDURE lock_compare_p( p_cma_rec IN ar_credit_memo_amounts%rowtype,

727: | 27-JUN-95 Charlie Tomberg Created |
728: | |
729: +===========================================================================*/
730:
731: PROCEDURE lock_compare_p( p_cma_rec IN ar_credit_memo_amounts%rowtype,
732: p_credit_memo_amount_id IN
733: ar_credit_memo_amounts.credit_memo_amount_id%type) IS
734:
735: l_new_cma_rec ar_credit_memo_amounts%rowtype;

Line 733: ar_credit_memo_amounts.credit_memo_amount_id%type) IS

729: +===========================================================================*/
730:
731: PROCEDURE lock_compare_p( p_cma_rec IN ar_credit_memo_amounts%rowtype,
732: p_credit_memo_amount_id IN
733: ar_credit_memo_amounts.credit_memo_amount_id%type) IS
734:
735: l_new_cma_rec ar_credit_memo_amounts%rowtype;
736:
737: BEGIN

Line 735: l_new_cma_rec ar_credit_memo_amounts%rowtype;

731: PROCEDURE lock_compare_p( p_cma_rec IN ar_credit_memo_amounts%rowtype,
732: p_credit_memo_amount_id IN
733: ar_credit_memo_amounts.credit_memo_amount_id%type) IS
734:
735: l_new_cma_rec ar_credit_memo_amounts%rowtype;
736:
737: BEGIN
738: arp_util.debug('arp_cma_pkg.lock_compare_p()+');
739:

Line 742: FROM ar_credit_memo_amounts cma

738: arp_util.debug('arp_cma_pkg.lock_compare_p()+');
739:
740: SELECT *
741: INTO l_new_cma_rec
742: FROM ar_credit_memo_amounts cma
743: WHERE cma.credit_memo_amount_id = p_credit_memo_amount_id
744: AND
745: (
746: NVL(cma.credit_memo_amount_id, AR_NUMBER_DUMMY) =

Line 865: | This procedure fetches a single row from ar_credit_memo_amounts |

861: | PROCEDURE |
862: | fetch_p |
863: | |
864: | DESCRIPTION |
865: | This procedure fetches a single row from ar_credit_memo_amounts |
866: | into a variable specified as a parameter based on the table's primary |
867: | key, credit_memo_amount_id |
868: | |
869: | SCOPE - PUBLIC |

Line 888: PROCEDURE fetch_p( p_cma_rec OUT NOCOPY ar_credit_memo_amounts%rowtype,

884: | 27-JUN-95 Charlie Tomberg Created |
885: | |
886: +===========================================================================*/
887:
888: PROCEDURE fetch_p( p_cma_rec OUT NOCOPY ar_credit_memo_amounts%rowtype,
889: p_credit_memo_amount_id IN
890: ar_credit_memo_amounts.credit_memo_amount_id%type)
891: IS
892:

Line 890: ar_credit_memo_amounts.credit_memo_amount_id%type)

886: +===========================================================================*/
887:
888: PROCEDURE fetch_p( p_cma_rec OUT NOCOPY ar_credit_memo_amounts%rowtype,
889: p_credit_memo_amount_id IN
890: ar_credit_memo_amounts.credit_memo_amount_id%type)
891: IS
892:
893: BEGIN
894: arp_util.debug('arp_cma_pkg.fetch_p()+');

Line 898: FROM ar_credit_memo_amounts

894: arp_util.debug('arp_cma_pkg.fetch_p()+');
895:
896: SELECT *
897: INTO p_cma_rec
898: FROM ar_credit_memo_amounts
899: WHERE credit_memo_amount_id = p_credit_memo_amount_id;
900:
901: arp_util.debug('arp_cma_pkg.fetch_p()-');
902:

Line 914: | This procedure deletes the ar_credit_memo_amounts row identified |

910: | PROCEDURE |
911: | delete_p |
912: | |
913: | DESCRIPTION |
914: | This procedure deletes the ar_credit_memo_amounts row identified |
915: | by the p_credit_memo_amount_id parameter. |
916: | |
917: | SCOPE - PUBLIC |
918: | |

Line 937: IN ar_credit_memo_amounts.credit_memo_amount_id%type)

933: | |
934: +===========================================================================*/
935:
936: procedure delete_p( p_credit_memo_amount_id
937: IN ar_credit_memo_amounts.credit_memo_amount_id%type)
938: IS
939:
940:
941: BEGIN

Line 946: DELETE FROM ar_credit_memo_amounts

942:
943:
944: arp_util.debug('arp_cma_pkg.delete_p()+');
945:
946: DELETE FROM ar_credit_memo_amounts
947: WHERE credit_memo_amount_id = p_credit_memo_amount_id;
948:
949: arp_util.debug('arp_cma_pkg.delete_p()-');
950:

Line 964: | This procedure deletes the ar_credit_memo_amounts rows identified |

960: | PROCEDURE |
961: | delete_f_ctl_id |
962: | |
963: | DESCRIPTION |
964: | This procedure deletes the ar_credit_memo_amounts rows identified |
965: | by the p_customer_trx_line_id parameter. |
966: | |
967: | SCOPE - PUBLIC |
968: | |

Line 996: DELETE FROM ar_credit_memo_amounts

992:
993:
994: arp_util.debug('arp_cma_pkg.delete_f_ctl_id()+');
995:
996: DELETE FROM ar_credit_memo_amounts
997: WHERE customer_trx_line_id = p_customer_trx_line_id;
998:
999: arp_util.debug('arp_cma_pkg.delete_f_ctl_id()-');
1000:

Line 1014: | This procedure deletes the ar_credit_memo_amounts rows identified |

1010: | PROCEDURE |
1011: | delete_f_ct_id |
1012: | |
1013: | DESCRIPTION |
1014: | This procedure deletes the ar_credit_memo_amounts rows identified |
1015: | by the p_customer_trx_id parameter. |
1016: | |
1017: | SCOPE - PUBLIC |
1018: | |

Line 1046: DELETE FROM ar_credit_memo_amounts

1042: BEGIN
1043:
1044: arp_util.debug('arp_cma_pkg.delete_f_ct_id()+');
1045:
1046: DELETE FROM ar_credit_memo_amounts
1047: WHERE customer_trx_line_id IN
1048: (SELECT customer_trx_line_id
1049: FROM ra_customer_trx_lines
1050: WHERE customer_trx_id = p_customer_trx_id);

Line 1067: | This procedure updates the ar_credit_memo_amounts row identified |

1063: | PROCEDURE |
1064: | update_p |
1065: | |
1066: | DESCRIPTION |
1067: | This procedure updates the ar_credit_memo_amounts row identified |
1068: | by the p_credit_memo_amount_id parameter. |
1069: | |
1070: | SCOPE - PUBLIC |
1071: | |

Line 1092: PROCEDURE update_p( p_cma_rec IN ar_credit_memo_amounts%rowtype,

1088: | 27-JUN-95 Charlie Tomberg Created |
1089: | |
1090: +===========================================================================*/
1091:
1092: PROCEDURE update_p( p_cma_rec IN ar_credit_memo_amounts%rowtype,
1093: p_credit_memo_amount_id IN
1094: ar_credit_memo_amounts.credit_memo_amount_id%type)
1095: IS
1096:

Line 1094: ar_credit_memo_amounts.credit_memo_amount_id%type)

1090: +===========================================================================*/
1091:
1092: PROCEDURE update_p( p_cma_rec IN ar_credit_memo_amounts%rowtype,
1093: p_credit_memo_amount_id IN
1094: ar_credit_memo_amounts.credit_memo_amount_id%type)
1095: IS
1096:
1097:
1098: BEGIN

Line 1123: | This procedure updates the ar_credit_memo_amounts rows identified |

1119: | PROCEDURE |
1120: | update_f_ctl_id |
1121: | |
1122: | DESCRIPTION |
1123: | This procedure updates the ar_credit_memo_amounts rows identified |
1124: | by the p_customer_trx_line_id parameter. |
1125: | |
1126: | SCOPE - PUBLIC |
1127: | |

Line 1148: PROCEDURE update_f_ctl_id( p_cma_rec IN ar_credit_memo_amounts%rowtype,

1144: | 27-JUN-95 Charlie Tomberg Created |
1145: | |
1146: +===========================================================================*/
1147:
1148: PROCEDURE update_f_ctl_id( p_cma_rec IN ar_credit_memo_amounts%rowtype,
1149: p_customer_trx_line_id IN
1150: ra_customer_trx_lines.customer_trx_line_id%type)
1151: IS
1152:

Line 1180: | This procedure inserts a row into ar_credit_memo_amounts that |

1176: | PROCEDURE |
1177: | insert_p |
1178: | |
1179: | DESCRIPTION |
1180: | This procedure inserts a row into ar_credit_memo_amounts that |
1181: | contains the column values specified in the p_cma_rec parameter. |
1182: | |
1183: | SCOPE - PUBLIC |
1184: | |

Line 1203: p_cma_rec IN ar_credit_memo_amounts%rowtype,

1199: | |
1200: +===========================================================================*/
1201:
1202: PROCEDURE insert_p(
1203: p_cma_rec IN ar_credit_memo_amounts%rowtype,
1204: p_credit_memo_amount_id
1205: OUT NOCOPY ar_credit_memo_amounts.credit_memo_amount_id%type
1206:
1207: ) IS

Line 1205: OUT NOCOPY ar_credit_memo_amounts.credit_memo_amount_id%type

1201:
1202: PROCEDURE insert_p(
1203: p_cma_rec IN ar_credit_memo_amounts%rowtype,
1204: p_credit_memo_amount_id
1205: OUT NOCOPY ar_credit_memo_amounts.credit_memo_amount_id%type
1206:
1207: ) IS
1208:
1209:

Line 1211: ar_credit_memo_amounts.credit_memo_amount_id%type;

1207: ) IS
1208:
1209:
1210: l_credit_memo_amount_id
1211: ar_credit_memo_amounts.credit_memo_amount_id%type;
1212:
1213:
1214: BEGIN
1215:

Line 1224: SELECT AR_CREDIT_MEMO_AMOUNTS_S.NEXTVAL

1220: /*---------------------------*
1221: | Get the unique identifier |
1222: *---------------------------*/
1223:
1224: SELECT AR_CREDIT_MEMO_AMOUNTS_S.NEXTVAL
1225: INTO l_credit_memo_amount_id
1226: FROM DUAL;
1227:
1228:

Line 1233: INSERT INTO ar_credit_memo_amounts

1229: /*-------------------*
1230: | Insert the record |
1231: *-------------------*/
1232:
1233: INSERT INTO ar_credit_memo_amounts
1234: (
1235: credit_memo_amount_id,
1236: customer_trx_line_id,
1237: gl_date,