APPS.JAI_CMN_TAX_DEFAULTATION_PKG dependencies on JAI_PO_LINE_LOCATIONS

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

435: counter NUMBER;
436: max_iter NUMBER := 10;
437: v_excise_jb NUMBER;
438:
439: v_line_focus_id_holder JAI_PO_LINE_LOCATIONS.line_focus_id%TYPE; -- cbabu for EnhancementBug# 2427465
440:
441:
442: /** bgowrava, Begin forward porting bug#5631784 */
443: refc_tax_cur ref_cur_typ;

Line 2729: FROM JAI_PO_LINE_LOCATIONS

2725: WHERE Line_Location_Id = p_line_id );
2726:
2727: CURSOR fetch_focus_id IS
2728: SELECT Line_Focus_Id
2729: FROM JAI_PO_LINE_LOCATIONS
2730: WHERE Po_Line_Id = p_line_id
2731: AND Po_Header_Id = p_header_id
2732: AND Line_Location_Id IS NULL;
2733:

Line 2736: FROM JAI_PO_LINE_LOCATIONS

2732: AND Line_Location_Id IS NULL;
2733:
2734: CURSOR fetch_focus1_id( line_id IN NUMBER ) IS
2735: SELECT Line_Focus_Id
2736: FROM JAI_PO_LINE_LOCATIONS
2737: WHERE Po_Line_Id = p_line_id
2738: AND Po_Header_Id = p_header_id
2739: AND Line_Location_Id = line_id;
2740:

Line 3314: UPDATE JAI_PO_LINE_LOCATIONS

3310: SUBSTR( transaction_name, 1, 9 ) = 'SCHEDULED'
3311: THEN
3312:
3313: BEGIN
3314: UPDATE JAI_PO_LINE_LOCATIONS
3315: SET tax_category_id = p_tax_category_id
3316: WHERE line_focus_id = v_line_focus_id_holder;
3317: EXCEPTION
3318: WHEN OTHERS THEN