DBA Data[Home] [Help]

APPS.ASO_COPY_QUOTE_PVT dependencies on FND_PROFILE

Line 115: l_copy_config_profile varchar2(1):=nvl(fnd_profile.value('ASO_COPY_CONFIG_EFF_DATE'),'Y');

111: l_copy_line_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
112:
113: -- ER 3177722
114: lx_config_tbl ASO_QUOTE_PUB.Config_Vaild_Tbl_Type;
115: l_copy_config_profile varchar2(1):=nvl(fnd_profile.value('ASO_COPY_CONFIG_EFF_DATE'),'Y');
116:
117: -- vtariker Price/Tax enh
118: CURSOR C_Get_Last_Upd_Date (
119: qte_hdr_id NUMBER

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

209: WHERE AGREEMENT_ID = P_AGREEMENT_ID
210: AND INVOICE_TO_CUSTOMER_ID = P_INVOICE_TO_CUSTOMER_ID;
211:
212: l_var varchar2(1);
213: l_sales_team_prof VARCHAR2(30) := FND_PROFILE.value('ASO_AUTO_TEAM_ASSIGN');
214: /* Code change for Quoting Usability Sun ER End */
215:
216: BEGIN
217: -- Standard Start of API savepoint

Line 461: IF ( NVL ( FND_PROFILE.VALUE ('ASO_AUTO_NUMBERING' ), 'Y' ) = 'Y' ) THEN

457: IF ( P_Copy_Quote_Control_Rec.New_Version = FND_API.G_FALSE ) THEN
458: IF ( P_Copy_Quote_Header_Rec.Quote_Number IS NULL
459: OR P_Copy_Quote_Header_Rec.Quote_Number = FND_API.G_MISS_NUM
460: ) THEN
461: IF ( NVL ( FND_PROFILE.VALUE ('ASO_AUTO_NUMBERING' ), 'Y' ) = 'Y' ) THEN
462: IF aso_debug_pub.g_debug_flag = 'Y' THEN
463: aso_debug_pub.ADD ( 'Copy_Quote - AUTO_NUMBERING is Y ' , 1 , 'N' );
464: END IF;
465:

Line 599: OPEN c_qte_status_id ( fnd_profile.VALUE ('ASO_DEFAULT_STATUS_CODE' ) );

595: WHERE Quote_Header_Id = l_qte_header_id;
596:
597: END IF; -- p_new_version
598:
599: OPEN c_qte_status_id ( fnd_profile.VALUE ('ASO_DEFAULT_STATUS_CODE' ) );
600: FETCH c_qte_status_id INTO l_qte_header_rec.quote_status_id;
601:
602: IF c_qte_status_id%NOTFOUND THEN
603: x_return_status := FND_API.G_RET_STS_ERROR;

Line 968: IF NVL(FND_PROFILE.Value('OKC_ENABLE_SALES_CONTRACTS'),'N') = 'Y'

964: END IF; -- Header_pricing_event/Tax_flag = TRUE
965:
966: -- hyang new okc
967:
968: IF NVL(FND_PROFILE.Value('OKC_ENABLE_SALES_CONTRACTS'),'N') = 'Y'
969: THEN
970:
971: IF aso_debug_pub.g_debug_flag = 'Y' THEN
972: aso_debug_pub.add(

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

1273: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
1274:
1275: l_old_qte_num NUMBER;
1276: l_sequence NUMBER := null;
1277: l_sales_team_prof VARCHAR2(30) := FND_PROFILE.value('ASO_AUTO_TEAM_ASSIGN');
1278:
1279: --BC4J Fix
1280: l_dup_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1281:

Line 2001: aso_debug_pub.ADD ( 'Copy_Header_Rows: value of ASO_API_ENABLE_SECURITY: ' || FND_PROFILE.VALUE ('ASO_API_ENABLE_SECURITY' ) , 1 , 'Y' );

1997: IF P_Copy_Quote_Control_Rec.New_Version = FND_API.G_FALSE THEN
1998: -- security changes
1999:
2000: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2001: aso_debug_pub.ADD ( 'Copy_Header_Rows: value of ASO_API_ENABLE_SECURITY: ' || FND_PROFILE.VALUE ('ASO_API_ENABLE_SECURITY' ) , 1 , 'Y' );
2002: END IF;
2003:
2004: l_qte_header_rec.batch_price_flag := FND_API.G_FALSE;
2005:

Line 2006: IF NVL ( FND_PROFILE.VALUE ('ASO_API_ENABLE_SECURITY' ), 'N' ) = 'Y' THEN

2002: END IF;
2003:
2004: l_qte_header_rec.batch_price_flag := FND_API.G_FALSE;
2005:
2006: IF NVL ( FND_PROFILE.VALUE ('ASO_API_ENABLE_SECURITY' ), 'N' ) = 'Y' THEN
2007:
2008: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2009: aso_debug_pub.ADD ( 'Copy_Header_Rows: Sales_Team: l_sales_team_prof: ' || l_sales_team_prof , 1 , 'N' );
2010: END IF;

Line 2894: l_appl_param_rec.calling_application_id := nvl(FND_PROFILE.value('JTF_PROFILE_DEFAULT_APPLICATION'),697);

2890:
2891:
2892: /*
2893: -- Validating if the item is a container item
2894: l_appl_param_rec.calling_application_id := nvl(FND_PROFILE.value('JTF_PROFILE_DEFAULT_APPLICATION'),697);
2895:
2896: cz_network_api_pub.is_container(p_api_version => 1.0
2897: ,p_inventory_item_id => l_qte_line_rec.inventory_item_id
2898: ,p_organization_id => l_qte_line_rec.organization_id

Line 5178: := FND_PROFILE.VALUE ('ASO_DEFAULT_EXP_GL_CAL' );

5174: AND Period_Set_Name = l_Def_Cal
5175: AND SYSDATE BETWEEN Start_Date AND End_Date;
5176:
5177: l_Default_Cal_Prof VARCHAR2 ( 15 )
5178: := FND_PROFILE.VALUE ('ASO_DEFAULT_EXP_GL_CAL' );
5179: l_Default_Per_Prof VARCHAR2 ( 15 )
5180: := FND_PROFILE.VALUE ('ASO_DEFAULT_EXP_GL_PERIOD' );
5181: l_qte_duration_prof NUMBER
5182: := FND_PROFILE.VALUE ('ASO_QUOTE_DURATION' );

Line 5180: := FND_PROFILE.VALUE ('ASO_DEFAULT_EXP_GL_PERIOD' );

5176:
5177: l_Default_Cal_Prof VARCHAR2 ( 15 )
5178: := FND_PROFILE.VALUE ('ASO_DEFAULT_EXP_GL_CAL' );
5179: l_Default_Per_Prof VARCHAR2 ( 15 )
5180: := FND_PROFILE.VALUE ('ASO_DEFAULT_EXP_GL_PERIOD' );
5181: l_qte_duration_prof NUMBER
5182: := FND_PROFILE.VALUE ('ASO_QUOTE_DURATION' );
5183:
5184: BEGIN

Line 5182: := FND_PROFILE.VALUE ('ASO_QUOTE_DURATION' );

5178: := FND_PROFILE.VALUE ('ASO_DEFAULT_EXP_GL_CAL' );
5179: l_Default_Per_Prof VARCHAR2 ( 15 )
5180: := FND_PROFILE.VALUE ('ASO_DEFAULT_EXP_GL_PERIOD' );
5181: l_qte_duration_prof NUMBER
5182: := FND_PROFILE.VALUE ('ASO_QUOTE_DURATION' );
5183:
5184: BEGIN
5185:
5186: X_Return_Status := FND_API.G_RET_STS_SUCCESS;

Line 5204: X_Quote_Exp_Date := sysdate + NVL(FND_PROFILE.value('ASO_QUOTE_DURATION'), 30);

5200: X_Quote_Exp_Date := SYSDATE + l_qte_duration_prof;
5201: ELSE
5202: /* If profile ASO_QUOTE_DURATION is null, then exp date is sysdate + 30
5203: see bug 3704719 for more detaisl */
5204: X_Quote_Exp_Date := sysdate + NVL(FND_PROFILE.value('ASO_QUOTE_DURATION'), 30);
5205: END IF;
5206:
5207: END IF;
5208:

Line 5218: X_Quote_Exp_Date := sysdate + NVL(FND_PROFILE.value('ASO_QUOTE_DURATION'), 30);

5214: X_Quote_Exp_Date := SYSDATE + l_qte_duration_prof;
5215: ELSE
5216: /* If profile ASO_QUOTE_DURATION is null, then exp date is sysdate + 30
5217: see bug 3704719 for more detaisl */
5218: X_Quote_Exp_Date := sysdate + NVL(FND_PROFILE.value('ASO_QUOTE_DURATION'), 30);
5219: END IF;
5220:
5221: END IF;
5222:

Line 6988: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');

6984: SELECT ASO_PAYMENTS_S.nextval FROM sys.dual;
6985:
6986: begin
6987: SAVEPOINT COPY_PAYMENT_ROW_PVT;
6988: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
6989:
6990: IF aso_debug_pub.g_debug_flag = 'Y' THEN
6991: aso_debug_pub.add('Begin copy_payment_row ', 1, 'Y');
6992: aso_debug_pub.add('l_payment_rec.Quote_Header_Id: ' || l_payment_rec.Quote_Header_Id, 1, 'Y');