[Home] [Help]
414: -- and commented in CREATE_INSTRUCTIONS procedure
415: -- at step3
416:
417: FORALL i in 1..l_po_line_loc_id_list.COUNT
418: UPDATE PO_DISTRIBUTIONS_ALL
419: SET invoice_adjustment_flag = 'S'
420: WHERE line_location_id = l_po_line_loc_id_list(i);
421:
422: END IF; /* l_po_line_loc_id_list.count > 0 */
6866: SELECT pd.line_location_id,
6867: SUM(d.amount)
6868: FROM ap_ppa_invoice_dists_gt d,
6869: ap_ppa_invoice_lines_gt l,
6870: po_distributions_all pd
6871: --bug#9573078 Introduced new conditions to put join lines_gt
6872: --and dists_gt with line number
6873: WHERE d.instruction_id = p_instruction_rec.invoice_id
6874: AND d.po_distribution_id = pd.po_distribution_id
6885: FND_GLOBAL.conc_login_id,
6886: FND_GLOBAL.conc_request_id
6887: FROM ap_ppa_invoice_dists_gt d,
6888: ap_ppa_invoice_lines_gt l,
6889: po_distributions_all pd
6890: --bug#9573078 Introduced new conditions to put join lines_gt
6891: --and dists_gt with line number
6892: WHERE pd.line_location_id = c_po_line_location_id
6893: AND pd.invoice_adjustment_flag = 'S'
7837: --bug#9573078
7838: --Introduced below UPDATE to NULL invoice_adjustment_flag
7839: --if all process done successfully.
7840:
7841: UPDATE po_distributions_all pd
7842: SET invoice_adjustment_flag = NULL
7843: WHERE invoice_adjustment_flag = 'S'
7844: AND po_distribution_id IN (
7845: SELECT d.po_distribution_id
7851: AND l.line_number = d.invoice_line_number);
7852:
7853: ELSE
7854:
7855: UPDATE po_distributions_all pd
7856: SET last_update_date = SYSDATE,
7857: last_updated_by = FND_GLOBAL.user_id,
7858: last_update_login = FND_GLOBAL.conc_login_id,
7859: request_id = FND_GLOBAL.conc_request_id,
7896: END IF;
7897: --
7898: --Bug#15996840
7899: IF(p_instruction_rec.invoice_id IS NOT NULL)THEN
7900: UPDATE po_distributions_all pd
7901: SET invoice_adjustment_flag = 'R'
7902: WHERE invoice_adjustment_flag = 'S'
7903: AND line_location_id IN
7904: (select po_line_location_id