APPS.PA_CONTROL_ITEMS_UTILS dependencies on PA_OBJ_STATUS_CHANGES

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

1005:
1006: --Bug # 4618856 - if statement is added to check the return status
1007: IF (x_return_status = 'S') THEN
1008:
1009: /* Bug#3297238: call the insert table handlers of pa_obj_status_changes and pa_ci_comments here */
1010: IF P_PA_DEBUG_MODE = 'Y' THEN
1011: pa_debug.write_file('ChangeCiStatus: before call to ADD_STATUS_CHANGE_COMMENT');
1012: END IF;
1013:

Line 1973: from pa_obj_status_changes

1969: select a.old_project_status_code, a.new_project_status_code
1970: from (select obj_status_change_id,
1971: old_project_status_code,
1972: new_project_status_code
1973: from pa_obj_status_changes
1974: where object_type = 'PA_CI_TYPES'
1975: and object_id = p_ci_id
1976: order by obj_status_change_id desc) a
1977: where rownum = 1;

Line 1983: l_prev_status pa_obj_status_changes.old_project_status_code%TYPE;

1979: l_diagramUrl VARCHAR2(2000);
1980: l_wf_item_type pa_project_statuses.workflow_item_type%TYPE;
1981: l_wf_process pa_project_statuses.workflow_process%TYPE;
1982: l_item_key pa_wf_processes.item_key%TYPE;
1983: l_prev_status pa_obj_status_changes.old_project_status_code%TYPE;
1984: l_curr_status pa_obj_status_changes.new_project_status_code%TYPE;
1985: l_comment pa_ci_comments.comment_text%TYPE;
1986: BEGIN
1987:

Line 1984: l_curr_status pa_obj_status_changes.new_project_status_code%TYPE;

1980: l_wf_item_type pa_project_statuses.workflow_item_type%TYPE;
1981: l_wf_process pa_project_statuses.workflow_process%TYPE;
1982: l_item_key pa_wf_processes.item_key%TYPE;
1983: l_prev_status pa_obj_status_changes.old_project_status_code%TYPE;
1984: l_curr_status pa_obj_status_changes.new_project_status_code%TYPE;
1985: l_comment pa_ci_comments.comment_text%TYPE;
1986: BEGIN
1987:
1988: OPEN c_wf_type;

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

2027: ,x_return_status => x_return_status
2028: ,x_msg_count => x_msg_count
2029: ,x_msg_data => x_msg_data);
2030:
2031: /* Bug#3297238: call the insert table handlers of pa_obj_status_changes and pa_ci_comments here */
2032:
2033: fnd_message.set_name('PA', 'PA_CI_ABORT_WF_COMMENT');
2034: l_comment := fnd_message.get;
2035:

Line 2117: SELECT pa_obj_status_changes_s.NEXTVAL

2113: fnd_message.set_token('NEW_STATUS', l_new_status_name);
2114: fnd_message.set_token('COMMENT', p_comment);
2115: l_comment_text := fnd_message.get;
2116:
2117: SELECT pa_obj_status_changes_s.NEXTVAL
2118: INTO l_obj_status_change_id
2119: FROM dual;
2120:
2121: PA_OBJ_STATUS_CHANGES_PKG.INSERT_ROW (

Line 2121: PA_OBJ_STATUS_CHANGES_PKG.INSERT_ROW (

2117: SELECT pa_obj_status_changes_s.NEXTVAL
2118: INTO l_obj_status_change_id
2119: FROM dual;
2120:
2121: PA_OBJ_STATUS_CHANGES_PKG.INSERT_ROW (
2122: X_ROWID => l_rowid,
2123: X_OBJ_STATUS_CHANGE_ID => l_obj_status_change_id,
2124: X_OBJECT_TYPE => p_object_type,
2125: X_OBJECT_ID => p_object_id,

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

2157: p_error_text => SUBSTRB(SQLERRM,1,240));
2158: RAISE;
2159: END ADD_STATUS_CHANGE_COMMENT;
2160:
2161: --Bug 4716789 Added an API to delete the data from pa_obj_status_changes
2162: PROCEDURE DELETE_OBJ_STATUS_CHANGES(
2163: p_object_type IN VARCHAR2
2164: ,p_object_id IN NUMBER
2165: ,x_return_status OUT NOCOPY VARCHAR2

Line 2172: DELETE FROM pa_obj_status_changes

2168: IS
2169: BEGIN
2170: x_return_status := FND_API.G_RET_STS_SUCCESS;
2171:
2172: DELETE FROM pa_obj_status_changes
2173: WHERE object_type = p_object_type
2174: AND object_id = p_object_id;
2175:
2176: EXCEPTION