APPS.GL_GLCOAM_PKG dependencies on FND_ID_FLEX_STRUCTURES

Line 21: FROM FND_ID_FLEX_STRUCTURES

17: x_id_flex_strt_code VARCHAR2(30);--Variable to get the structure code.
18:
19: CURSOR insert_update(flex_num NUMBER) IS
20: SELECT id_flex_num
21: FROM FND_ID_FLEX_STRUCTURES
22: WHERE application_id = 101
23: AND id_flex_code = 'GLLE'
24: AND id_flex_num = flex_num;
25:

Line 51: DELETE FROM FND_ID_FLEX_STRUCTURES

47: --If there is already an existing structure with the same ID, delete it.
48: OPEN insert_update(X_id_flex_num);
49: FETCH insert_update INTO x_num;
50: IF(insert_update%FOUND)THEN
51: DELETE FROM FND_ID_FLEX_STRUCTURES
52: WHERE application_id = 101
53: AND id_flex_code = 'GLLE'
54: AND id_flex_num = X_id_flex_num;
55:

Line 56: DELETE FROM FND_ID_FLEX_STRUCTURES_TL

52: WHERE application_id = 101
53: AND id_flex_code = 'GLLE'
54: AND id_flex_num = X_id_flex_num;
55:
56: DELETE FROM FND_ID_FLEX_STRUCTURES_TL
57: WHERE application_id = 101
58: AND id_flex_code = 'GLLE'
59: AND id_flex_num = X_id_flex_num;
60:

Line 90: INSERT INTO FND_ID_FLEX_STRUCTURES

86: END IF;
87: CLOSE insert_update;
88:
89: --Insert the new chart of accounts based on the Ledger Flexfield.
90: INSERT INTO FND_ID_FLEX_STRUCTURES
91: (application_id,
92: id_flex_code,
93: id_flex_num,
94: last_update_date,

Line 130: FROM FND_ID_FLEX_STRUCTURES

126: shorthand_length,
127: structure_view_name,
128: id_flex_structure_code--,
129: -- security_group_id
130: FROM FND_ID_FLEX_STRUCTURES
131: WHERE application_id = 101
132: AND id_flex_code = 'GL#'
133: AND id_flex_num = X_id_flex_num;
134:

Line 137: INSERT INTO FND_ID_FLEX_STRUCTURES_TL

133: AND id_flex_num = X_id_flex_num;
134:
135: --Insert the chart of accounts in multiple languages supported by the
136: --application.
137: INSERT INTO FND_ID_FLEX_STRUCTURES_TL
138: (application_id,
139: id_flex_code,
140: id_flex_num,
141: language,

Line 167: FROM FND_ID_FLEX_STRUCTURES_TL

163: description,
164: shorthand_prompt,
165: source_lang
166: -- security_group_id
167: FROM FND_ID_FLEX_STRUCTURES_TL
168: WHERE application_id = 101
169: AND id_flex_code = 'GL#'
170: AND id_flex_num = X_id_flex_num;
171:

Line 503: FROM FND_ID_FLEX_STRUCTURES

499: CLOSE segments_exist;
500:
501: SELECT id_flex_structure_code
502: INTO x_id_flex_strt_code
503: FROM FND_ID_FLEX_STRUCTURES
504: WHERE application_id = 101
505: AND id_flex_code = 'GLLE'
506: AND id_flex_num = X_id_flex_num;
507: