APPS.ASO_COPY_TMPL_PUB dependencies on FND_PROFILE

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

64: l_quote_category_code varchar2(240);
65:
66: -- ER 3177722
67: lx_config_tbl ASO_QUOTE_PUB.Config_Vaild_Tbl_Type;
68: l_copy_config_profile varchar2(1):=nvl(fnd_profile.value('ASO_COPY_CONFIG_EFF_DATE'),'Y');
69:
70:
71: begin
72:

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

141: l_qte_header_rec.order_type_id:=l_order_type_id;
142: l_qte_header_rec.quote_category_code:=l_quote_category_code;
143:
144:
145: OPEN c_qte_status_id ( fnd_profile.VALUE ('ASO_DEFAULT_STATUS_CODE' ) );
146: FETCH c_qte_status_id INTO l_qte_header_rec.quote_status_id;
147:
148: IF c_qte_status_id%NOTFOUND THEN
149: x_return_status := FND_API.G_RET_STS_ERROR;