[Home] [Help]
72: FROM as_statuses_vl
73: WHERE TRIM(NLS_UPPER(status_code)) = p_status_code; -- trimmed value passed while opening
74:
75: BEGIN
76: -- Standard start of api save point
77: SAVEPOINT create_status;
78:
79: -- Initialize Message List
80: IF fnd_api.to_boolean (p_init_msg_list)
81: THEN
82: fnd_msg_pub.initialize;
83: END IF;
84:
85: -- Standard Call to check api compatibility
86: IF NOT fnd_api.compatible_api_call (
87: l_api_version,
88: p_api_version_number,
89: l_api_name,
398: l_last_update_date,
399: l_last_updated_by,
400: l_last_update_login);
401:
402: -- Standard Check for p_commit
403: IF fnd_api.to_boolean (p_commit)
404: THEN
405: COMMIT WORK;
406: END IF;
404: THEN
405: COMMIT WORK;
406: END IF;
407:
408: -- Standard call to get message count and if count is 1, get message infor.
409: fnd_msg_pub.count_and_get(
410: p_count => x_msg_count,
411: p_data => x_msg_data
412: );
572:
573:
574: BEGIN
575:
576: -- Standard start of api save point
577: SAVEPOINT update_status;
578:
579: -- Initialize Message List
580: IF fnd_api.to_boolean (p_init_msg_list)
581: THEN
582: fnd_msg_pub.initialize;
583: END IF;
584:
585: -- Standard Call to check api compatibility
586: IF NOT fnd_api.compatible_api_call (
587: l_api_version,
588: p_api_version_number,
589: l_api_name,
958: l_last_updated_by,
959: l_last_update_login);
960:
961:
962: -- Standard Check for p_commit
963: IF fnd_api.to_boolean (p_commit)
964: THEN
965: COMMIT WORK;
966: END IF;
969: CLOSE get_update_row_cur; -- closed after update...
970: CLOSE lock_row_for_update ;
971:
972:
973: -- Standard call to get message count and if count is 1, get message infor.
974: fnd_msg_pub.count_and_get(
975: p_count => x_msg_count,
976: p_data => x_msg_data
977: );