1498: IF( l_emc_installed = 'Y') THEN
1499:
1500: /* intialize all global variables */
1501:
1502: g_request_id := FND_GLOBAL.CONC_REQUEST_ID();
1503: g_program_appl_id := FND_GLOBAL.PROG_APPL_ID();
1504: g_program_id := FND_GLOBAL.CONC_PROGRAM_ID();
1505: g_user_id := FND_GLOBAL.USER_ID();
1506: g_program_start_date := SYSDATE;
1499:
1500: /* intialize all global variables */
1501:
1502: g_request_id := FND_GLOBAL.CONC_REQUEST_ID();
1503: g_program_appl_id := FND_GLOBAL.PROG_APPL_ID();
1504: g_program_id := FND_GLOBAL.CONC_PROGRAM_ID();
1505: g_user_id := FND_GLOBAL.USER_ID();
1506: g_program_start_date := SYSDATE;
1507: g_error_mesg := NULL;
1500: /* intialize all global variables */
1501:
1502: g_request_id := FND_GLOBAL.CONC_REQUEST_ID();
1503: g_program_appl_id := FND_GLOBAL.PROG_APPL_ID();
1504: g_program_id := FND_GLOBAL.CONC_PROGRAM_ID();
1505: g_user_id := FND_GLOBAL.USER_ID();
1506: g_program_start_date := SYSDATE;
1507: g_error_mesg := NULL;
1508: g_status := 'FAILED';
1501:
1502: g_request_id := FND_GLOBAL.CONC_REQUEST_ID();
1503: g_program_appl_id := FND_GLOBAL.PROG_APPL_ID();
1504: g_program_id := FND_GLOBAL.CONC_PROGRAM_ID();
1505: g_user_id := FND_GLOBAL.USER_ID();
1506: g_program_start_date := SYSDATE;
1507: g_error_mesg := NULL;
1508: g_status := 'FAILED';
1509: g_proc_name := 'BIX_DM_EMAIL_SUMMARY_PKG';
1655: IF( l_emc_installed = 'Y') THEN
1656:
1657: /* intialize all global variables */
1658:
1659: g_request_id := FND_GLOBAL.CONC_REQUEST_ID();
1660: g_program_appl_id := FND_GLOBAL.PROG_APPL_ID();
1661: g_program_id := FND_GLOBAL.CONC_PROGRAM_ID();
1662: g_user_id := FND_GLOBAL.USER_ID();
1663: g_program_start_date := SYSDATE;
1656:
1657: /* intialize all global variables */
1658:
1659: g_request_id := FND_GLOBAL.CONC_REQUEST_ID();
1660: g_program_appl_id := FND_GLOBAL.PROG_APPL_ID();
1661: g_program_id := FND_GLOBAL.CONC_PROGRAM_ID();
1662: g_user_id := FND_GLOBAL.USER_ID();
1663: g_program_start_date := SYSDATE;
1664: g_error_mesg := NULL;
1657: /* intialize all global variables */
1658:
1659: g_request_id := FND_GLOBAL.CONC_REQUEST_ID();
1660: g_program_appl_id := FND_GLOBAL.PROG_APPL_ID();
1661: g_program_id := FND_GLOBAL.CONC_PROGRAM_ID();
1662: g_user_id := FND_GLOBAL.USER_ID();
1663: g_program_start_date := SYSDATE;
1664: g_error_mesg := NULL;
1665: g_status := 'FAILED';
1658:
1659: g_request_id := FND_GLOBAL.CONC_REQUEST_ID();
1660: g_program_appl_id := FND_GLOBAL.PROG_APPL_ID();
1661: g_program_id := FND_GLOBAL.CONC_PROGRAM_ID();
1662: g_user_id := FND_GLOBAL.USER_ID();
1663: g_program_start_date := SYSDATE;
1664: g_error_mesg := NULL;
1665: g_status := 'FAILED';
1666: g_proc_name := 'BIX_DM_EMAIL_SUMMARY_PKG';