APPS.JAI_CMN_TAX_DEFAULTATION_PKG dependencies on JAI_PO_LINE_LOCATIONS

Line 483: v_line_focus_id_holder JAI_PO_LINE_LOCATIONS.line_focus_id%TYPE; -- cbabu for EnhancementBug# 2427465

479: counter NUMBER;
480: max_iter NUMBER := 10;
481: v_excise_jb NUMBER;
482:
483: v_line_focus_id_holder JAI_PO_LINE_LOCATIONS.line_focus_id%TYPE; -- cbabu for EnhancementBug# 2427465
484:
485:
486: /** bgowrava, Begin forward porting bug#5631784 */
487: refc_tax_cur ref_cur_typ;

Line 3929: FROM JAI_PO_LINE_LOCATIONS

3925: WHERE Line_Location_Id = p_line_id );
3926:
3927: CURSOR fetch_focus_id IS
3928: SELECT Line_Focus_Id
3929: FROM JAI_PO_LINE_LOCATIONS
3930: WHERE Po_Line_Id = p_line_id
3931: AND Po_Header_Id = p_header_id
3932: AND Line_Location_Id IS NULL;
3933:

Line 3936: FROM JAI_PO_LINE_LOCATIONS

3932: AND Line_Location_Id IS NULL;
3933:
3934: CURSOR fetch_focus1_id( line_id IN NUMBER ) IS
3935: SELECT Line_Focus_Id
3936: FROM JAI_PO_LINE_LOCATIONS
3937: WHERE Po_Line_Id = p_line_id
3938: AND Po_Header_Id = p_header_id
3939: AND Line_Location_Id = line_id;
3940:

Line 4547: UPDATE JAI_PO_LINE_LOCATIONS

4543: SUBSTR( transaction_name, 1, 9 ) = 'SCHEDULED'
4544: THEN
4545:
4546: BEGIN
4547: UPDATE JAI_PO_LINE_LOCATIONS
4548: SET tax_category_id = p_tax_category_id
4549: WHERE line_focus_id = v_line_focus_id_holder;
4550: EXCEPTION
4551: WHEN OTHERS THEN