DBA Data[Home] [Help]

APPS.GMF_VALIDATE_ACCOUNT dependencies on GL_ACCT_MST

Line 35: p_acct_id IN gl_acct_mst.acct_id%TYPE,

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',
39: x_ccid OUT NOCOPY NUMBER,

Line 37: p_acct_no IN gl_acct_mst.acct_no%TYPE,

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,
41: x_status OUT NOCOPY VARCHAR2,

Line 55: p_acct_id IN gl_acct_mst.acct_id%TYPE,

51: -- Bug 3080232. Added additional parameter p_acct_no.
52: PROCEDURE cross_validate
53: (
54: p_co_code IN gl_plcy_mst.co_code%TYPE,
55: p_acct_id IN gl_acct_mst.acct_id%TYPE,
56: p_called_from IN VARCHAR2,
57: x_status OUT NOCOPY VARCHAR2,
58: p_acct_no IN gl_acct_mst.acct_no%TYPE DEFAULT NULL
59: );

Line 58: p_acct_no IN gl_acct_mst.acct_no%TYPE DEFAULT NULL

54: p_co_code IN gl_plcy_mst.co_code%TYPE,
55: p_acct_id IN gl_acct_mst.acct_id%TYPE,
56: p_called_from IN VARCHAR2,
57: x_status OUT NOCOPY VARCHAR2,
58: p_acct_no IN gl_acct_mst.acct_no%TYPE DEFAULT NULL
59: );
60:
61: --
62: -- Procedure to validate the accu and acct combination.

Line 71: p_acct_no IN gl_acct_mst.acct_no%TYPE,

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,
75: x_ccid OUT NOCOPY NUMBER,

Line 74: x_acct_id OUT NOCOPY gl_acct_mst.acct_id%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
78: );

Line 82: p_co_code IN gl_acct_mst.co_code%TYPE,

78: );
79:
80: -- Function to return account no
81: FUNCTION get_acct_no (
82: p_co_code IN gl_acct_mst.co_code%TYPE,
83: p_acct_id IN gl_acct_mst.acct_id%TYPE
84: ) RETURN VARCHAR2;
85:
86:

Line 83: p_acct_id IN gl_acct_mst.acct_id%TYPE

79:
80: -- Function to return account no
81: FUNCTION get_acct_no (
82: p_co_code IN gl_acct_mst.co_code%TYPE,
83: p_acct_id IN gl_acct_mst.acct_id%TYPE
84: ) RETURN VARCHAR2;
85:
86:
87: -- Function to return account unit no