APPS.IGI_AP_INV_DIST_PKG dependencies on IGI_INVOICE_DISTRIBUTIONS_ALL

Line 27: FROM IGI_INVOICE_DISTRIBUTIONS_ALL

23:
24: /* bug # 5905278 start R12 Uptake of SIA - cursor C1 is modified to include invoice_line_number */
25: /* CURSOR C1 IS
26: SELECT *
27: FROM IGI_INVOICE_DISTRIBUTIONS_ALL
28: WHERE (invoice_id,distribution_line_number,org_id) =
29: (SELECT invoice_id,distribution_line_number, org_id
30: FROM AP_INVOICE_DISTRIBUTIONS_ALL
31: WHERE rowid = X_Rowid)

Line 35: FROM IGI_INVOICE_DISTRIBUTIONS_ALL

31: WHERE rowid = X_Rowid)
32: FOR UPDATE of igi_sap_flag NOWAIT; */
33: CURSOR C1 IS
34: SELECT *
35: FROM IGI_INVOICE_DISTRIBUTIONS_ALL
36: WHERE (invoice_id,invoice_line_number,distribution_line_number,org_id) =
37: (SELECT invoice_id,invoice_line_number,distribution_line_number, org_id
38: FROM AP_INVOICE_DISTRIBUTIONS_ALL
39: WHERE rowid = X_Rowid)

Line 94: UPDATE IGI_INVOICE_DISTRIBUTIONS_ALL

90: ,X_Last_Update_Date DATE
91: ,X_Last_Updated_By NUMBER
92: ) IS
93: BEGIN
94: UPDATE IGI_INVOICE_DISTRIBUTIONS_ALL
95: SET
96: igi_sap_flag = X_igi_sap_flag,
97: last_update_login = X_Last_Update_Login,
98: last_updated_by = X_Last_Updated_By,