APPS.CN_API dependencies on CN_CREDIT_TYPES

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

2040: -- | Description : Procedure to return precision and extended precision for credit
2041: -- | types
2042: -- |-------------------------------------------------------------------------=
2043: PROCEDURE get_credit_info
2044: (p_credit_type_name IN cn_credit_types.name%TYPE, /* credit type name */
2045: x_precision OUT NOCOPY NUMBER, /* number of digits to right of decimal*/
2046: x_ext_precision OUT NOCOPY NUMBER, /* precision where more precision is needed*/
2047: p_org_id NUMBER
2048: ) IS

Line 2054: FROM cn_credit_types

2050: BEGIN
2051:
2052: SELECT PRECISION, EXTENDED_PRECISION
2053: INTO x_precision, x_ext_precision
2054: FROM cn_credit_types
2055: WHERE name = p_credit_type_name
2056: AND org_id = p_org_id;
2057:
2058: /* Precision should never be NULL; this is just so it works w/ bad data*/

Line 2091: l_monetary_flag cn_credit_types.monetary_flag%TYPE;

2087: p_repcurr_code IN VARCHAR2,
2088: p_org_id IN NUMBER
2089: ) RETURN NUMBER IS
2090:
2091: l_monetary_flag cn_credit_types.monetary_flag%TYPE;
2092: l_conv_date DATE;
2093: l_conv_amount NUMBER;
2094: l_repcurr_amount NUMBER;
2095:

Line 2110: FROM cn_credit_types_all

2106:
2107: BEGIN
2108:
2109: SELECT monetary_flag into l_monetary_flag
2110: FROM cn_credit_types_all
2111: WHERE credit_type_id = p_from_credit_type_id
2112: AND org_id = p_org_id;
2113:
2114: IF (l_monetary_flag = 'N') THEN

Line 2187: l_monetary_flag cn_credit_types.monetary_flag%TYPE;

2183: x_return_status OUT NOCOPY VARCHAR2,
2184: p_org_id IN NUMBER
2185: ) IS
2186:
2187: l_monetary_flag cn_credit_types.monetary_flag%TYPE;
2188: l_conv_date DATE;
2189: l_conv_amount NUMBER;
2190:
2191: CURSOR get_closest_date IS

Line 2212: FROM cn_credit_types_all

2208: -- dbms_output.put_line('p_funcurr_code = '|| p_funcurr_code);
2209: -- dbms_output.put_line('p_repcurr_code = ' || p_repcurr_code);
2210:
2211: SELECT monetary_flag into l_monetary_flag
2212: FROM cn_credit_types_all
2213: WHERE credit_type_id = p_from_credit_type_id
2214: AND org_id = p_org_id;
2215:
2216: -- dbms_output.put_line('l_monetary_flag = ' || l_monetary_flag);