118: --
119: -- Procedure
120: -- Add_To_Summary_Table
121: -- Purpose
122: -- Inserts rows into the gcs_entity_cctr_orgs table.
123: -- Arguments
124: -- p_entity_id Entity for which the logic must be performed
125: -- Example
126: -- GCS_ENTITIES_PKG.Add_To_Summary_Table(...);
132: v_module := 'Add_To_Summary_Table';
133: module_log_write(v_module, g_module_enter);
134:
135: --Added by Santosh - 5235164
136: DELETE gcs_entity_cctr_orgs WHERE entity_id = p_entity_id;
137:
138:
139: INSERT INTO gcs_entity_cctr_orgs
140: (entity_id,
135: --Added by Santosh - 5235164
136: DELETE gcs_entity_cctr_orgs WHERE entity_id = p_entity_id;
137:
138:
139: INSERT INTO gcs_entity_cctr_orgs
140: (entity_id,
141: company_cost_center_org_id,
142: object_version_number,
143: creation_date,
1391:
1392: END Load_Entities;
1393:
1394: --
1395: -- GCS_ENTITY_CCTR_ORGS update
1396: --
1397:
1398: PROCEDURE Update_Entity_Orgs(x_errbuf OUT NOCOPY VARCHAR2,
1399: x_retcode OUT NOCOPY VARCHAR2) IS
1402: v_module := 'Update_Entity_Orgs';
1403: module_log_write(v_module, g_module_enter);
1404:
1405: --Added by Santosh - 5235164
1406: DELETE gcs_entity_cctr_orgs;
1407:
1408: INSERT INTO gcs_entity_cctr_orgs
1409: (entity_id,
1410: company_cost_center_org_id,
1404:
1405: --Added by Santosh - 5235164
1406: DELETE gcs_entity_cctr_orgs;
1407:
1408: INSERT INTO gcs_entity_cctr_orgs
1409: (entity_id,
1410: company_cost_center_org_id,
1411: object_version_number,
1412: creation_date,