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.PV_AME_API_W dependencies on JTF_NUMBER_TABLE

Line 14: , p_approval_list IN JTF_NUMBER_TABLE);

10: returnStatus CONSTANT VARCHAR2(10) := 'RETURN';
11:
12: PROCEDURE DEL_PRIOR_REP_APPR(p_approval_entity IN VARCHAR2
13: , p_referral_id IN NUMBER
14: , p_approval_list IN JTF_NUMBER_TABLE);
15:
16: PROCEDURE GET_APPROVERS(p_approval_entity IN VARCHAR2
17: ,p_referral_id IN NUMBER
18: ,p_mode IN VARCHAR2

Line 19: ,x_approval_list OUT NOCOPY JTF_NUMBER_TABLE

15:
16: PROCEDURE GET_APPROVERS(p_approval_entity IN VARCHAR2
17: ,p_referral_id IN NUMBER
18: ,p_mode IN VARCHAR2
19: ,x_approval_list OUT NOCOPY JTF_NUMBER_TABLE
20: ,x_approval_completed OUT NOCOPY VARCHAR2
21: ,x_default_approver OUT NOCOPY VARCHAR2
22: ,x_user_id_exists OUT NOCOPY VARCHAR2);
23:

Line 88: approverUserIds JTF_NUMBER_TABLE;

84:
85: l_approval_completed VARCHAR2(10);
86: l_default_approver VARCHAR2(10);
87:
88: approverUserIds JTF_NUMBER_TABLE;
89: l_valid_users_flag VARCHAR2(1);
90:
91: BEGIN
92:

Line 209: approverUserIds := JTF_NUMBER_TABLE();

205: ,'B4 GET_APPROVERS....'
206: );
207: END IF;
208:
209: approverUserIds := JTF_NUMBER_TABLE();
210:
211: GET_APPROVERS(p_approval_entity => p_approval_entity
212: ,p_referral_id => p_referral_id
213: ,p_mode => 'START'

Line 489: l_approval_list JTF_NUMBER_TABLE;

485: l_ret_reason_code VARCHAR2(30);
486: l_return_note_id NUMBER;
487: l_user_name VARCHAR2(100);
488:
489: l_approval_list JTF_NUMBER_TABLE;
490: l_default_approver VARCHAR2(10);
491: l_valid_users_flag VARCHAR2(1);
492: l_response_to_ame VARCHAR2(25);
493: l_resp_count NUMBER;

Line 1017: l_approval_list := JTF_NUMBER_TABLE();

1013:
1014: -- l_approver_current_status = 'PENDING_DEFAULT'
1015: IF p_response = AME_UTIL.forwardStatus THEN
1016: x_approval_done := 'N';
1017: l_approval_list := JTF_NUMBER_TABLE();
1018: l_approval_list.EXTEND();
1019: l_approval_list(1) := p_forwardee_user_id;
1020: l_pending_status := 'PENDING_DEFAULT';
1021:

Line 1395: ,x_approval_list OUT NOCOPY JTF_NUMBER_TABLE

1391:
1392: PROCEDURE GET_APPROVERS(p_approval_entity IN VARCHAR2
1393: ,p_referral_id IN NUMBER
1394: ,p_mode IN VARCHAR2
1395: ,x_approval_list OUT NOCOPY JTF_NUMBER_TABLE
1396: ,x_approval_completed OUT NOCOPY VARCHAR2
1397: ,x_default_approver OUT NOCOPY VARCHAR2
1398: ,x_user_id_exists OUT NOCOPY VARCHAR2)
1399: IS

Line 1448: x_approval_list := JTF_NUMBER_TABLE();

1444: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
1445: ,'GET_APPROVERS Calling new APIs '
1446: );
1447: END IF;
1448: x_approval_list := JTF_NUMBER_TABLE();
1449:
1450: AME_API2.getNextApprovers3(applicationIdIn => 691
1451: ,transactionTypeIn => p_approval_entity
1452: ,transactionIdIn => p_referral_id

Line 1594: x_approval_list := JTF_NUMBER_TABLE();

1590: x_default_approver := 'Y';
1591:
1592: -- clearing the table in case there were any already existing
1593: -- valid users in list.
1594: x_approval_list := JTF_NUMBER_TABLE();
1595: x_approval_list.EXTEND(1);
1596:
1597: IF p_approval_entity = 'PVREFFRL' THEN
1598: x_approval_list(1) := FND_PROFILE.Value('PV_DEFAULT_REFERRAL_APPROVER');

Line 1627: , p_approval_list IN JTF_NUMBER_TABLE)

1623:
1624:
1625: PROCEDURE DEL_PRIOR_REP_APPR(p_approval_entity IN VARCHAR2
1626: , p_referral_id IN NUMBER
1627: , p_approval_list IN JTF_NUMBER_TABLE)
1628: IS
1629: CURSOR lc_prior_approvers IS
1630: SELECT APPROVER_ID
1631: FROM PV_GE_TEMP_APPROVERS