DBA Data[Home] [Help]

APPS.GCS_RP_UTILITY_PKG dependencies on GCS_ENTRY_LINES

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 36: insert into gcs_entry_lines

32: exception when others then l_elimtb_y_n := 'Y';
33: end;
34:
35: if (l_elimtb_y_n = 'N') then
36: insert into gcs_entry_lines
37: ( entry_id,
38: company_cost_center_org_id,
39: intercompany_id,
40: ytd_debit_balance_e,

Line 71: insert into gcs_entry_lines

67: p_row_count := SQL%ROWCOUNT;
68:
69: --insert rows if the offset flag was used
70: if (p_offset_flag = 'Y') then
71: insert into gcs_entry_lines
72: ( entry_id,
73: company_cost_center_org_id,
74: intercompany_id,
75: ytd_debit_balance_e,

Line 102: insert into gcs_entry_lines

98: GROUP BY geg.off_line_item_id
99: ;
100: end if; --p_offset_flag = Y
101: else
102: insert into gcs_entry_lines
103: ( entry_id,
104: company_cost_center_org_id,
105: intercompany_id,
106: ytd_debit_balance_e,

Line 137: insert into gcs_entry_lines

133: p_row_count := SQL%ROWCOUNT;
134:
135: --insert rows if the offset flag was used
136: if (p_offset_flag = 'Y') then
137: insert into gcs_entry_lines
138: ( entry_id,
139: company_cost_center_org_id,
140: intercompany_id,
141: ytd_debit_balance_e,