APPS.PA_CONTROL_ITEMS_UTILS dependencies on PA_OBJ_STATUS_CHANGES

Line 959: /* Bug#3297238: call the insert table handlers of pa_obj_status_changes and pa_ci_comments here */

955:
956: --Bug # 4618856 - if statement is added to check the return status
957: IF (x_return_status = 'S') THEN
958:
959: /* Bug#3297238: call the insert table handlers of pa_obj_status_changes and pa_ci_comments here */
960: IF P_PA_DEBUG_MODE = 'Y' THEN
961: pa_debug.write_file('ChangeCiStatus: before call to ADD_STATUS_CHANGE_COMMENT');
962: END IF;
963:

Line 1877: from pa_obj_status_changes

1873: select a.old_project_status_code, a.new_project_status_code
1874: from (select obj_status_change_id,
1875: old_project_status_code,
1876: new_project_status_code
1877: from pa_obj_status_changes
1878: where object_type = 'PA_CI_TYPES'
1879: and object_id = p_ci_id
1880: order by obj_status_change_id desc) a
1881: where rownum = 1;

Line 1887: l_prev_status pa_obj_status_changes.old_project_status_code%TYPE;

1883: l_diagramUrl VARCHAR2(2000);
1884: l_wf_item_type pa_project_statuses.workflow_item_type%TYPE;
1885: l_wf_process pa_project_statuses.workflow_process%TYPE;
1886: l_item_key pa_wf_processes.item_key%TYPE;
1887: l_prev_status pa_obj_status_changes.old_project_status_code%TYPE;
1888: l_curr_status pa_obj_status_changes.new_project_status_code%TYPE;
1889: l_comment pa_ci_comments.comment_text%TYPE;
1890: BEGIN
1891:

Line 1888: l_curr_status pa_obj_status_changes.new_project_status_code%TYPE;

1884: l_wf_item_type pa_project_statuses.workflow_item_type%TYPE;
1885: l_wf_process pa_project_statuses.workflow_process%TYPE;
1886: l_item_key pa_wf_processes.item_key%TYPE;
1887: l_prev_status pa_obj_status_changes.old_project_status_code%TYPE;
1888: l_curr_status pa_obj_status_changes.new_project_status_code%TYPE;
1889: l_comment pa_ci_comments.comment_text%TYPE;
1890: BEGIN
1891:
1892: OPEN c_wf_type;

Line 1935: /* Bug#3297238: call the insert table handlers of pa_obj_status_changes and pa_ci_comments here */

1931: ,x_return_status => x_return_status
1932: ,x_msg_count => x_msg_count
1933: ,x_msg_data => x_msg_data);
1934:
1935: /* Bug#3297238: call the insert table handlers of pa_obj_status_changes and pa_ci_comments here */
1936:
1937: fnd_message.set_name('PA', 'PA_CI_ABORT_WF_COMMENT');
1938: l_comment := fnd_message.get;
1939:

Line 2021: SELECT pa_obj_status_changes_s.NEXTVAL

2017: fnd_message.set_token('NEW_STATUS', l_new_status_name);
2018: fnd_message.set_token('COMMENT', p_comment);
2019: l_comment_text := fnd_message.get;
2020:
2021: SELECT pa_obj_status_changes_s.NEXTVAL
2022: INTO l_obj_status_change_id
2023: FROM dual;
2024:
2025: PA_OBJ_STATUS_CHANGES_PKG.INSERT_ROW (

Line 2025: PA_OBJ_STATUS_CHANGES_PKG.INSERT_ROW (

2021: SELECT pa_obj_status_changes_s.NEXTVAL
2022: INTO l_obj_status_change_id
2023: FROM dual;
2024:
2025: PA_OBJ_STATUS_CHANGES_PKG.INSERT_ROW (
2026: X_ROWID => l_rowid,
2027: X_OBJ_STATUS_CHANGE_ID => l_obj_status_change_id,
2028: X_OBJECT_TYPE => p_object_type,
2029: X_OBJECT_ID => p_object_id,

Line 2065: --Bug 4716789 Added an API to delete the data from pa_obj_status_changes

2061: p_error_text => SUBSTRB(SQLERRM,1,240));
2062: RAISE;
2063: END ADD_STATUS_CHANGE_COMMENT;
2064:
2065: --Bug 4716789 Added an API to delete the data from pa_obj_status_changes
2066: PROCEDURE DELETE_OBJ_STATUS_CHANGES(
2067: p_object_type IN VARCHAR2
2068: ,p_object_id IN NUMBER
2069: ,x_return_status OUT NOCOPY VARCHAR2

Line 2076: DELETE FROM pa_obj_status_changes

2072: IS
2073: BEGIN
2074: x_return_status := FND_API.G_RET_STS_SUCCESS;
2075:
2076: DELETE FROM pa_obj_status_changes
2077: WHERE object_type = p_object_type
2078: AND object_id = p_object_id;
2079:
2080: EXCEPTION