APPS.PO_AUTO_LINE_PROCESS_PVT dependencies on PO_PRICE_DIFFERENTIALS

Line 1742: FROM po_price_differentials PD

1738: PD.price_differential_num ,
1739: PD.price_type ,
1740: DECODE ( PD.entity_type , 'REQ LINE' , PD.multiplier , 'PO LINE' , PD.multiplier , 'PRICE BREAK' , PD.min_multiplier , 'BLANKET LINE' , PD.min_multiplier ) multiplier ,
1741: PD.enabled_flag
1742: FROM po_price_differentials PD
1743: WHERE PD.entity_type = p_source_entity_type
1744: AND PD.entity_id = p_source_entity_id
1745: AND NVL(PD.enabled_flag,'N') = 'Y';
1746:

Line 1747: l_source_entity_type PO_PRICE_DIFFERENTIALS.entity_type%TYPE;

1743: WHERE PD.entity_type = p_source_entity_type
1744: AND PD.entity_id = p_source_entity_id
1745: AND NVL(PD.enabled_flag,'N') = 'Y';
1746:
1747: l_source_entity_type PO_PRICE_DIFFERENTIALS.entity_type%TYPE;
1748: l_source_entity_id PO_PRICE_DIFFERENTIALS.entity_id%TYPE;
1749:
1750: CURSOR c_price_break(p_line_num NUMBER,p_intf_line_id NUMBER)
1751: IS

Line 1748: l_source_entity_id PO_PRICE_DIFFERENTIALS.entity_id%TYPE;

1744: AND PD.entity_id = p_source_entity_id
1745: AND NVL(PD.enabled_flag,'N') = 'Y';
1746:
1747: l_source_entity_type PO_PRICE_DIFFERENTIALS.entity_type%TYPE;
1748: l_source_entity_id PO_PRICE_DIFFERENTIALS.entity_id%TYPE;
1749:
1750: CURSOR c_price_break(p_line_num NUMBER,p_intf_line_id NUMBER)
1751: IS
1752: SELECT interface_line_id,

Line 2600: ELSIF ( po_price_differentials_pvt.allows_price_differentials(p_lines.requisition_line_id_tbl(i)) ) THEN

2596:
2597: l_source_entity_type := 'REQ LINE';
2598: l_source_entity_id := p_lines.requisition_line_id_tbl(i);
2599:
2600: ELSIF ( po_price_differentials_pvt.allows_price_differentials(p_lines.requisition_line_id_tbl(i)) ) THEN
2601: l_progress := '350';
2602: IF ( l_price_break_id IS NOT NULL ) THEN
2603: l_source_entity_type := 'PRICE BREAK';
2604: l_source_entity_id := l_price_break_id;