APPS.PO_RCO_VALIDATION_PVT dependencies on POR_NONCAT_TEMPLATES_ALL_B

Line 3282: l_price_editable_flag por_noncat_templates_all_b.price_editable_flag%TYPE;

3278: l_global_agreement_flag po_headers_all.global_agreement_flag%TYPE;
3279: l_order_type_lookup_code po_requisition_lines_all.order_type_lookup_code%TYPE ;
3280: l_po_header_id po_headers_all.po_header_id%TYPE;
3281: l_template_id po_requisition_lines_all.noncat_template_id%TYPE;
3282: l_price_editable_flag por_noncat_templates_all_b.price_editable_flag%TYPE;
3283: l_amount_editable_flag por_noncat_templates_all_b.amount_editable_flag%TYPE;
3284: -- added for retroactive pricing checks
3285: l_retropricing VARCHAR2(20) := '';
3286: l_amount_based_service_line BOOLEAN := FALSE;

Line 3283: l_amount_editable_flag por_noncat_templates_all_b.amount_editable_flag%TYPE;

3279: l_order_type_lookup_code po_requisition_lines_all.order_type_lookup_code%TYPE ;
3280: l_po_header_id po_headers_all.po_header_id%TYPE;
3281: l_template_id po_requisition_lines_all.noncat_template_id%TYPE;
3282: l_price_editable_flag por_noncat_templates_all_b.price_editable_flag%TYPE;
3283: l_amount_editable_flag por_noncat_templates_all_b.amount_editable_flag%TYPE;
3284: -- added for retroactive pricing checks
3285: l_retropricing VARCHAR2(20) := '';
3286: l_amount_based_service_line BOOLEAN := FALSE;
3287: l_destination_type_code po_requisition_lines_all.destination_type_code%TYPE;

Line 3343: FROM por_noncat_templates_all_b

3339: IF (l_template_id IS NOT NULL) THEN
3340: BEGIN
3341: SELECT price_editable_flag, amount_editable_flag
3342: INTO l_price_editable_flag, l_amount_editable_flag
3343: FROM por_noncat_templates_all_b
3344: WHERE template_id = l_template_id;
3345:
3346: exception when NO_DATA_FOUND then
3347: l_price_editable_flag:='Y';