690: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
691: IS
692: CURSOR C_item_type_code IS
693: SELECT lookup_code
694: FROM aso_lookups lk
695: WHERE lookup_type = 'ASO_ITEM_TYPE'
696: AND lookup_code = p_item_type_code;
697:
698: /* select item_type_code from aso_i_item_types_v
921: from aso_i_service_types_v
922: where service_reference_type_code = p_service_ref_type_code;*/
923: CURSOR C_servicetypes IS
924: select lookup_code
925: from aso_lookups
926: where lookup_code = p_service_ref_type_code and
927: lookup_type = 'ASO_SERVICE_TYPE';
928:
929: l_service_code VARCHAR2(30);
1302: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
1303: IS
1304: CURSOR C_party_type IS
1305: select 'VALID'
1306: from aso_lookups
1307: where lookup_type = 'ASO_PARTY_TYPE'
1308: and lookup_code = p_party_type;
1309:
1310: l_valid VARCHAR2(240);
1490: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
1491: IS
1492: CURSOR C_party_object_type IS
1493: select 'VALID'
1494: from aso_lookups
1495: where lookup_type = 'ASO_PARTY_OBJECT_TYPE'
1496: and lookup_code = p_party_object_type;
1497:
1498: l_valid VARCHAR2(240);
3560: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
3561: )
3562: IS
3563: CURSOR C1 IS select 'x'
3564: from aso_lookups
3565: where lookup_type = 'ASO_QUOTE_OBJECT_TYPE'
3566: and lookup_code = p_QUOTE_OBJECT_TYPE_CODE;
3567: l_exist VARCHAR2(1);
3568: BEGIN
3605: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
3606: )
3607: IS
3608: CURSOR C1 IS select 'x'
3609: from aso_lookups
3610: where lookup_type = 'ASO_RELATED_OBJECT_TYPE'
3611: and lookup_code = p_OBJECT_TYPE_CODE;
3612:
3613: l_exist VARCHAR2(1);
3652: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
3653: )
3654: IS
3655: CURSOR C1 IS SELECT 'x'
3656: from aso_lookups
3657: where lookup_type = 'ASO_OBJECT_RELATIONSHIP_TYPE'
3658: and lookup_code = p_RELATIONSHIP_TYPE_CODE;
3659:
3660: l_exist VARCHAR2(1);
5703: CURSOR C_PAYMENT_TYPE(p_lookup_code varchar2) is --Payment Type
5704: SELECT 1 FROM DUAL WHERE exists
5705: (
5706: SELECT Lookup_Code Payment_Type_Code
5707: from ASO_LOOKUPS
5708: WHERE LOOKUP_TYPE = 'ASO_PAYMENT_TYPE'
5709: and lookup_code <> 'PO'
5710: and trunc(nvl(start_date_active,sysdate)) <= trunc(sysdate)
5711: and trunc(nvl(end_daTe_active,sysdate)) >= trunc (sysdate)
5770: CURSOR C_AUTOMATIC_PRICING(p_lookup_code varchar2) IS --Auotmatic Pricing
5771: SELECT 1 FROM DUAL WHERE exists
5772: (
5773: select lookup_code
5774: from aso_lookups
5775: where lookup_type='ASO_PRICE_TAX_COMPUTE_OPTION'
5776: and lookup_code = p_lookup_code
5777: and ENABLED_FLAG = 'Y'
5778: and trunc(sysdate) between trunc(start_date_active)
5784: CURSOR C_AUTOMATIC_TAX(p_lookup_code varchar2) IS --Auotmatic Tax
5785: SELECT 1 FROM DUAL WHERE exists
5786: (
5787: select lookup_code
5788: from aso_lookups
5789: where lookup_type='ASO_PRICE_TAX_COMPUTE_OPTION'
5790: and lookup_code = p_lookup_code
5791: and ENABLED_FLAG = 'Y'
5792: and trunc(sysdate) between trunc(start_date_active)