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.PO_COMMUNICATION_PVT dependencies on PER_ALL_PEOPLE_F

Line 60: g_arcBuyer_fname PER_ALL_PEOPLE_F.FIRST_NAME%type :=null;

56: g_agreement_number PO_HEADERS_ALL.SEGMENT1%type := null;
57: g_agreement_flag PO_HEADERS_ALL.GLOBAL_AGREEMENT_FLAG%type :=null;
58: g_agreementLine_number PO_LINES_ALL.LINE_NUM%type :=null;
59: g_line_id PO_LINES_ALL.FROM_LINE_ID%type :=null;
60: g_arcBuyer_fname PER_ALL_PEOPLE_F.FIRST_NAME%type :=null;
61: g_arcBuyer_lname PER_ALL_PEOPLE_F.LAST_NAME%type :=null;
62: g_arcBuyer_title PER_ALL_PEOPLE_F.TITLE%type :=null;
63: g_arcAgent_id PO_HEADERS_ARCHIVE_ALL.AGENT_ID%type :=null;
64: g_header_id1 PO_HEADERS_ALL.PO_HEADER_ID%type := null;

Line 61: g_arcBuyer_lname PER_ALL_PEOPLE_F.LAST_NAME%type :=null;

57: g_agreement_flag PO_HEADERS_ALL.GLOBAL_AGREEMENT_FLAG%type :=null;
58: g_agreementLine_number PO_LINES_ALL.LINE_NUM%type :=null;
59: g_line_id PO_LINES_ALL.FROM_LINE_ID%type :=null;
60: g_arcBuyer_fname PER_ALL_PEOPLE_F.FIRST_NAME%type :=null;
61: g_arcBuyer_lname PER_ALL_PEOPLE_F.LAST_NAME%type :=null;
62: g_arcBuyer_title PER_ALL_PEOPLE_F.TITLE%type :=null;
63: g_arcAgent_id PO_HEADERS_ARCHIVE_ALL.AGENT_ID%type :=null;
64: g_header_id1 PO_HEADERS_ALL.PO_HEADER_ID%type := null;
65: g_release_id PO_RELEASES_ALL.PO_RELEASE_ID%type :=null;

Line 62: g_arcBuyer_title PER_ALL_PEOPLE_F.TITLE%type :=null;

58: g_agreementLine_number PO_LINES_ALL.LINE_NUM%type :=null;
59: g_line_id PO_LINES_ALL.FROM_LINE_ID%type :=null;
60: g_arcBuyer_fname PER_ALL_PEOPLE_F.FIRST_NAME%type :=null;
61: g_arcBuyer_lname PER_ALL_PEOPLE_F.LAST_NAME%type :=null;
62: g_arcBuyer_title PER_ALL_PEOPLE_F.TITLE%type :=null;
63: g_arcAgent_id PO_HEADERS_ARCHIVE_ALL.AGENT_ID%type :=null;
64: g_header_id1 PO_HEADERS_ALL.PO_HEADER_ID%type := null;
65: g_release_id PO_RELEASES_ALL.PO_RELEASE_ID%type :=null;
66: g_timezone VARCHAR2(255) :=NULL;

Line 76: g_person_id PER_ALL_PEOPLE_F.PERSON_ID%type :=null;

72: g_job_id PO_LINES_ALL.JOB_ID%type :=null;
73: g_job_name PER_JOBS_VL.name%type :=null;
74: g_phone HR_LOCATIONS.TELEPHONE_NUMBER_1%type :=null;
75: --Bug 4504228 START
76: g_person_id PER_ALL_PEOPLE_F.PERSON_ID%type :=null;
77: g_buyer_email_address PER_ALL_PEOPLE_F.EMAIL_ADDRESS%type :=null;
78: g_buyer_phone PER_ALL_PEOPLE_F.office_number%type :=null;
79: --Bug 4504228 END
80: g_buyer_fax HR_LOCATIONS.TELEPHONE_NUMBER_2%type :=null; --Bug5671523 Adding g_buyer_fax

Line 77: g_buyer_email_address PER_ALL_PEOPLE_F.EMAIL_ADDRESS%type :=null;

73: g_job_name PER_JOBS_VL.name%type :=null;
74: g_phone HR_LOCATIONS.TELEPHONE_NUMBER_1%type :=null;
75: --Bug 4504228 START
76: g_person_id PER_ALL_PEOPLE_F.PERSON_ID%type :=null;
77: g_buyer_email_address PER_ALL_PEOPLE_F.EMAIL_ADDRESS%type :=null;
78: g_buyer_phone PER_ALL_PEOPLE_F.office_number%type :=null;
79: --Bug 4504228 END
80: g_buyer_fax HR_LOCATIONS.TELEPHONE_NUMBER_2%type :=null; --Bug5671523 Adding g_buyer_fax
81: g_fax HR_LOCATIONS.TELEPHONE_NUMBER_2%type :=null;

Line 78: g_buyer_phone PER_ALL_PEOPLE_F.office_number%type :=null;

74: g_phone HR_LOCATIONS.TELEPHONE_NUMBER_1%type :=null;
75: --Bug 4504228 START
76: g_person_id PER_ALL_PEOPLE_F.PERSON_ID%type :=null;
77: g_buyer_email_address PER_ALL_PEOPLE_F.EMAIL_ADDRESS%type :=null;
78: g_buyer_phone PER_ALL_PEOPLE_F.office_number%type :=null;
79: --Bug 4504228 END
80: g_buyer_fax HR_LOCATIONS.TELEPHONE_NUMBER_2%type :=null; --Bug5671523 Adding g_buyer_fax
81: g_fax HR_LOCATIONS.TELEPHONE_NUMBER_2%type :=null;
82: g_location_name HR_LOCATIONS.LOCATION_CODE%type :=null;

Line 5937: per_all_people_f rather than the hr_locations.So commenting out

5933: end;
5934: --bug#3438608
5935:
5936: /*Bug 4504228 START Retrieving the phone and email contact of buyer from
5937: per_all_people_f rather than the hr_locations.So commenting out
5938: the below function and adding two functions getPhone(p_agent_id)
5939: and getEmail()*/
5940:
5941: /*function getPhone return varchar2 is

Line 5969: per_all_people_f pap

5965: pph.phone_number
5966: INTO PO_COMMUNICATION_PVT.g_buyer_email_address,
5967: PO_COMMUNICATION_PVT.g_buyer_phone
5968: FROM per_phones pph,
5969: per_all_people_f pap
5970: WHERE pph.parent_id(+)=pap.person_id
5971: AND pph.parent_table(+)='PER_ALL_PEOPLE_F'
5972: AND pph.phone_type (+)= 'W1'
5973: AND pap.person_id = p_agent_id

Line 5971: AND pph.parent_table(+)='PER_ALL_PEOPLE_F'

5967: PO_COMMUNICATION_PVT.g_buyer_phone
5968: FROM per_phones pph,
5969: per_all_people_f pap
5970: WHERE pph.parent_id(+)=pap.person_id
5971: AND pph.parent_table(+)='PER_ALL_PEOPLE_F'
5972: AND pph.phone_type (+)= 'W1'
5973: AND pap.person_id = p_agent_id
5974: AND trunc(sysdate) BETWEEN pap.effective_start_date AND pap.effective_end_date
5975: AND trunc(sysdate) BETWEEN nvl(pph.date_from,trunc(sysdate)) AND nvl(pph.date_to,trunc(sysdate))

Line 5984: per_all_people_f pap

5980: SELECT
5981: pph.phone_number
5982: INTO PO_COMMUNICATION_PVT.g_buyer_fax
5983: FROM per_phones pph,
5984: per_all_people_f pap
5985: WHERE pph.parent_id(+)=pap.person_id
5986: AND pph.parent_table(+)='PER_ALL_PEOPLE_F'
5987: AND pph.phone_type(+)='WF'
5988: AND pap.person_id = p_agent_id

Line 5986: AND pph.parent_table(+)='PER_ALL_PEOPLE_F'

5982: INTO PO_COMMUNICATION_PVT.g_buyer_fax
5983: FROM per_phones pph,
5984: per_all_people_f pap
5985: WHERE pph.parent_id(+)=pap.person_id
5986: AND pph.parent_table(+)='PER_ALL_PEOPLE_F'
5987: AND pph.phone_type(+)='WF'
5988: AND pap.person_id = p_agent_id
5989: AND trunc(sysdate) BETWEEN pap.effective_start_date AND pap.effective_end_date
5990: AND trunc(sysdate) BETWEEN nvl(pph.date_from,trunc(sysdate)) AND nvl(pph.date_to,trunc(sysdate)) -- bug#5999438

Line 6185: PER_ALL_PEOPLE_F HRE,

6181: INTO PO_COMMUNICATION_PVT.g_arcBuyer_fname, PO_COMMUNICATION_PVT.g_arcBuyer_lname,
6182: PO_COMMUNICATION_PVT.g_arcBuyer_title, PO_COMMUNICATION_PVT.g_arcAgent_id
6183:
6184: FROM
6185: PER_ALL_PEOPLE_F HRE,
6186: PO_HEADERS_ARCHIVE_ALL PHA
6187: WHERE
6188: HRE.PERSON_ID = PHA.AGENT_ID AND
6189: --HRE.EMPLOYEE_NUMBER IS NOT NULL AND --

Line 6232: PER_ALL_PEOPLE_F HRE,

6228: PHA.AGENT_ID
6229: INTO PO_COMMUNICATION_PVT.g_arcBuyer_fname, PO_COMMUNICATION_PVT.g_arcBuyer_lname, PO_COMMUNICATION_PVT.g_arcAgent_id
6230:
6231: FROM
6232: PER_ALL_PEOPLE_F HRE,
6233: PO_RELEASES_ARCHIVE_ALL PHA
6234: WHERE
6235: HRE.PERSON_ID = PHA.AGENT_ID AND
6236: -- HRE.EMPLOYEE_NUMBER IS NOT NULL AND --