APPS.AP_IAW_PKG dependencies on AP_INV_APRVL_HIST_S

Line 2285: SELECT AP_INV_APRVL_HIST_S.nextval

2281:
2282: --set the environment
2283: fnd_client_info.set_org_context(p_inv_aprvl_hist.org_id);
2284:
2285: SELECT AP_INV_APRVL_HIST_S.nextval
2286: INTO l_hist_id
2287: FROM dual;
2288:
2289: SELECT max(notification_order) + 1

Line 2387: SELECT AP_INV_APRVL_HIST_S.nextval

2383: --Now set the environment
2384: --fnd_client_info.set_org_context(l_org_id);
2385:
2386:
2387: SELECT AP_INV_APRVL_HIST_S.nextval
2388: INTO l_hist_id
2389: FROM dual;
2390:
2391: SELECT max(nvl(notification_order,0)) + 1

Line 2456: SELECT AP_INV_APRVL_HIST_S.nextval

2452:
2453: --Now set the environment
2454: fnd_client_info.set_org_context(p_line_aprvl_hist.org_id);
2455:
2456: SELECT AP_INV_APRVL_HIST_S.nextval
2457: INTO l_hist_id
2458: FROM dual;
2459:
2460: SELECT max(notification_order) + 1

Line 2584: SELECT AP_INV_APRVL_HIST_S.nextval

2580:
2581: FETCH Lines_Cur INTO l_line_num, l_item_class, l_item_id;
2582: EXIT WHEN Lines_Cur%NOTFOUND OR Lines_Cur%NOTFOUND IS NULL;
2583:
2584: SELECT AP_INV_APRVL_HIST_S.nextval
2585: INTO l_hist_id
2586: FROM dual;
2587:
2588: SELECT max(nvl(notification_order,0)) + 1