APPS.GMF_VALIDATE_ACCOUNT dependencies on GL_PLCY_MST

Line 44: p_co_code IN gl_plcy_mst.co_code%TYPE,

40: # against fnd_id_flex_structures
41: ########################################################################*/
42:
43: PROCEDURE validate_segments(
44: p_co_code IN gl_plcy_mst.co_code%TYPE,
45: p_acctg_unit_id IN gl_accu_mst.acctg_unit_id%TYPE,
46: p_acct_id IN gl_acct_mst.acct_id%TYPE,
47: p_acctg_unit_no IN gl_accu_mst.acctg_unit_no%TYPE,
48: p_acct_no IN gl_acct_mst.acct_no%TYPE,

Line 66: CURSOR c_struct_dtls (p_co_code gl_plcy_mst.co_code%TYPE)

62:
63: /**
64: * rs Bug 5384550 - use GL# explicitly
65: **/
66: CURSOR c_struct_dtls (p_co_code gl_plcy_mst.co_code%TYPE)
67: IS
68: SELECT
69: flex.application_id,
70: flex.id_flex_code,

Line 78: gl_plcy_mst plcy

74: sob.chart_of_accounts_id
75: FROM
76: fnd_id_flex_structures flex,
77: gl_sets_of_books sob,
78: gl_plcy_mst plcy
79: WHERE
80: flex.id_flex_num = sob.chart_of_accounts_id
81: AND sob.set_of_books_id = plcy.sob_id
82: AND plcy.co_code = p_co_code

Line 92: l_seg_delimiter gl_plcy_mst.segment_delimiter%TYPE;

88: l_coa_id gl_sets_of_books.chart_of_accounts_id%TYPE;
89:
90: l_concat_segs VARCHAR2(4000);
91: l_concat_segs1 VARCHAR2(4000);
92: l_seg_delimiter gl_plcy_mst.segment_delimiter%TYPE;
93: l_Segment_array fnd_flex_ext.SegmentArray;
94: l_segment_count PLS_INTEGER; -- Bug xxx
95:
96: l_appl_id fnd_application.application_id%TYPE;

Line 99: l_flexDelimiter gl_plcy_mst.segment_delimiter%TYPE;

95:
96: l_appl_id fnd_application.application_id%TYPE;
97: l_id_flex_code fnd_id_flex_structures.id_flex_code%TYPE;
98: l_id_flex_num fnd_id_flex_structures.id_flex_num%TYPE;
99: l_flexDelimiter gl_plcy_mst.segment_delimiter%TYPE;
100:
101: l_ccid NUMBER := -1;
102: e_acctg_unit_not_found EXCEPTION;
103: e_acct_not_found EXCEPTION;

Line 285: p_co_code IN gl_plcy_mst.co_code%TYPE,

281: ########################################################################*/
282:
283: PROCEDURE cross_validate
284: (
285: p_co_code IN gl_plcy_mst.co_code%TYPE,
286: p_acct_id IN gl_acct_mst.acct_id%TYPE,
287: p_called_from IN VARCHAR2,
288: x_status OUT NOCOPY VARCHAR2,
289: p_acct_no IN gl_acct_mst.acct_no%TYPE DEFAULT NULL

Line 413: p_co_code IN gl_plcy_mst.co_code%TYPE,

409: ########################################################################*/
410:
411: PROCEDURE get_accu_acct_ids
412: (
413: p_co_code IN gl_plcy_mst.co_code%TYPE,
414: p_acctg_unit_no IN gl_accu_mst.acctg_unit_no%TYPE,
415: p_acct_no IN gl_acct_mst.acct_no%TYPE,
416: p_create_acct IN VARCHAR2 DEFAULT 'N',
417: x_acctg_unit_id OUT NOCOPY gl_accu_mst.acctg_unit_id%TYPE,