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 1416: l_comment_text pa_ci_comments.comment_text%TYPE;

1412: notification_preference VARCHAR2(2000);
1413: language VARCHAR2(2000);
1414: territory VARCHAR2(2000);
1415: l_priority_name pa_lookups.meaning%TYPE;
1416: l_comment_text pa_ci_comments.comment_text%TYPE;
1417: l_loop_var1 NUMBER := 1;
1418: l_record_version_number NUMBER;
1419: l_ci_owner_id pa_control_items.owner_id%TYPE;
1420: l_ci_owner_name VARCHAR2(2000);

Line 1562: from pa_ci_comments

1558: --This cursor gets the change owner comment text.
1559: Cursor get_comment_text(c_ci_id pa_control_items.ci_id%TYPE)
1560: IS
1561: select comment_text
1562: from pa_ci_comments
1563: where ci_comment_id =
1564: (select max(ci_comment_id) from pa_ci_comments where ci_id = c_ci_id and type_code = 'CHANGE_OWNER');
1565:
1566: -- This cursor gets the partyid of all the people involved in the hierarchy

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

1560: IS
1561: select comment_text
1562: from pa_ci_comments
1563: where ci_comment_id =
1564: (select max(ci_comment_id) from pa_ci_comments where ci_id = c_ci_id and type_code = 'CHANGE_OWNER');
1565:
1566: -- This cursor gets the partyid of all the people involved in the hierarchy
1567: Cursor get_parties_in_hierarchy(c_action_id pa_ci_actions.ci_action_id%TYPE)
1568: Is

Line 2511: from pa_ci_comments

2507:
2508: -- Added the cursor for bug# 4527911
2509: cursor is_comment_inserted_cur(p_ci_action_id NUMBER) IS
2510: select 1
2511: from pa_ci_comments
2512: where ci_action_id = p_ci_action_id
2513: and type_code='UNSOLICITED';
2514:
2515: l_party_id number;

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

2606: There are two ways in which this api can be called:
2607: 1) When user takes keep open action from the workflow notification.
2608: 2) When user takes keep open action from take action page. When the notification result is set to
2609: KEEP_OPEN from backend then again this api is called by the workflow system.
2610: In case 2 the user comment will already be inserted in PA_CI_COMMENTS from the application, so no need to insert it again.
2611: IF there is already a line in pa_ci_comments for the action with type_code UNSOLICITED it means that the comment is already
2612: inserted.*/
2613:
2614:

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

2607: 1) When user takes keep open action from the workflow notification.
2608: 2) When user takes keep open action from take action page. When the notification result is set to
2609: KEEP_OPEN from backend then again this api is called by the workflow system.
2610: In case 2 the user comment will already be inserted in PA_CI_COMMENTS from the application, so no need to insert it again.
2611: IF there is already a line in pa_ci_comments for the action with type_code UNSOLICITED it means that the comment is already
2612: inserted.*/
2613:
2614:
2615: OPEN is_comment_inserted_cur(l_ci_action_id);