APPS.PON_CLO_RENUMBER_PKG dependencies on PO_TBL_VARCHAR100

Line 5: -- Changing the following table type to genric PO_TBL_VARCHAR100 as some of these procedures

1: PACKAGE pon_clo_renumber_pkg AUTHID CURRENT_USER AS
2: /* $Header: PONCLORNS.pls 120.15.12020000.2 2013/02/09 11:15:01 hvutukur ship $ */
3:
4: /********************Type Declarations **************************/
5: -- Changing the following table type to genric PO_TBL_VARCHAR100 as some of these procedures
6: -- will be called from Java/Middle-tier -- serukull
7: -- TYPE TBL_VARCHAR2_100 IS TABLE OF VARCHAR2(100);
8:
9:

Line 27: FUNCTION NEXT_CLIN_NUM ( ASSIGNED_NUM_ARRAY PO_TBL_VARCHAR100 ) return VARCHAR2;

23: Name : NEXT_CLIN_NUM (Only PLSQL Implementation required)
24: Input : Array / PLSQL table of already assigned Clin numbers
25: Output : Next lowest Clin number available.
26: ********************************/
27: FUNCTION NEXT_CLIN_NUM ( ASSIGNED_NUM_ARRAY PO_TBL_VARCHAR100 ) return VARCHAR2;
28:
29: FUNCTION NEXT_CLIN_NUM_WRAPPER(p_Document_ID IN NUMBER,
30: p_product_code IN VARCHAR2) RETURN varchar2;
31:

Line 45: new_lines IN PO_TBL_VARCHAR100) RETURN VARCHAR2;

41: This is to get latest possible next clin number.
42: */
43: FUNCTION NEXT_CLIN_NUM_WRAPPER2(p_Document_ID IN NUMBER,
44: p_product_code IN VARCHAR2,
45: new_lines IN PO_TBL_VARCHAR100) RETURN VARCHAR2;
46:
47:
48: /* When user enters a clin number manually, this procudure validates the clin number */
49: PROCEDURE VALIDATE_CLIN_NUMBER( p_line_id IN NUMBER, p_doc_id IN NUMBER, p_new_value IN varchar2,