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.ARPT_SQL_FUNC_UTIL dependencies on SO_AGREEMENTS

Line 1702: so_agreements soa,

1698: WHERE EXISTS
1699: (
1700: SELECT 'commitments_exist'
1701: FROM hz_cust_accounts cust_acct,
1702: so_agreements soa,
1703: hz_cust_acct_sites acct_site,
1704: ra_cust_trx_types inv_type,
1705: ra_cust_trx_types type,
1706: ra_customer_trx trx

Line 1809: FROM so_agreements a

1805: FROM DUAL
1806: WHERE EXISTS
1807: (
1808: SELECT 'agreements_exist'
1809: FROM so_agreements a
1810: WHERE a.customer_id IN
1811: (
1812: SELECT cr.cust_account_id
1813: FROM hz_cust_acct_relate cr

Line 2362: l_name so_agreements.name%type;

2358:
2359: FUNCTION is_agreement_date_valid(p_trx_date IN DATE,
2360: p_agreement_id IN NUMBER)
2361: RETURN VARCHAR2 IS
2362: l_name so_agreements.name%type;
2363: l_valid_date VARCHAR2(10);
2364: l_start_date_active so_agreements.start_date_active%type;
2365: l_end_date_active so_agreements.end_date_active%type;
2366: BEGIN

Line 2364: l_start_date_active so_agreements.start_date_active%type;

2360: p_agreement_id IN NUMBER)
2361: RETURN VARCHAR2 IS
2362: l_name so_agreements.name%type;
2363: l_valid_date VARCHAR2(10);
2364: l_start_date_active so_agreements.start_date_active%type;
2365: l_end_date_active so_agreements.end_date_active%type;
2366: BEGIN
2367: IF p_agreement_id IS NOT NULL THEN
2368: IF pg_agreement_rec.EXISTS(p_agreement_id) THEN

Line 2365: l_end_date_active so_agreements.end_date_active%type;

2361: RETURN VARCHAR2 IS
2362: l_name so_agreements.name%type;
2363: l_valid_date VARCHAR2(10);
2364: l_start_date_active so_agreements.start_date_active%type;
2365: l_end_date_active so_agreements.end_date_active%type;
2366: BEGIN
2367: IF p_agreement_id IS NOT NULL THEN
2368: IF pg_agreement_rec.EXISTS(p_agreement_id) THEN
2369:

Line 2393: FROM so_agreements

2389:
2390: ELSE
2391: SELECT name,start_date_active, end_date_active
2392: INTO l_name, l_start_date_active, l_end_date_active
2393: FROM so_agreements
2394: WHERE agreement_id = p_agreement_id ;
2395:
2396: IF NVL(p_trx_date, trunc(sysdate)) >=
2397: NVL( l_start_date_active,NVL(p_trx_date, trunc(sysdate))) AND

Line 2424: l_name so_agreements.name%type;

2420: END is_agreement_date_valid;
2421:
2422: FUNCTION get_agreement_name(p_agreement_id IN NUMBER)
2423: RETURN VARCHAR2 IS
2424: l_name so_agreements.name%type;
2425: l_start_date_active so_agreements.start_date_active%type;
2426: l_end_date_active so_agreements.end_date_active%type;
2427: BEGIN
2428:

Line 2425: l_start_date_active so_agreements.start_date_active%type;

2421:
2422: FUNCTION get_agreement_name(p_agreement_id IN NUMBER)
2423: RETURN VARCHAR2 IS
2424: l_name so_agreements.name%type;
2425: l_start_date_active so_agreements.start_date_active%type;
2426: l_end_date_active so_agreements.end_date_active%type;
2427: BEGIN
2428:
2429: IF p_agreement_id IS NOT NULL THEN

Line 2426: l_end_date_active so_agreements.end_date_active%type;

2422: FUNCTION get_agreement_name(p_agreement_id IN NUMBER)
2423: RETURN VARCHAR2 IS
2424: l_name so_agreements.name%type;
2425: l_start_date_active so_agreements.start_date_active%type;
2426: l_end_date_active so_agreements.end_date_active%type;
2427: BEGIN
2428:
2429: IF p_agreement_id IS NOT NULL THEN
2430: IF pg_agreement_rec.EXISTS(p_agreement_id) THEN

Line 2437: FROM so_agreements

2433:
2434: ELSE
2435: SELECT name,start_date_active, end_date_active
2436: INTO l_name, l_start_date_active, l_end_date_active
2437: FROM so_agreements
2438: WHERE agreement_id = p_agreement_id ;
2439:
2440: pg_agreement_rec(p_agreement_id).name := l_name;
2441: pg_agreement_rec(p_agreement_id).is_valid_date := NULL;