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.JAI_AR_MATCH_TAX_PKG dependencies on USER_PROCEDURES

Line 1020: CURSOR c_proc_exists(cp_object_name user_procedures.object_name%type,

1016: ln_gl_dist_id ra_cust_trx_line_gl_dist_all.cust_trx_line_gl_dist_id%TYPE;
1017: lv_account_class_rec VARCHAR2(10) := 'REC';
1018:
1019:
1020: CURSOR c_proc_exists(cp_object_name user_procedures.object_name%type,
1021: cp_procedure_name user_procedures.procedure_name%type) IS
1022: SELECT 1
1023: FROM user_procedures
1024: WHERE object_name = cp_object_name

Line 1021: cp_procedure_name user_procedures.procedure_name%type) IS

1017: lv_account_class_rec VARCHAR2(10) := 'REC';
1018:
1019:
1020: CURSOR c_proc_exists(cp_object_name user_procedures.object_name%type,
1021: cp_procedure_name user_procedures.procedure_name%type) IS
1022: SELECT 1
1023: FROM user_procedures
1024: WHERE object_name = cp_object_name
1025: AND procedure_name = cp_procedure_name ;

Line 1023: FROM user_procedures

1019:
1020: CURSOR c_proc_exists(cp_object_name user_procedures.object_name%type,
1021: cp_procedure_name user_procedures.procedure_name%type) IS
1022: SELECT 1
1023: FROM user_procedures
1024: WHERE object_name = cp_object_name
1025: AND procedure_name = cp_procedure_name ;
1026:
1027: CURSOR cur_payment_schedule_mrc(cp_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE)

Line 1043: lv_object_name user_procedures.object_name%type ;

1039: AND account_class = lv_account_class_rec --'REC'
1040: AND latest_rec_flag = jai_constants.yes; --'Y';
1041:
1042: /* Ramananda for bug#5219225. */
1043: lv_object_name user_procedures.object_name%type ;
1044: lv_procedure_name user_procedures.procedure_name%type ;
1045: ln_exists NUMBER := 0 ;
1046: lv_sqlstmt VARCHAR2(2000) ;
1047:

Line 1044: lv_procedure_name user_procedures.procedure_name%type ;

1040: AND latest_rec_flag = jai_constants.yes; --'Y';
1041:
1042: /* Ramananda for bug#5219225. */
1043: lv_object_name user_procedures.object_name%type ;
1044: lv_procedure_name user_procedures.procedure_name%type ;
1045: ln_exists NUMBER := 0 ;
1046: lv_sqlstmt VARCHAR2(2000) ;
1047:
1048: BEGIN

Line 1436: CURSOR c_proc_exists(cp_object_name user_procedures.object_name%type,

1432: p_process_status OUT NOCOPY VARCHAR2,
1433: p_process_message OUT NOCOPY VARCHAR2,
1434: p_event_id IN NUMBER DEFAULT NULL) --added for bug#7645588
1435: IS
1436: CURSOR c_proc_exists(cp_object_name user_procedures.object_name%type,
1437: cp_procedure_name user_procedures.procedure_name%type) IS
1438: SELECT 1
1439: FROM user_procedures
1440: WHERE object_name = cp_object_name

Line 1437: cp_procedure_name user_procedures.procedure_name%type) IS

1433: p_process_message OUT NOCOPY VARCHAR2,
1434: p_event_id IN NUMBER DEFAULT NULL) --added for bug#7645588
1435: IS
1436: CURSOR c_proc_exists(cp_object_name user_procedures.object_name%type,
1437: cp_procedure_name user_procedures.procedure_name%type) IS
1438: SELECT 1
1439: FROM user_procedures
1440: WHERE object_name = cp_object_name
1441: AND procedure_name = cp_procedure_name ;

Line 1439: FROM user_procedures

1435: IS
1436: CURSOR c_proc_exists(cp_object_name user_procedures.object_name%type,
1437: cp_procedure_name user_procedures.procedure_name%type) IS
1438: SELECT 1
1439: FROM user_procedures
1440: WHERE object_name = cp_object_name
1441: AND procedure_name = cp_procedure_name ;
1442:
1443: CURSOR cur_gl_seq

Line 1449: lv_object_name user_procedures.object_name%type ;

1445: SELECT ra_cust_trx_line_gl_dist_s.NEXTVAL
1446: FROM dual;
1447:
1448: /* Ramananda for bug#5219225. */
1449: lv_object_name user_procedures.object_name%type ;
1450: lv_procedure_name user_procedures.procedure_name%type ;
1451: ln_exists NUMBER := 0 ;
1452: lv_sqlstmt VARCHAR2(2000);
1453:

Line 1450: lv_procedure_name user_procedures.procedure_name%type ;

1446: FROM dual;
1447:
1448: /* Ramananda for bug#5219225. */
1449: lv_object_name user_procedures.object_name%type ;
1450: lv_procedure_name user_procedures.procedure_name%type ;
1451: ln_exists NUMBER := 0 ;
1452: lv_sqlstmt VARCHAR2(2000);
1453:
1454: ln_cust_trx_line_gl_dist_id ra_cust_trx_line_gl_dist_all.cust_trx_line_gl_dist_id%TYPE;

Line 1652: lv_object_name user_procedures.object_name%type ;

1648: p_process_status OUT NOCOPY VARCHAR2,
1649: p_process_message OUT NOCOPY VARCHAR2)
1650: IS
1651: /* Ramananda for bug#5219225. */
1652: lv_object_name user_procedures.object_name%type ;
1653: lv_procedure_name user_procedures.procedure_name%type ;
1654: ln_exists NUMBER := 0 ;
1655: lv_sqlstmt VARCHAR2(2000) ;
1656: lv_account_class_tax VARCHAR2(10) := 'TAX';

Line 1653: lv_procedure_name user_procedures.procedure_name%type ;

1649: p_process_message OUT NOCOPY VARCHAR2)
1650: IS
1651: /* Ramananda for bug#5219225. */
1652: lv_object_name user_procedures.object_name%type ;
1653: lv_procedure_name user_procedures.procedure_name%type ;
1654: ln_exists NUMBER := 0 ;
1655: lv_sqlstmt VARCHAR2(2000) ;
1656: lv_account_class_tax VARCHAR2(10) := 'TAX';
1657: lv_account_class_freight VARCHAR2(10) := 'FREIGHT';

Line 1683: CURSOR c_proc_exists(cp_object_name user_procedures.object_name%type,

1679: customer_trx_line_id;
1680:
1681:
1682: /* Ramananda for bug#5219225. */
1683: CURSOR c_proc_exists(cp_object_name user_procedures.object_name%type,
1684: cp_procedure_name user_procedures.procedure_name%type) IS
1685: SELECT 1
1686: FROM user_procedures
1687: WHERE object_name = cp_object_name

Line 1684: cp_procedure_name user_procedures.procedure_name%type) IS

1680:
1681:
1682: /* Ramananda for bug#5219225. */
1683: CURSOR c_proc_exists(cp_object_name user_procedures.object_name%type,
1684: cp_procedure_name user_procedures.procedure_name%type) IS
1685: SELECT 1
1686: FROM user_procedures
1687: WHERE object_name = cp_object_name
1688: AND procedure_name = cp_procedure_name ;

Line 1686: FROM user_procedures

1682: /* Ramananda for bug#5219225. */
1683: CURSOR c_proc_exists(cp_object_name user_procedures.object_name%type,
1684: cp_procedure_name user_procedures.procedure_name%type) IS
1685: SELECT 1
1686: FROM user_procedures
1687: WHERE object_name = cp_object_name
1688: AND procedure_name = cp_procedure_name ;
1689:
1690: BEGIN

Line 1764: lv_object_name user_procedures.object_name%type ;

1760: IS
1761:
1762:
1763: v_org_id number;
1764: lv_object_name user_procedures.object_name%type ;
1765: lv_procedure_name user_procedures.procedure_name%type ;
1766: ln_exists NUMBER := 0 ;
1767: lv_sqlstmt VARCHAR2(2000) ;
1768: lv_account_class_tax VARCHAR2(10) := 'TAX';

Line 1765: lv_procedure_name user_procedures.procedure_name%type ;

1761:
1762:
1763: v_org_id number;
1764: lv_object_name user_procedures.object_name%type ;
1765: lv_procedure_name user_procedures.procedure_name%type ;
1766: ln_exists NUMBER := 0 ;
1767: lv_sqlstmt VARCHAR2(2000) ;
1768: lv_account_class_tax VARCHAR2(10) := 'TAX';
1769: lv_account_class_freight VARCHAR2(10) := 'FREIGHT';

Line 1840: CURSOR c_proc_exists(cp_object_name user_procedures.object_name%type,

1836: FROM ra_customer_trx_lines_all
1837: WHERE customer_trx_line_id = cp_customer_trx_line_id;
1838:
1839: /* Ramananda for bug#5219225. */
1840: CURSOR c_proc_exists(cp_object_name user_procedures.object_name%type,
1841: cp_procedure_name user_procedures.procedure_name%type) IS
1842: SELECT 1
1843: FROM user_procedures
1844: WHERE object_name = cp_object_name

Line 1841: cp_procedure_name user_procedures.procedure_name%type) IS

1837: WHERE customer_trx_line_id = cp_customer_trx_line_id;
1838:
1839: /* Ramananda for bug#5219225. */
1840: CURSOR c_proc_exists(cp_object_name user_procedures.object_name%type,
1841: cp_procedure_name user_procedures.procedure_name%type) IS
1842: SELECT 1
1843: FROM user_procedures
1844: WHERE object_name = cp_object_name
1845: AND procedure_name = cp_procedure_name ;

Line 1843: FROM user_procedures

1839: /* Ramananda for bug#5219225. */
1840: CURSOR c_proc_exists(cp_object_name user_procedures.object_name%type,
1841: cp_procedure_name user_procedures.procedure_name%type) IS
1842: SELECT 1
1843: FROM user_procedures
1844: WHERE object_name = cp_object_name
1845: AND procedure_name = cp_procedure_name ;
1846:
1847: --get the sum of amount, acctd_amount and max of acctd_amount from ra_cust_trx_line_gl_dist_all for cp_customer_trx_id