APPS.HZ_UTILITY_V2PUB dependencies on AR_LOOKUPS

Line 272: l_lookup_type AR_LOOKUPS.lookup_type%TYPE;

268: l_position1 NUMBER;
269: l_position2 NUMBER;
270:
271: l_lookup_table VARCHAR2(30);
272: l_lookup_type AR_LOOKUPS.lookup_type%TYPE;
273: l_lookup_code AR_LOOKUPS.lookup_code%TYPE;
274:
275: l_relationship_type VARCHAR2(30);
276: l_incl_unrelated_entities VARCHAR2(1);

Line 273: l_lookup_code AR_LOOKUPS.lookup_code%TYPE;

269: l_position2 NUMBER;
270:
271: l_lookup_table VARCHAR2(30);
272: l_lookup_type AR_LOOKUPS.lookup_type%TYPE;
273: l_lookup_code AR_LOOKUPS.lookup_code%TYPE;
274:
275: l_relationship_type VARCHAR2(30);
276: l_incl_unrelated_entities VARCHAR2(1);
277:

Line 315: IF UPPER( l_lookup_table ) = 'AR_LOOKUPS' THEN

311: l_lookup_type := SUBSTRB( p_val, l_position1 + G_LENGTH,
312: l_position2 - l_position1 - G_LENGTH );
313: l_lookup_code := SUBSTRB( p_val, l_position2 + G_LENGTH );
314:
315: IF UPPER( l_lookup_table ) = 'AR_LOOKUPS' THEN
316: BEGIN
317: SELECT meaning INTO x_lookup_meaning
318: FROM AR_LOOKUPS
319: WHERE LOOKUP_TYPE = l_lookup_type

Line 318: FROM AR_LOOKUPS

314:
315: IF UPPER( l_lookup_table ) = 'AR_LOOKUPS' THEN
316: BEGIN
317: SELECT meaning INTO x_lookup_meaning
318: FROM AR_LOOKUPS
319: WHERE LOOKUP_TYPE = l_lookup_type
320: AND LOOKUP_CODE = l_lookup_code
321: AND ( ENABLED_FLAG = 'Y' AND
322: TRUNC( SYSDATE ) BETWEEN

Line 1015: * AR_LOOKUPS

1011: * IN:
1012: * p_column Column name you want to validate.
1013: * p_lookup_table Table/view name you want to validate against to.
1014: * For now, we are supporting
1015: * AR_LOOKUPS
1016: * SO_LOOKUPS
1017: * OE_SHIP_METHODS_V
1018: * FND_LOOKUP_VALUES
1019: * Default value is AR_LOOKUPS

Line 1019: * Default value is AR_LOOKUPS

1015: * AR_LOOKUPS
1016: * SO_LOOKUPS
1017: * OE_SHIP_METHODS_V
1018: * FND_LOOKUP_VALUES
1019: * Default value is AR_LOOKUPS
1020: * p_lookup_type FND lookup type
1021: * p_column_value Column value
1022: * IN/OUT:
1023: * x_return_status Return status.

Line 1640: * AR_LOOKUPS

1636: * ARGUMENTS
1637: * IN:
1638: * p_lookup_table Table/view name you want to validate against to.
1639: * For now, we are supporting
1640: * AR_LOOKUPS
1641: * SO_LOOKUPS
1642: * OE_SHIP_METHODS_V
1643: * FND_LOOKUP_VALUES
1644: * Default value is AR_LOOKUPS

Line 1644: * Default value is AR_LOOKUPS

1640: * AR_LOOKUPS
1641: * SO_LOOKUPS
1642: * OE_SHIP_METHODS_V
1643: * FND_LOOKUP_VALUES
1644: * Default value is AR_LOOKUPS
1645: * p_lookup_type FND lookup type
1646: * p_lookup_code FND lookup code
1647: *
1648: * NOTES

Line 1918: ar_lookups al

1914: -- psu.site_use_type,
1915: -- psu.primary_per_type
1916: from hz_party_sites ps,
1917: hz_party_site_uses psu,
1918: ar_lookups al
1919: where
1920: ps.party_site_id = l_party_site_id and
1921: psu.party_site_id = ps.party_site_id and
1922: psu.status = 'A' and

Line 1981: ar_lookups al

1977: cursor c_site_use_purposes (l_party_site_id IN NUMBER) is
1978: select al.MEANING
1979: from hz_party_sites ps,
1980: hz_party_site_uses psu,
1981: ar_lookups al
1982: where
1983: ps.party_site_id = l_party_site_id and
1984: psu.party_site_id = ps.party_site_id and
1985: psu.status = 'A' and

Line 2037: ar_lookups al

2033: cursor c_site_use_purposes (l_acct_site_id IN NUMBER) is
2034: select al.MEANING
2035: from hz_cust_acct_sites s,
2036: hz_cust_site_uses u,
2037: ar_lookups al
2038: where
2039: s.cust_acct_site_id = l_acct_site_id and
2040: u.cust_acct_site_id = s.cust_acct_site_id and
2041: u.status = 'A' and