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_APPROVAL_USER_LIMITS

Line 909: | AR_APPROVAL_USER_LIMITS. |

905: | MODIFICATION HISTORY |
906: | 08-SEP-95 Charlie Tomberg Created |
907: | |
908: | 03-FEB-00 Saloni Shah Made changes data model changes to |
909: | AR_APPROVAL_USER_LIMITS. |
910: | |
911: | 03-FEB-00 Saloni Shah Made changes for the BR/BOE project |
912: | A new IN parameter p_chk_approval_limits |
913: | was added. |

Line 928: l_approval_amount_to ar_approval_user_limits.amount_to%type;

924: l_date_dummy DATE;
925: l_number_dummy NUMBER;
926: l_closing_status gl_period_statuses.closing_status%type;
927: l_result VARCHAR2(1);
928: l_approval_amount_to ar_approval_user_limits.amount_to%type;
929: l_approval_amount_from ar_approval_user_limits.amount_from%type;
930:
931: BEGIN
932:

Line 929: l_approval_amount_from ar_approval_user_limits.amount_from%type;

925: l_number_dummy NUMBER;
926: l_closing_status gl_period_statuses.closing_status%type;
927: l_result VARCHAR2(1);
928: l_approval_amount_to ar_approval_user_limits.amount_to%type;
929: l_approval_amount_from ar_approval_user_limits.amount_from%type;
930:
931: BEGIN
932:
933: arp_util.debug('arp_process_adjustment.validate_update_approve_adj()+',

Line 999: FROM ar_approval_user_limits aul

995: SELECT aul.amount_to,
996: aul.amount_from
997: INTO l_approval_amount_to,
998: l_approval_amount_from
999: FROM ar_approval_user_limits aul
1000: WHERE aul.user_id = arp_adjustments_pkg.pg_user_id
1001: AND aul.currency_code = p_ps_rec.invoice_currency_code
1002: /* Bug 941429: Credit memo workflow added a new document_type column
1003: to AR_APPROVAL_USER_LIMITS. Now user_id and currency_code alone can't

Line 1003: to AR_APPROVAL_USER_LIMITS. Now user_id and currency_code alone can't

999: FROM ar_approval_user_limits aul
1000: WHERE aul.user_id = arp_adjustments_pkg.pg_user_id
1001: AND aul.currency_code = p_ps_rec.invoice_currency_code
1002: /* Bug 941429: Credit memo workflow added a new document_type column
1003: to AR_APPROVAL_USER_LIMITS. Now user_id and currency_code alone can't
1004: uniquely identify a row. Need to include document_type as well */
1005: AND aul.document_type = 'ADJ';
1006:
1007: EXCEPTION