eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_CONTROL_ITEMS_WORKFLOW dependencies on PA_CI_COMMENTS

Line 1313: l_comment_text pa_ci_comments.comment_text%TYPE;

1309: notification_preference VARCHAR2(2000);
1310: language VARCHAR2(2000);
1311: territory VARCHAR2(2000);
1312: l_priority_name pa_lookups.meaning%TYPE;
1313: l_comment_text pa_ci_comments.comment_text%TYPE;
1314: l_loop_var1 NUMBER := 1;
1315: l_record_version_number NUMBER;
1316: l_ci_owner_id pa_control_items.owner_id%TYPE;
1317: l_ci_owner_name VARCHAR2(2000);

Line 1449: from pa_ci_comments

1445: --This cursor gets the change owner comment text.
1446: Cursor get_comment_text(c_ci_id pa_control_items.ci_id%TYPE)
1447: IS
1448: select comment_text
1449: from pa_ci_comments
1450: where ci_comment_id =
1451: (select max(ci_comment_id) from pa_ci_comments where ci_id = c_ci_id and type_code = 'CHANGE_OWNER');
1452:
1453: -- This cursor gets the partyid of all the people involved in the hierarchy

Line 1451: (select max(ci_comment_id) from pa_ci_comments where ci_id = c_ci_id and type_code = 'CHANGE_OWNER');

1447: IS
1448: select comment_text
1449: from pa_ci_comments
1450: where ci_comment_id =
1451: (select max(ci_comment_id) from pa_ci_comments where ci_id = c_ci_id and type_code = 'CHANGE_OWNER');
1452:
1453: -- This cursor gets the partyid of all the people involved in the hierarchy
1454: Cursor get_parties_in_hierarchy(c_action_id pa_ci_actions.ci_action_id%TYPE)
1455: Is

Line 2268: from pa_ci_comments

2264:
2265: -- Added the cursor for bug# 4527911
2266: cursor is_comment_inserted_cur(p_ci_action_id NUMBER) IS
2267: select 1
2268: from pa_ci_comments
2269: where ci_action_id = p_ci_action_id
2270: and type_code='UNSOLICITED';
2271:
2272: l_party_id number;

Line 2367: In case 2 the user comment will already be inserted in PA_CI_COMMENTS from the application, so no need to insert it again.

2363: There are two ways in which this api can be called:
2364: 1) When user takes keep open action from the workflow notification.
2365: 2) When user takes keep open action from take action page. When the notification result is set to
2366: KEEP_OPEN from backend then again this api is called by the workflow system.
2367: In case 2 the user comment will already be inserted in PA_CI_COMMENTS from the application, so no need to insert it again.
2368: IF there is already a line in pa_ci_comments for the action with type_code UNSOLICITED it means that the comment is already
2369: inserted.*/
2370:
2371:

Line 2368: IF there is already a line in pa_ci_comments for the action with type_code UNSOLICITED it means that the comment is already

2364: 1) When user takes keep open action from the workflow notification.
2365: 2) When user takes keep open action from take action page. When the notification result is set to
2366: KEEP_OPEN from backend then again this api is called by the workflow system.
2367: In case 2 the user comment will already be inserted in PA_CI_COMMENTS from the application, so no need to insert it again.
2368: IF there is already a line in pa_ci_comments for the action with type_code UNSOLICITED it means that the comment is already
2369: inserted.*/
2370:
2371:
2372: OPEN is_comment_inserted_cur(l_ci_action_id);