APPS.PA_CI_ACTIONS_PVT dependencies on PA_CI_COMMENTS

Line 827: select ci_id, type_code, created_by, creation_date, ci_action_id from pa_ci_comments

823: l_ci_action_id number;
824: l_rowid rowid;
825:
826: Cursor old_comment IS
827: select ci_id, type_code, created_by, creation_date, ci_action_id from pa_ci_comments
828: where ci_comment_id = p_ci_comment_id;
829:
830: Cursor check_record_changed IS
831: select rowid

Line 832: from pa_ci_comments

828: where ci_comment_id = p_ci_comment_id;
829:
830: Cursor check_record_changed IS
831: select rowid
832: from pa_ci_comments
833: where ci_comment_id = p_ci_comment_id
834: and record_version_number = p_record_version_number
835: for update;
836: BEGIN

Line 874: PA_CI_COMMENTS_PKG.UPDATE_ROW(

870:
871: If (x_return_status = fnd_api.g_ret_sts_success
872: AND p_validate_only <> fnd_api.g_true) then
873:
874: PA_CI_COMMENTS_PKG.UPDATE_ROW(
875: P_CI_COMMENT_ID => P_CI_COMMENT_ID,
876: P_CI_ID => l_ci_id,
877: P_TYPE_CODE => l_type_code,
878: P_COMMENT_TEXT => P_COMMENT_TEXT,

Line 947: PA_CI_COMMENTS_PKG.INSERT_ROW(

943:
944: If (x_return_status = fnd_api.g_ret_sts_success
945: AND p_validate_only <> fnd_api.g_true
946: AND P_COMMENT_TEXT IS NOT NULL) then
947: PA_CI_COMMENTS_PKG.INSERT_ROW(
948: P_CI_COMMENT_ID => P_CI_COMMENT_ID,
949: P_CI_ID => P_CI_ID,
950: P_TYPE_CODE => P_TYPE_CODE,
951: P_COMMENT_TEXT => P_COMMENT_TEXT,

Line 1095: FROM PA_CI_COMMENTS

1091: WHERE ci_id = p_ci_id;
1092:
1093: CURSOR delete_comment IS
1094: SELECT ci_comment_id
1095: FROM PA_CI_COMMENTS
1096: WHERE ci_action_id = l_ci_action_id;
1097:
1098: BEGIN
1099: x_return_status := fnd_api.g_ret_sts_success;

Line 1120: PA_CI_COMMENTS_PKG.DELETE_ROW(

1116: OPEN delete_comment;
1117: LOOP
1118: FETCH delete_comment INTO l_ci_comment_id;
1119: EXIT WHEN delete_comment%NOTFOUND;
1120: PA_CI_COMMENTS_PKG.DELETE_ROW(
1121: P_CI_COMMENT_ID => l_ci_comment_id);
1122: END LOOP;
1123: CLOSE delete_comment;
1124: END LOOP;