DBA Data[Home] [Help]

APPS.QOT_DEFAULT_PVT dependencies on FND_PROFILE

Line 683: l_Default_Cal_Prof VARCHAR2(15):= FND_PROFILE.VALUE ('ASO_DEFAULT_EXP_GL_CAL' );

679: WHERE Period_Type = l_Def_Per
680: AND Period_Set_Name = l_Def_Cal
681: AND SYSDATE BETWEEN NVL(Start_Date,sysdate) AND NVL(End_Date,sysdate);
682:
683: l_Default_Cal_Prof VARCHAR2(15):= FND_PROFILE.VALUE ('ASO_DEFAULT_EXP_GL_CAL' );
684: l_Default_Per_Prof VARCHAR2(15):= FND_PROFILE.VALUE ('ASO_DEFAULT_EXP_GL_PERIOD' );
685: l_qte_duration_prof NUMBER := NVL(FND_PROFILE.VALUE ('ASO_QUOTE_DURATION'),30);
686:
687: l_Quote_Exp_Date DATE;

Line 684: l_Default_Per_Prof VARCHAR2(15):= FND_PROFILE.VALUE ('ASO_DEFAULT_EXP_GL_PERIOD' );

680: AND Period_Set_Name = l_Def_Cal
681: AND SYSDATE BETWEEN NVL(Start_Date,sysdate) AND NVL(End_Date,sysdate);
682:
683: l_Default_Cal_Prof VARCHAR2(15):= FND_PROFILE.VALUE ('ASO_DEFAULT_EXP_GL_CAL' );
684: l_Default_Per_Prof VARCHAR2(15):= FND_PROFILE.VALUE ('ASO_DEFAULT_EXP_GL_PERIOD' );
685: l_qte_duration_prof NUMBER := NVL(FND_PROFILE.VALUE ('ASO_QUOTE_DURATION'),30);
686:
687: l_Quote_Exp_Date DATE;
688:

Line 685: l_qte_duration_prof NUMBER := NVL(FND_PROFILE.VALUE ('ASO_QUOTE_DURATION'),30);

681: AND SYSDATE BETWEEN NVL(Start_Date,sysdate) AND NVL(End_Date,sysdate);
682:
683: l_Default_Cal_Prof VARCHAR2(15):= FND_PROFILE.VALUE ('ASO_DEFAULT_EXP_GL_CAL' );
684: l_Default_Per_Prof VARCHAR2(15):= FND_PROFILE.VALUE ('ASO_DEFAULT_EXP_GL_PERIOD' );
685: l_qte_duration_prof NUMBER := NVL(FND_PROFILE.VALUE ('ASO_QUOTE_DURATION'),30);
686:
687: l_Quote_Exp_Date DATE;
688:
689: BEGIN

Line 1600: If NVL(FND_PROFILE.VALUE('ASO_AUTO_TEAM_ASSIGN'),'NONE') <> 'NONE' Then

1596: l_salesgroup_id NUMBER;
1597: l_org_id NUMBER;
1598: BEGIN
1599:
1600: If NVL(FND_PROFILE.VALUE('ASO_AUTO_TEAM_ASSIGN'),'NONE') <> 'NONE' Then
1601: aso_debug_pub.add('Function Get_SalesGroup_From_Salesrep -- Automatic Team Assign'||fnd_profile.value('ASO_AUTO_TEAM_ASSIGN'),1,'N');
1602: return null;
1603: End If;
1604:

Line 1601: aso_debug_pub.add('Function Get_SalesGroup_From_Salesrep -- Automatic Team Assign'||fnd_profile.value('ASO_AUTO_TEAM_ASSIGN'),1,'N');

1597: l_org_id NUMBER;
1598: BEGIN
1599:
1600: If NVL(FND_PROFILE.VALUE('ASO_AUTO_TEAM_ASSIGN'),'NONE') <> 'NONE' Then
1601: aso_debug_pub.add('Function Get_SalesGroup_From_Salesrep -- Automatic Team Assign'||fnd_profile.value('ASO_AUTO_TEAM_ASSIGN'),1,'N');
1602: return null;
1603: End If;
1604:
1605: IF p_database_object_name = 'ASO_AK_QUOTE_HEADER_V' THEN

Line 1671: If NVL(FND_PROFILE.VALUE('ASO_AUTO_TEAM_ASSIGN'),'NONE') <> 'NONE' Then

1667: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1668: aso_debug_pub.add('Function Get_SalesGroup_From_Profile -- Begin :',1,'N');
1669: END IF;
1670:
1671: If NVL(FND_PROFILE.VALUE('ASO_AUTO_TEAM_ASSIGN'),'NONE') <> 'NONE' Then
1672: aso_debug_pub.add('Function Get_SalesGroup_From_Profile -- Automatic Team Assign'||fnd_profile.value('ASO_AUTO_TEAM_ASSIGN'),1,'N');
1673: return null;
1674: End If;
1675:

Line 1672: aso_debug_pub.add('Function Get_SalesGroup_From_Profile -- Automatic Team Assign'||fnd_profile.value('ASO_AUTO_TEAM_ASSIGN'),1,'N');

1668: aso_debug_pub.add('Function Get_SalesGroup_From_Profile -- Begin :',1,'N');
1669: END IF;
1670:
1671: If NVL(FND_PROFILE.VALUE('ASO_AUTO_TEAM_ASSIGN'),'NONE') <> 'NONE' Then
1672: aso_debug_pub.add('Function Get_SalesGroup_From_Profile -- Automatic Team Assign'||fnd_profile.value('ASO_AUTO_TEAM_ASSIGN'),1,'N');
1673: return null;
1674: End If;
1675:
1676: IF p_database_object_name = 'ASO_AK_QUOTE_HEADER_V' THEN

Line 1748: If NVL(FND_PROFILE.VALUE('ASO_AUTO_TEAM_ASSIGN'),'NONE') <> 'NONE' Then

1744: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1745: aso_debug_pub.add('Function Get_SalesRep --- Begin :',1,'N');
1746: END IF;
1747:
1748: If NVL(FND_PROFILE.VALUE('ASO_AUTO_TEAM_ASSIGN'),'NONE') <> 'NONE' Then
1749: aso_debug_pub.add('Function Get_SalesRep -- Automatic Team Assign'||fnd_profile.value('ASO_AUTO_TEAM_ASSIGN'),1,'N');
1750: return null;
1751: End If;
1752:

Line 1749: aso_debug_pub.add('Function Get_SalesRep -- Automatic Team Assign'||fnd_profile.value('ASO_AUTO_TEAM_ASSIGN'),1,'N');

1745: aso_debug_pub.add('Function Get_SalesRep --- Begin :',1,'N');
1746: END IF;
1747:
1748: If NVL(FND_PROFILE.VALUE('ASO_AUTO_TEAM_ASSIGN'),'NONE') <> 'NONE' Then
1749: aso_debug_pub.add('Function Get_SalesRep -- Automatic Team Assign'||fnd_profile.value('ASO_AUTO_TEAM_ASSIGN'),1,'N');
1750: return null;
1751: End If;
1752:
1753: IF p_database_object_name = 'ASO_AK_QUOTE_HEADER_V' THEN

Line 1909: fnd_profile.Value('ICX_PREFERRED_CURRENCY') ,1,'N');

1905: IF p_database_object_name='ASO_AK_QUOTE_HEADER_V' OR
1906: p_database_object_name = 'ASO_AK_QUOTE_OPPTY_V' THEN
1907: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1908: aso_debug_pub.add('Function Get_Currency_From_Profile Profile ICX_PREFERRED_CURRENCY : '||
1909: fnd_profile.Value('ICX_PREFERRED_CURRENCY') ,1,'N');
1910: END IF;
1911:
1912: return FND_PROFILE.Value('ICX_PREFERRED_CURRENCY');
1913: END IF;

Line 1912: return FND_PROFILE.Value('ICX_PREFERRED_CURRENCY');

1908: aso_debug_pub.add('Function Get_Currency_From_Profile Profile ICX_PREFERRED_CURRENCY : '||
1909: fnd_profile.Value('ICX_PREFERRED_CURRENCY') ,1,'N');
1910: END IF;
1911:
1912: return FND_PROFILE.Value('ICX_PREFERRED_CURRENCY');
1913: END IF;
1914: EXCEPTION
1915: WHEN NO_DATA_FOUND THEN
1916: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN