APPS.ZX_EXTRACT_PKG dependencies on FND_PROFILE

Line 60: PG_DEBUG VARCHAR2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');

56: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
57: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
58: g_error_buffer VARCHAR2(100);
59:
60: PG_DEBUG VARCHAR2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
61:
62:
63: CURSOR multi_org_csr IS
64: SELECT multi_org_flag

Line 1515: g_created_by := nvl(fnd_profile.value('USER_ID'),1);

1511: END IF;
1512:
1513: -- Populate the WHO columns :
1514:
1515: g_created_by := nvl(fnd_profile.value('USER_ID'),1);
1516: g_creation_date := sysdate;
1517: g_last_updated_by := nvl(fnd_profile.value('USER_ID'),1);
1518: g_last_update_date := sysdate;
1519: g_last_update_login := 1;

Line 1517: g_last_updated_by := nvl(fnd_profile.value('USER_ID'),1);

1513: -- Populate the WHO columns :
1514:
1515: g_created_by := nvl(fnd_profile.value('USER_ID'),1);
1516: g_creation_date := sysdate;
1517: g_last_updated_by := nvl(fnd_profile.value('USER_ID'),1);
1518: g_last_update_date := sysdate;
1519: g_last_update_login := 1;
1520:
1521: -- Get the max length of P_ERRBUF, rounded down to 50 characters

Line 3574: --pg_debug_flag:= nvl(FND_PROFILE.value('TAX_DEBUG_FLAG'),'N');

3570: FUNCTION PURGE(p_request_id in number) return number is
3571: num_rows_deleted number := 0;
3572: BEGIN
3573:
3574: --pg_debug_flag:= nvl(FND_PROFILE.value('TAX_DEBUG_FLAG'),'N');
3575:
3576:
3577: select count(*) into num_rows_deleted
3578: from zx_rep_trx_detail_t