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 687: | AR_APPROVAL_USER_LIMITS. |

683: | MODIFICATION HISTORY |
684: | 08-SEP-95 Charlie Tomberg Created |
685: | |
686: | 03-FEB-00 Saloni Shah Made changes data model changes to |
687: | AR_APPROVAL_USER_LIMITS. |
688: | |
689: | 03-FEB-00 Saloni Shah Made changes for the BR/BOE project |
690: | A new IN parameter p_chk_approval_limits |
691: | was added. |

Line 706: l_approval_amount_to ar_approval_user_limits.amount_to%type;

702: l_date_dummy DATE;
703: l_number_dummy NUMBER;
704: l_closing_status gl_period_statuses.closing_status%type;
705: l_result VARCHAR2(1);
706: l_approval_amount_to ar_approval_user_limits.amount_to%type;
707: l_approval_amount_from ar_approval_user_limits.amount_from%type;
708:
709: BEGIN
710:

Line 707: l_approval_amount_from ar_approval_user_limits.amount_from%type;

703: l_number_dummy NUMBER;
704: l_closing_status gl_period_statuses.closing_status%type;
705: l_result VARCHAR2(1);
706: l_approval_amount_to ar_approval_user_limits.amount_to%type;
707: l_approval_amount_from ar_approval_user_limits.amount_from%type;
708:
709: BEGIN
710:
711: arp_util.debug('arp_process_adjustment.validate_update_approve_adj()+',

Line 777: FROM ar_approval_user_limits aul

773: SELECT aul.amount_to,
774: aul.amount_from
775: INTO l_approval_amount_to,
776: l_approval_amount_from
777: FROM ar_approval_user_limits aul
778: WHERE aul.user_id = arp_adjustments_pkg.pg_user_id
779: AND aul.currency_code = p_ps_rec.invoice_currency_code
780: /* Bug 941429: Credit memo workflow added a new document_type column
781: to AR_APPROVAL_USER_LIMITS. Now user_id and currency_code alone can't

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

777: FROM ar_approval_user_limits aul
778: WHERE aul.user_id = arp_adjustments_pkg.pg_user_id
779: AND aul.currency_code = p_ps_rec.invoice_currency_code
780: /* Bug 941429: Credit memo workflow added a new document_type column
781: to AR_APPROVAL_USER_LIMITS. Now user_id and currency_code alone can't
782: uniquely identify a row. Need to include document_type as well */
783: AND aul.document_type = 'ADJ';
784:
785: EXCEPTION