APPS.PO_RCO_VALIDATION_PVT dependencies on POR_NONCAT_TEMPLATES_ALL_B

Line 3218: l_price_editable_flag por_noncat_templates_all_b.price_editable_flag%TYPE;

3214: l_global_agreement_flag po_headers_all.global_agreement_flag%TYPE;
3215: l_order_type_lookup_code po_requisition_lines_all.order_type_lookup_code%TYPE ;
3216: l_po_header_id po_headers_all.po_header_id%TYPE;
3217: l_template_id po_requisition_lines_all.noncat_template_id%TYPE;
3218: l_price_editable_flag por_noncat_templates_all_b.price_editable_flag%TYPE;
3219: l_amount_editable_flag por_noncat_templates_all_b.amount_editable_flag%TYPE;
3220: -- added for retroactive pricing checks
3221: l_retropricing VARCHAR2(20) := '';
3222: l_amount_based_service_line BOOLEAN := FALSE;

Line 3219: l_amount_editable_flag por_noncat_templates_all_b.amount_editable_flag%TYPE;

3215: l_order_type_lookup_code po_requisition_lines_all.order_type_lookup_code%TYPE ;
3216: l_po_header_id po_headers_all.po_header_id%TYPE;
3217: l_template_id po_requisition_lines_all.noncat_template_id%TYPE;
3218: l_price_editable_flag por_noncat_templates_all_b.price_editable_flag%TYPE;
3219: l_amount_editable_flag por_noncat_templates_all_b.amount_editable_flag%TYPE;
3220: -- added for retroactive pricing checks
3221: l_retropricing VARCHAR2(20) := '';
3222: l_amount_based_service_line BOOLEAN := FALSE;
3223: l_destination_type_code po_requisition_lines_all.destination_type_code%TYPE;

Line 3277: FROM por_noncat_templates_all_b

3273: -- update depends on template definition
3274: IF (l_template_id IS NOT NULL) THEN
3275: SELECT price_editable_flag, amount_editable_flag
3276: INTO l_price_editable_flag, l_amount_editable_flag
3277: FROM por_noncat_templates_all_b
3278: WHERE template_id = l_template_id;
3279:
3280: IF (l_price_editable_flag = 'N') THEN
3281: p_price_changeable_flag := 'N';