DBA Data[Home] [Help]

APPS.GMF_VALIDATE_ACCOUNT dependencies on FND_ID_FLEX_STRUCTURES

Line 40: # against fnd_id_flex_structures

36: #
37: # HISTORY
38: # 10-Jun-2002 Uday Moogala Bug 2468906 - Created.
39: # 11-Jul-2006 rseshadr Bug 5384550 - use GL# explicitly in queries
40: # against fnd_id_flex_structures
41: ########################################################################*/
42:
43: PROCEDURE validate_segments(
44: p_co_code IN gl_plcy_mst.co_code%TYPE,

Line 76: fnd_id_flex_structures flex,

72: plcy.segment_delimiter,
73: flex.CONCATENATED_SEGMENT_DELIMITER,
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

Line 97: l_id_flex_code fnd_id_flex_structures.id_flex_code%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;
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;

Line 98: l_id_flex_num fnd_id_flex_structures.id_flex_num%TYPE;

94: l_segment_count PLS_INTEGER; -- Bug xxx
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;