APPS.EGO_PAGES_BULKLOAD_PVT dependencies on EGO_PAGE_ENTRIES_B

Line 488: FROM ego_page_entries_b

484: last_updated_by = G_USER_ID,
485: last_update_date = SYSDATE,
486: last_update_login = G_LOGIN_ID
487: WHERE EXISTS (SELECT 1
488: FROM ego_page_entries_b
489: WHERE page_id = epi.page_id
490: AND association_id = epi.old_association_id)
491: AND transaction_type = G_OPR_SYNC
492: AND process_status = G_PROCESS_RECORD

Line 1317: FROM ego_page_entries_b

1313: /*Sets the SYNC to CREATE or UPDATE*/
1314: IF (p_ent_tbl(i).transaction_type = G_OPR_SYNC) THEN
1315: BEGIN
1316: SELECT 'Y' INTO lv_flag
1317: FROM ego_page_entries_b
1318: WHERE page_id = p_ent_tbl(i).page_id
1319: AND association_id = p_ent_tbl(i).old_association_id;
1320:
1321: p_ent_tbl(i).transaction_type := G_OPR_UPDATE;

Line 1736: FROM ego_page_entries_b

1732: Nvl(program_id, G_PROGRAM_ID),
1733: Nvl(program_update_date, SYSDATE)
1734: FROM ego_page_entries_interface epei
1735: WHERE NOT EXISTS (SELECT 1
1736: FROM ego_page_entries_b
1737: WHERE page_id = epei.page_id
1738: AND association_id = epei.old_association_id
1739: AND classification_code = epei.classification_code)
1740: AND transaction_type <> G_OPR_CREATE

Line 1752: FROM ego_page_entries_b

1748: last_updated_by = G_USER_ID,
1749: last_update_date = SYSDATE,
1750: last_update_login = G_LOGIN_ID
1751: WHERE NOT EXISTS (SELECT 1
1752: FROM ego_page_entries_b
1753: WHERE page_id = epi.page_id
1754: AND association_id = epi.old_association_id
1755: AND classification_code = epi.classification_code)
1756: AND transaction_type <> G_OPR_CREATE

Line 1813: FROM ego_page_entries_b

1809: Nvl(program_id, G_PROGRAM_ID),
1810: Nvl(program_update_date, SYSDATE)
1811: FROM ego_page_entries_interface epi
1812: WHERE EXISTS (SELECT 1
1813: FROM ego_page_entries_b
1814: WHERE page_id = epi.page_id
1815: AND sequence = epi.sequence)
1816: AND transaction_id IS NOT NULL
1817: AND transaction_type = G_OPR_CREATE /*Added this for bug 9733398*/

Line 1828: FROM ego_page_entries_b

1824: last_updated_by = G_USER_ID,
1825: last_update_date = SYSDATE,
1826: last_update_login = G_LOGIN_ID
1827: WHERE EXISTS (SELECT 1
1828: FROM ego_page_entries_b
1829: WHERE page_id = epi.page_id
1830: AND sequence = epi.sequence)
1831: AND transaction_id IS NOT NULL
1832: AND transaction_type = G_OPR_CREATE /*Added this for bug 9733398*/

Line 1979: FROM ego_page_entries_b

1975: /*Error out if flow is UPDATE or DELETE and the page entry does not exist*/
1976: IF (p_ent_tbl(i).transaction_type <> G_OPR_CREATE) THEN
1977: BEGIN
1978: SELECT 'Y' INTO lv_flag
1979: FROM ego_page_entries_b
1980: WHERE page_id = p_ent_tbl(i).page_id
1981: AND association_id = p_ent_tbl(i).old_association_id
1982: AND classification_code = p_ent_tbl(i).classification_code;
1983: EXCEPTION

Line 2013: FROM ego_page_entries_b

2009: lv_smt := 2;
2010: /*Error if SEQ already exists in the page*/
2011: BEGIN
2012: SELECT 'Y' INTO lv_flag
2013: FROM ego_page_entries_b
2014: WHERE page_id = p_ent_tbl(i).page_id
2015: AND sequence = p_ent_tbl(i).sequence;
2016:
2017: IF (lv_flag = 'Y') THEN

Line 2279: FROM EGO_PAGE_ENTRIES_B

2275: DECLARE
2276: lv_count NUMBER;
2277: BEGIN
2278: SELECT COUNT(1) INTO lv_count
2279: FROM EGO_PAGE_ENTRIES_B
2280: WHERE page_id = p_ent_tbl(i).page_id
2281: AND association_id = p_ent_tbl(i).old_association_id;
2282:
2283: IF (lv_count = 1) THEN

Line 2781: FROM EGO_PAGE_ENTRIES_B

2777: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Create Page Entity');
2778:
2779: /*check if the same AG is being reassociated to the page. This repeat check is required*/
2780: SELECT count(1) INTO lv_count_ag
2781: FROM EGO_PAGE_ENTRIES_B
2782: WHERE page_id = P_ent_tbl(i).page_id
2783: AND classification_code = P_ent_tbl(i).classification_code
2784: AND association_id = P_ent_tbl(i).old_association_id;
2785:

Line 2788: FROM ego_page_entries_b

2784: AND association_id = P_ent_tbl(i).old_association_id;
2785:
2786: /*check if the same sequence is already used. This repeat check is required.*/
2787: SELECT count(1) INTO lv_count_seq
2788: FROM ego_page_entries_b
2789: WHERE page_id = P_ent_tbl(i).page_id
2790: AND sequence = P_ent_tbl(i).sequence;
2791:
2792: IF (lv_count_ag > 0) THEN

Line 2864: FROM ego_page_entries_b

2860:
2861: /*Added for bug 9733398*/
2862: /*check if the same sequence is already used.*/
2863: SELECT count(1) INTO lv_count_seq
2864: FROM ego_page_entries_b
2865: WHERE page_id = P_ent_tbl(i).page_id
2866: AND sequence = P_ent_tbl(i).sequence
2867: AND association_id <> P_ent_tbl(i).old_association_id;
2868:

Line 3226: FROM EGO_PAGE_ENTRIES_B

3222: BEGIN
3223: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Smt 1');
3224:
3225: SELECT sequence INTO lv_sequence
3226: FROM EGO_PAGE_ENTRIES_B
3227: WHERE page_id = p_ent_tbl(i).page_id
3228: AND association_id = p_ent_tbl(i).old_association_id;
3229:
3230: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Smt 2');