APPS.POA_EDW_PO_DIST_F_C dependencies on FND_PROFILE

Line 108: IF (fnd_profile.value('POA_TRACE')='Y') THEN

104: /* Faustina's addition */
105:
106: l_temp_date := sysdate;
107:
108: IF (fnd_profile.value('POA_TRACE')='Y') THEN
109: dbms_session.set_sql_trace(TRUE);
110: END IF;
111:
112: IF (fnd_profile.value('POA_DEBUG') = 'Y') THEN

Line 112: IF (fnd_profile.value('POA_DEBUG') = 'Y') THEN

108: IF (fnd_profile.value('POA_TRACE')='Y') THEN
109: dbms_session.set_sql_trace(TRUE);
110: END IF;
111:
112: IF (fnd_profile.value('POA_DEBUG') = 'Y') THEN
113: poa_log.g_debug := TRUE;
114: END IF;
115:
116: IF(fnd_profile.value('POA_POPULATE_SAVINGS_TXN') = 'Y') then

Line 116: IF(fnd_profile.value('POA_POPULATE_SAVINGS_TXN') = 'Y') then

112: IF (fnd_profile.value('POA_DEBUG') = 'Y') THEN
113: poa_log.g_debug := TRUE;
114: END IF;
115:
116: IF(fnd_profile.value('POA_POPULATE_SAVINGS_TXN') = 'Y') then
117: poa_savings_main.populate_savings(g_push_from_date, g_push_to_date+1, FALSE);
118: edw_log.put_line('Populated Savings table');
119: END IF;
120:

Line 548: l_batch_size NUMBER := fnd_profile.value('POA_COLLECTION_BATCH_SIZE');

544: RETURN NUMBER
545: IS
546:
547: l_seq_id NUMBER := -1;
548: l_batch_size NUMBER := fnd_profile.value('POA_COLLECTION_BATCH_SIZE');
549: TYPE plsqltable IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
550: l_primary_key plsqltable;
551: l_batch_id plsqltable;
552: l_count NUMBER;