2492: close get_user_id;
2493:
2494: -- bug 852056: Need to create process here, and then set
2495: -- attributes: USER_ID, RESPONSIBILITY_ID, and APPLICATION_ID
2496: -- also need to initialize fnd_global
2497: wf_engine.CreateProcess ( ItemType => l_ItemType,
2498: ItemKey => l_ItemKey,
2499: process => l_WorkflowProcess);
2500:
3329: -- SQL What: Set the "Amount Billed notification sent" flag to Y.
3330: UPDATE po_lines_all
3331: SET svc_amount_notif_sent = 'Y',
3332: last_update_date = sysdate,
3333: last_updated_by = fnd_global.user_id
3334: WHERE po_line_id = l_tl_line_rec.po_line_id;
3335:
3336: END IF;
3337:
3353: -- SQL What: Set the "Assignment Completion notification sent" flag to Y.
3354: UPDATE po_lines_all
3355: SET svc_completion_notif_sent = 'Y',
3356: last_update_date = sysdate,
3357: last_updated_by = fnd_global.user_id
3358: WHERE po_line_id = l_tl_line_rec.po_line_id;
3359:
3360: END IF;
3361: