APPS.OKS_RENEW_UTIL_PVT dependencies on OKS_K_DEFAULTS

Line 161: FROM OKS_K_DEFAULTS_V

157: p_object_code IN VARCHAR2,
158: p_date IN DATE
159: ) IS
160: SELECT payment_terms_id1, payment_terms_id2
161: FROM OKS_K_DEFAULTS_V
162: WHERE SEGMENT_ID1 = p_id1
163: AND SEGMENT_ID2 = p_id2
164: AND JTOT_OBJECT_CODE = p_object_code
165: AND CDT_TYPE = 'SDT'

Line 172: FROM OKS_K_DEFAULTS_V

168:
169: -- Cursor to fetch renewal rules defined at Global level in Global Defaults.
170: CURSOR l_global_level_cur IS
171: SELECT payment_terms_id1, payment_terms_id2
172: FROM OKS_K_DEFAULTS_V
173: WHERE cdt_type = 'MDT'
174: AND segment_id1 IS NULL
175: AND segment_id2 IS NULL
176: AND jtot_object_code IS NULL;

Line 327: FROM oks_k_defaults

323:
324: CURSOR get_gcd_org_period_val (p_org_id IN VARCHAR2)
325: IS
326: SELECT period_type, period_start, price_uom
327: FROM oks_k_defaults
328: WHERE cdt_type = 'SDT'
329: AND segment_id1 = p_org_id;
330:
331: CURSOR get_gcd_glob_period_val

Line 334: FROM oks_k_defaults

330:
331: CURSOR get_gcd_glob_period_val
332: IS
333: SELECT period_type, period_start, price_uom
334: FROM oks_k_defaults
335: WHERE cdt_type = 'MDT'
336: AND segment_id1 IS NULL;
337:
338: l_period_type oks_k_defaults.period_type%TYPE;

Line 338: l_period_type oks_k_defaults.period_type%TYPE;

334: FROM oks_k_defaults
335: WHERE cdt_type = 'MDT'
336: AND segment_id1 IS NULL;
337:
338: l_period_type oks_k_defaults.period_type%TYPE;
339: l_period_start oks_k_defaults.period_start%TYPE;
340: l_price_uom oks_k_defaults.price_uom%TYPE;
341:
342: BEGIN

Line 339: l_period_start oks_k_defaults.period_start%TYPE;

335: WHERE cdt_type = 'MDT'
336: AND segment_id1 IS NULL;
337:
338: l_period_type oks_k_defaults.period_type%TYPE;
339: l_period_start oks_k_defaults.period_start%TYPE;
340: l_price_uom oks_k_defaults.price_uom%TYPE;
341:
342: BEGIN
343: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 340: l_price_uom oks_k_defaults.price_uom%TYPE;

336: AND segment_id1 IS NULL;
337:
338: l_period_type oks_k_defaults.period_type%TYPE;
339: l_period_start oks_k_defaults.period_start%TYPE;
340: l_price_uom oks_k_defaults.price_uom%TYPE;
341:
342: BEGIN
343: x_return_status := OKC_API.G_RET_STS_SUCCESS;
344: IF p_hdr_id IS NOT NULL

Line 503: FROM oks_k_defaults

499: period_type,
500: period_start,
501: price_uom,
502: template_language
503: FROM oks_k_defaults
504: WHERE
505: (cdt_type = 'MDT' AND jtot_object_code IS NULL AND segment_id1 IS NULL AND segment_id2 IS NULL)
506: OR
507: (cdt_type = 'SDT' AND jtot_object_code = 'OKX_OPERUNIT' AND segment_id1 = to_char(cp_org_id) AND segment_id2 = '#'

Line 1015: cdt_type oks_k_defaults.cdt_type%TYPE,

1011: x_msg_data OUT NOCOPY VARCHAR2)
1012: IS
1013:
1014: TYPE l_tset_rec IS RECORD(
1015: cdt_type oks_k_defaults.cdt_type%TYPE,
1016: jtot_object_code oks_k_defaults.jtot_object_code%TYPE,
1017: template_set_id oks_k_defaults.template_set_id%TYPE,
1018: template_language oks_k_defaults.template_language%TYPE);
1019:

Line 1016: jtot_object_code oks_k_defaults.jtot_object_code%TYPE,

1012: IS
1013:
1014: TYPE l_tset_rec IS RECORD(
1015: cdt_type oks_k_defaults.cdt_type%TYPE,
1016: jtot_object_code oks_k_defaults.jtot_object_code%TYPE,
1017: template_set_id oks_k_defaults.template_set_id%TYPE,
1018: template_language oks_k_defaults.template_language%TYPE);
1019:
1020: TYPE l_tset_tbl_type IS TABLE OF l_tset_rec INDEX BY BINARY_INTEGER;

Line 1017: template_set_id oks_k_defaults.template_set_id%TYPE,

1013:
1014: TYPE l_tset_rec IS RECORD(
1015: cdt_type oks_k_defaults.cdt_type%TYPE,
1016: jtot_object_code oks_k_defaults.jtot_object_code%TYPE,
1017: template_set_id oks_k_defaults.template_set_id%TYPE,
1018: template_language oks_k_defaults.template_language%TYPE);
1019:
1020: TYPE l_tset_tbl_type IS TABLE OF l_tset_rec INDEX BY BINARY_INTEGER;
1021:

Line 1018: template_language oks_k_defaults.template_language%TYPE);

1014: TYPE l_tset_rec IS RECORD(
1015: cdt_type oks_k_defaults.cdt_type%TYPE,
1016: jtot_object_code oks_k_defaults.jtot_object_code%TYPE,
1017: template_set_id oks_k_defaults.template_set_id%TYPE,
1018: template_language oks_k_defaults.template_language%TYPE);
1019:
1020: TYPE l_tset_tbl_type IS TABLE OF l_tset_rec INDEX BY BINARY_INTEGER;
1021:
1022: l_api_name CONSTANT VARCHAR2(30) := 'GET_TEMPLATE_SET';

Line 1050: FROM oks_k_defaults

1046: -- cursor will always return 1 record and at max return 3 records
1047: CURSOR c_cgd_template_set(cp_org_id IN NUMBER, cp_party_id IN NUMBER, cp_date IN DATE) IS
1048: SELECT
1049: cdt_type, jtot_object_code, template_set_id, template_language
1050: FROM oks_k_defaults
1051: WHERE
1052: (cdt_type = 'MDT' AND jtot_object_code IS NULL AND segment_id1 IS NULL AND segment_id2 IS NULL)
1053: OR
1054: (cdt_type = 'SDT' AND jtot_object_code = 'OKX_OPERUNIT' AND segment_id1 = to_char(cp_org_id) AND segment_id2 = '#'