DBA Data[Home] [Help]

APPS.QOT_DEFAULT_PVT dependencies on FND_PROFILE

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

686: WHERE Period_Type = l_Def_Per
687: AND Period_Set_Name = l_Def_Cal
688: AND SYSDATE BETWEEN NVL(Start_Date,sysdate) AND NVL(End_Date,sysdate);
689:
690: l_Default_Cal_Prof VARCHAR2(15):= FND_PROFILE.VALUE ('ASO_DEFAULT_EXP_GL_CAL' );
691: l_Default_Per_Prof VARCHAR2(15):= FND_PROFILE.VALUE ('ASO_DEFAULT_EXP_GL_PERIOD' );
692: l_qte_duration_prof NUMBER := NVL(FND_PROFILE.VALUE ('ASO_QUOTE_DURATION'),30);
693:
694: l_Quote_Exp_Date DATE;

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

687: AND Period_Set_Name = l_Def_Cal
688: AND SYSDATE BETWEEN NVL(Start_Date,sysdate) AND NVL(End_Date,sysdate);
689:
690: l_Default_Cal_Prof VARCHAR2(15):= FND_PROFILE.VALUE ('ASO_DEFAULT_EXP_GL_CAL' );
691: l_Default_Per_Prof VARCHAR2(15):= FND_PROFILE.VALUE ('ASO_DEFAULT_EXP_GL_PERIOD' );
692: l_qte_duration_prof NUMBER := NVL(FND_PROFILE.VALUE ('ASO_QUOTE_DURATION'),30);
693:
694: l_Quote_Exp_Date DATE;
695:

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

688: AND SYSDATE BETWEEN NVL(Start_Date,sysdate) AND NVL(End_Date,sysdate);
689:
690: l_Default_Cal_Prof VARCHAR2(15):= FND_PROFILE.VALUE ('ASO_DEFAULT_EXP_GL_CAL' );
691: l_Default_Per_Prof VARCHAR2(15):= FND_PROFILE.VALUE ('ASO_DEFAULT_EXP_GL_PERIOD' );
692: l_qte_duration_prof NUMBER := NVL(FND_PROFILE.VALUE ('ASO_QUOTE_DURATION'),30);
693:
694: l_Quote_Exp_Date DATE;
695:
696: BEGIN

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

1610: l_salesgroup_id NUMBER;
1611: l_org_id NUMBER;
1612: BEGIN
1613:
1614: If NVL(FND_PROFILE.VALUE('ASO_AUTO_TEAM_ASSIGN'),'NONE') <> 'NONE' Then
1615: aso_debug_pub.add('Function Get_SalesGroup_From_Salesrep -- Automatic Team Assign'||fnd_profile.value('ASO_AUTO_TEAM_ASSIGN'),1,'N');
1616: return null;
1617: End If;
1618:

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

1611: l_org_id NUMBER;
1612: BEGIN
1613:
1614: If NVL(FND_PROFILE.VALUE('ASO_AUTO_TEAM_ASSIGN'),'NONE') <> 'NONE' Then
1615: aso_debug_pub.add('Function Get_SalesGroup_From_Salesrep -- Automatic Team Assign'||fnd_profile.value('ASO_AUTO_TEAM_ASSIGN'),1,'N');
1616: return null;
1617: End If;
1618:
1619: IF p_database_object_name = 'ASO_AK_QUOTE_HEADER_V' THEN

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

1681: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1682: aso_debug_pub.add('Function Get_SalesGroup_From_Profile -- Begin :',1,'N');
1683: END IF;
1684:
1685: If NVL(FND_PROFILE.VALUE('ASO_AUTO_TEAM_ASSIGN'),'NONE') <> 'NONE' Then
1686: aso_debug_pub.add('Function Get_SalesGroup_From_Profile -- Automatic Team Assign'||fnd_profile.value('ASO_AUTO_TEAM_ASSIGN'),1,'N');
1687: return null;
1688: End If;
1689:

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

1682: aso_debug_pub.add('Function Get_SalesGroup_From_Profile -- Begin :',1,'N');
1683: END IF;
1684:
1685: If NVL(FND_PROFILE.VALUE('ASO_AUTO_TEAM_ASSIGN'),'NONE') <> 'NONE' Then
1686: aso_debug_pub.add('Function Get_SalesGroup_From_Profile -- Automatic Team Assign'||fnd_profile.value('ASO_AUTO_TEAM_ASSIGN'),1,'N');
1687: return null;
1688: End If;
1689:
1690: IF p_database_object_name = 'ASO_AK_QUOTE_HEADER_V' THEN

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

1758: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1759: aso_debug_pub.add('Function Get_SalesRep --- Begin :',1,'N');
1760: END IF;
1761:
1762: If NVL(FND_PROFILE.VALUE('ASO_AUTO_TEAM_ASSIGN'),'NONE') <> 'NONE' Then
1763: aso_debug_pub.add('Function Get_SalesRep -- Automatic Team Assign'||fnd_profile.value('ASO_AUTO_TEAM_ASSIGN'),1,'N');
1764: return null;
1765: End If;
1766:

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

1759: aso_debug_pub.add('Function Get_SalesRep --- Begin :',1,'N');
1760: END IF;
1761:
1762: If NVL(FND_PROFILE.VALUE('ASO_AUTO_TEAM_ASSIGN'),'NONE') <> 'NONE' Then
1763: aso_debug_pub.add('Function Get_SalesRep -- Automatic Team Assign'||fnd_profile.value('ASO_AUTO_TEAM_ASSIGN'),1,'N');
1764: return null;
1765: End If;
1766:
1767: IF p_database_object_name = 'ASO_AK_QUOTE_HEADER_V' THEN

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

1919: IF p_database_object_name='ASO_AK_QUOTE_HEADER_V' OR
1920: p_database_object_name = 'ASO_AK_QUOTE_OPPTY_V' THEN
1921: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1922: aso_debug_pub.add('Function Get_Currency_From_Profile Profile ICX_PREFERRED_CURRENCY : '||
1923: fnd_profile.Value('ICX_PREFERRED_CURRENCY') ,1,'N');
1924: END IF;
1925:
1926: return FND_PROFILE.Value('ICX_PREFERRED_CURRENCY');
1927: END IF;

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

1922: aso_debug_pub.add('Function Get_Currency_From_Profile Profile ICX_PREFERRED_CURRENCY : '||
1923: fnd_profile.Value('ICX_PREFERRED_CURRENCY') ,1,'N');
1924: END IF;
1925:
1926: return FND_PROFILE.Value('ICX_PREFERRED_CURRENCY');
1927: END IF;
1928: EXCEPTION
1929: WHEN NO_DATA_FOUND THEN
1930: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN