APPS.CN_API dependencies on CN_CREDIT_TYPES

Line 2066: (p_credit_type_name IN cn_credit_types.name%TYPE, /* credit type name */

2062: -- | Description : Procedure to return precision and extended precision for credit
2063: -- | types
2064: -- |-------------------------------------------------------------------------=
2065: PROCEDURE get_credit_info
2066: (p_credit_type_name IN cn_credit_types.name%TYPE, /* credit type name */
2067: x_precision OUT NOCOPY NUMBER, /* number of digits to right of decimal*/
2068: x_ext_precision OUT NOCOPY NUMBER, /* precision where more precision is needed*/
2069: p_org_id NUMBER
2070: ) IS

Line 2076: FROM cn_credit_types

2072: BEGIN
2073:
2074: SELECT PRECISION, EXTENDED_PRECISION
2075: INTO x_precision, x_ext_precision
2076: FROM cn_credit_types
2077: WHERE name = p_credit_type_name
2078: AND org_id = p_org_id;
2079:
2080: /* Precision should never be NULL; this is just so it works w/ bad data*/

Line 2113: l_monetary_flag cn_credit_types.monetary_flag%TYPE;

2109: p_repcurr_code IN VARCHAR2,
2110: p_org_id IN NUMBER
2111: ) RETURN NUMBER IS
2112:
2113: l_monetary_flag cn_credit_types.monetary_flag%TYPE;
2114: l_conv_date DATE;
2115: l_conv_amount NUMBER;
2116: l_repcurr_amount NUMBER;
2117:

Line 2132: FROM cn_credit_types_all

2128:
2129: BEGIN
2130:
2131: SELECT monetary_flag into l_monetary_flag
2132: FROM cn_credit_types_all
2133: WHERE credit_type_id = p_from_credit_type_id
2134: AND org_id = p_org_id;
2135:
2136: IF (l_monetary_flag = 'N') THEN

Line 2209: l_monetary_flag cn_credit_types.monetary_flag%TYPE;

2205: x_return_status OUT NOCOPY VARCHAR2,
2206: p_org_id IN NUMBER
2207: ) IS
2208:
2209: l_monetary_flag cn_credit_types.monetary_flag%TYPE;
2210: l_conv_date DATE;
2211: l_conv_amount NUMBER;
2212:
2213: CURSOR get_closest_date IS

Line 2234: FROM cn_credit_types_all

2230: -- dbms_output.put_line('p_funcurr_code = '|| p_funcurr_code);
2231: -- dbms_output.put_line('p_repcurr_code = ' || p_repcurr_code);
2232:
2233: SELECT monetary_flag into l_monetary_flag
2234: FROM cn_credit_types_all
2235: WHERE credit_type_id = p_from_credit_type_id
2236: AND org_id = p_org_id;
2237:
2238: -- dbms_output.put_line('l_monetary_flag = ' || l_monetary_flag);