DBA Data[Home] [Help]

APPS.ASO_SALES_CREDIT_PVT dependencies on FND_PROFILE

Line 29: l_auto_sales_cred_prof VARCHAR2(50) := NVL(FND_PROFILE.Value('ASO_AUTO_SALES_CREDIT'),'NONE');

25: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
26: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
27: IS
28:
29: l_auto_sales_cred_prof VARCHAR2(50) := NVL(FND_PROFILE.Value('ASO_AUTO_SALES_CREDIT'),'NONE');
30: l_auto_sales_team_prof VARCHAR2(50) := NVL(FND_PROFILE.Value('ASO_AUTO_TEAM_ASSIGN'),'NONE');
31:
32: Leave_Proc EXCEPTION;
33:

Line 30: l_auto_sales_team_prof VARCHAR2(50) := NVL(FND_PROFILE.Value('ASO_AUTO_TEAM_ASSIGN'),'NONE');

26: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
27: IS
28:
29: l_auto_sales_cred_prof VARCHAR2(50) := NVL(FND_PROFILE.Value('ASO_AUTO_SALES_CREDIT'),'NONE');
30: l_auto_sales_team_prof VARCHAR2(50) := NVL(FND_PROFILE.Value('ASO_AUTO_TEAM_ASSIGN'),'NONE');
31:
32: Leave_Proc EXCEPTION;
33:
34: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;

Line 79: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');

75:
76:
77: BEGIN
78:
79: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
80:
81: -- Standard Start of API savepoint
82: SAVEPOINT ALLOCATE_SALES_CREDITS_PVT;
83:

Line 123: IF (NVL(FND_PROFILE.Value('ASO_API_ENABLE_SECURITY'),'N') = 'N') THEN

119: RAISE Leave_Proc;
120: END IF;
121:
122: -- Check if security profiles are set
123: IF (NVL(FND_PROFILE.Value('ASO_API_ENABLE_SECURITY'),'N') = 'N') THEN
124:
125: IF aso_debug_pub.g_debug_flag = 'Y' THEN
126: aso_debug_pub.add('API_Enable_Sec is N ',1,'Y');
127: END IF;

Line 415: l_cred_upd_lines_prof VARCHAR2(50) := FND_PROFILE.Value('ASO_SALES_CREDIT_UPDATE');

411: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
412:
413: IS
414:
415: l_cred_upd_lines_prof VARCHAR2(50) := FND_PROFILE.Value('ASO_SALES_CREDIT_UPDATE');
416:
417: l_quota_id NUMBER;
418: l_non_quota_id NUMBER;
419: l_total_rev NUMBER := 0;