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

Line 186: p_party_id hz_parties.party_id%type) return number is

182: end lesson_status_transition_valid;
183:
184:
185: function get_contact_id_for_party(
186: p_party_id hz_parties.party_id%type) return number is
187:
188: cursor contact(
189: p_party_id hz_parties.party_id%type) is
190: select acct_role.cust_account_role_id

Line 189: p_party_id hz_parties.party_id%type) is

185: function get_contact_id_for_party(
186: p_party_id hz_parties.party_id%type) return number is
187:
188: cursor contact(
189: p_party_id hz_parties.party_id%type) is
190: select acct_role.cust_account_role_id
191: from hz_cust_account_roles acct_role,
192: hz_relationships rel,
193: hz_cust_accounts role_acct

Line 199: rel.subject_table_name = 'HZ_PARTIES' and

195: acct_role.role_type = 'CONTACT' and
196: acct_role.cust_account_id = role_acct.cust_account_id and
197: role_acct.party_id = rel.object_id and
198: rel.subject_id = p_party_id and
199: rel.subject_table_name = 'HZ_PARTIES' and
200: rel.object_table_name = 'HZ_PARTIES';
201:
202: v_result hz_parties.party_id%type;
203: begin

Line 200: rel.object_table_name = 'HZ_PARTIES';

196: acct_role.cust_account_id = role_acct.cust_account_id and
197: role_acct.party_id = rel.object_id and
198: rel.subject_id = p_party_id and
199: rel.subject_table_name = 'HZ_PARTIES' and
200: rel.object_table_name = 'HZ_PARTIES';
201:
202: v_result hz_parties.party_id%type;
203: begin
204: open contact(p_party_id);

Line 202: v_result hz_parties.party_id%type;

198: rel.subject_id = p_party_id and
199: rel.subject_table_name = 'HZ_PARTIES' and
200: rel.object_table_name = 'HZ_PARTIES';
201:
202: v_result hz_parties.party_id%type;
203: begin
204: open contact(p_party_id);
205: fetch contact into v_result;
206: close contact;

Line 558: rel.subject_table_name = 'HZ_PARTIES' and

554: acct_role.role_type = 'CONTACT' and
555: acct_role.cust_account_id = role_acct.cust_account_id and
556: role_acct.party_id = rel.object_id and
557: rel.subject_id = p_party_id and
558: rel.subject_table_name = 'HZ_PARTIES' and
559: rel.object_table_name = 'HZ_PARTIES';
560:
561: cursor perf_lesson_status is
562: select per.lesson_status,

Line 559: rel.object_table_name = 'HZ_PARTIES';

555: acct_role.cust_account_id = role_acct.cust_account_id and
556: role_acct.party_id = rel.object_id and
557: rel.subject_id = p_party_id and
558: rel.subject_table_name = 'HZ_PARTIES' and
559: rel.object_table_name = 'HZ_PARTIES';
560:
561: cursor perf_lesson_status is
562: select per.lesson_status,
563: offe.learning_object_id

Line 725: rel.subject_table_name = 'HZ_PARTIES' and

721: acct_role.role_type = 'CONTACT' and
722: acct_role.cust_account_id = role_acct.cust_account_id and
723: role_acct.party_id = rel.object_id and
724: rel.subject_id = p_party_id and
725: rel.subject_table_name = 'HZ_PARTIES' and
726: rel.object_table_name = 'HZ_PARTIES' and
727: act.activity_version_id = offr.activity_version_id;
728:
729: l_event_id OTA_EVENTS.EVENT_ID%TYPE:= null;

Line 726: rel.object_table_name = 'HZ_PARTIES' and

722: acct_role.cust_account_id = role_acct.cust_account_id and
723: role_acct.party_id = rel.object_id and
724: rel.subject_id = p_party_id and
725: rel.subject_table_name = 'HZ_PARTIES' and
726: rel.object_table_name = 'HZ_PARTIES' and
727: act.activity_version_id = offr.activity_version_id;
728:
729: l_event_id OTA_EVENTS.EVENT_ID%TYPE:= null;
730: l_test_id OTA_TESTS.TEST_ID%type:=null;

Line 1678: p_party_id hz_parties.party_id%type) is

1674: book.booking_status_type_id = stype.booking_status_type_id and
1675: stype.type in ('P', 'A', 'E');
1676:
1677: cursor get_delegate_contact(
1678: p_party_id hz_parties.party_id%type) is
1679: select acct_role.cust_account_role_id
1680: from hz_cust_account_roles acct_role,
1681: hz_relationships rel,
1682: hz_cust_accounts role_acct

Line 1688: rel.subject_table_name = 'HZ_PARTIES' and

1684: acct_role.role_type = 'CONTACT' and
1685: acct_role.cust_account_id = role_acct.cust_account_id and
1686: role_acct.party_id = rel.object_id and
1687: rel.subject_id = p_party_id and
1688: rel.subject_table_name = 'HZ_PARTIES' and
1689: rel.object_table_name = 'HZ_PARTIES';
1690:
1691: a_contact get_delegate_contact%ROWTYPE;
1692: begin

Line 1689: rel.object_table_name = 'HZ_PARTIES';

1685: acct_role.cust_account_id = role_acct.cust_account_id and
1686: role_acct.party_id = rel.object_id and
1687: rel.subject_id = p_party_id and
1688: rel.subject_table_name = 'HZ_PARTIES' and
1689: rel.object_table_name = 'HZ_PARTIES';
1690:
1691: a_contact get_delegate_contact%ROWTYPE;
1692: begin
1693: p_reason := EVENT_REASON_NO_REASON;