APPS.PA_CI_ACTIONS_PVT dependencies on PA_CI_COMMENTS

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

791: l_ci_action_id number;
792: l_rowid rowid;
793:
794: Cursor old_comment IS
795: select ci_id, type_code, created_by, creation_date, ci_action_id from pa_ci_comments
796: where ci_comment_id = p_ci_comment_id;
797:
798: Cursor check_record_changed IS
799: select rowid

Line 800: from pa_ci_comments

796: where ci_comment_id = p_ci_comment_id;
797:
798: Cursor check_record_changed IS
799: select rowid
800: from pa_ci_comments
801: where ci_comment_id = p_ci_comment_id
802: and record_version_number = p_record_version_number
803: for update;
804: BEGIN

Line 842: PA_CI_COMMENTS_PKG.UPDATE_ROW(

838:
839: If (x_return_status = fnd_api.g_ret_sts_success
840: AND p_validate_only <> fnd_api.g_true) then
841:
842: PA_CI_COMMENTS_PKG.UPDATE_ROW(
843: P_CI_COMMENT_ID => P_CI_COMMENT_ID,
844: P_CI_ID => l_ci_id,
845: P_TYPE_CODE => l_type_code,
846: P_COMMENT_TEXT => P_COMMENT_TEXT,

Line 915: PA_CI_COMMENTS_PKG.INSERT_ROW(

911:
912: If (x_return_status = fnd_api.g_ret_sts_success
913: AND p_validate_only <> fnd_api.g_true
914: AND P_COMMENT_TEXT IS NOT NULL) then
915: PA_CI_COMMENTS_PKG.INSERT_ROW(
916: P_CI_COMMENT_ID => P_CI_COMMENT_ID,
917: P_CI_ID => P_CI_ID,
918: P_TYPE_CODE => P_TYPE_CODE,
919: P_COMMENT_TEXT => P_COMMENT_TEXT,

Line 1063: FROM PA_CI_COMMENTS

1059: WHERE ci_id = p_ci_id;
1060:
1061: CURSOR delete_comment IS
1062: SELECT ci_comment_id
1063: FROM PA_CI_COMMENTS
1064: WHERE ci_action_id = l_ci_action_id;
1065:
1066: BEGIN
1067: x_return_status := fnd_api.g_ret_sts_success;

Line 1088: PA_CI_COMMENTS_PKG.DELETE_ROW(

1084: OPEN delete_comment;
1085: LOOP
1086: FETCH delete_comment INTO l_ci_comment_id;
1087: EXIT WHEN delete_comment%NOTFOUND;
1088: PA_CI_COMMENTS_PKG.DELETE_ROW(
1089: P_CI_COMMENT_ID => l_ci_comment_id);
1090: END LOOP;
1091: CLOSE delete_comment;
1092: END LOOP;