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_ADJUSTMENTS_PKG dependencies on AR_ADJUSTMENTS

Line 57: | p_adj_rec - ar_adjustments record |

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 |

Line 86: p_adj_rec IN ar_adjustments%rowtype,

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,

Line 423: 'UPDATE ar_adjustments

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),

Line 714: | This procedure Updates records in ar_adjustments |

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: | |

Line 751: p_adj_rec IN ar_adjustments%rowtype)

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);

Line 852: -- p_table_name => 'AR_ADJUSTMENTS',

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:

Line 911: PROCEDURE set_to_dummy( p_adj_rec OUT NOCOPY ar_adjustments%rowtype) IS

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()+');

Line 995: | This procedure locks the ar_adjustments row identified by |

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: | |

Line 1017: PROCEDURE lock_p( p_adjustment_id IN ar_adjustments.adjustment_id%type

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;

Line 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:

Line 1029: FROM ar_adjustments

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()-');

Line 1046: | This procedure locks the ar_adjustments rows identified by |

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: | |

Line 1074: FROM ar_adjustments

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:

Line 1098: | This procedure locks the ar_adjustments rows identified by |

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: | |

Line 1126: FROM ar_adjustments

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:

Line 1150: | This procedure locks the ar_adjustments rows identified by |

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: | |

Line 1178: FROM ar_adjustments

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:

Line 1202: | This procedure locks the ar_adjustments rows identified by |

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: | |

Line 1230: FROM ar_adjustments

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

Line 1253: | This procedure locks the ar_adjustments row identified |

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 |

Line 1276: PROCEDURE lock_fetch_p( p_adj_rec IN OUT NOCOPY ar_adjustments%rowtype,

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

Line 1278: ar_adjustments.adjustment_id%type) IS

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:

Line 1285: FROM ar_adjustments

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()-');

Line 1302: | This procedure locks the ar_adjustments row identified |

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 |

Line 1326: PROCEDURE lock_compare_p( p_adj_rec IN ar_adjustments%rowtype,

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;

Line 1327: p_adjustment_id IN ar_adjustments.adjustment_id%type)

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:

Line 1330: l_new_adj_rec ar_adjustments%rowtype;

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:

Line 1337: FROM ar_adjustments adj

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) =

Line 1869: | This procedure locks the ar_adjustments row identified |

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 |

Line 2018: l_adj_rec ar_adjustments%rowtype;

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:

Line 2242: | This procedure fetches a single row from ar_adjustments |

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 |

Line 2265: PROCEDURE fetch_p( p_adj_rec OUT NOCOPY ar_adjustments%rowtype,

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

Line 2266: p_adjustment_id IN ar_adjustments.adjustment_id%type)

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()+');

Line 2274: FROM ar_adjustments

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:

Line 2290: | This procedure deletes the ar_adjustments row identified |

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: | |

Line 2314: procedure delete_p( p_adjustment_id IN ar_adjustments.adjustment_id%type)

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

Line 2323: DELETE FROM ar_adjustments

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 |

Line 2333: p_table_name => 'AR_ADJUSTMENTS',

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()-');

Line 2352: | This procedure deletes the ar_adjustments rows identified |

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: | |

Line 2387: DELETE FROM ar_adjustments

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:

Line 2399: p_table_name => 'AR_ADJUSTMENTS',

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:

Line 2419: | This procedure deletes the ar_adjustments rows identified |

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: | |

Line 2454: DELETE FROM ar_adjustments

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:

Line 2466: p_table_name => 'AR_ADJUSTMENTS',

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:

Line 2487: | This procedure deletes the ar_adjustments rows identified |

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: | |

Line 2522: DELETE FROM ar_adjustments

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:

Line 2534: p_table_name => 'AR_ADJUSTMENTS',

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:

Line 2554: | This procedure deletes the ar_adjustments rows identified |

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: | |

Line 2589: DELETE FROM ar_adjustments

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:

Line 2601: p_table_name => 'AR_ADJUSTMENTS',

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()-');

Line 2620: | This procedure updates the ar_adjustments row identified |

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: | |

Line 2646: PROCEDURE update_p( p_adj_rec IN ar_adjustments%rowtype,

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

Line 2647: p_adjustment_id IN ar_adjustments.adjustment_id%type,

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:

Line 2680: | This procedure updates the ar_adjustments rows identified |

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: | |

Line 2706: PROCEDURE update_f_ct_id( p_adj_rec IN ar_adjustments%rowtype,

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:

Line 2738: | This procedure updates the ar_adjustments rows identified |

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: | |

Line 2764: PROCEDURE update_f_st_id( p_adj_rec IN ar_adjustments%rowtype,

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:

Line 2796: | This procedure updates the ar_adjustments rows identified |

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: | |

Line 2822: PROCEDURE update_f_ps_id( p_adj_rec IN ar_adjustments%rowtype,

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)

Line 2857: | This procedure updates the ar_adjustments rows identified |

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: | |

Line 2883: PROCEDURE update_f_ctl_id( p_adj_rec IN ar_adjustments%rowtype,

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)

Line 2918: | This procedure inserts a row into ar_adjustments that |

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: | |

Line 2954: | library for insertion of ar_adjustments|

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

Line 2957: PROCEDURE insert_p( p_adj_rec IN ar_adjustments%rowtype,

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,

Line 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:

Line 2962: p_adjustment_id OUT NOCOPY ar_adjustments.adjustment_id%type

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;

Line 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:

Line 2967: l_adjustment_number ar_adjustments.adjustment_number%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:
2971: BEGIN

Line 2982: SELECT AR_ADJUSTMENTS_S.NEXTVAL,

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;

Line 3011: INSERT INTO ar_adjustments

3007: /*-------------------*
3008: | Insert the record |
3009: *-------------------*/
3010:
3011: INSERT INTO ar_adjustments
3012: (
3013: adjustment_id,
3014: amount,
3015: acctd_amount,

Line 3184: p_table_name => 'AR_ADJUSTMENTS',

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: */

Line 3224: PROCEDURE merge_adj_recs( p_old_adj_rec IN ar_adjustments%rowtype,

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

Line 3225: p_new_adj_rec IN ar_adjustments%rowtype,

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:

Line 3226: p_out_adj_rec OUT NOCOPY ar_adjustments%rowtype ) IS

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()+');

Line 3620: p_adj_rec IN ar_adjustments%rowtype) IS

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);

Line 3626: arp_util.debug(' Dump of ar_adjustments record *');

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 : '||

Line 3785: PROCEDURE display_adj_p(p_adjustment_id IN ar_adjustments.adjustment_id%type)

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;

Line 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);