APPS.PA_COPY_CHANGE_DOC_PVT dependencies on PA_CI_COMMENTS

Line 68: select * from PA_CI_COMMENTS

64: WHERE object_id_from1 = p_ci_id;
65:
66: CURSOR c_comments_from(p_action_id number)
67: is
68: select * from PA_CI_COMMENTS
69: WHERE ci_id = p_ci_id
70: AND nvl(ci_action_id,-999)=p_action_id;
71:
72: CURSOR c_comments_from1

Line 74: select * from PA_CI_COMMENTS

70: AND nvl(ci_action_id,-999)=p_action_id;
71:
72: CURSOR c_comments_from1
73: is
74: select * from PA_CI_COMMENTS
75: WHERE ci_id = p_ci_id
76: AND ci_action_id is null;
77:
78: CURSOR c_supp_dtls_from

Line 321: PA_CI_COMMENTS_PKG.INSERT_ROW (

317:
318: FOR ci_comments_from IN c_comments_from(ci_actions_from.CI_ACTION_ID)
319: LOOP
320:
321: PA_CI_COMMENTS_PKG.INSERT_ROW (
322: P_CI_COMMENT_ID => ci_comments_from.CI_COMMENT_ID,
323: P_CI_ID => x_ci_id,
324: P_TYPE_CODE => ci_comments_from.TYPE_CODE,
325: P_COMMENT_TEXT => ci_comments_from.COMMENT_TEXT,

Line 347: PA_CI_COMMENTS_PKG.INSERT_ROW (

343:
344: FOR ci_comments_from IN c_comments_from1
345: LOOP
346:
347: PA_CI_COMMENTS_PKG.INSERT_ROW (
348: P_CI_COMMENT_ID => ci_comments_from.CI_COMMENT_ID,
349: P_CI_ID => x_ci_id,
350: P_TYPE_CODE => ci_comments_from.TYPE_CODE,
351: P_COMMENT_TEXT => ci_comments_from.COMMENT_TEXT,