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:
2757: event key(estimate_detail_id). l_charges_rec_type can utilized for future modifications*/
2758:
2759: l_charges_rec_type.incident_id := EstDtlTab(i).incident_id;
2760: l_charges_rec_type.org_id := EstDtlTab(i).org_id;
2761: wf_resp_appl_id := FND_GLOBAL.RESP_APPL_ID;
2762: wf_resp_id := FND_GLOBAL.RESP_ID;
2763: wf_user_id := FND_GLOBAL.USER_ID;
2764:
2765: CS_CHG_WF_EVENT_PKG.RAISE_SUBMITCHARGES_EVENT(
2758:
2759: l_charges_rec_type.incident_id := EstDtlTab(i).incident_id;
2760: l_charges_rec_type.org_id := EstDtlTab(i).org_id;
2761: wf_resp_appl_id := FND_GLOBAL.RESP_APPL_ID;
2762: wf_resp_id := FND_GLOBAL.RESP_ID;
2763: wf_user_id := FND_GLOBAL.USER_ID;
2764:
2765: CS_CHG_WF_EVENT_PKG.RAISE_SUBMITCHARGES_EVENT(
2766: p_api_version => 1.0,
2759: l_charges_rec_type.incident_id := EstDtlTab(i).incident_id;
2760: l_charges_rec_type.org_id := EstDtlTab(i).org_id;
2761: wf_resp_appl_id := FND_GLOBAL.RESP_APPL_ID;
2762: wf_resp_id := FND_GLOBAL.RESP_ID;
2763: wf_user_id := FND_GLOBAL.USER_ID;
2764:
2765: CS_CHG_WF_EVENT_PKG.RAISE_SUBMITCHARGES_EVENT(
2766: p_api_version => 1.0,
2767: p_init_msg_list => FND_API.G_FALSE,
3209: submit_restriction_message = p_submit_restriction_message,
3210: submit_error_message = p_submit_error_message,
3211: submit_from_system = p_submit_from_system,
3212: last_update_date = sysdate,
3213: last_update_login = fnd_global.login_id, --6027992
3214: last_updated_by = fnd_global.user_id --6027992
3215: WHERE Estimate_Detail_Id = p_estimate_detail_id;
3216:
3217: EXCEPTION
3210: submit_error_message = p_submit_error_message,
3211: submit_from_system = p_submit_from_system,
3212: last_update_date = sysdate,
3213: last_update_login = fnd_global.login_id, --6027992
3214: last_updated_by = fnd_global.user_id --6027992
3215: WHERE Estimate_Detail_Id = p_estimate_detail_id;
3216:
3217: EXCEPTION
3218: WHEN NO_DATA_FOUND THEN