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_DATES dependencies on RA_CUSTOMER_TRX

Line 436: p_request_id IN ra_customer_trx.request_id%type,

432: | |
433: +===========================================================================*/
434:
435: PROCEDURE val_gl_periods_for_rules(
436: p_request_id IN ra_customer_trx.request_id%type,
437: p_acc_rule_id IN ra_rules.rule_id%type,
438: p_acc_duration IN
439: ra_customer_trx_lines.accounting_rule_duration%type,
440: p_rule_start_date IN

Line 439: ra_customer_trx_lines.accounting_rule_duration%type,

435: PROCEDURE val_gl_periods_for_rules(
436: p_request_id IN ra_customer_trx.request_id%type,
437: p_acc_rule_id IN ra_rules.rule_id%type,
438: p_acc_duration IN
439: ra_customer_trx_lines.accounting_rule_duration%type,
440: p_rule_start_date IN
441: ra_customer_trx_lines.rule_start_date%type,
442: p_sob_id IN
443: gl_sets_of_books.set_of_books_id%type ) IS

Line 441: ra_customer_trx_lines.rule_start_date%type,

437: p_acc_rule_id IN ra_rules.rule_id%type,
438: p_acc_duration IN
439: ra_customer_trx_lines.accounting_rule_duration%type,
440: p_rule_start_date IN
441: ra_customer_trx_lines.rule_start_date%type,
442: p_sob_id IN
443: gl_sets_of_books.set_of_books_id%type ) IS
444: l_ai_flag boolean;
445: l_count integer;

Line 667: ra_customer_trx.customer_trx_id%type,

663: +===========================================================================*/
664:
665: PROCEDURE get_date_based_on_rev_sched(
666: p_customer_trx_id IN
667: ra_customer_trx.customer_trx_id%type,
668: p_invoicing_rule_id IN
669: ra_customer_trx.invoicing_rule_id%type,
670: p_candidate_date OUT NOCOPY DATE
671: ) IS

Line 669: ra_customer_trx.invoicing_rule_id%type,

665: PROCEDURE get_date_based_on_rev_sched(
666: p_customer_trx_id IN
667: ra_customer_trx.customer_trx_id%type,
668: p_invoicing_rule_id IN
669: ra_customer_trx.invoicing_rule_id%type,
670: p_candidate_date OUT NOCOPY DATE
671: ) IS
672:
673: actual_num_fiscal_year gl_periods.period_year%TYPE;

Line 688: FROM ra_customer_trx_lines rl

684: arp_global.MSG_LEVEL_DEBUG);
685:
686: SELECT MIN(rl.rule_start_date)
687: INTO p_candidate_date
688: FROM ra_customer_trx_lines rl
689: WHERE rl.customer_trx_id = p_customer_trx_id
690: AND line_type = 'LINE';
691:
692: ELSE

Line 700: FROM ra_customer_trx_lines ctl,

696: /*Bug 2505767, Added an additional check in the where clause to pick up only
697: those periods which match with the type defined in the set of books*/
698: SELECT COUNT(gp1.period_set_name)
699: INTO actual_num_fiscal_year
700: FROM ra_customer_trx_lines ctl,
701: gl_sets_of_books b,
702: gl_periods gp1
703: WHERE ctl.customer_trx_id = p_customer_trx_id
704: AND ctl.set_of_books_id = b.set_of_books_id

Line 724: FROM ra_customer_trx_lines ctl,

720: )
721: )
722: )
723: INTO p_candidate_date
724: FROM ra_customer_trx_lines ctl,
725: gl_periods gp1,
726: gl_periods gp2,
727: gl_sets_of_books b,
728: gl_period_types t,

Line 859: ra_customer_trx.customer_trx_id%type,

855: +===========================================================================*/
856:
857: PROCEDURE derive_gl_trx_dates_from_rules (
858: p_customer_trx_id IN
859: ra_customer_trx.customer_trx_id%type,
860: p_gl_date IN OUT NOCOPY
861: ra_cust_trx_line_gl_dist.gl_date%type,
862: p_trx_date IN OUT NOCOPY
863: ra_customer_trx.trx_date%type,

Line 863: ra_customer_trx.trx_date%type,

859: ra_customer_trx.customer_trx_id%type,
860: p_gl_date IN OUT NOCOPY
861: ra_cust_trx_line_gl_dist.gl_date%type,
862: p_trx_date IN OUT NOCOPY
863: ra_customer_trx.trx_date%type,
864: p_recalculate_tax_flag IN OUT NOCOPY boolean,
865: P_created_from IN ar_trx_header_gt.created_from%type default NULL,
866: p_defaulted_gl_date_flag IN ar_trx_header_gt.defaulted_gl_date_flag%type default NULL
867: ) IS

Line 871: l_db_trx_date ra_customer_trx.trx_date%type;

867: ) IS
868:
869:
870: l_candidate_date date;
871: l_db_trx_date ra_customer_trx.trx_date%type;
872: l_db_gl_date ra_cust_trx_line_gl_dist.gl_date%type;
873:
874: l_trx_date ra_customer_trx.trx_date%type;
875: l_gl_date ra_cust_trx_line_gl_dist.gl_date%type;

Line 874: l_trx_date ra_customer_trx.trx_date%type;

870: l_candidate_date date;
871: l_db_trx_date ra_customer_trx.trx_date%type;
872: l_db_gl_date ra_cust_trx_line_gl_dist.gl_date%type;
873:
874: l_trx_date ra_customer_trx.trx_date%type;
875: l_gl_date ra_cust_trx_line_gl_dist.gl_date%type;
876:
877: l_exchange_rate ra_customer_trx.exchange_rate%type;
878: l_currency_code ra_customer_trx.invoice_currency_code%type;

Line 877: l_exchange_rate ra_customer_trx.exchange_rate%type;

873:
874: l_trx_date ra_customer_trx.trx_date%type;
875: l_gl_date ra_cust_trx_line_gl_dist.gl_date%type;
876:
877: l_exchange_rate ra_customer_trx.exchange_rate%type;
878: l_currency_code ra_customer_trx.invoice_currency_code%type;
879:
880: l_period_name varchar2(15);
881: l_start_date date;

Line 878: l_currency_code ra_customer_trx.invoice_currency_code%type;

874: l_trx_date ra_customer_trx.trx_date%type;
875: l_gl_date ra_cust_trx_line_gl_dist.gl_date%type;
876:
877: l_exchange_rate ra_customer_trx.exchange_rate%type;
878: l_currency_code ra_customer_trx.invoice_currency_code%type;
879:
880: l_period_name varchar2(15);
881: l_start_date date;
882: l_end_date date;

Line 893: l_invoicing_rule_id ra_customer_trx.invoicing_rule_id%type;

889: l_default_gl_date ra_cust_trx_line_gl_dist.gl_date%type;
890: l_defaulting_rule_used varchar2(100);
891: l_error_message varchar2(100);
892:
893: l_invoicing_rule_id ra_customer_trx.invoicing_rule_id%type;
894:
895: l_trx_rec ra_customer_trx%rowtype;
896: l_dist_rec ra_cust_trx_line_gl_dist%rowtype;
897:

Line 895: l_trx_rec ra_customer_trx%rowtype;

891: l_error_message varchar2(100);
892:
893: l_invoicing_rule_id ra_customer_trx.invoicing_rule_id%type;
894:
895: l_trx_rec ra_customer_trx%rowtype;
896: l_dist_rec ra_cust_trx_line_gl_dist%rowtype;
897:
898:
899: BEGIN

Line 933: FROM ra_customer_trx ct,

929: l_db_gl_date,
930: l_exchange_rate,
931: l_currency_code,
932: l_invoicing_rule_id
933: FROM ra_customer_trx ct,
934: ra_cust_trx_line_gl_dist ctlgd
935: WHERE ct.customer_trx_id = ctlgd.customer_trx_id
936: AND ct.customer_trx_id = p_customer_trx_id
937: AND ctlgd.account_class = 'REC'