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

Line 20: | Validates row that is going to be inserted into ar_adjustments |

16: | PROCEDURE |
17: | validate_insert_adjustment |
18: | |
19: | DESCRIPTION |
20: | Validates row that is going to be inserted into ar_adjustments |
21: | |
22: | SCOPE - PRIVATE |
23: | |
24: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |

Line 161: | Validates row that is going to be updateded in ar_adjustments |

157: | PROCEDURE |
158: | validate_update_adjustment |
159: | |
160: | DESCRIPTION |
161: | Validates row that is going to be updateded in ar_adjustments |
162: | |
163: | SCOPE - PRIVATE |
164: | |
165: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |

Line 357: p_adjustment_id IN ar_adjustments.adjustment_id%type,

353: | |
354: +===========================================================================*/
355:
356: PROCEDURE set_flags(
357: p_adjustment_id IN ar_adjustments.adjustment_id%type,
358: p_old_adj_rec IN ar_adjustments%rowtype,
359: p_new_adj_rec IN ar_adjustments%rowtype,
360: p_status_changed_flag OUT NOCOPY boolean)
361:

Line 358: p_old_adj_rec IN ar_adjustments%rowtype,

354: +===========================================================================*/
355:
356: PROCEDURE set_flags(
357: p_adjustment_id IN ar_adjustments.adjustment_id%type,
358: p_old_adj_rec IN ar_adjustments%rowtype,
359: p_new_adj_rec IN ar_adjustments%rowtype,
360: p_status_changed_flag OUT NOCOPY boolean)
361:
362: IS

Line 359: p_new_adj_rec IN ar_adjustments%rowtype,

355:
356: PROCEDURE set_flags(
357: p_adjustment_id IN ar_adjustments.adjustment_id%type,
358: p_old_adj_rec IN ar_adjustments%rowtype,
359: p_new_adj_rec IN ar_adjustments%rowtype,
360: p_status_changed_flag OUT NOCOPY boolean)
361:
362: IS
363:

Line 439: ar_adjustments%rowtype,

435: | ar_receivable_applications.
436: +===========================================================================*/
437:
438: PROCEDURE validate_inv_line_amount(p_adj_rec IN
439: ar_adjustments%rowtype,
440: p_ps_rec IN ar_payment_schedules%rowtype)
441: IS
442:
443: CURSOR cu_rem_amt(p_customer_trx_id IN NUMBER, p_customer_trx_line_id IN NUMBER) IS

Line 642: FROM ar_adjustments

638: p_adj_rec.customer_trx_line_id;
639:
640: SELECT NVL(SUM(amount),0)
641: INTO l_sum_line_adj
642: FROM ar_adjustments
643: WHERE customer_trx_line_id = p_adj_rec.customer_trx_line_id
644: AND NVL(postable, 'Y') = 'Y'
645: AND customer_trx_id = p_adj_rec.customer_trx_id;
646:

Line 829: l_adj_rec ar_adjustments%rowtype;

825: p_payment_schedule_id IN number,
826: p_amount IN number,
827: p_receivables_trx_id IN NUMBER DEFAULT NULL) IS
828:
829: l_adj_rec ar_adjustments%rowtype;
830: l_ps_rec ar_payment_schedules%rowtype;
831:
832: BEGIN
833:

Line 917: PROCEDURE validate_update_approve_adj( p_adj_rec IN ar_adjustments%rowtype,

913: | was added. |
914: | |
915: +===========================================================================*/
916:
917: PROCEDURE validate_update_approve_adj( p_adj_rec IN ar_adjustments%rowtype,
918: p_ps_rec IN ar_payment_schedules%rowtype,
919: p_adjustment_code IN ar_lookups.lookup_code%type,
920: p_chk_approval_limits IN varchar2
921: ) IS

Line 1080: | Inserts a record into ar_adjustments |

1076: | PROCEDURE |
1077: | insert_adjustment |
1078: | |
1079: | DESCRIPTION |
1080: | Inserts a record into ar_adjustments |
1081: | |
1082: | SCOPE - PUBLIC |
1083: | |
1084: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |

Line 1137: ar_adjustments%rowtype,

1133:
1134: PROCEDURE insert_adjustment(p_form_name IN varchar2,
1135: p_form_version IN number,
1136: p_adj_rec IN OUT
1137: ar_adjustments%rowtype,
1138: p_adjustment_number OUT NOCOPY
1139: ar_adjustments.adjustment_number%type,
1140: p_adjustment_id OUT NOCOPY
1141: ar_adjustments.adjustment_id%type,

Line 1139: ar_adjustments.adjustment_number%type,

1135: p_form_version IN number,
1136: p_adj_rec IN OUT
1137: ar_adjustments%rowtype,
1138: p_adjustment_number OUT NOCOPY
1139: ar_adjustments.adjustment_number%type,
1140: p_adjustment_id OUT NOCOPY
1141: ar_adjustments.adjustment_id%type,
1142: p_check_amount IN varchar2 := FND_API.G_TRUE,
1143: p_move_deferred_tax IN varchar2 := 'Y',

Line 1141: ar_adjustments.adjustment_id%type,

1137: ar_adjustments%rowtype,
1138: p_adjustment_number OUT NOCOPY
1139: ar_adjustments.adjustment_number%type,
1140: p_adjustment_id OUT NOCOPY
1141: ar_adjustments.adjustment_id%type,
1142: p_check_amount IN varchar2 := FND_API.G_TRUE,
1143: p_move_deferred_tax IN varchar2 := 'Y',
1144: p_called_from IN varchar2 DEFAULT NULL,
1145: p_old_adjust_id IN ar_adjustments.adjustment_id%type DEFAULT NULL,

Line 1145: p_old_adjust_id IN ar_adjustments.adjustment_id%type DEFAULT NULL,

1141: ar_adjustments.adjustment_id%type,
1142: p_check_amount IN varchar2 := FND_API.G_TRUE,
1143: p_move_deferred_tax IN varchar2 := 'Y',
1144: p_called_from IN varchar2 DEFAULT NULL,
1145: p_old_adjust_id IN ar_adjustments.adjustment_id%type DEFAULT NULL,
1146: p_override_flag IN varchar2 DEFAULT NULL,
1147: p_app_level IN VARCHAR2 DEFAULT 'TRANSACTION')
1148:
1149:

Line 1152: l_adjustment_id ar_adjustments.adjustment_id%type;

1148:
1149:
1150: IS
1151:
1152: l_adjustment_id ar_adjustments.adjustment_id%type;
1153: l_ps_rec ar_payment_schedules%rowtype;
1154: l_acctd_amount ar_adjustments.acctd_amount%type;
1155: l_amount_adjusted ar_payment_schedules.amount_adjusted%type;
1156: l_aah_rec ar_approval_action_history%rowtype;

Line 1154: l_acctd_amount ar_adjustments.acctd_amount%type;

1150: IS
1151:
1152: l_adjustment_id ar_adjustments.adjustment_id%type;
1153: l_ps_rec ar_payment_schedules%rowtype;
1154: l_acctd_amount ar_adjustments.acctd_amount%type;
1155: l_amount_adjusted ar_payment_schedules.amount_adjusted%type;
1156: l_aah_rec ar_approval_action_history%rowtype;
1157: l_approval_action_history_id
1158: ar_approval_action_history.approval_action_history_id%type;

Line 1164: l_adj_type ar_adjustments.type%type;

1160: ln_acctd_adr_tmp NUMBER;
1161: /* VAT changes */
1162: l_ae_doc_rec ae_doc_rec_type;
1163:
1164: l_adj_type ar_adjustments.type%type;
1165: l_accounting_affect_flag ar_receivables_trx.accounting_affect_flag%type;
1166:
1167: l_app_ps_status VARCHAR2(10);
1168: --BUG#2750340

Line 1517: FROM ar_adjustments

1513: TAX_ADJUSTED
1514: INTO
1515: l_line_adjusted,
1516: l_tax_adjusted
1517: FROM ar_adjustments
1518: WHERE adjustment_id = l_adjustment_id;
1519:
1520: INSERT INTO AR_ACTIVITY_DETAILS (
1521: LINE_ID,

Line 1804: | Updates a record in ar_adjustments |

1800: | PROCEDURE |
1801: | update_adjustment |
1802: | |
1803: | DESCRIPTION |
1804: | Updates a record in ar_adjustments |
1805: | |
1806: | SCOPE - PUBLIC |
1807: | |
1808: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |

Line 1849: p_adj_rec IN ar_adjustments%rowtype,

1845:
1846: PROCEDURE update_adjustment(
1847: p_form_name IN varchar2,
1848: p_form_version IN varchar2,
1849: p_adj_rec IN ar_adjustments%rowtype,
1850: p_move_deferred_tax IN varchar2 := 'Y',
1851: p_adjustment_id IN ar_adjustments.adjustment_id%type)
1852:
1853: IS

Line 1851: p_adjustment_id IN ar_adjustments.adjustment_id%type)

1847: p_form_name IN varchar2,
1848: p_form_version IN varchar2,
1849: p_adj_rec IN ar_adjustments%rowtype,
1850: p_move_deferred_tax IN varchar2 := 'Y',
1851: p_adjustment_id IN ar_adjustments.adjustment_id%type)
1852:
1853: IS
1854:
1855: l_adj_rec ar_adjustments%rowtype;

Line 1855: l_adj_rec ar_adjustments%rowtype;

1851: p_adjustment_id IN ar_adjustments.adjustment_id%type)
1852:
1853: IS
1854:
1855: l_adj_rec ar_adjustments%rowtype;
1856: l_aah_rec ar_approval_action_history%rowtype;
1857: l_ps_rec ar_payment_schedules%rowtype;
1858: l_approval_action_history_id
1859: ar_approval_action_history.approval_action_history_id%type;

Line 1861: l_old_adj_rec ar_adjustments%rowtype;

1857: l_ps_rec ar_payment_schedules%rowtype;
1858: l_approval_action_history_id
1859: ar_approval_action_history.approval_action_history_id%type;
1860: l_status_changed_flag boolean;
1861: l_old_adj_rec ar_adjustments%rowtype;
1862: l_acctd_amount_adjusted ar_adjustments.acctd_amount%type;
1863: l_ae_doc_rec ae_doc_rec_type;
1864: l_accounting_affect_flag ar_receivables_trx.accounting_affect_flag%type;
1865: /* Bug fix 2377672

Line 1862: l_acctd_amount_adjusted ar_adjustments.acctd_amount%type;

1858: l_approval_action_history_id
1859: ar_approval_action_history.approval_action_history_id%type;
1860: l_status_changed_flag boolean;
1861: l_old_adj_rec ar_adjustments%rowtype;
1862: l_acctd_amount_adjusted ar_adjustments.acctd_amount%type;
1863: l_ae_doc_rec ae_doc_rec_type;
1864: l_accounting_affect_flag ar_receivables_trx.accounting_affect_flag%type;
1865: /* Bug fix 2377672
1866: variables to decide whether the accounting needs to be re-created */

Line 2038: FROM ar_adjustments

2034: TAX_ADJUSTED
2035: INTO
2036: l_line_adjusted,
2037: l_tax_adjusted
2038: FROM ar_adjustments
2039: WHERE adjustment_id = p_adjustment_id;
2040:
2041: UPDATE AR_ACTIVITY_DETAILS
2042: SET AMOUNT = l_line_adjusted,

Line 2160: FROM ar_adjustments where payment_schedule_id=l_adj_rec.payment_schedule_id

2156: pending to be adjusted needs to be re-calculated*/
2157: BEGIN
2158: l_amount_adjusted_pending:=0;
2159: Select SUM(AMOUNT) into l_amount_adjusted_pending
2160: FROM ar_adjustments where payment_schedule_id=l_adj_rec.payment_schedule_id
2161: AND STATUS NOT IN ('A','R','U');
2162: UPDATE ar_payment_schedules set amount_adjusted_pending=
2163: DECODE(l_amount_adjusted_pending,0,NULL,l_amount_adjusted_pending)
2164: WHERE payment_schedule_id=l_adj_rec.payment_schedule_id;

Line 2220: ar_adjustments adj ,

2216: l_event_source_info.entity_type_code,
2217: l_event_source_info.source_id_int_1,
2218: l_event_source_info.application_id
2219: from
2220: ar_adjustments adj ,
2221: xla_transaction_entities_upg xet
2222: where adj.adjustment_id = p_adjustment_id
2223: and adj.adjustment_id = NVL(xet.source_id_int_1, -99)
2224: and xet.entity_code ='ADJUSTMENTS'

Line 2410: | Deletes a record from ar_adjustments |

2406: | PROCEDURE |
2407: | update_approve_adj |
2408: | |
2409: | DESCRIPTION |
2410: | Deletes a record from ar_adjustments |
2411: | |
2412: | SCOPE - PUBLIC |
2413: | |
2414: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |

Line 2449: p_adj_rec IN ar_adjustments%rowtype,

2445: +===========================================================================*/
2446:
2447: PROCEDURE update_approve_adj(p_form_name IN varchar2,
2448: p_form_version IN number,
2449: p_adj_rec IN ar_adjustments%rowtype,
2450: p_adjustment_code ar_lookups.lookup_code%type,
2451: p_adjustment_id IN ar_adjustments.adjustment_id%type,
2452: p_chk_approval_limits IN varchar2,
2453: p_move_deferred_tax IN varchar2 := 'Y') IS

Line 2451: p_adjustment_id IN ar_adjustments.adjustment_id%type,

2447: PROCEDURE update_approve_adj(p_form_name IN varchar2,
2448: p_form_version IN number,
2449: p_adj_rec IN ar_adjustments%rowtype,
2450: p_adjustment_code ar_lookups.lookup_code%type,
2451: p_adjustment_id IN ar_adjustments.adjustment_id%type,
2452: p_chk_approval_limits IN varchar2,
2453: p_move_deferred_tax IN varchar2 := 'Y') IS
2454:
2455: l_ps_rec ar_payment_schedules%rowtype;

Line 2456: l_adj_rec ar_adjustments%rowtype;

2452: p_chk_approval_limits IN varchar2,
2453: p_move_deferred_tax IN varchar2 := 'Y') IS
2454:
2455: l_ps_rec ar_payment_schedules%rowtype;
2456: l_adj_rec ar_adjustments%rowtype;
2457: l_aah_rec ar_approval_action_history%rowtype;
2458: l_acctd_amount_adjusted ar_adjustments.acctd_amount%type;
2459:
2460: l_approval_action_history_id

Line 2458: l_acctd_amount_adjusted ar_adjustments.acctd_amount%type;

2454:
2455: l_ps_rec ar_payment_schedules%rowtype;
2456: l_adj_rec ar_adjustments%rowtype;
2457: l_aah_rec ar_approval_action_history%rowtype;
2458: l_acctd_amount_adjusted ar_adjustments.acctd_amount%type;
2459:
2460: l_approval_action_history_id
2461: ar_approval_action_history.approval_action_history_id%type;
2462: l_old_adj_rec ar_adjustments%rowtype;

Line 2462: l_old_adj_rec ar_adjustments%rowtype;

2458: l_acctd_amount_adjusted ar_adjustments.acctd_amount%type;
2459:
2460: l_approval_action_history_id
2461: ar_approval_action_history.approval_action_history_id%type;
2462: l_old_adj_rec ar_adjustments%rowtype;
2463: l_ae_doc_rec ae_doc_rec_type;
2464: l_accounting_affect_flag ar_receivables_trx.accounting_affect_flag%type;
2465: --BUG#2750340
2466: l_xla_ev_rec arp_xla_events.xla_events_type;

Line 2653: | Update ar_adjustments |

2649:
2650: l_adj_rec.status := NVL( p_adjustment_code, l_adj_rec.status );
2651:
2652: /*--------------------------+
2653: | Update ar_adjustments |
2654: +--------------------------*/
2655:
2656: arp_adjustments_pkg.update_p( l_adj_rec,
2657: p_adjustment_id,

Line 2813: PROCEDURE test_adj( p_adj_rec IN OUT NOCOPY ar_adjustments%rowtype,

2809: | 12-SEP-95 Charlie Tomberg Created |
2810: | |
2811: +===========================================================================*/
2812:
2813: PROCEDURE test_adj( p_adj_rec IN OUT NOCOPY ar_adjustments%rowtype,
2814: p_result IN OUT NOCOPY varchar2,
2815: p_old_ps_rec IN OUT NOCOPY ar_payment_schedules%rowtype) IS
2816:
2817: l_new_ps_rec ar_payment_schedules%rowtype;

Line 2839: from ar_adjustments

2835: select decode(max(adjustment_id),
2836: NULL, 'A: Fail, ',
2837: 'A: Pass, ')
2838: into p_result
2839: from ar_adjustments
2840: where adjustment_id = p_adj_rec.adjustment_id
2841: and adjustment_number = p_adj_rec.adjustment_number
2842: and payment_schedule_id = p_adj_rec.payment_schedule_id
2843: and customer_trx_id = p_adj_rec.customer_trx_id

Line 2994: PROCEDURE validate_args_radj( p_adj_id IN ar_adjustments.adjustment_id%TYPE,

2990: RAISE;
2991: END;
2992:
2993:
2994: PROCEDURE validate_args_radj( p_adj_id IN ar_adjustments.adjustment_id%TYPE,
2995: p_reversal_gl_date IN DATE,
2996: p_reversal_date IN DATE );
2997: --
2998: PROCEDURE modify_adj_rec( p_adj_id IN ar_adjustments.adjustment_id%TYPE,

Line 2998: PROCEDURE modify_adj_rec( p_adj_id IN ar_adjustments.adjustment_id%TYPE,

2994: PROCEDURE validate_args_radj( p_adj_id IN ar_adjustments.adjustment_id%TYPE,
2995: p_reversal_gl_date IN DATE,
2996: p_reversal_date IN DATE );
2997: --
2998: PROCEDURE modify_adj_rec( p_adj_id IN ar_adjustments.adjustment_id%TYPE,
2999: p_reversal_gl_date IN DATE,
3000: p_reversal_date IN DATE );
3001: --
3002:

Line 3004: p_adj_id IN ar_adjustments.adjustment_id%TYPE );

3000: p_reversal_date IN DATE );
3001: --
3002:
3003: PROCEDURE val_insert_rev_actions(
3004: p_adj_id IN ar_adjustments.adjustment_id%TYPE );
3005: --
3006: /*===========================================================================+
3007: | PROCEDURE |
3008: | reverse_adjustment() |

Line 3012: | in the AR_ADJUSTMENTS table |

3008: | reverse_adjustment() |
3009: | |
3010: | DESCRIPTION |
3011: | This function reverses an adjustment by inserting an opposing entry |
3012: | in the AR_ADJUSTMENTS table |
3013: | |
3014: | SCOPE - PUBLIC |
3015: | |
3016: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |

Line 3041: p_adj_id IN ar_adjustments.adjustment_id%TYPE,

3037: | Removed hard coded comment and replaced it
3038: | with message dictionary equivalent.
3039: +===========================================================================*/
3040: PROCEDURE reverse_adjustment(
3041: p_adj_id IN ar_adjustments.adjustment_id%TYPE,
3042: p_reversal_gl_date IN DATE,
3043: p_reversal_date IN DATE,
3044: p_module_name IN VARCHAR2,
3045: p_module_version IN VARCHAR2 ) IS

Line 3048: l_adj_rec ar_adjustments%ROWTYPE;

3044: p_module_name IN VARCHAR2,
3045: p_module_version IN VARCHAR2 ) IS
3046: l_aah_rec ar_approval_action_history%ROWTYPE;
3047: l_aah_id NUMBER;
3048: l_adj_rec ar_adjustments%ROWTYPE;
3049: l_ps_rec ar_payment_schedules%rowtype;
3050: --BUG#2750340
3051: l_xla_ev_rec arp_xla_events.xla_events_type;
3052:

Line 3071: -- Select from ar_adjustments to update status. This is just a

3067: THEN
3068: validate_args_radj( p_adj_id, p_reversal_gl_date, p_reversal_date );
3069: END IF;
3070:
3071: -- Select from ar_adjustments to update status. This is just a
3072: -- simple select statement, so not using a separate function. Also
3073: -- note that the WHERE clause is different than the fetch_p procedure
3074: -- in the table handler. Also locking the table
3075:

Line 3085: FROM ar_adjustments adj

3081: END IF;
3082: BEGIN
3083: SELECT *
3084: INTO l_adj_rec
3085: FROM ar_adjustments adj
3086: WHERE adj.adjustment_id = p_adj_id
3087: AND adj.status not in ('A', 'R')
3088: FOR UPDATE of adj.STATUS NOWAIT;
3089:

Line 3140: ar_adjustments adj ,

3136: l_event_source_info.entity_type_code,
3137: l_event_source_info.source_id_int_1,
3138: l_event_source_info.application_id
3139: from
3140: ar_adjustments adj ,
3141: xla_transaction_entities_upg xet
3142: where adj.adjustment_id = p_adj_id
3143: and adj.adjustment_id = nvl(xet.source_id_int_1,-99)
3144: and xet.entity_code ='ADJUSTMENTS'

Line 3258: PROCEDURE validate_args_radj( p_adj_id IN ar_adjustments.adjustment_id%TYPE,

3254: | |
3255: | MODIFICATION HISTORY - Created by Ganesh Vaidee - 04/25/95 |
3256: | |
3257: +===========================================================================*/
3258: PROCEDURE validate_args_radj( p_adj_id IN ar_adjustments.adjustment_id%TYPE,
3259: p_reversal_gl_date IN DATE,
3260: p_reversal_date IN DATE ) IS
3261: BEGIN
3262: IF PG_DEBUG in ('Y', 'C') THEN

Line 3311: PROCEDURE modify_adj_rec( p_adj_id IN ar_adjustments.adjustment_id%TYPE,

3307: | |
3308: | MODIFICATION HISTORY - Created by Ganesh Vaidee - 04/25/95 |
3309: | |
3310: +===========================================================================*/
3311: PROCEDURE modify_adj_rec( p_adj_id IN ar_adjustments.adjustment_id%TYPE,
3312: p_reversal_gl_date IN DATE,
3313: p_reversal_date IN DATE ) IS
3314: l_adj_rec ar_adjustments%ROWTYPE;
3315: l_rev_gl_date DATE;

Line 3314: l_adj_rec ar_adjustments%ROWTYPE;

3310: +===========================================================================*/
3311: PROCEDURE modify_adj_rec( p_adj_id IN ar_adjustments.adjustment_id%TYPE,
3312: p_reversal_gl_date IN DATE,
3313: p_reversal_date IN DATE ) IS
3314: l_adj_rec ar_adjustments%ROWTYPE;
3315: l_rev_gl_date DATE;
3316: l_error_message VARCHAR2(128);
3317: l_defaulting_rule_used VARCHAR2(100);
3318: l_default_gl_date DATE;

Line 3404: | arp_adj_pkg.insert_p - Insert a row into AR_ADJUSTMENTS table|

3400: | |
3401: | SCOPE - PUBLIC |
3402: | |
3403: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - |
3404: | arp_adj_pkg.insert_p - Insert a row into AR_ADJUSTMENTS table|
3405: | |
3406: | ARGUMENTS : IN OUT: |
3407: | p_adj_rec - Adjustment Record structure |
3408: | p_module_name _ Name of module that called this procedure|

Line 3428: p_adj_rec IN OUT NOCOPY ar_adjustments%ROWTYPE,

3424: |10/16/1998 Sushama Borde Bug fix 741725: Used AOL API get_next_sequence
3425: | instead of get_seq_name.
3426: +===========================================================================*/
3427: PROCEDURE insert_reverse_actions (
3428: p_adj_rec IN OUT NOCOPY ar_adjustments%ROWTYPE,
3429: p_module_name IN VARCHAR2,
3430: p_module_version IN VARCHAR2 ) IS
3431: l_new_adj_id ar_adjustments.adjustment_id%TYPE;
3432: l_old_adj_id ar_adjustments.adjustment_id%TYPE;

Line 3431: l_new_adj_id ar_adjustments.adjustment_id%TYPE;

3427: PROCEDURE insert_reverse_actions (
3428: p_adj_rec IN OUT NOCOPY ar_adjustments%ROWTYPE,
3429: p_module_name IN VARCHAR2,
3430: p_module_version IN VARCHAR2 ) IS
3431: l_new_adj_id ar_adjustments.adjustment_id%TYPE;
3432: l_old_adj_id ar_adjustments.adjustment_id%TYPE;
3433:
3434: l_rec_name VARCHAR2(50);
3435: l_number NUMBER;

Line 3432: l_old_adj_id ar_adjustments.adjustment_id%TYPE;

3428: p_adj_rec IN OUT NOCOPY ar_adjustments%ROWTYPE,
3429: p_module_name IN VARCHAR2,
3430: p_module_version IN VARCHAR2 ) IS
3431: l_new_adj_id ar_adjustments.adjustment_id%TYPE;
3432: l_old_adj_id ar_adjustments.adjustment_id%TYPE;
3433:
3434: l_rec_name VARCHAR2(50);
3435: l_number NUMBER;
3436:

Line 3587: arp_standard.debug( 'before ar_adjustments_pkg.insert_p in app_delete' );

3583:
3584: -- Insert opposing adjustment
3585:
3586: IF PG_DEBUG in ('Y', 'C') THEN
3587: arp_standard.debug( 'before ar_adjustments_pkg.insert_p in app_delete' );
3588: END IF;
3589: arp_adj_pkg.insert_p( p_adj_rec, l_new_adj_id );
3590: IF PG_DEBUG in ('Y', 'C') THEN
3591: arp_standard.debug( 'after ar_adjustments_pkg.insert_p in app_delete' );

Line 3591: arp_standard.debug( 'after ar_adjustments_pkg.insert_p in app_delete' );

3587: arp_standard.debug( 'before ar_adjustments_pkg.insert_p in app_delete' );
3588: END IF;
3589: arp_adj_pkg.insert_p( p_adj_rec, l_new_adj_id );
3590: IF PG_DEBUG in ('Y', 'C') THEN
3591: arp_standard.debug( 'after ar_adjustments_pkg.insert_p in app_delete' );
3592: END IF;
3593:
3594:
3595: /* VAT changes: create acct entry */

Line 3638: select status into l_adj_status from ar_adjustments

3634:
3635:
3636: IF NVL(l_adj_post_to_gl, 'N') = 'Y' THEN
3637:
3638: select status into l_adj_status from ar_adjustments
3639: where adjustment_id = l_new_adj_id ;
3640:
3641: IF ( l_adj_status = 'R' ) THEN
3642: BEGIN

Line 3660: ar_adjustments adj ,

3656: l_event_source_info.entity_type_code,
3657: l_event_source_info.source_id_int_1,
3658: l_event_source_info.application_id
3659: from
3660: ar_adjustments adj ,
3661: xla_transaction_entities_upg xet
3662: where adj.adjustment_id = l_new_adj_id
3663: and adj.adjustment_id = nvl(xet.source_id_int_1,-99)
3664: and xet.entity_code ='ADJUSTMENTS'

Line 3756: p_adj_id IN ar_adjustments.adjustment_id%TYPE ) IS

3752: | MODIFICATION HISTORY - Created by Ganesh Vaidee - 04/25/95 |
3753: | |
3754: +===========================================================================*/
3755: PROCEDURE val_insert_rev_actions(
3756: p_adj_id IN ar_adjustments.adjustment_id%TYPE ) IS
3757: BEGIN
3758: IF PG_DEBUG in ('Y', 'C') THEN
3759: arp_standard.debug( 'arp_process_adjustment.val_insert_rev_actions()+' );
3760: END IF;