APPS.OZF_RESALE_COMMON_PVT dependencies on FND_PROFILE

Line 39: G_ITEM_ORG_ID NUMBER := FND_PROFILE.value('AMS_ITEM_ORGANIZATION_ID');

35: G_TP_ACCRUAL_UTIL_TYPE CONSTANT VARCHAR2(30) :='ADJUSTMENT';
36: G_CHBK_ADJ_TYPE_ID CONSTANT NUMBER := -10;
37: G_ACCEPT_ALLOWED CONSTANT VARCHAR2(30) := 'ACCEPT_ALLOWED';
38: G_ACCEPT_CLAIMED CONSTANT VARCHAR2(30) := 'ACCEPT_CLAIMED';
39: G_ITEM_ORG_ID NUMBER := FND_PROFILE.value('AMS_ITEM_ORGANIZATION_ID');
40: g_universal_currency CONSTANT VARCHAR2 (15) := fnd_profile.VALUE ('OZF_UNIV_CURR_CODE');
41:
42: -------------------------------------------------------------------------------
43:

Line 40: g_universal_currency CONSTANT VARCHAR2 (15) := fnd_profile.VALUE ('OZF_UNIV_CURR_CODE');

36: G_CHBK_ADJ_TYPE_ID CONSTANT NUMBER := -10;
37: G_ACCEPT_ALLOWED CONSTANT VARCHAR2(30) := 'ACCEPT_ALLOWED';
38: G_ACCEPT_CLAIMED CONSTANT VARCHAR2(30) := 'ACCEPT_CLAIMED';
39: G_ITEM_ORG_ID NUMBER := FND_PROFILE.value('AMS_ITEM_ORGANIZATION_ID');
40: g_universal_currency CONSTANT VARCHAR2 (15) := fnd_profile.VALUE ('OZF_UNIV_CURR_CODE');
41:
42: -------------------------------------------------------------------------------
43:
44:

Line 1162: l_dup_chk_attrb_unique_prfl varchar2(250):= FND_PROFILE.value('OZF_DUP_CHECK_ATTRB_UNIQUE');

1158: l_adjustment_id NUMBER;
1159: l_claimed_amount NUMBER;
1160: l_line_id NUMBER := NULL;
1161: l_tracing_flag VARCHAR2(1); --Bug# 8414563 fixed by ateotia
1162: l_dup_chk_attrb_unique_prfl varchar2(250):= FND_PROFILE.value('OZF_DUP_CHECK_ATTRB_UNIQUE');
1163: l_addl_attrb_dup_check_prfl varchar2(250):= FND_PROFILE.value('OZF_DUP_CHECK_ADDL_ATTRB');
1164:
1165:
1166: CURSOR dup_line_direct_resale_csr ( p_resale_line_int_id IN NUMBER )

Line 1163: l_addl_attrb_dup_check_prfl varchar2(250):= FND_PROFILE.value('OZF_DUP_CHECK_ADDL_ATTRB');

1159: l_claimed_amount NUMBER;
1160: l_line_id NUMBER := NULL;
1161: l_tracing_flag VARCHAR2(1); --Bug# 8414563 fixed by ateotia
1162: l_dup_chk_attrb_unique_prfl varchar2(250):= FND_PROFILE.value('OZF_DUP_CHECK_ATTRB_UNIQUE');
1163: l_addl_attrb_dup_check_prfl varchar2(250):= FND_PROFILE.value('OZF_DUP_CHECK_ADDL_ATTRB');
1164:
1165:
1166: CURSOR dup_line_direct_resale_csr ( p_resale_line_int_id IN NUMBER )
1167: IS