22: p_login_id out NOCOPY number,
23: p_user_id out NOCOPY number
24: ) is
25: begin
26: p_login_id := FND_GLOBAL.Login_Id;
27: p_user_id := FND_GLOBAL.User_Id;
28:
29: end get_who_info;
30:
23: p_user_id out NOCOPY number
24: ) is
25: begin
26: p_login_id := FND_GLOBAL.Login_Id;
27: p_user_id := FND_GLOBAL.User_Id;
28:
29: end get_who_info;
30:
31:
364: submit_restriction_message = p_submit_restriction_message,
365: submit_error_message = p_submit_error_message,
366: submit_from_system = p_submit_from_system,
367: last_update_date = sysdate, -- bug 8838622
368: last_update_login = fnd_global.login_id, -- bug 8838622
369: last_updated_by = fnd_global.user_id -- bug 8838622
370: WHERE Estimate_Detail_Id = p_estimate_detail_id;
371:
372: -- dbms_output.put_line('submit_error_message' || substr(p_submit_error_message,1,100));
365: submit_error_message = p_submit_error_message,
366: submit_from_system = p_submit_from_system,
367: last_update_date = sysdate, -- bug 8838622
368: last_update_login = fnd_global.login_id, -- bug 8838622
369: last_updated_by = fnd_global.user_id -- bug 8838622
370: WHERE Estimate_Detail_Id = p_estimate_detail_id;
371:
372: -- dbms_output.put_line('submit_error_message' || substr(p_submit_error_message,1,100));
373:
3329: event key(estimate_detail_id). l_charges_rec_type can utilized for future modifications*/
3330:
3331: l_charges_rec_type.incident_id := EstDtlTab(i).incident_id;
3332: l_charges_rec_type.org_id := EstDtlTab(i).org_id;
3333: wf_resp_appl_id := FND_GLOBAL.RESP_APPL_ID;
3334: wf_resp_id := FND_GLOBAL.RESP_ID;
3335: wf_user_id := FND_GLOBAL.USER_ID;
3336:
3337: CS_CHG_WF_EVENT_PKG.RAISE_SUBMITCHARGES_EVENT(
3330:
3331: l_charges_rec_type.incident_id := EstDtlTab(i).incident_id;
3332: l_charges_rec_type.org_id := EstDtlTab(i).org_id;
3333: wf_resp_appl_id := FND_GLOBAL.RESP_APPL_ID;
3334: wf_resp_id := FND_GLOBAL.RESP_ID;
3335: wf_user_id := FND_GLOBAL.USER_ID;
3336:
3337: CS_CHG_WF_EVENT_PKG.RAISE_SUBMITCHARGES_EVENT(
3338: p_api_version => 1.0,
3331: l_charges_rec_type.incident_id := EstDtlTab(i).incident_id;
3332: l_charges_rec_type.org_id := EstDtlTab(i).org_id;
3333: wf_resp_appl_id := FND_GLOBAL.RESP_APPL_ID;
3334: wf_resp_id := FND_GLOBAL.RESP_ID;
3335: wf_user_id := FND_GLOBAL.USER_ID;
3336:
3337: CS_CHG_WF_EVENT_PKG.RAISE_SUBMITCHARGES_EVENT(
3338: p_api_version => 1.0,
3339: p_init_msg_list => FND_API.G_FALSE,
3807: submit_restriction_message = p_submit_restriction_message,
3808: submit_error_message = p_submit_error_message,
3809: submit_from_system = p_submit_from_system,
3810: last_update_date = sysdate,
3811: last_update_login = fnd_global.login_id, --6027992
3812: last_updated_by = fnd_global.user_id --6027992
3813: WHERE Estimate_Detail_Id = p_estimate_detail_id;
3814:
3815: EXCEPTION
3808: submit_error_message = p_submit_error_message,
3809: submit_from_system = p_submit_from_system,
3810: last_update_date = sysdate,
3811: last_update_login = fnd_global.login_id, --6027992
3812: last_updated_by = fnd_global.user_id --6027992
3813: WHERE Estimate_Detail_Id = p_estimate_detail_id;
3814:
3815: EXCEPTION
3816: WHEN NO_DATA_FOUND THEN