APPS.INV_ITEM_ATTRIBUTES_PKG dependencies on FND_PROFILE

Line 92: G_DEBUG VARCHAR2(1) := NVL(fnd_profile.value('AFLOG_ENABLED'), 'N');

88: g_count NUMBER := 0;
89: g_unit_test_mode BOOLEAN := FALSE;
90: G_PKG_NAME CONSTANT VARCHAR2(30) := 'INV_ITEM_ATT_MTN';
91: G_SLEEP_TIME NUMBER := 15;
92: G_DEBUG VARCHAR2(1) := NVL(fnd_profile.value('AFLOG_ENABLED'), 'N');
93:
94: g_submit_failure_exc EXCEPTION;
95:
96: TYPE g_request_tbl_type IS TABLE OF NUMBER

Line 1821: ( FND_PROFILE.Value('INV_CCEOI_COMMIT_POINT')

1817:
1818: -- get the max batch size from the profile option;
1819: -- default it to 1000 if the profile option is not defined.
1820: l_max_batch_size := NVL( TO_NUMBER
1821: ( FND_PROFILE.Value('INV_CCEOI_COMMIT_POINT')
1822: )
1823: , 1000
1824: );
1825:

Line 1836: ( FND_PROFILE.Value('INV_MGD_MAX_WORK')

1832:
1833: -- get the max number of workers from the profile option;
1834: -- default it to 1 if the profile option is not defined.
1835: l_request_count := NVL( TO_NUMBER
1836: ( FND_PROFILE.Value('INV_MGD_MAX_WORK')
1837: )
1838: , 1
1839: );
1840:

Line 1978: SET tmp.chosen_value = FND_PROFILE.VALUE('INV_STATUS_DEFAULT')

1974:
1975: ELSE
1976:
1977: UPDATE mtl_item_values_temp tmp
1978: SET tmp.chosen_value = FND_PROFILE.VALUE('INV_STATUS_DEFAULT')
1979: WHERE tmp.current_att_index = l_current_att_index
1980: AND tmp.item_update_id = p_seq_id;
1981: END IF; -- inventory_item_status_code check
1982: