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 1682: l_salesgroup_id := aso_utility_pvt.get_ou_attribute_value(aso_utility_pvt.G_DEFAULT_SALES_GROUP,l_org_id);

1678: ELSIF p_database_object_name = 'ASO_AK_QUOTE_OPPTY_V' THEN
1679: l_org_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.O_Org_id;
1680: END IF;
1681:
1682: l_salesgroup_id := aso_utility_pvt.get_ou_attribute_value(aso_utility_pvt.G_DEFAULT_SALES_GROUP,l_org_id);
1683:
1684: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1685: aso_debug_pub.add('Function Get_SalesGroup_From_Profile Sales Group Id :' ||l_salesgroup_id,1,'N');
1686: END IF;

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

1735: AND nvl(trunc(end_date_active), trunc(sysdate)) >= trunc(sysdate);
1736:
1737: l_creator_res NUMBER;
1738: l_valid VARCHAR2(1) := 'N';
1739: l_default_salesrep VARCHAR2(40) := aso_utility_pvt.get_default_salesrep;
1740: l_profile_salesrep_id NUMBER;
1741: l_org_id NUMBER;
1742:
1743: BEGIN

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

1790: l_creator_res := NULL ;
1791: END IF;
1792:
1793: -- Passing Org id in the call - Girish 10/18/2005
1794: l_profile_salesrep_id := aso_utility_pvt.get_ou_attribute_value(l_default_salesrep, l_org_id);
1795:
1796: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1797: aso_debug_pub.add('Function Get_SalesRep l_profile_salesrep_id: '||l_profile_salesrep_id,1,'N');
1798: END IF;