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 1060: g_created_by := nvl(fnd_profile.value('USER_ID'),1);

1056:
1057:
1058: -- Populate the WHO columns :
1059:
1060: g_created_by := nvl(fnd_profile.value('USER_ID'),1);
1061: g_creation_date := sysdate;
1062: g_last_updated_by := nvl(fnd_profile.value('USER_ID'),1);
1063: g_last_update_date := sysdate;
1064: g_last_update_login := 1;

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

1058: -- Populate the WHO columns :
1059:
1060: g_created_by := nvl(fnd_profile.value('USER_ID'),1);
1061: g_creation_date := sysdate;
1062: g_last_updated_by := nvl(fnd_profile.value('USER_ID'),1);
1063: g_last_update_date := sysdate;
1064: g_last_update_login := 1;
1065:
1066: -- Get the max length of P_ERRBUF, rounded down to 50 characters

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

3074: FUNCTION PURGE(p_request_id in number) return number is
3075: num_rows_deleted number := 0;
3076: BEGIN
3077:
3078: --pg_debug_flag:= nvl(FND_PROFILE.value('TAX_DEBUG_FLAG'),'N');
3079:
3080:
3081: select count(*) into num_rows_deleted
3082: from zx_rep_trx_detail_t