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.

[Home] [Help]

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 922: l_org_name hz_parties.party_name%type;

918: x_role_name_display out NOCOPY varchar2) is
919:
920: l_method_name varchar2 (20) := 'GET_ORG_AD_HOC_ROLE';
921: l_requester_user_id fnd_user.user_id%type;
922: l_org_name hz_parties.party_name%type;
923: l_org_number hz_parties.party_number%type;
924: l_uni_approver_not_found boolean := true;
925: l_role_name wf_local_roles.name%type;
926: l_approver_display_name varchar2(1000);

Line 923: l_org_number hz_parties.party_number%type;

919:
920: l_method_name varchar2 (20) := 'GET_ORG_AD_HOC_ROLE';
921: l_requester_user_id fnd_user.user_id%type;
922: l_org_name hz_parties.party_name%type;
923: l_org_number hz_parties.party_number%type;
924: l_uni_approver_not_found boolean := true;
925: l_role_name wf_local_roles.name%type;
926: l_approver_display_name varchar2(1000);
927:

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

931: where name = x_role_name;
932:
933: cursor getUniversalApprovers is
934: select fnd.user_name
935: from hz_parties hz_org, hz_relationships hzr, fnd_user fnd
936: where hz_org.party_number = l_org_number
937: and hz_org.party_type = 'ORGANIZATION'
938: and hz_org.party_id = hzr.object_id
939: and hzr.start_date <= sysdate

Line 942: and hzr.object_table_name = 'HZ_PARTIES'

938: and hz_org.party_id = hzr.object_id
939: and hzr.start_date <= sysdate
940: and nvl (hzr.end_date, sysdate + 1) > sysdate
941: and hzr.relationship_code = 'EMPLOYEE_OF'
942: and hzr.object_table_name = 'HZ_PARTIES'
943: and hzr.subject_table_name = 'HZ_PARTIES'
944: and fnd.customer_id = hzr.party_id
945: and fnd.start_date <= sysdate
946: and nvl (fnd.end_date, sysdate + 1) > sysdate

Line 943: and hzr.subject_table_name = 'HZ_PARTIES'

939: and hzr.start_date <= sysdate
940: and nvl (hzr.end_date, sysdate + 1) > sysdate
941: and hzr.relationship_code = 'EMPLOYEE_OF'
942: and hzr.object_table_name = 'HZ_PARTIES'
943: and hzr.subject_table_name = 'HZ_PARTIES'
944: and fnd.customer_id = hzr.party_id
945: and fnd.start_date <= sysdate
946: and nvl (fnd.end_date, sysdate + 1) > sysdate
947:

Line 1277: and hzr.subject_table_name = 'HZ_PARTIES'

1273: and hzr.start_date <= sysdate
1274: and nvl (hzr.END_DATE, sysdate + 1) > sysdate
1275: and hzr.relationship_code in ('EMPLOYEE_OF','CONTACT_OF')
1276: and hzr.object_type = 'ORGANIZATION'
1277: and hzr.subject_table_name = 'HZ_PARTIES'
1278: and hzr.object_table_name = 'HZ_PARTIES';
1279: --
1280: begin
1281:

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

1274: and nvl (hzr.END_DATE, sysdate + 1) > sysdate
1275: and hzr.relationship_code in ('EMPLOYEE_OF','CONTACT_OF')
1276: and hzr.object_type = 'ORGANIZATION'
1277: and hzr.subject_table_name = 'HZ_PARTIES'
1278: and hzr.object_table_name = 'HZ_PARTIES';
1279: --
1280: begin
1281:
1282: JTF_DEBUG_PUB.LOG_DEBUG (2, G_MODULE, 'Entering GetApprover (' ||

Line 2464: l_org_name hz_parties.party_name%type;

2460: resultout out NOCOPY varchar2) is
2461:
2462: l_appl_id JTF_UM_USERTYPES_B.APPLICATION_ID%TYPE;
2463: l_approver_username fnd_user.user_name%type;
2464: l_org_name hz_parties.party_name%type;
2465: l_org_number hz_parties.party_number%type;
2466: l_primary_user_role fnd_profile_option_values.profile_option_value%type;
2467: l_procedure_name CONSTANT varchar2(26) := 'universal_approvers_exists';
2468: l_request_id number;

Line 2465: l_org_number hz_parties.party_number%type;

2461:
2462: l_appl_id JTF_UM_USERTYPES_B.APPLICATION_ID%TYPE;
2463: l_approver_username fnd_user.user_name%type;
2464: l_org_name hz_parties.party_name%type;
2465: l_org_number hz_parties.party_number%type;
2466: l_primary_user_role fnd_profile_option_values.profile_option_value%type;
2467: l_procedure_name CONSTANT varchar2(26) := 'universal_approvers_exists';
2468: l_request_id number;
2469: l_request_type varchar2 (10);

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

2690: where subscription_reg_id = to_number (itemkey);
2691:
2692: -- For bug fix 3894853
2693: cursor getOrgDetail is
2694: SELECT party.status FROM HZ_PARTIES PARTY, HZ_RELATIONSHIPS PREL
2695: WHERE PARTY.PARTY_ID = PREL.OBJECT_ID
2696: AND PREL.PARTY_ID = (select fnd.customer_id
2697: from jtf_um_usertype_reg reg , fnd_user fnd
2698: where usertype_reg_id = to_number(itemkey)

Line 2701: AND PREL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

2697: from jtf_um_usertype_reg reg , fnd_user fnd
2698: where usertype_reg_id = to_number(itemkey)
2699: and reg.user_id=fnd.USER_ID
2700: )
2701: AND PREL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
2702: AND PREL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
2703: AND PREL.START_DATE < SYSDATE
2704: AND NVL(PREL.END_DATE, SYSDATE+1) > SYSDATE
2705: AND PREL.RELATIONSHIP_CODE in ('EMPLOYEE_OF', 'CONTACT_OF');

Line 2702: AND PREL.OBJECT_TABLE_NAME = 'HZ_PARTIES'

2698: where usertype_reg_id = to_number(itemkey)
2699: and reg.user_id=fnd.USER_ID
2700: )
2701: AND PREL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
2702: AND PREL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
2703: AND PREL.START_DATE < SYSDATE
2704: AND NVL(PREL.END_DATE, SYSDATE+1) > SYSDATE
2705: AND PREL.RELATIONSHIP_CODE in ('EMPLOYEE_OF', 'CONTACT_OF');
2706:

Line 3198: and hzr.object_table_name = 'HZ_PARTIES'

3194: and fu.customer_id = hzr.party_id
3195: and hzr.start_date <= sysdate
3196: and nvl (hzr.end_date, sysdate + 1) > sysdate
3197: and hzr.relationship_code in ('EMPLOYEE_OF', 'CONTACT_OF')
3198: and hzr.object_table_name = 'HZ_PARTIES'
3199: and hzr.subject_table_name = 'HZ_PARTIES'
3200: and hzr.object_id = p_org_party_id;
3201:
3202: p_usertype_reg_id number;

Line 3199: and hzr.subject_table_name = 'HZ_PARTIES'

3195: and hzr.start_date <= sysdate
3196: and nvl (hzr.end_date, sysdate + 1) > sysdate
3197: and hzr.relationship_code in ('EMPLOYEE_OF', 'CONTACT_OF')
3198: and hzr.object_table_name = 'HZ_PARTIES'
3199: and hzr.subject_table_name = 'HZ_PARTIES'
3200: and hzr.object_id = p_org_party_id;
3201:
3202: p_usertype_reg_id number;
3203: p_user_id number;

Line 3327: and hzr.object_table_name = 'HZ_PARTIES'

3323: and fu.customer_id = hzr.party_id
3324: and hzr.start_date <= sysdate
3325: and nvl (hzr.end_date, sysdate + 1) > sysdate
3326: and hzr.relationship_code in ('EMPLOYEE_OF', 'CONTACT_OF')
3327: and hzr.object_table_name = 'HZ_PARTIES'
3328: and hzr.subject_table_name = 'HZ_PARTIES'
3329: and hzr.object_id = p_org_party_id;
3330:
3331: cursor find_new_item_type is

Line 3328: and hzr.subject_table_name = 'HZ_PARTIES'

3324: and hzr.start_date <= sysdate
3325: and nvl (hzr.end_date, sysdate + 1) > sysdate
3326: and hzr.relationship_code in ('EMPLOYEE_OF', 'CONTACT_OF')
3327: and hzr.object_table_name = 'HZ_PARTIES'
3328: and hzr.subject_table_name = 'HZ_PARTIES'
3329: and hzr.object_id = p_org_party_id;
3330:
3331: cursor find_new_item_type is
3332: select wf_item_type