2640: WHERE p_clm_standard_form_tbl(i) IN ( SELECT DISTINCT standard_form
2641: FROM PO_PRINT_FORM_FORMATS
2642: WHERE style_id = p_style_id_tbl(i)
2643: AND document_type = Decode (PO_PDOI_PARAMS.g_request.document_type,
2644: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD,'PO_AWARD_STD_FORM')
2645: AND inactive_date IS NULL
2646: );
2647: EXCEPTION
2648: WHEN No_Data_Found THEN
2720: FROM PO_PRINT_FORM_FORMATS
2721: WHERE style_id = p_style_id_tbl(i)
2722: AND standard_form = p_clm_standard_form_tbl(i)
2723: AND document_type = Decode (PO_PDOI_PARAMS.g_request.document_type,
2724: PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD,'PO_AWARD_STD_FORM')
2725: AND inactive_date IS NULL
2726: );
2727: EXCEPTION
2728: WHEN No_Data_Found THEN
3098: FOR i IN 1..p_intf_header_id.Count
3099: LOOP
3100: IF p_clm_award_type_tbl(i) IS NOT NULL
3101: THEN
3102: IF p_type_lookup_code_tbl(i) = PO_PDOI_CONSTANTS.g_DOC_TYPE_STANDARD
3103: THEN
3104: BEGIN
3105: SELECT 'Y' INTO is_valid_awd_type
3106: FROM dual
3119: , p_message_name => 'PO_AWARD_TYPE_INVALID'
3120: );
3121: l_results_count := l_results_count + 1;
3122: END;
3123: ELSIF p_type_lookup_code_tbl(i) IN (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,
3124: PO_PDOI_CONSTANTS.g_DOC_TYPE_CONTRACT)
3125: THEN
3126: BEGIN
3127: SELECT 'Y' INTO is_valid_awd_type
3120: );
3121: l_results_count := l_results_count + 1;
3122: END;
3123: ELSIF p_type_lookup_code_tbl(i) IN (PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,
3124: PO_PDOI_CONSTANTS.g_DOC_TYPE_CONTRACT)
3125: THEN
3126: BEGIN
3127: SELECT 'Y' INTO is_valid_awd_type
3128: FROM dual
3127: SELECT 'Y' INTO is_valid_awd_type
3128: FROM dual
3129: WHERE EXISTS ( SELECT 1 FROM po_lookup_codes
3130: WHERE lookup_type = Decode(p_type_lookup_code_tbl(i),
3131: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,'PO_CLM_AWD_TYPE_BPA',
3132: PO_PDOI_CONSTANTS.g_DOC_TYPE_CONTRACT,'PO_CLM_AWD_TYPE_CPA')
3133: AND lookup_code = p_clm_award_type_tbl(i)
3134: );
3135: EXCEPTION WHEN No_Data_Found
3128: FROM dual
3129: WHERE EXISTS ( SELECT 1 FROM po_lookup_codes
3130: WHERE lookup_type = Decode(p_type_lookup_code_tbl(i),
3131: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET,'PO_CLM_AWD_TYPE_BPA',
3132: PO_PDOI_CONSTANTS.g_DOC_TYPE_CONTRACT,'PO_CLM_AWD_TYPE_CPA')
3133: AND lookup_code = p_clm_award_type_tbl(i)
3134: );
3135: EXCEPTION WHEN No_Data_Found
3136: THEN