[Home] [Help]
268:
269: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Statement 1');
270:
271: UPDATE ego_pages_interface epi
272: SET classification_code = EGO_ICC_BULKLOAD_PVT.Get_Catalog_Group_Id(classification_name,'FIND_COMBINATION'),
273: last_updated_by = G_USER_ID,
274: last_update_date = SYSDATE,
275: last_update_login = G_LOGIN_ID
276: WHERE classification_name IS NOT NULL
347:
348: x_return_status := G_RET_STS_SUCCESS;
349:
350: UPDATE ego_page_entries_interface epi
351: SET classification_code = EGO_ICC_BULKLOAD_PVT.Get_Catalog_Group_Id(classification_name,'FIND_COMBINATION'),
352: last_updated_by = G_USER_ID,
353: last_update_date = SYSDATE,
354: last_update_login = G_LOGIN_ID
355: WHERE classification_name IS NOT NULL
1051: FOR i IN p_pg_tbl.FIRST.. p_pg_tbl.LAST LOOP
1052: IF (p_pg_tbl(i).process_status = G_PROCESS_RECORD) THEN
1053: /*Get the ICC ID from the Concatenated ICC Name*/
1054: IF (p_pg_tbl(i).classification_name IS NOT NULL AND p_pg_tbl(i).classification_code IS NULL) THEN
1055: p_pg_tbl(i).classification_code := EGO_ICC_BULKLOAD_PVT.Get_Catalog_Group_Id(p_pg_tbl(i).classification_name,'FIND_COMBINATION');
1056: END IF;
1057:
1058: /*Get the page ID and set SYNC to UPDATE*/
1059: IF (p_pg_tbl(i).transaction_type <> G_OPR_CREATE) THEN
1130: FOR i IN p_ent_tbl.FIRST.. p_ent_tbl.LAST LOOP
1131: IF (p_ent_tbl(i).process_status = G_PROCESS_RECORD) THEN
1132: /*Get the ICC ID from the Concatenated ICC Name*/
1133: IF (p_ent_tbl(i).classification_name IS NOT NULL AND p_ent_tbl(i).classification_code IS NULL) THEN
1134: p_ent_tbl(i).classification_code := EGO_ICC_BULKLOAD_PVT.Get_Catalog_Group_Id(p_ent_tbl(i).classification_name,'FIND_COMBINATION');
1135: END IF;
1136:
1137: /*Get the page ID*/
1138: IF (p_ent_tbl(i).page_id IS NULL AND p_ent_tbl(i).internal_name IS NOT NULL AND p_ent_tbl(i).classification_code IS NOT NULL) THEN