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;
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:
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
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:
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
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:
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
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:
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
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;
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