30: --
31: PROCEDURE validate_segments
32: (
33: p_co_code IN gl_plcy_mst.co_code%TYPE,
34: p_acctg_unit_id IN gl_accu_mst.acctg_unit_id%TYPE,
35: p_acct_id IN gl_acct_mst.acct_id%TYPE,
36: p_acctg_unit_no IN gl_accu_mst.acctg_unit_no%TYPE,
37: p_acct_no IN gl_acct_mst.acct_no%TYPE,
38: p_create_combination IN VARCHAR2 DEFAULT 'N',
32: (
33: p_co_code IN gl_plcy_mst.co_code%TYPE,
34: p_acctg_unit_id IN gl_accu_mst.acctg_unit_id%TYPE,
35: p_acct_id IN gl_acct_mst.acct_id%TYPE,
36: p_acctg_unit_no IN gl_accu_mst.acctg_unit_no%TYPE,
37: p_acct_no IN gl_acct_mst.acct_no%TYPE,
38: p_create_combination IN VARCHAR2 DEFAULT 'N',
39: x_ccid OUT NOCOPY NUMBER,
40: x_concat_seg OUT NOCOPY VARCHAR2,
66: --
67: PROCEDURE get_accu_acct_ids
68: (
69: p_co_code IN gl_plcy_mst.co_code%TYPE,
70: p_acctg_unit_no IN gl_accu_mst.acctg_unit_no%TYPE,
71: p_acct_no IN gl_acct_mst.acct_no%TYPE,
72: p_create_acct IN VARCHAR2 DEFAULT 'N',
73: x_acctg_unit_id OUT NOCOPY gl_accu_mst.acctg_unit_id%TYPE,
74: x_acct_id OUT NOCOPY gl_acct_mst.acct_id%TYPE,
69: p_co_code IN gl_plcy_mst.co_code%TYPE,
70: p_acctg_unit_no IN gl_accu_mst.acctg_unit_no%TYPE,
71: p_acct_no IN gl_acct_mst.acct_no%TYPE,
72: p_create_acct IN VARCHAR2 DEFAULT 'N',
73: x_acctg_unit_id OUT NOCOPY gl_accu_mst.acctg_unit_id%TYPE,
74: x_acct_id OUT NOCOPY gl_acct_mst.acct_id%TYPE,
75: x_ccid OUT NOCOPY NUMBER,
76: x_status OUT NOCOPY VARCHAR2,
77: x_errmsg OUT NOCOPY VARCHAR2
85:
86:
87: -- Function to return account unit no
88: FUNCTION get_acctg_unit_no (
89: p_co_code IN gl_accu_mst.co_code%TYPE,
90: p_acctg_unit_id IN gl_accu_mst.acctg_unit_id%TYPE
91: ) RETURN VARCHAR2;
92:
93: --
86:
87: -- Function to return account unit no
88: FUNCTION get_acctg_unit_no (
89: p_co_code IN gl_accu_mst.co_code%TYPE,
90: p_acctg_unit_id IN gl_accu_mst.acctg_unit_id%TYPE
91: ) RETURN VARCHAR2;
92:
93: --
94: -- Fuction to return error messages record type to forms.