53: | arp_util.debug |
54: | |
55: | ARGUMENTS : IN: |
56: | p_update_cursor - ID of the update cursor |
57: | p_adj_rec - ar_adjustments record |
58: | p_exchange_rate |
59: | p_currency_code |
60: | p_precision |
61: | p_mau |
82: +===========================================================================*/
83:
84:
85: PROCEDURE bind_adj_variables(p_update_cursor IN integer,
86: p_adj_rec IN ar_adjustments%rowtype,
87: p_exchange_rate IN
88: ar_payment_schedules.exchange_rate%type,
89: p_currency_code IN
90: fnd_currencies.currency_code%type,
419:
420: arp_util.debug('arp_adjustments_pkg.construct_adj_update_stmt()+');
421:
422: update_text :=
423: 'UPDATE ar_adjustments
424: SET adjustment_id =
425: DECODE(:adjustment_id,
426: :ar_number_dummy, adjustment_id,
427: :adjustment_id),
710: | PROCEDURE |
711: | generic_update |
712: | |
713: | DESCRIPTION |
714: | This procedure Updates records in ar_adjustments |
715: | identified by the where clause that is passed in as a parameter. Only |
716: | those columns in the srep record parameter that do not contain the |
717: | special dummy values are updated. |
718: | |
747: p_where_clause IN varchar2,
748: p_where1 IN number,
749: p_exchange_rate IN
750: ar_payment_schedules.exchange_rate%type,
751: p_adj_rec IN ar_adjustments%rowtype)
752: IS
753:
754: l_count number;
755: l_update_statement varchar2(25000);
848: | call mrc engine to update AR_MC_ADJUSTMENTS |
849: +---------------------------------------------*/
850: -- ar_mrc_engine.maintain_mrc_data(
851: -- p_event_mode => 'UPDATE',
852: -- p_table_name => 'AR_ADJUSTMENTS',
853: -- p_mode => 'SINGLE',
854: -- p_key_value => adj_array(I));
855: -- END LOOP;
856:
907: | 29-JUN-95 Charlie Tomberg Created |
908: | |
909: +===========================================================================*/
910:
911: PROCEDURE set_to_dummy( p_adj_rec OUT NOCOPY ar_adjustments%rowtype) IS
912:
913: BEGIN
914:
915: arp_util.debug('arp_adjustments_pkg.set_to_dummy()+');
991: | PROCEDURE |
992: | lock_p |
993: | |
994: | DESCRIPTION |
995: | This procedure locks the ar_adjustments row identified by |
996: | p_adjustment_id parameter. |
997: | |
998: | SCOPE - PUBLIC |
999: | |
1013: | 29-JUN-95 Charlie Tomberg Created |
1014: | |
1015: +===========================================================================*/
1016:
1017: PROCEDURE lock_p( p_adjustment_id IN ar_adjustments.adjustment_id%type
1018: )
1019: IS
1020:
1021: l_adjustment_id ar_adjustments.adjustment_id%type;
1017: PROCEDURE lock_p( p_adjustment_id IN ar_adjustments.adjustment_id%type
1018: )
1019: IS
1020:
1021: l_adjustment_id ar_adjustments.adjustment_id%type;
1022:
1023: BEGIN
1024: arp_util.debug('arp_adjustments_pkg.lock_p()+');
1025:
1025:
1026:
1027: SELECT adjustment_id
1028: INTO l_adjustment_id
1029: FROM ar_adjustments
1030: WHERE adjustment_id = p_adjustment_id
1031: FOR UPDATE OF adjustment_id NOWAIT;
1032:
1033: arp_util.debug('arp_adjustments_pkg.lock_p()-');
1042: | PROCEDURE |
1043: | lock_f_ct_id |
1044: | |
1045: | DESCRIPTION |
1046: | This procedure locks the ar_adjustments rows identified by |
1047: | p_customer_trx_id parameter. |
1048: | |
1049: | SCOPE - PUBLIC |
1050: | |
1070: IS
1071:
1072: CURSOR LOCK_C IS
1073: SELECT adjustment_id
1074: FROM ar_adjustments
1075: WHERE customer_trx_id = p_customer_trx_id
1076: FOR UPDATE OF adjustment_id NOWAIT;
1077:
1078:
1094: | PROCEDURE |
1095: | lock_f_st_id |
1096: | |
1097: | DESCRIPTION |
1098: | This procedure locks the ar_adjustments rows identified by |
1099: | p_subsequent_trx_id parameter. |
1100: | |
1101: | SCOPE - PUBLIC |
1102: | |
1122: IS
1123:
1124: CURSOR LOCK_C IS
1125: SELECT adjustment_id
1126: FROM ar_adjustments
1127: WHERE subsequent_trx_id = p_subsequent_trx_id
1128: FOR UPDATE OF adjustment_id NOWAIT;
1129:
1130:
1146: | PROCEDURE |
1147: | lock_f_ps_id |
1148: | |
1149: | DESCRIPTION |
1150: | This procedure locks the ar_adjustments rows identified by |
1151: | p_payment_schedule_trx_id parameter. |
1152: | |
1153: | SCOPE - PUBLIC |
1154: | |
1174: IS
1175:
1176: CURSOR LOCK_C IS
1177: SELECT adjustment_id
1178: FROM ar_adjustments
1179: WHERE payment_schedule_id = p_payment_schedule_id
1180: FOR UPDATE OF adjustment_id NOWAIT;
1181:
1182:
1198: | PROCEDURE |
1199: | lock_f_ctl_id |
1200: | |
1201: | DESCRIPTION |
1202: | This procedure locks the ar_adjustments rows identified by |
1203: | p_customer_trx_line_id parameter. |
1204: | |
1205: | SCOPE - PUBLIC |
1206: | |
1226: IS
1227:
1228: CURSOR lock_c IS
1229: SELECT adjustment_id
1230: FROM ar_adjustments
1231: WHERE customer_trx_line_id = p_customer_trx_line_id
1232: FOR UPDATE OF adjustment_id NOWAIT;
1233:
1234: BEGIN
1249: | PROCEDURE |
1250: | lock_fetch_p |
1251: | |
1252: | DESCRIPTION |
1253: | This procedure locks the ar_adjustments row identified |
1254: | by the p_adjustment_id parameter and populates the |
1255: | p_adj_rec parameter with the row that was locked. |
1256: | |
1257: | SCOPE - PUBLIC |
1272: | 29-JUN-95 Charlie Tomberg Created |
1273: | |
1274: +===========================================================================*/
1275:
1276: PROCEDURE lock_fetch_p( p_adj_rec IN OUT NOCOPY ar_adjustments%rowtype,
1277: p_adjustment_id IN
1278: ar_adjustments.adjustment_id%type) IS
1279:
1280: BEGIN
1274: +===========================================================================*/
1275:
1276: PROCEDURE lock_fetch_p( p_adj_rec IN OUT NOCOPY ar_adjustments%rowtype,
1277: p_adjustment_id IN
1278: ar_adjustments.adjustment_id%type) IS
1279:
1280: BEGIN
1281: arp_util.debug('arp_adjustments_pkg.lock_fetch_p()+');
1282:
1281: arp_util.debug('arp_adjustments_pkg.lock_fetch_p()+');
1282:
1283: SELECT *
1284: INTO p_adj_rec
1285: FROM ar_adjustments
1286: WHERE adjustment_id = p_adjustment_id
1287: FOR UPDATE OF adjustment_id NOWAIT;
1288:
1289: arp_util.debug('arp_adjustments_pkg.lock_fetch_p()-');
1298: | PROCEDURE |
1299: | lock_compare_p |
1300: | |
1301: | DESCRIPTION |
1302: | This procedure locks the ar_adjustments row identified |
1303: | by the p_adjustment_id parameter only if no columns in |
1304: | that row have changed from when they were first selected in the form. |
1305: | |
1306: | SCOPE - PUBLIC |
1322: | 29-JUN-95 Charlie Tomberg Created |
1323: | |
1324: +===========================================================================*/
1325:
1326: PROCEDURE lock_compare_p( p_adj_rec IN ar_adjustments%rowtype,
1327: p_adjustment_id IN ar_adjustments.adjustment_id%type)
1328: IS
1329:
1330: l_new_adj_rec ar_adjustments%rowtype;
1323: | |
1324: +===========================================================================*/
1325:
1326: PROCEDURE lock_compare_p( p_adj_rec IN ar_adjustments%rowtype,
1327: p_adjustment_id IN ar_adjustments.adjustment_id%type)
1328: IS
1329:
1330: l_new_adj_rec ar_adjustments%rowtype;
1331:
1326: PROCEDURE lock_compare_p( p_adj_rec IN ar_adjustments%rowtype,
1327: p_adjustment_id IN ar_adjustments.adjustment_id%type)
1328: IS
1329:
1330: l_new_adj_rec ar_adjustments%rowtype;
1331:
1332: BEGIN
1333: arp_util.debug('arp_adjustments_pkg.lock_compare_p()+');
1334:
1333: arp_util.debug('arp_adjustments_pkg.lock_compare_p()+');
1334:
1335: SELECT *
1336: INTO l_new_adj_rec
1337: FROM ar_adjustments adj
1338: WHERE adj.adjustment_id = p_adjustment_id
1339: AND
1340: (
1341: NVL(adj.adjustment_id, AR_NUMBER_DUMMY) =
1865: | PROCEDURE |
1866: | lock_compare_cover |
1867: | |
1868: | DESCRIPTION |
1869: | This procedure locks the ar_adjustments row identified |
1870: | by the p_adjustment_id parameter only if no columns in |
1871: | that row have changed from when they were first selected in the form. |
1872: | |
1873: | SCOPE - PUBLIC |
2014: p_program_update_date IN date,
2015: p_request_id IN number )
2016: IS
2017:
2018: l_adj_rec ar_adjustments%rowtype;
2019:
2020: BEGIN
2021: arp_util.debug('arp_adjustments_pkg.lock_compare_cover()+');
2022:
2238: | PROCEDURE |
2239: | fetch_p |
2240: | |
2241: | DESCRIPTION |
2242: | This procedure fetches a single row from ar_adjustments |
2243: | into a variable specified as a parameter based on the table's primary |
2244: | key, adjustment_id |
2245: | |
2246: | SCOPE - PUBLIC |
2261: | 29-JUN-95 Charlie Tomberg Created |
2262: | |
2263: +===========================================================================*/
2264:
2265: PROCEDURE fetch_p( p_adj_rec OUT NOCOPY ar_adjustments%rowtype,
2266: p_adjustment_id IN ar_adjustments.adjustment_id%type)
2267: IS
2268:
2269: BEGIN
2262: | |
2263: +===========================================================================*/
2264:
2265: PROCEDURE fetch_p( p_adj_rec OUT NOCOPY ar_adjustments%rowtype,
2266: p_adjustment_id IN ar_adjustments.adjustment_id%type)
2267: IS
2268:
2269: BEGIN
2270: arp_util.debug('arp_adjustments_pkg.fetch_p()+');
2270: arp_util.debug('arp_adjustments_pkg.fetch_p()+');
2271:
2272: SELECT *
2273: INTO p_adj_rec
2274: FROM ar_adjustments
2275: WHERE adjustment_id = p_adjustment_id;
2276:
2277: arp_util.debug('arp_adjustments_pkg.fetch_p()-');
2278:
2286: | PROCEDURE |
2287: | delete_p |
2288: | |
2289: | DESCRIPTION |
2290: | This procedure deletes the ar_adjustments row identified |
2291: | by the p_adjustment_id parameter. |
2292: | |
2293: | SCOPE - PUBLIC |
2294: | |
2310: | for MRC integration |
2311: | |
2312: +===========================================================================*/
2313:
2314: procedure delete_p( p_adjustment_id IN ar_adjustments.adjustment_id%type)
2315: IS
2316:
2317:
2318: BEGIN
2319:
2320:
2321: arp_util.debug('arp_adjustments_pkg.delete_p()+');
2322:
2323: DELETE FROM ar_adjustments
2324: WHERE adjustment_id = p_adjustment_id;
2325:
2326: /*---------------------------------+
2327: | Calling central MRC library |
2329: +---------------------------------*/
2330: /*BUG4301323
2331: ar_mrc_engine.maintain_mrc_data(
2332: p_event_mode => 'DELETE',
2333: p_table_name => 'AR_ADJUSTMENTS',
2334: p_mode => 'SINGLE',
2335: p_key_value => p_adjustment_id);
2336: */
2337: arp_util.debug('arp_adjustments_pkg.delete_p()-');
2348: | PROCEDURE |
2349: | delete_f_ct_id |
2350: | |
2351: | DESCRIPTION |
2352: | This procedure deletes the ar_adjustments rows identified |
2353: | by the p_customer_trx_id parameter. |
2354: | |
2355: | SCOPE - PUBLIC |
2356: | |
2383:
2384:
2385: arp_util.debug('arp_adjustments_pkg.delete_f_ct_id()+');
2386:
2387: DELETE FROM ar_adjustments
2388: WHERE customer_trx_id = p_customer_trx_id
2389: RETURNING adjustment_id
2390: BULK COLLECT INTO l_adj_key_value_list;
2391:
2395: +---------------------------------*/
2396: /*4301323
2397: ar_mrc_engine.maintain_mrc_data(
2398: p_event_mode => 'DELETE',
2399: p_table_name => 'AR_ADJUSTMENTS',
2400: p_mode => 'BATCH',
2401: p_key_value_list => l_adj_key_value_list);
2402: */
2403:
2415: | PROCEDURE |
2416: | delete_f_st_id |
2417: | |
2418: | DESCRIPTION |
2419: | This procedure deletes the ar_adjustments rows identified |
2420: | by the p_subsequent_trx_id parameter. |
2421: | |
2422: | SCOPE - PUBLIC |
2423: | |
2450:
2451:
2452: arp_util.debug('arp_adjustments_pkg.delete_f_st_id()+');
2453:
2454: DELETE FROM ar_adjustments
2455: WHERE subsequent_trx_id = p_subsequent_trx_id
2456: RETURNING adjustment_id
2457: BULK COLLECT INTO l_adj_key_value_list;
2458:
2462: +---------------------------------*/
2463: /*4301323
2464: ar_mrc_engine.maintain_mrc_data(
2465: p_event_mode => 'DELETE',
2466: p_table_name => 'AR_ADJUSTMENTS',
2467: p_mode => 'BATCH',
2468: p_key_value_list => l_adj_key_value_list);
2469: */
2470:
2483: | PROCEDURE |
2484: | delete_f_ps_id |
2485: | |
2486: | DESCRIPTION |
2487: | This procedure deletes the ar_adjustments rows identified |
2488: | by the p_payment_schedule_id parameter. |
2489: | |
2490: | SCOPE - PUBLIC |
2491: | |
2518:
2519:
2520: arp_util.debug('arp_adjustments_pkg.delete_f_ps_id()+');
2521:
2522: DELETE FROM ar_adjustments
2523: WHERE payment_schedule_id = p_payment_schedule_id
2524: RETURNING adjustment_id
2525: BULK COLLECT INTO l_adj_key_value_list;
2526:
2530: +---------------------------------*/
2531: /*4301323
2532: ar_mrc_engine.maintain_mrc_data(
2533: p_event_mode => 'DELETE',
2534: p_table_name => 'AR_ADJUSTMENTS',
2535: p_mode => 'BATCH',
2536: p_key_value_list => l_adj_key_value_list);
2537: */
2538:
2550: | PROCEDURE |
2551: | delete_f_ctl_id |
2552: | |
2553: | DESCRIPTION |
2554: | This procedure deletes the ar_adjustments rows identified |
2555: | by the p_customer_trx_line_id parameter. |
2556: | |
2557: | SCOPE - PUBLIC |
2558: | |
2585:
2586:
2587: arp_util.debug('arp_adjustments_pkg.delete_f_ctl_id()+');
2588:
2589: DELETE FROM ar_adjustments
2590: WHERE customer_trx_line_id = p_customer_trx_line_id
2591: RETURNING adjustment_id
2592: BULK COLLECT INTO l_adj_key_value_list;
2593:
2597: +---------------------------------*/
2598: /*BUG4301323
2599: ar_mrc_engine.maintain_mrc_data(
2600: p_event_mode => 'DELETE',
2601: p_table_name => 'AR_ADJUSTMENTS',
2602: p_mode => 'BATCH',
2603: p_key_value_list => l_adj_key_value_list);
2604: */
2605: arp_util.debug('arp_adjustments_pkg.delete_f_ctl_id()-');
2616: | PROCEDURE |
2617: | update_p |
2618: | |
2619: | DESCRIPTION |
2620: | This procedure updates the ar_adjustments row identified |
2621: | by the p_adjustment_id parameter. |
2622: | |
2623: | SCOPE - PUBLIC |
2624: | |
2642: | 29-JUN-95 Charlie Tomberg Created |
2643: | |
2644: +===========================================================================*/
2645:
2646: PROCEDURE update_p( p_adj_rec IN ar_adjustments%rowtype,
2647: p_adjustment_id IN ar_adjustments.adjustment_id%type,
2648: p_exchange_rate IN ar_payment_schedules.exchange_rate%type
2649: )
2650: IS
2643: | |
2644: +===========================================================================*/
2645:
2646: PROCEDURE update_p( p_adj_rec IN ar_adjustments%rowtype,
2647: p_adjustment_id IN ar_adjustments.adjustment_id%type,
2648: p_exchange_rate IN ar_payment_schedules.exchange_rate%type
2649: )
2650: IS
2651:
2676: | PROCEDURE |
2677: | update_f_ct_id |
2678: | |
2679: | DESCRIPTION |
2680: | This procedure updates the ar_adjustments rows identified |
2681: | by the p_customer_trx_id parameter. |
2682: | |
2683: | SCOPE - PUBLIC |
2684: | |
2702: | 29-JUN-95 Charlie Tomberg Created |
2703: | |
2704: +===========================================================================*/
2705:
2706: PROCEDURE update_f_ct_id( p_adj_rec IN ar_adjustments%rowtype,
2707: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
2708: p_exchange_rate IN ar_payment_schedules.exchange_rate%type)
2709: IS
2710:
2734: | PROCEDURE |
2735: | update_f_st_id |
2736: | |
2737: | DESCRIPTION |
2738: | This procedure updates the ar_adjustments rows identified |
2739: | by the p_subsequent_trx_id parameter. |
2740: | |
2741: | SCOPE - PUBLIC |
2742: | |
2760: | 29-JUN-95 Charlie Tomberg Created |
2761: | |
2762: +===========================================================================*/
2763:
2764: PROCEDURE update_f_st_id( p_adj_rec IN ar_adjustments%rowtype,
2765: p_subsequent_trx_id IN ra_customer_trx.customer_trx_id%type,
2766: p_exchange_rate IN ar_payment_schedules.exchange_rate%type)
2767: IS
2768:
2792: | PROCEDURE |
2793: | update_f_ps_id |
2794: | |
2795: | DESCRIPTION |
2796: | This procedure updates the ar_adjustments rows identified |
2797: | by the p_payment_schedule_id parameter. |
2798: | |
2799: | SCOPE - PUBLIC |
2800: | |
2818: | 29-JUN-95 Charlie Tomberg Created |
2819: | |
2820: +===========================================================================*/
2821:
2822: PROCEDURE update_f_ps_id( p_adj_rec IN ar_adjustments%rowtype,
2823: p_payment_schedule_id IN
2824: ar_payment_schedules.payment_schedule_id%type,
2825: p_exchange_rate IN
2826: ar_payment_schedules.exchange_rate%type)
2853: | PROCEDURE |
2854: | update_f_ctl_id |
2855: | |
2856: | DESCRIPTION |
2857: | This procedure updates the ar_adjustments rows identified |
2858: | by the p_customer_trx_line_id parameter. |
2859: | |
2860: | SCOPE - PUBLIC |
2861: | |
2879: | 29-JUN-95 Charlie Tomberg Created |
2880: | |
2881: +===========================================================================*/
2882:
2883: PROCEDURE update_f_ctl_id( p_adj_rec IN ar_adjustments%rowtype,
2884: p_customer_trx_line_id IN
2885: ra_customer_trx_lines.customer_trx_line_id%type,
2886: p_exchange_rate IN
2887: ar_payment_schedules.exchange_rate%type)
2914: | PROCEDURE |
2915: | insert_p |
2916: | |
2917: | DESCRIPTION |
2918: | This procedure inserts a row into ar_adjustments that |
2919: | contains the column values specified in the p_adj_rec parameter. |
2920: | |
2921: | SCOPE - PUBLIC |
2922: | |
2950: | is set to 'N' if the |
2951: | accounting_affect_flag of the |
2952: | receivables_trx is 'N'. |
2953: | 15-OCT-00 Debbie Jancis Enh: MRC integration. Called central|
2954: | library for insertion of ar_adjustments|
2955: +===========================================================================*/
2956:
2957: PROCEDURE insert_p( p_adj_rec IN ar_adjustments%rowtype,
2958: p_exchange_rate IN
2953: | 15-OCT-00 Debbie Jancis Enh: MRC integration. Called central|
2954: | library for insertion of ar_adjustments|
2955: +===========================================================================*/
2956:
2957: PROCEDURE insert_p( p_adj_rec IN ar_adjustments%rowtype,
2958: p_exchange_rate IN
2959: ar_payment_schedules.exchange_rate%type,
2960: p_adjustment_number OUT NOCOPY
2961: ar_adjustments.adjustment_number%type,
2957: PROCEDURE insert_p( p_adj_rec IN ar_adjustments%rowtype,
2958: p_exchange_rate IN
2959: ar_payment_schedules.exchange_rate%type,
2960: p_adjustment_number OUT NOCOPY
2961: ar_adjustments.adjustment_number%type,
2962: p_adjustment_id OUT NOCOPY ar_adjustments.adjustment_id%type
2963:
2964: ) IS
2965:
2958: p_exchange_rate IN
2959: ar_payment_schedules.exchange_rate%type,
2960: p_adjustment_number OUT NOCOPY
2961: ar_adjustments.adjustment_number%type,
2962: p_adjustment_id OUT NOCOPY ar_adjustments.adjustment_id%type
2963:
2964: ) IS
2965:
2966: l_adjustment_id ar_adjustments.adjustment_id%type;
2962: p_adjustment_id OUT NOCOPY ar_adjustments.adjustment_id%type
2963:
2964: ) IS
2965:
2966: l_adjustment_id ar_adjustments.adjustment_id%type;
2967: l_adjustment_number ar_adjustments.adjustment_number%type;
2968: l_accounting_affect_flag ar_receivables_trx.accounting_affect_flag%type;
2969: l_adj_post_to_gl_flag ra_cust_trx_types.adj_post_to_gl%type;
2970:
2963:
2964: ) IS
2965:
2966: l_adjustment_id ar_adjustments.adjustment_id%type;
2967: l_adjustment_number ar_adjustments.adjustment_number%type;
2968: l_accounting_affect_flag ar_receivables_trx.accounting_affect_flag%type;
2969: l_adj_post_to_gl_flag ra_cust_trx_types.adj_post_to_gl%type;
2970:
2971: BEGIN
2978: /*---------------------------*
2979: | Get the unique identifier |
2980: *---------------------------*/
2981:
2982: SELECT AR_ADJUSTMENTS_S.NEXTVAL,
2983: AR_ADJUSTMENT_NUMBER_S.NEXTVAL
2984: INTO l_adjustment_id,
2985: l_adjustment_number
2986: FROM DUAL;
3007: /*-------------------*
3008: | Insert the record |
3009: *-------------------*/
3010:
3011: INSERT INTO ar_adjustments
3012: (
3013: adjustment_id,
3014: amount,
3015: acctd_amount,
3180: | into MRC tables |
3181: +-------------------------------------------*/
3182: /*BUG4301323
3183: ar_mrc_engine.maintain_mrc_data( p_event_mode => 'INSERT',
3184: p_table_name => 'AR_ADJUSTMENTS',
3185: p_mode => 'SINGLE',
3186: p_key_value => p_adjustment_id);
3187:
3188: */
3220: | 11-SEP-95 Charlie Tomberg Created |
3221: | |
3222: +===========================================================================*/
3223:
3224: PROCEDURE merge_adj_recs( p_old_adj_rec IN ar_adjustments%rowtype,
3225: p_new_adj_rec IN ar_adjustments%rowtype,
3226: p_out_adj_rec OUT NOCOPY ar_adjustments%rowtype ) IS
3227:
3228: BEGIN
3221: | |
3222: +===========================================================================*/
3223:
3224: PROCEDURE merge_adj_recs( p_old_adj_rec IN ar_adjustments%rowtype,
3225: p_new_adj_rec IN ar_adjustments%rowtype,
3226: p_out_adj_rec OUT NOCOPY ar_adjustments%rowtype ) IS
3227:
3228: BEGIN
3229:
3222: +===========================================================================*/
3223:
3224: PROCEDURE merge_adj_recs( p_old_adj_rec IN ar_adjustments%rowtype,
3225: p_new_adj_rec IN ar_adjustments%rowtype,
3226: p_out_adj_rec OUT NOCOPY ar_adjustments%rowtype ) IS
3227:
3228: BEGIN
3229:
3230: arp_util.debug('arp_adjustments_pkg.merge_adj_recs()+');
3616: | |
3617: +===========================================================================*/
3618:
3619: PROCEDURE display_adj_rec(
3620: p_adj_rec IN ar_adjustments%rowtype) IS
3621:
3622: BEGIN
3623: arp_util.debug('arp_adjustments_pkg.display_adj_rec()+',
3624: pg_msg_level_debug);
3622: BEGIN
3623: arp_util.debug('arp_adjustments_pkg.display_adj_rec()+',
3624: pg_msg_level_debug);
3625:
3626: arp_util.debug('******** Dump of ar_adjustments record *********');
3627:
3628: arp_util.debug('adjustment_id : '||
3629: p_adj_rec.adjustment_id);
3630: arp_util.debug('acctd_amount : '||
3781: | 29-AUG-95 Martin Johnson Created |
3782: | |
3783: +===========================================================================*/
3784:
3785: PROCEDURE display_adj_p(p_adjustment_id IN ar_adjustments.adjustment_id%type)
3786:
3787: IS
3788:
3789: l_adj_rec ar_adjustments%rowtype;
3785: PROCEDURE display_adj_p(p_adjustment_id IN ar_adjustments.adjustment_id%type)
3786:
3787: IS
3788:
3789: l_adj_rec ar_adjustments%rowtype;
3790:
3791: BEGIN
3792: arp_util.debug('arp_adjustments_pkg.display_adj_p()+',
3793: pg_msg_level_debug);