APPS.EGO_PUB_WS_UTIL dependencies on EGO_PUBLICATION_BATCH_GT

Line 1785: -- Get all entities of EGO_PUBLICATION_BATCH_GT

1781: WHERE SESSION_ID = l_session_id
1782: AND INPUT_ID = l_input_id
1783: AND SYSTEM_CODE = l_system_code;
1784:
1785: -- Get all entities of EGO_PUBLICATION_BATCH_GT
1786: CURSOR c_pub_bat_gt(l_batch_id NUMBER)
1787: IS
1788: SELECT BATCH_ID,
1789: PK1_VALUE,

Line 1797: FROM EGO_PUBLICATION_BATCH_GT

1793: PK5_VALUE,
1794: SYSTEM_CODE,
1795: STATUS,
1796: MESSAGE
1797: FROM EGO_PUBLICATION_BATCH_GT
1798: WHERE BATCH_ID = l_batch_id;
1799:
1800: BEGIN
1801:

Line 1852: INSERT INTO EGO_PUBLICATION_BATCH_GT

1848: FOR ent IN c_pub_ws_entities(p_session_id)
1849: LOOP
1850:
1851: --DBMS_OUTPUT.PUT_LINE('ent.pk1_value: ' || to_char(ent.pk1_value));
1852: INSERT INTO EGO_PUBLICATION_BATCH_GT
1853: (BATCH_ID,
1854: BATCH_ENTITY_OBJECT_ID,
1855: PK1_VALUE,
1856: PK2_VALUE,

Line 1904: INSERT INTO EGO_PUBLICATION_BATCH_GT

1900: FOR ent IN c_pub_ws_entities(p_session_id)
1901: LOOP
1902:
1903: --DBMS_OUTPUT.PUT_LINE('ent.pk1_value: ' || to_char(ent.pk1_value));
1904: INSERT INTO EGO_PUBLICATION_BATCH_GT
1905: (BATCH_ID,
1906: BATCH_ENTITY_OBJECT_ID,
1907: PK1_VALUE,
1908: PK2_VALUE,

Line 1958: INSERT INTO EGO_PUBLICATION_BATCH_GT

1954: FOR ent IN c_pub_ws_entities(p_session_id)
1955: LOOP
1956:
1957: --DBMS_OUTPUT.PUT_LINE('ent.pk1_value: ' || to_char(ent.pk1_value));
1958: INSERT INTO EGO_PUBLICATION_BATCH_GT
1959: ( BATCH_ID,
1960: BATCH_ENTITY_OBJECT_ID,
1961: PK1_VALUE,
1962: PK2_VALUE,

Line 2067: UPDATE EGO_PUBLICATION_BATCH_GT

2063: FND_MESSAGE.SET_TOKEN ('ENTITY_NAME', l_param_value);
2064: FND_MESSAGE.SET_TOKEN ('SYSTEM_CODE', l_system_code);
2065: l_message := SUBSTR(FND_MESSAGE.Get, 1, 2000);
2066:
2067: UPDATE EGO_PUBLICATION_BATCH_GT
2068: SET STATUS = 'F', MESSAGE = l_message
2069: WHERE BATCH_ID = l_batch_id
2070: AND PK1_VALUE = ip.PK1_VALUE
2071: AND NVL(PK2_VALUE,'pk2_value') = NVL(ip.PK2_VALUE,'pk2_value')

Line 2096: UPDATE EGO_PUBLICATION_BATCH_GT

2092: --DBMS_OUTPUT.PUT_LINE('l_batch_id: ' || to_char(l_batch_id));
2093: --DBMS_OUTPUT.PUT_LINE('ip.PK1_VALUE: ' || to_char(ip.PK1_VALUE));
2094: --DBMS_OUTPUT.PUT_LINE('ip.SYSTEM_CODE: ' || to_char(ip.SYSTEM_CODE));
2095:
2096: UPDATE EGO_PUBLICATION_BATCH_GT
2097: SET STATUS = 'F', MESSAGE = l_message
2098: WHERE BATCH_ID = l_batch_id
2099: AND PK1_VALUE = ip.PK1_VALUE
2100: AND NVL(PK2_VALUE,'pk2_value') = NVL(ip.PK2_VALUE,'pk2_value')

Line 2124: UPDATE EGO_PUBLICATION_BATCH_GT

2120: FND_MESSAGE.SET_TOKEN ('ENTITY_NAME', l_param_value);
2121: FND_MESSAGE.SET_TOKEN ('SYSTEM_CODE', l_system_code);
2122: l_message := SUBSTR(FND_MESSAGE.Get, 1, 2000);
2123:
2124: UPDATE EGO_PUBLICATION_BATCH_GT
2125: SET STATUS = 'W', MESSAGE = l_message
2126: WHERE BATCH_ID = l_batch_id
2127: AND PK1_VALUE = ip.PK1_VALUE
2128: AND NVL(PK2_VALUE,'pk2_value') = NVL(ip.PK2_VALUE,'pk2_value')