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 1612: so_agreements soa,

1608: WHERE EXISTS
1609: (
1610: SELECT 'commitments_exist'
1611: FROM hz_cust_accounts cust_acct,
1612: so_agreements soa,
1613: hz_cust_acct_sites acct_site,
1614: ra_cust_trx_types inv_type,
1615: ra_cust_trx_types type,
1616: ra_customer_trx trx

Line 1719: FROM so_agreements a

1715: FROM DUAL
1716: WHERE EXISTS
1717: (
1718: SELECT 'agreements_exist'
1719: FROM so_agreements a
1720: WHERE a.customer_id IN
1721: (
1722: SELECT cr.cust_account_id
1723: FROM hz_cust_acct_relate cr

Line 2243: l_name so_agreements.name%type;

2239:
2240: FUNCTION is_agreement_date_valid(p_trx_date IN DATE,
2241: p_agreement_id IN NUMBER)
2242: RETURN VARCHAR2 IS
2243: l_name so_agreements.name%type;
2244: l_valid_date VARCHAR2(10);
2245: l_start_date_active so_agreements.start_date_active%type;
2246: l_end_date_active so_agreements.end_date_active%type;
2247: BEGIN

Line 2245: l_start_date_active so_agreements.start_date_active%type;

2241: p_agreement_id IN NUMBER)
2242: RETURN VARCHAR2 IS
2243: l_name so_agreements.name%type;
2244: l_valid_date VARCHAR2(10);
2245: l_start_date_active so_agreements.start_date_active%type;
2246: l_end_date_active so_agreements.end_date_active%type;
2247: BEGIN
2248: IF p_agreement_id IS NOT NULL THEN
2249: IF pg_agreement_rec.EXISTS(p_agreement_id) THEN

Line 2246: l_end_date_active so_agreements.end_date_active%type;

2242: RETURN VARCHAR2 IS
2243: l_name so_agreements.name%type;
2244: l_valid_date VARCHAR2(10);
2245: l_start_date_active so_agreements.start_date_active%type;
2246: l_end_date_active so_agreements.end_date_active%type;
2247: BEGIN
2248: IF p_agreement_id IS NOT NULL THEN
2249: IF pg_agreement_rec.EXISTS(p_agreement_id) THEN
2250:

Line 2274: FROM so_agreements

2270:
2271: ELSE
2272: SELECT name,start_date_active, end_date_active
2273: INTO l_name, l_start_date_active, l_end_date_active
2274: FROM so_agreements
2275: WHERE agreement_id = p_agreement_id ;
2276:
2277: IF NVL(p_trx_date, trunc(sysdate)) >=
2278: NVL( l_start_date_active,NVL(p_trx_date, trunc(sysdate))) AND

Line 2305: l_name so_agreements.name%type;

2301: END is_agreement_date_valid;
2302:
2303: FUNCTION get_agreement_name(p_agreement_id IN NUMBER)
2304: RETURN VARCHAR2 IS
2305: l_name so_agreements.name%type;
2306: l_start_date_active so_agreements.start_date_active%type;
2307: l_end_date_active so_agreements.end_date_active%type;
2308: BEGIN
2309:

Line 2306: l_start_date_active so_agreements.start_date_active%type;

2302:
2303: FUNCTION get_agreement_name(p_agreement_id IN NUMBER)
2304: RETURN VARCHAR2 IS
2305: l_name so_agreements.name%type;
2306: l_start_date_active so_agreements.start_date_active%type;
2307: l_end_date_active so_agreements.end_date_active%type;
2308: BEGIN
2309:
2310: IF p_agreement_id IS NOT NULL THEN

Line 2307: l_end_date_active so_agreements.end_date_active%type;

2303: FUNCTION get_agreement_name(p_agreement_id IN NUMBER)
2304: RETURN VARCHAR2 IS
2305: l_name so_agreements.name%type;
2306: l_start_date_active so_agreements.start_date_active%type;
2307: l_end_date_active so_agreements.end_date_active%type;
2308: BEGIN
2309:
2310: IF p_agreement_id IS NOT NULL THEN
2311: IF pg_agreement_rec.EXISTS(p_agreement_id) THEN

Line 2318: FROM so_agreements

2314:
2315: ELSE
2316: SELECT name,start_date_active, end_date_active
2317: INTO l_name, l_start_date_active, l_end_date_active
2318: FROM so_agreements
2319: WHERE agreement_id = p_agreement_id ;
2320:
2321: pg_agreement_rec(p_agreement_id).name := l_name;
2322: pg_agreement_rec(p_agreement_id).is_valid_date := NULL;