DBA Data[Home] [Help]

APPS.ASO_SUBMIT_QUOTE_PVT dependencies on FND_PROFILE

Line 158: l_sales_team_prof VARCHAR2(30) := FND_PROFILE.value('ASO_AUTO_TEAM_ASSIGN');

154: -- lx_return_status VARCHAR2(1); -- 1966456
155: /** Bug# 4045135. Removing this check since deferred scheduling may book orders at a later stage.
156: l_book_flag VARCHAR2(1);
157: **/
158: l_sales_team_prof VARCHAR2(30) := FND_PROFILE.value('ASO_AUTO_TEAM_ASSIGN');
159: l_sales_cred_prof VARCHAR2(50) := FND_PROFILE.value('ASO_AUTO_SALES_CREDIT');
160:
161: l_Sales_Alloc_Control_Rec ASO_QUOTE_PUB.SALES_ALLOC_CONTROL_REC_TYPE
162: := ASO_QUOTE_PUB.G_MISS_SALES_ALLOC_CONTROL_REC;

Line 159: l_sales_cred_prof VARCHAR2(50) := FND_PROFILE.value('ASO_AUTO_SALES_CREDIT');

155: /** Bug# 4045135. Removing this check since deferred scheduling may book orders at a later stage.
156: l_book_flag VARCHAR2(1);
157: **/
158: l_sales_team_prof VARCHAR2(30) := FND_PROFILE.value('ASO_AUTO_TEAM_ASSIGN');
159: l_sales_cred_prof VARCHAR2(50) := FND_PROFILE.value('ASO_AUTO_SALES_CREDIT');
160:
161: l_Sales_Alloc_Control_Rec ASO_QUOTE_PUB.SALES_ALLOC_CONTROL_REC_TYPE
162: := ASO_QUOTE_PUB.G_MISS_SALES_ALLOC_CONTROL_REC;
163:

Line 176: l_om_defaulting_prof VARCHAR2(2) := FND_PROFILE.Value('ASO_OM_DEFAULTING');

172: WHERE header_id = lx_order_header_rec.order_header_id;
173: **/
174: -- Change END
175:
176: l_om_defaulting_prof VARCHAR2(2) := FND_PROFILE.Value('ASO_OM_DEFAULTING');
177:
178: lx_status VARCHAR2(1); -- 2692785
179:
180: l_index_rlt NUMBER; -- pbh/prg

Line 522: l_order_status_prof:=fnd_profile.value('ASO_DEFAULT_ORDER_STATE');

518:
519: /* End : Code Change done for Bug 13391823 */
520:
521: /* ER 3177722 */
522: l_order_status_prof:=fnd_profile.value('ASO_DEFAULT_ORDER_STATE');
523: IF aso_debug_pub.g_debug_flag = 'Y' THEN
524: aso_debug_pub.add('Submit_Quote - l_order_status_prof: '||l_order_status_prof, 1, 'N');
525: END IF;
526: if l_order_status_prof='ENTERED' then

Line 543: if NVL(FND_PROFILE.VALUE('ASO_STATUS_OVERRIDE'),'N') = 'Y' THEN

539: from aso_quote_statuses_vl
540: where QUOTE_STATUS_ID = l_qte_header_rec.quote_status_id;
541:
542: if l_Update_Allowed_Flg='F' then
543: if NVL(FND_PROFILE.VALUE('ASO_STATUS_OVERRIDE'),'N') = 'Y' THEN
544: l_Update_Allowed_Flg := 'T';
545: end if;
546: end if;-- l_update_allowed_flag
547:

Line 807: IF NVL(FND_PROFILE.Value('ASO_CC_AUTHORIZATION_ENABLED'), 'N') = 'Y' THEN

803: IF aso_debug_pub.g_debug_flag = 'Y' THEN
804: aso_debug_pub.add('Submit_Quote - payment_type is CC ', 1, 'N');
805: END IF;
806:
807: IF NVL(FND_PROFILE.Value('ASO_CC_AUTHORIZATION_ENABLED'), 'N') = 'Y' THEN
808: IF aso_debug_pub.g_debug_flag = 'Y' THEN
809: aso_debug_pub.add('Submit_Q: CC_Authorization_enabled ', 1, 'N');
810: END IF;
811:

Line 861: IF NVL(FND_PROFILE.Value('ASO_API_ENABLE_SECURITY'),'N') = 'Y' THEN

857:
858: IF l_istore_source <> 'Y' OR (l_istore_source = 'Y' AND
859: (l_qte_header_rec.resource_id IS NOT NULL AND l_qte_header_rec.resource_id <> FND_API.G_MISS_NUM)) THEN
860:
861: IF NVL(FND_PROFILE.Value('ASO_API_ENABLE_SECURITY'),'N') = 'Y' THEN
862:
863: IF (l_sales_team_prof = 'FULL') THEN
864:
865: ASO_SALES_TEAM_PVT.Assign_Sales_Team