APPS.CZ_MIGRATE dependencies on DBMS_APPLICATION_INFO

Line 49: DBMS_APPLICATION_INFO.SET_MODULE('','');

45: errbuf := CZ_UTILS.GET_TEXT('CZ_MIGR_WARNING_SETUP');
46: report(errbuf, URGENCY_WARNING);
47: END IF;
48:
49: DBMS_APPLICATION_INFO.SET_MODULE('','');
50: END setup_migration_cp;
51: ---------------------------------------------------------------------------------------
52: PROCEDURE run_migration_cp(errbuf OUT NOCOPY VARCHAR2,
53: retcode OUT NOCOPY NUMBER,

Line 80: DBMS_APPLICATION_INFO.SET_MODULE('','');

76: errbuf := CZ_UTILS.GET_TEXT('CZ_MIGR_WARNING_RUN');
77: report(errbuf, URGENCY_WARNING);
78: END IF;
79:
80: DBMS_APPLICATION_INFO.SET_MODULE('','');
81: END run_migration_cp;
82: ---------------------------------------------------------------------------------------
83: FUNCTION verify_server_entry(p_local_name IN VARCHAR2, x_link_name IN OUT NOCOPY VARCHAR2)
84: RETURN INTEGER IS

Line 164: DBMS_APPLICATION_INFO.SET_MODULE('CZMIGRATION', TO_CHAR(x_run_id));

160: report(CZ_UTILS.GET_TEXT('CZ_MIGR_SESSION_EXISTS'), URGENCY_ERROR);
161: RETURN FATAL_ERROR;
162: END LOOP;
163:
164: DBMS_APPLICATION_INFO.SET_MODULE('CZMIGRATION', TO_CHAR(x_run_id));
165:
166: BEGIN
167: SELECT value INTO MigrationStatus FROM cz_db_settings
168: WHERE UPPER(section_name) = 'MIGRATE' AND UPPER(setting_id) = 'MIGRATIONSTATUS';

Line 351: DBMS_APPLICATION_INFO.SET_MODULE('CZMIGRATION', TO_CHAR(x_run_id));

347: report(CZ_UTILS.GET_TEXT('CZ_MIGR_SESSION_EXISTS'), URGENCY_ERROR);
348: RETURN FATAL_ERROR;
349: END LOOP;
350:
351: DBMS_APPLICATION_INFO.SET_MODULE('CZMIGRATION', TO_CHAR(x_run_id));
352:
353: BEGIN
354: SELECT value INTO MigrationStatus FROM cz_db_settings
355: WHERE UPPER(section_name) = 'MIGRATE' AND UPPER(setting_id) = 'MIGRATIONSTATUS';

Line 530: 'begin DBMS_APPLICATION_INFO.SET_MODULE@'||dbLinkName||'(:1, :2); end;' USING 'PUBLISH_MODEL',TO_CHAR(x_run_id) ;

526: END LOOP;
527: CLOSE l_src_sessn_cur;
528:
529: EXECUTE IMMEDIATE
530: 'begin DBMS_APPLICATION_INFO.SET_MODULE@'||dbLinkName||'(:1, :2); end;' USING 'PUBLISH_MODEL',TO_CHAR(x_run_id) ;
531:
532: FOR i IN(SELECT ui_def_id FROM CZ_UI_DEFS
533: WHERE deleted_flag='0' AND ui_style IN(G_OA_UIMT_STYLE,G_OA_UI_STYLE))
534: LOOP

Line 573: 'begin DBMS_APPLICATION_INFO.SET_MODULE@'||dbLinkName||'(:1, :2); end;' USING '','' ;

569: END IF;
570:
571: -----reset module info on the target
572: EXECUTE IMMEDIATE
573: 'begin DBMS_APPLICATION_INFO.SET_MODULE@'||dbLinkName||'(:1, :2); end;' USING '','' ;
574:
575: begin
576: update cz_db_settings set value='COMPLETED'
577: where section_name='MIGRATE' and setting_id='MigrationStatus';