DBA Data[Home] [Help]

APPS.GCS_RP_UTILITY_PKG dependencies on GCS_ENTRIES_GT

Line 9: -- Generated SQL statement to insert data into gcs_entry_lines from gcs_entries_gt

5: --
6: -- Procedure
7: -- create_entry_lines
8: -- Purpose
9: -- Generated SQL statement to insert data into gcs_entry_lines from gcs_entries_gt
10: --
11: -- Arguments
12: -- p_entry_id: entry identifier
13: -- p_row_count: #of rows inserted

Line 29: from gcs_entries_gt geg

25:
26: begin
27: select 'N'
28: into l_elimtb_y_n
29: from gcs_entries_gt geg
30: where formula_text NOT LIKE '%ELIMTB%'
31: and rownum < 2;
32: exception when others then l_elimtb_y_n := 'Y';
33: end;

Line 62: FROM gcs_entries_gt geg

58: fnd_global.user_id,
59: fnd_global.user_id,
60: sysdate,
61: fnd_global.login_id
62: FROM gcs_entries_gt geg
63: GROUP BY geg.tgt_line_item_id
64: ;
65:
66: --check number of rows inserted

Line 97: FROM gcs_entries_gt geg

93: fnd_global.user_id,
94: fnd_global.user_id,
95: sysdate,
96: fnd_global.login_id
97: FROM gcs_entries_gt geg
98: GROUP BY geg.off_line_item_id
99: ;
100: end if; --p_offset_flag = Y
101: else

Line 128: FROM gcs_entries_gt geg

124: fnd_global.user_id,
125: fnd_global.user_id,
126: sysdate,
127: fnd_global.login_id
128: FROM gcs_entries_gt geg
129: GROUP BY geg.src_company_cost_center_org_id, geg.tgt_line_item_id
130: ;
131:
132: --check number of rows inserted

Line 163: FROM gcs_entries_gt geg

159: fnd_global.user_id,
160: fnd_global.user_id,
161: sysdate,
162: fnd_global.login_id
163: FROM gcs_entries_gt geg
164: GROUP BY geg.src_company_cost_center_org_id, geg.off_line_item_id
165: ;
166: end if; --p_offset_flag = Y
167: end if;