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.JTF_UM_WF_APPROVAL dependencies on HZ_PARTIES

Line 221: x_org_name out NOCOPY hz_parties.party_name%type,

217: -- x_org_name - organization's name
218: -- x_org_number - organization's number
219: --
220: procedure get_org_info (p_user_id in fnd_user.user_id%type,
221: x_org_name out NOCOPY hz_parties.party_name%type,
222: x_org_number out NOCOPY hz_parties.party_number%type) is
223:
224: l_method_name varchar2 (12) := 'GET_ORG_INFO';
225:

Line 222: x_org_number out NOCOPY hz_parties.party_number%type) is

218: -- x_org_number - organization's number
219: --
220: procedure get_org_info (p_user_id in fnd_user.user_id%type,
221: x_org_name out NOCOPY hz_parties.party_name%type,
222: x_org_number out NOCOPY hz_parties.party_number%type) is
223:
224: l_method_name varchar2 (12) := 'GET_ORG_INFO';
225:
226: cursor getOrgNameAndNumber is

Line 228: from fnd_user fnd, hz_parties hz, hz_relationships hzr

224: l_method_name varchar2 (12) := 'GET_ORG_INFO';
225:
226: cursor getOrgNameAndNumber is
227: select hz.party_name, hz.party_number
228: from fnd_user fnd, hz_parties hz, hz_relationships hzr
229: where fnd.user_id = p_user_id
230: and fnd.customer_id = hzr.party_id
231: and hzr.start_date <= sysdate
232: and nvl (hzr.end_date, sysdate + 1) > sysdate

Line 234: and hzr.object_table_name = 'HZ_PARTIES'

230: and fnd.customer_id = hzr.party_id
231: and hzr.start_date <= sysdate
232: and nvl (hzr.end_date, sysdate + 1) > sysdate
233: and hzr.relationship_code in ('EMPLOYEE_OF','CONTACT_OF')
234: and hzr.object_table_name = 'HZ_PARTIES'
235: and hzr.subject_table_name = 'HZ_PARTIES'
236: and hzr.object_id = hz.party_id;
237:
238: begin

Line 235: and hzr.subject_table_name = 'HZ_PARTIES'

231: and hzr.start_date <= sysdate
232: and nvl (hzr.end_date, sysdate + 1) > sysdate
233: and hzr.relationship_code in ('EMPLOYEE_OF','CONTACT_OF')
234: and hzr.object_table_name = 'HZ_PARTIES'
235: and hzr.subject_table_name = 'HZ_PARTIES'
236: and hzr.object_id = hz.party_id;
237:
238: begin
239:

Line 632: from hz_parties hz, hz_relationships hzr, fnd_user fnd

628:
629: --
630: cursor getCompanyNumber is
631: select hz.party_number
632: from hz_parties hz, hz_relationships hzr, fnd_user fnd
633: where fnd.user_id = requesterUserID
634: and fnd.customer_id = hzr.party_id
635: and hzr.start_date <= sysdate
636: and nvl (hzr.end_date, sysdate + 1) > sysdate

Line 638: and hzr.object_table_name = 'HZ_PARTIES'

634: and fnd.customer_id = hzr.party_id
635: and hzr.start_date <= sysdate
636: and nvl (hzr.end_date, sysdate + 1) > sysdate
637: and hzr.relationship_code in ('EMPLOYEE_OF','CONTACT_OF')
638: and hzr.object_table_name = 'HZ_PARTIES'
639: and hzr.subject_table_name = 'HZ_PARTIES'
640: and hzr.object_id = hz.party_id;
641:
642: cursor getUsertypeKey is

Line 639: and hzr.subject_table_name = 'HZ_PARTIES'

635: and hzr.start_date <= sysdate
636: and nvl (hzr.end_date, sysdate + 1) > sysdate
637: and hzr.relationship_code in ('EMPLOYEE_OF','CONTACT_OF')
638: and hzr.object_table_name = 'HZ_PARTIES'
639: and hzr.subject_table_name = 'HZ_PARTIES'
640: and hzr.object_id = hz.party_id;
641:
642: cursor getUsertypeKey is
643: select USERTYPE_KEY

Line 928: l_org_name hz_parties.party_name%type;

924: x_role_name_display out NOCOPY varchar2) is
925:
926: l_method_name varchar2 (20) := 'GET_ORG_AD_HOC_ROLE';
927: l_requester_user_id fnd_user.user_id%type;
928: l_org_name hz_parties.party_name%type;
929: l_org_number hz_parties.party_number%type;
930: l_uni_approver_not_found boolean := true;
931: l_role_name wf_local_roles.name%type;
932: l_approver_display_name varchar2(1000);

Line 929: l_org_number hz_parties.party_number%type;

925:
926: l_method_name varchar2 (20) := 'GET_ORG_AD_HOC_ROLE';
927: l_requester_user_id fnd_user.user_id%type;
928: l_org_name hz_parties.party_name%type;
929: l_org_number hz_parties.party_number%type;
930: l_uni_approver_not_found boolean := true;
931: l_role_name wf_local_roles.name%type;
932: l_approver_display_name varchar2(1000);
933: l_notif_pref WF_LOCAL_ROLES.NOTIFICATION_PREFERENCE%TYPE;

Line 942: from hz_parties hz_org, hz_relationships hzr, fnd_user fnd

938: where name = x_role_name;
939:
940: cursor getUniversalApprovers is
941: select fnd.user_name
942: from hz_parties hz_org, hz_relationships hzr, fnd_user fnd
943: where hz_org.party_number = l_org_number
944: and hz_org.party_type = 'ORGANIZATION'
945: and hz_org.party_id = hzr.object_id
946: and hzr.start_date <= sysdate

Line 949: and hzr.object_table_name = 'HZ_PARTIES'

945: and hz_org.party_id = hzr.object_id
946: and hzr.start_date <= sysdate
947: and nvl (hzr.end_date, sysdate + 1) > sysdate
948: and hzr.relationship_code = 'EMPLOYEE_OF'
949: and hzr.object_table_name = 'HZ_PARTIES'
950: and hzr.subject_table_name = 'HZ_PARTIES'
951: and fnd.customer_id = hzr.party_id
952: and fnd.start_date <= sysdate
953: and nvl (fnd.end_date, sysdate + 1) > sysdate

Line 950: and hzr.subject_table_name = 'HZ_PARTIES'

946: and hzr.start_date <= sysdate
947: and nvl (hzr.end_date, sysdate + 1) > sysdate
948: and hzr.relationship_code = 'EMPLOYEE_OF'
949: and hzr.object_table_name = 'HZ_PARTIES'
950: and hzr.subject_table_name = 'HZ_PARTIES'
951: and fnd.customer_id = hzr.party_id
952: and fnd.start_date <= sysdate
953: and nvl (fnd.end_date, sysdate + 1) > sysdate
954:

Line 1289: and hzr.subject_table_name = 'HZ_PARTIES'

1285: and hzr.start_date <= sysdate
1286: and nvl (hzr.END_DATE, sysdate + 1) > sysdate
1287: and hzr.relationship_code in ('EMPLOYEE_OF','CONTACT_OF')
1288: and hzr.object_type = 'ORGANIZATION'
1289: and hzr.subject_table_name = 'HZ_PARTIES'
1290: and hzr.object_table_name = 'HZ_PARTIES';
1291: --
1292: begin
1293:

Line 1290: and hzr.object_table_name = 'HZ_PARTIES';

1286: and nvl (hzr.END_DATE, sysdate + 1) > sysdate
1287: and hzr.relationship_code in ('EMPLOYEE_OF','CONTACT_OF')
1288: and hzr.object_type = 'ORGANIZATION'
1289: and hzr.subject_table_name = 'HZ_PARTIES'
1290: and hzr.object_table_name = 'HZ_PARTIES';
1291: --
1292: begin
1293:
1294: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Entering GetApprover (' ||

Line 2490: l_org_name hz_parties.party_name%type;

2486: resultout out NOCOPY varchar2) is
2487:
2488: l_appl_id JTF_UM_USERTYPES_B.APPLICATION_ID%TYPE;
2489: l_approver_username fnd_user.user_name%type;
2490: l_org_name hz_parties.party_name%type;
2491: l_org_number hz_parties.party_number%type;
2492: l_primary_user_role fnd_profile_option_values.profile_option_value%type;
2493: l_procedure_name CONSTANT varchar2(26) := 'universal_approvers_exists';
2494: l_request_id number;

Line 2491: l_org_number hz_parties.party_number%type;

2487:
2488: l_appl_id JTF_UM_USERTYPES_B.APPLICATION_ID%TYPE;
2489: l_approver_username fnd_user.user_name%type;
2490: l_org_name hz_parties.party_name%type;
2491: l_org_number hz_parties.party_number%type;
2492: l_primary_user_role fnd_profile_option_values.profile_option_value%type;
2493: l_procedure_name CONSTANT varchar2(26) := 'universal_approvers_exists';
2494: l_request_id number;
2495: l_request_type varchar2 (10);

Line 2720: SELECT party.status FROM HZ_PARTIES PARTY, HZ_RELATIONSHIPS PREL

2716: where subscription_reg_id = to_number (itemkey);
2717:
2718: -- For bug fix 3894853
2719: cursor getOrgDetail is
2720: SELECT party.status FROM HZ_PARTIES PARTY, HZ_RELATIONSHIPS PREL
2721: WHERE PARTY.PARTY_ID = PREL.OBJECT_ID
2722: AND PREL.PARTY_ID = (select fnd.customer_id
2723: from jtf_um_usertype_reg reg , fnd_user fnd
2724: where usertype_reg_id = to_number(itemkey)

Line 2727: AND PREL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

2723: from jtf_um_usertype_reg reg , fnd_user fnd
2724: where usertype_reg_id = to_number(itemkey)
2725: and reg.user_id=fnd.USER_ID
2726: )
2727: AND PREL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
2728: AND PREL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
2729: AND PREL.START_DATE < SYSDATE
2730: AND NVL(PREL.END_DATE, SYSDATE+1) > SYSDATE
2731: AND PREL.RELATIONSHIP_CODE in ('EMPLOYEE_OF', 'CONTACT_OF');

Line 2728: AND PREL.OBJECT_TABLE_NAME = 'HZ_PARTIES'

2724: where usertype_reg_id = to_number(itemkey)
2725: and reg.user_id=fnd.USER_ID
2726: )
2727: AND PREL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
2728: AND PREL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
2729: AND PREL.START_DATE < SYSDATE
2730: AND NVL(PREL.END_DATE, SYSDATE+1) > SYSDATE
2731: AND PREL.RELATIONSHIP_CODE in ('EMPLOYEE_OF', 'CONTACT_OF');
2732:

Line 3258: and hzr.object_table_name = 'HZ_PARTIES'

3254: and fu.customer_id = hzr.party_id
3255: and hzr.start_date <= sysdate
3256: and nvl (hzr.end_date, sysdate + 1) > sysdate
3257: and hzr.relationship_code in ('EMPLOYEE_OF', 'CONTACT_OF')
3258: and hzr.object_table_name = 'HZ_PARTIES'
3259: and hzr.subject_table_name = 'HZ_PARTIES'
3260: and hzr.object_id = p_org_party_id;
3261:
3262: p_usertype_reg_id number;

Line 3259: and hzr.subject_table_name = 'HZ_PARTIES'

3255: and hzr.start_date <= sysdate
3256: and nvl (hzr.end_date, sysdate + 1) > sysdate
3257: and hzr.relationship_code in ('EMPLOYEE_OF', 'CONTACT_OF')
3258: and hzr.object_table_name = 'HZ_PARTIES'
3259: and hzr.subject_table_name = 'HZ_PARTIES'
3260: and hzr.object_id = p_org_party_id;
3261:
3262: p_usertype_reg_id number;
3263: p_user_id number;

Line 3387: and hzr.object_table_name = 'HZ_PARTIES'

3383: and fu.customer_id = hzr.party_id
3384: and hzr.start_date <= sysdate
3385: and nvl (hzr.end_date, sysdate + 1) > sysdate
3386: and hzr.relationship_code in ('EMPLOYEE_OF', 'CONTACT_OF')
3387: and hzr.object_table_name = 'HZ_PARTIES'
3388: and hzr.subject_table_name = 'HZ_PARTIES'
3389: and hzr.object_id = p_org_party_id;
3390:
3391: cursor find_new_item_type is

Line 3388: and hzr.subject_table_name = 'HZ_PARTIES'

3384: and hzr.start_date <= sysdate
3385: and nvl (hzr.end_date, sysdate + 1) > sysdate
3386: and hzr.relationship_code in ('EMPLOYEE_OF', 'CONTACT_OF')
3387: and hzr.object_table_name = 'HZ_PARTIES'
3388: and hzr.subject_table_name = 'HZ_PARTIES'
3389: and hzr.object_id = p_org_party_id;
3390:
3391: cursor find_new_item_type is
3392: select wf_item_type