APPS.OKC_CDRL_PVT dependencies on OKC_CDRL_PVT

Line 1: PACKAGE BODY OKC_CDRL_PVT AS

1: PACKAGE BODY OKC_CDRL_PVT AS
2: /* $Header: OKCVCDRLB.pls 120.0.12020000.13 2013/04/06 12:25:05 serukull noship $ */
3:
4:
5: ---------------------------------------------------------------------------

Line 8: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_CDRL_PVT';

4:
5: ---------------------------------------------------------------------------
6: -- Global VARIABLES
7: ---------------------------------------------------------------------------
8: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_CDRL_PVT';
9: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
10: G_ENTITY_NAME CONSTANT VARCHAR2(40) := 'OKC_DELIVERABLES';
11:
12: G_MODULE CONSTANT VARCHAR2(200) := 'okc.plsql.'||G_PKG_NAME||'.';

Line 305: ||Decode( Length(p_target_exhibit)+Length(OKC_CDRL_PVT.DECIMAL_TO_ELIN(X)),4,'',3,'0',2,'00')

301: SELECT NEXT_ELIN_SET
302: BULK COLLECT INTO data_item_num_tbl
303: FROM
304: (SELECT p_target_exhibit
305: ||Decode( Length(p_target_exhibit)+Length(OKC_CDRL_PVT.DECIMAL_TO_ELIN(X)),4,'',3,'0',2,'00')
306: ||OKC_CDRL_PVT.DECIMAL_TO_ELIN(X)
307: AS NEXT_ELIN_SET
308: FROM
309: (SELECT LEVEL AS X

Line 306: ||OKC_CDRL_PVT.DECIMAL_TO_ELIN(X)

302: BULK COLLECT INTO data_item_num_tbl
303: FROM
304: (SELECT p_target_exhibit
305: ||Decode( Length(p_target_exhibit)+Length(OKC_CDRL_PVT.DECIMAL_TO_ELIN(X)),4,'',3,'0',2,'00')
306: ||OKC_CDRL_PVT.DECIMAL_TO_ELIN(X)
307: AS NEXT_ELIN_SET
308: FROM
309: (SELECT LEVEL AS X
310: FROM dual

Line 1142: FROM (SELECT OKC_CDRL_PVT.ELIN_TO_DECIMAL(SubStr(data_item_number,'|| exhibit_len||'+1,4-'||exhibit_len||')) elin_decimal FROM okc_deliverables

1138:
1139: exhibit_len:=Length(p_exhibit_code);
1140:
1141: line_num_tbl_qry := 'SELECT Nvl(Max(ROWNUM),0)+1
1142: FROM (SELECT OKC_CDRL_PVT.ELIN_TO_DECIMAL(SubStr(data_item_number,'|| exhibit_len||'+1,4-'||exhibit_len||')) elin_decimal FROM okc_deliverables
1143: where business_document_type = :1 and business_document_id =:2
1144: and business_document_version = -99 and DEL_CATEGORY_CODE = :3
1145: and exhibit_code = :4 order by 1) WHERE ELIN_DECIMAL=rownum';
1146:

Line 1558: ||Decode( Length(p_exhibit_code)+Length(OKC_CDRL_PVT.DECIMAL_TO_ELIN(X)),4,'',3,'0',2,'00')

1554: SELECT NEXT_ELIN_SET
1555: BULK COLLECT INTO data_item_num_tbl
1556: FROM
1557: (SELECT p_exhibit_code
1558: ||Decode( Length(p_exhibit_code)+Length(OKC_CDRL_PVT.DECIMAL_TO_ELIN(X)),4,'',3,'0',2,'00')
1559: ||OKC_CDRL_PVT.DECIMAL_TO_ELIN(X)
1560: AS NEXT_ELIN_SET
1561: FROM
1562: (SELECT LEVEL AS X

Line 1559: ||OKC_CDRL_PVT.DECIMAL_TO_ELIN(X)

1555: BULK COLLECT INTO data_item_num_tbl
1556: FROM
1557: (SELECT p_exhibit_code
1558: ||Decode( Length(p_exhibit_code)+Length(OKC_CDRL_PVT.DECIMAL_TO_ELIN(X)),4,'',3,'0',2,'00')
1559: ||OKC_CDRL_PVT.DECIMAL_TO_ELIN(X)
1560: AS NEXT_ELIN_SET
1561: FROM
1562: (SELECT LEVEL AS X
1563: FROM dual

Line 2035: END OKC_CDRL_PVT;

2031: END IF;
2032: END get_new_deliverable_id;
2033:
2034:
2035: END OKC_CDRL_PVT;