APPS.ARP_ARXCOQIT dependencies on AR_PAYMENT_SCHEDULES

Line 194: p_from_clause IN varchar2 DEFAULT 'ar_payment_schedules_v',

190:
191: procedure fold_total( p_where_clause IN varchar2,
192: p_total IN OUT NOCOPY number,
193: p_func_total IN OUT NOCOPY number,
194: p_from_clause IN varchar2 DEFAULT 'ar_payment_schedules_v',
195: p_cur_count OUT NOCOPY number) is
196: l_select_cursor INTEGER;
197: l_ignore INTEGER;
198: l_amount NUMBER;

Line 271: IF p_from_clause = 'AR_PAYMENT_SCHEDULES_TRX2_V' AND INSTR(l_out_where_clause,'CUSTOMER_ID=') <> 0 THEN

267: --Bug 1563252 : modified the query string to add the from clause dynamically.
268:
269: /* 3988361 :If the customer_id is used for selection the use n6 index */
270:
271: IF p_from_clause = 'AR_PAYMENT_SCHEDULES_TRX2_V' AND INSTR(l_out_where_clause,'CUSTOMER_ID=') <> 0 THEN
272: dbms_sql.parse(l_select_cursor,
273: 'select /*+ INDEX(AR_PAYMENT_SCHEDULES_TRX2_V.ps AR_PAYMENT_SCHEDULES_N6) */
274: count( distinct invoice_currency_code ),
275: sum(amount_due_remaining),

Line 273: 'select /*+ INDEX(AR_PAYMENT_SCHEDULES_TRX2_V.ps AR_PAYMENT_SCHEDULES_N6) */

269: /* 3988361 :If the customer_id is used for selection the use n6 index */
270:
271: IF p_from_clause = 'AR_PAYMENT_SCHEDULES_TRX2_V' AND INSTR(l_out_where_clause,'CUSTOMER_ID=') <> 0 THEN
272: dbms_sql.parse(l_select_cursor,
273: 'select /*+ INDEX(AR_PAYMENT_SCHEDULES_TRX2_V.ps AR_PAYMENT_SCHEDULES_N6) */
274: count( distinct invoice_currency_code ),
275: sum(amount_due_remaining),
276: sum(acctd_amount_due_remaining)
277: from '||p_from_clause||' '||l_out_where_clause, dbms_sql.v7);

Line 409: p_from_clause IN varchar2 DEFAULT 'ar_payment_schedules_v',

405: END;
406:
407: -- Bug 2089289
408: procedure fold_currency_code( p_where_clause IN varchar2,
409: p_from_clause IN varchar2 DEFAULT 'ar_payment_schedules_v',
410: p_currency_code OUT NOCOPY varchar2) is
411: l_select_cursor INTEGER;
412: l_ignore INTEGER;
413: l_currency_code VARCHAR2(15);

Line 583: procedure check_changed( p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

579: end;
580:
581:
582:
583: procedure check_changed( p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
584: p_amount_in_dispute IN ar_payment_schedules.payment_schedule_id%TYPE, p_dispute_amount_changed IN OUT NOCOPY NUMBER ) IS
585: begin
586: select count(*)
587: into p_dispute_amount_changed

Line 584: p_amount_in_dispute IN ar_payment_schedules.payment_schedule_id%TYPE, p_dispute_amount_changed IN OUT NOCOPY NUMBER ) IS

580:
581:
582:
583: procedure check_changed( p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
584: p_amount_in_dispute IN ar_payment_schedules.payment_schedule_id%TYPE, p_dispute_amount_changed IN OUT NOCOPY NUMBER ) IS
585: begin
586: select count(*)
587: into p_dispute_amount_changed
588: from ar_payment_schedules

Line 588: from ar_payment_schedules

584: p_amount_in_dispute IN ar_payment_schedules.payment_schedule_id%TYPE, p_dispute_amount_changed IN OUT NOCOPY NUMBER ) IS
585: begin
586: select count(*)
587: into p_dispute_amount_changed
588: from ar_payment_schedules
589: where payment_schedule_id = p_ps_id
590: and (( amount_in_dispute <> p_amount_in_dispute) OR
591: (amount_in_dispute is NOT NULL and
592: p_amount_in_dispute IS NULL ) OR

Line 622: procedure get_days_late( p_due_date IN ar_payment_schedules.due_date%TYPE,

618: arp_standard.debug('Build_And_Bind: ' || 'Exception in ever_in_dispute_flag' );
619: END IF;
620: end;
621:
622: procedure get_days_late( p_due_date IN ar_payment_schedules.due_date%TYPE,
623: p_days_late IN OUT NOCOPY number) IS
624: begin
625: select trunc(sysdate) - p_due_date
626: into p_days_late