DBA Data[Home] [Help]

APPS.QOT_DEFAULT_PVT dependencies on ASO_UTILITY_PVT

Line 86: l_order_type_id := aso_utility_pvt.get_ou_attribute_value(aso_utility_pvt.GET_DEFAULT_ORDER_TYPE,l_org_id);

82: ELSIF p_database_object_name = 'ASO_AK_QUOTE_OPPTY_V' THEN
83: l_org_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.O_Org_id;
84: END IF;
85:
86: l_order_type_id := aso_utility_pvt.get_ou_attribute_value(aso_utility_pvt.GET_DEFAULT_ORDER_TYPE,l_org_id);
87:
88: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
89: aso_debug_pub.add('Function Get_OrderType Default Organization Id :' ||l_order_type_id,1,'N');
90: END IF;

Line 139: l_contract_template_id := aso_utility_pvt.get_ou_attribute_value(aso_utility_pvt.GET_DEFAULT_CONTRACT_TEMPLATE,l_org_id);

135: ELSIF p_database_object_name = 'ASO_AK_QUOTE_OPPTY_V' THEN
136: l_org_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.O_Org_id;
137: END IF;
138:
139: l_contract_template_id := aso_utility_pvt.get_ou_attribute_value(aso_utility_pvt.GET_DEFAULT_CONTRACT_TEMPLATE,l_org_id);
140:
141: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
142: aso_debug_pub.add('Function Get_ContractTemplate Contract_Template_Id :' ||l_contract_template_id,1,'N');
143: END IF;

Line 1696: l_salesgroup_id := aso_utility_pvt.get_ou_attribute_value(aso_utility_pvt.G_DEFAULT_SALES_GROUP,l_org_id);

1692: ELSIF p_database_object_name = 'ASO_AK_QUOTE_OPPTY_V' THEN
1693: l_org_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.O_Org_id;
1694: END IF;
1695:
1696: l_salesgroup_id := aso_utility_pvt.get_ou_attribute_value(aso_utility_pvt.G_DEFAULT_SALES_GROUP,l_org_id);
1697:
1698: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1699: aso_debug_pub.add('Function Get_SalesGroup_From_Profile Sales Group Id :' ||l_salesgroup_id,1,'N');
1700: END IF;

Line 1753: l_default_salesrep VARCHAR2(40) := aso_utility_pvt.get_default_salesrep;

1749: AND nvl(trunc(end_date_active), trunc(sysdate)) >= trunc(sysdate);
1750:
1751: l_creator_res NUMBER;
1752: l_valid VARCHAR2(1) := 'N';
1753: l_default_salesrep VARCHAR2(40) := aso_utility_pvt.get_default_salesrep;
1754: l_profile_salesrep_id NUMBER;
1755: l_org_id NUMBER;
1756:
1757: BEGIN

Line 1808: l_profile_salesrep_id := aso_utility_pvt.get_ou_attribute_value(l_default_salesrep, l_org_id);

1804: l_creator_res := NULL ;
1805: END IF;
1806:
1807: -- Passing Org id in the call - Girish 10/18/2005
1808: l_profile_salesrep_id := aso_utility_pvt.get_ou_attribute_value(l_default_salesrep, l_org_id);
1809:
1810: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1811: aso_debug_pub.add('Function Get_SalesRep l_profile_salesrep_id: '||l_profile_salesrep_id,1,'N');
1812: END IF;