eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EGO_PUB_FWK_PK dependencies on EGO_PUBLICATION_BATCH_GT

Line 95: delete from Ego_Publication_Batch_GT;

91:
92: BEGIN --Procedure add_derived_entities
93:
94: l_stmt_num := 0;
95: delete from Ego_Publication_Batch_GT;
96: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE
97: ,p_module => 'EGO_PUB_FWK_PK.add_derived_entities'
98: ,p_message => 'Enter EGO_PUB_FWK_PK.add_derived_entities ... '
99: ||to_char(sysdate, 'dd-mon-yyyy hh:mi:ss'));

Line 174: INSERT INTO EGO_PUBLICATION_BATCH_GT

170: l_stmt_num := 20;
171:
172: -- Adding column for entity_type_id . Added for Metadata Sync
173: FORALL i IN pk1_value.FIRST..pk1_value.LAST
174: INSERT INTO EGO_PUBLICATION_BATCH_GT
175: (
176: Batch_id
177: ,Pk1_Value
178: ,Pk2_value

Line 210: ||' ' || sql%rowcount || ' rows are inserted into EGO_PUBLICATION_BATCH_GT.');

206: );
207: EGO_COMMON_PVT.WRITE_DIAGNOSTIC ( p_log_level => FND_LOG.LEVEL_STATEMENT
208: ,p_module => 'EGO_PUB_FWK_PK.add_derived_entities'
209: ,p_message => 'lStmtNum=' || to_char(l_stmt_num)
210: ||' ' || sql%rowcount || ' rows are inserted into EGO_PUBLICATION_BATCH_GT.');
211:
212:
213: l_stmt_num := 30;
214: process_entities ( p_batch_id => l_batch_id

Line 226: delete from EGO_PUBLICATION_BATCH_GT;

222: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
224: END IF;
225:
226: delete from EGO_PUBLICATION_BATCH_GT;
227:
228: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE
229: ,p_module => 'EGO_PUB_FWK_PK.add_derived_entities'
230: ,p_message => 'Exit EGO_PUB_FWK_PK.add_derived_entities successfully... '

Line 347: FROM Ego_Publication_Batch_GT

343: ,SYSDATE
344: ,FND_GLOBAL.USER_ID
345: ,FND_GLOBAL.LOGIN_ID
346: ,1
347: FROM Ego_Publication_Batch_GT
348: WHERE Batch_Id = p_batch_id;
349: EGO_COMMON_PVT.WRITE_DIAGNOSTIC ( p_log_level => FND_LOG.LEVEL_STATEMENT
350: ,p_module => 'EGO_PUB_FWK_PK.process_entities'
351: ,p_message => 'lStmtNum=' || to_char(l_stmt_num)

Line 518: FROM Ego_Publication_Batch_GT

514: ,dbg_pk4_value
515: ,dbg_pk5_value
516: ,t_dbg_status
517: ,t_dbg_msg
518: FROM Ego_Publication_Batch_GT
519: WHERE Batch_id = p_batch_id;
520:
521:
522: EGO_COMMON_PVT.WRITE_DIAGNOSTIC ( p_log_level => FND_LOG.LEVEL_STATEMENT

Line 604: from ego_publication_batch_gt

600: BEGIN
601: l_stmt_num := 10;
602: Select count(*)
603: into l_ct_S
604: from ego_publication_batch_gt
605: WHERE batch_id = p_batch_id
606: and RETURN_STATUS = C_SUCCESS;
607: EXCEPTION
608: WHEN no_data_found THEN

Line 625: from ego_publication_batch_gt

621:
622: l_stmt_num := 30;
623: select count(*)
624: into l_ct_bat
625: from ego_publication_batch_gt
626: WHERE batch_id = p_batch_id;
627:
628: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_STATEMENT
629: ,p_module => 'EGO_PUB_FWK_PK.calc_return_status'

Line 713: Update ego_publication_batch_gt

709: ,p_module => 'EGO_PUB_FWK_PK.Basic_validation'
710: ,p_message => 'Inavlid Batch mode in stmt num: ' || l_stmt_num );
711:
712: l_stmt_num := 30;
713: Update ego_publication_batch_gt
714: set return_status = C_FAILED,
715: return_error_code = 'EGO_INVALID_MODE',
716: return_error_message = FND_MESSAGE.get_string ('EGO', 'EGO_INVALID_MODE'),
717: ret_err_msg_lang = USERENV('LANG')

Line 787: Update ego_publication_batch_gt

783: ,p_message => 'Exception EGO_PUB_BATCHID_NULL in stmt num: '||l_stmt_num || ':' ||'sqlerrm=>'|| sqlerrm);
784:
785:
786: l_stmt_num := 20;
787: Update ego_publication_batch_gt
788: set return_status = C_FAILED,
789: return_error_code = 'EGO_PUB_BATCHID_NULL',
790: return_error_message = FND_MESSAGE.get_string ('EGO', 'EGO_PUB_BATCHID_NULL'),
791: ret_err_msg_lang = USERENV('LANG')

Line 810: Update ego_publication_batch_gt

806: ,p_message => 'Exception EGO_NO_HEADER in stmt num: '||l_stmt_num || ':' ||'sqlerrm=>'|| sqlerrm);
807:
808:
809: l_stmt_num := 30;
810: Update ego_publication_batch_gt
811: set return_status = C_FAILED,
812: return_error_code = 'EGO_NO_HEADER',
813: return_error_message = FND_MESSAGE.get_string ('EGO', 'EGO_NO_HEADER'),
814: ret_err_msg_lang = USERENV('LANG')

Line 851: Update Ego_Publication_Batch_GT

847: ,p_message => 'Enter EGO_PUB_FWK_PK.validateStatus ... '
848: ||to_char(sysdate, 'dd-mon-yyyy hh:mi:ss'));
849:
850: l_stmt_num := 10;
851: Update Ego_Publication_Batch_GT
852: Set Return_status = C_FAILED,
853: process_flag = 1,
854: return_error_code = 'EGO_INVALID_STATUS_CODE',
855: return_error_message = FND_MESSAGE.get_string ('EGO', 'EGO_INVALID_STATUS_CODE'),

Line 896: Update Ego_Publication_Batch_GT

892: ||to_char(sysdate, 'dd-mon-yyyy hh:mi:ss'));
893:
894:
895: l_stmt_num := 10;
896: Update Ego_Publication_Batch_GT
897: Set Return_status = C_FAILED,
898: process_flag = 2,
899: return_error_code = 'EGO_INVALID_BAT_SYS',
900: return_error_message = FND_MESSAGE.get_string ('EGO', 'EGO_INVALID_BAT_SYS'),

Line 944: UPDATE ego_publication_batch_gt gt

940:
941:
942: l_stmt_num := 10;
943:
944: UPDATE ego_publication_batch_gt gt
945: SET batch_entity_object_id =
946: (SELECT eo.batch_entity_object_id
947: FROM ego_pub_bat_ent_objs_b eo
948: WHERE batch_id = gt.batch_id

Line 957: UPDATE ego_publication_batch_gt

953: AND nvl(eo.pk5_value, -99) = nvl(gt.pk5_value, -99)
954: and gt.batch_id = p_batch_id);
955:
956: l_stmt_num := 20;
957: UPDATE ego_publication_batch_gt
958: SET return_status = C_FAILED,
959: process_flag = 3,
960: return_error_code = 'EGO_INVALID_BAT_SYS_ENT',
961: return_error_message = FND_MESSAGE.get_string ('EGO', 'EGO_INVALID_BAT_SYS_ENT'),

Line 1049: from ego_publication_batch_gt

1045: t_batch_id,
1046: t_system_code,
1047: t_status,
1048: t_message
1049: from ego_publication_batch_gt
1050: where batch_id = p_batch_id
1051: and return_status is null
1052: and process_flag is null;
1053:

Line 1090: update ego_publication_batch_gt

1086:
1087: END IF;
1088:
1089: l_stmt_num := 90;
1090: update ego_publication_batch_gt
1091: set return_status = C_SUCCESS
1092: where batch_id = p_batch_id
1093: and process_flag is null;
1094:

Line 1126: --The following variables types should match with Ego_Publication_Batch_GT

1122: ,x_return_status OUT NOCOPY VARCHAR2
1123: ,x_msg_count OUT NOCOPY NUMBER
1124: ,x_msg_data OUT NOCOPY VARCHAR2)
1125: IS
1126: --The following variables types should match with Ego_Publication_Batch_GT
1127: pk1_value CHAR150_ARR_TBL_TYPE;
1128: pk2_value CHAR150_ARR_TBL_TYPE;
1129: pk3_value CHAR150_ARR_TBL_TYPE;
1130: pk4_value CHAR150_ARR_TBL_TYPE;

Line 1156: delete from Ego_Publication_Batch_GT;

1152: EGO_NO_DATA EXCEPTION;
1153: EGO_NO_BAT_STS_IN EXCEPTION;
1154:
1155: BEGIN
1156: delete from Ego_Publication_Batch_GT;
1157:
1158: l_stmt_num := 0;
1159: EGO_COMMON_PVT.WRITE_DIAGNOSTIC( p_log_level => FND_LOG.LEVEL_PROCEDURE
1160: ,p_module => 'EGO_PUB_FWK_PK.Update_Pub_Status'

Line 1218: INSERT INTO EGO_PUBLICATION_BATCH_GT

1214: END LOOP;
1215:
1216: l_stmt_num := 30;
1217: FORALL i IN t_system_code.FIRST..t_system_code.LAST
1218: INSERT INTO EGO_PUBLICATION_BATCH_GT
1219: (
1220: Batch_id
1221: ,pk1_value
1222: ,pk2_value

Line 1255: ||' ' ||sql%rowcount || ' rows are inserted into EGO_PUBLICATION_BATCH_GT.');

1251: );
1252: EGO_COMMON_PVT.WRITE_DIAGNOSTIC ( p_log_level => FND_LOG.LEVEL_STATEMENT
1253: ,p_module => 'EGO_PUB_FWK_PK.Update_Pub_Status'
1254: ,p_message => 'lStmtNum=' || to_char(l_stmt_num)
1255: ||' ' ||sql%rowcount || ' rows are inserted into EGO_PUBLICATION_BATCH_GT.');
1256:
1257:
1258: l_stmt_num := 40;
1259: Process_Pub_Status( p_mode => p_mode

Line 1296: FROM Ego_Publication_Batch_GT

1292: ,t_ret_status
1293: ,t_ret_err_msg
1294: ,t_ret_err_code
1295: ,t_ret_err_msg_lang
1296: FROM Ego_Publication_Batch_GT
1297: WHERE Batch_id = p_batch_id;
1298:
1299:
1300: EGO_COMMON_PVT.WRITE_DIAGNOSTIC ( p_log_level => FND_LOG.LEVEL_STATEMENT

Line 1343: delete from Ego_Publication_Batch_GT;

1339: t_ret_err_code(i) || ' --' ||
1340: t_ret_err_msg_lang(i) );
1341: END LOOP;
1342:
1343: delete from Ego_Publication_Batch_GT;
1344:
1345: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE
1346: ,p_module => 'EGO_PUB_FWK_PK.Update_Pub_Status'
1347: ,p_message => 'Exit EGO_PUB_FWK_PK.Update_Pub_Status successfully... '

Line 1381: Delete from Ego_Publication_Batch_GT;

1377:
1378: BEGIN
1379: x_return_status := FND_API.G_RET_STS_SUCCESS;
1380:
1381: Delete from Ego_Publication_Batch_GT;
1382:
1383: EXCEPTION
1384: WHEN OTHERS THEN
1385: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_UNEXPECTED