APPS.OKE_NUMBER_SEQUENCES_PKG dependencies on OKE_NUMBER_SEQUENCES_PKG

Line 1: PACKAGE BODY OKE_NUMBER_SEQUENCES_PKG AS

1: PACKAGE BODY OKE_NUMBER_SEQUENCES_PKG AS
2: /* $Header: OKENMSQB.pls 120.1 2005/08/29 13:16:43 ausmani noship $ */
3:
4: --
5: -- Global Variables for Line Number generation

Line 220: AND OKE_NUMBER_SEQUENCES_PKG.Value_Is_Numeric

216: AND ltrim(Chg_Request_Num,'0') = (
217: SELECT TO_CHAR(MAX(TO_NUMBER(Chg_Request_Num)))
218: FROM oke_chg_requests
219: WHERE K_Header_ID = cr.K_Header_ID
220: AND OKE_NUMBER_SEQUENCES_PKG.Value_Is_Numeric
221: (Chg_Request_Num) = 'Y'
222: )
223: FOR UPDATE OF Chg_Request_Num;
224:

Line 315: AND OKE_NUMBER_SEQUENCES_PKG.Value_Is_Numeric

311: SELECT TO_CHAR(MAX(TO_NUMBER(Line_Number)))
312: FROM okc_k_lines_b
313: WHERE Dnz_Chr_ID = d.Dnz_Chr_ID
314: AND NVL(CLe_ID,-1) = NVL(X_Parent_Line_ID,-1)
315: AND OKE_NUMBER_SEQUENCES_PKG.Value_Is_Numeric
316: (Line_Number) = 'Y'
317: )
318: FOR UPDATE OF Line_Number;
319:

Line 498: AND OKE_NUMBER_SEQUENCES_PKG.Value_Is_Numeric

494: SELECT to_char(max(to_number(Deliverable_Num)))
495: FROM oke_k_deliverables_b
496: WHERE K_Header_ID = d.K_Header_ID
497: AND K_Line_ID = d.K_Line_ID
498: AND OKE_NUMBER_SEQUENCES_PKG.Value_Is_Numeric
499: (Deliverable_Num) = 'Y'
500: )
501: FOR UPDATE OF Deliverable_Num;
502:

Line 604: END OKE_NUMBER_SEQUENCES_PKG;

600: WHEN OTHERS THEN
601: RETURN ( sqlerrm );
602: END Next_Deliverable_Number;
603:
604: END OKE_NUMBER_SEQUENCES_PKG;