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 7028: per_all_people_f rather than the hr_locations.So commenting out

7024: end;
7025: --bug#3438608
7026:
7027: /*Bug 4504228 START Retrieving the phone and email contact of buyer from
7028: per_all_people_f rather than the hr_locations.So commenting out
7029: the below function and adding two functions getPhone(p_agent_id)
7030: and getEmail()*/
7031:
7032: /*function getPhone return varchar2 is

Line 7062: per_all_people_f pap

7058: pph.phone_number
7059: INTO PO_COMMUNICATION_PVT.g_buyer_email_address,
7060: PO_COMMUNICATION_PVT.g_buyer_phone
7061: FROM per_phones pph,
7062: per_all_people_f pap
7063: WHERE pph.parent_id(+) = pap.person_id
7064: AND pph.parent_table(+) = 'PER_ALL_PEOPLE_F'
7065: AND pph.phone_type (+) = 'W1'
7066: AND pap.person_id = p_agent_id

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

7060: PO_COMMUNICATION_PVT.g_buyer_phone
7061: FROM per_phones pph,
7062: per_all_people_f pap
7063: WHERE pph.parent_id(+) = pap.person_id
7064: AND pph.parent_table(+) = 'PER_ALL_PEOPLE_F'
7065: AND pph.phone_type (+) = 'W1'
7066: AND pap.person_id = p_agent_id
7067: AND trunc(sysdate) BETWEEN pap.effective_start_date AND pap.effective_end_date
7068: AND trunc(sysdate) BETWEEN nvl(pph.date_from, trunc(sysdate)) AND nvl(pph.date_to, trunc(sysdate))

Line 7086: per_all_people_f pap

7082: SELECT
7083: pph.phone_number
7084: INTO PO_COMMUNICATION_PVT.g_buyer_fax
7085: FROM per_phones pph,
7086: per_all_people_f pap
7087: WHERE pph.parent_id(+) = pap.person_id
7088: AND pph.parent_table(+) = 'PER_ALL_PEOPLE_F'
7089: AND pph.phone_type(+) = 'WF'
7090: AND pap.person_id = p_agent_id

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

7084: INTO PO_COMMUNICATION_PVT.g_buyer_fax
7085: FROM per_phones pph,
7086: per_all_people_f pap
7087: WHERE pph.parent_id(+) = pap.person_id
7088: AND pph.parent_table(+) = 'PER_ALL_PEOPLE_F'
7089: AND pph.phone_type(+) = 'WF'
7090: AND pap.person_id = p_agent_id
7091: AND trunc(sysdate) BETWEEN pap.effective_start_date AND pap.effective_end_date
7092: AND trunc(sysdate) BETWEEN nvl(pph.date_from, trunc(sysdate)) AND nvl(pph.date_to, trunc(sysdate)) -- bug#5999438

Line 7293: PER_ALL_PEOPLE_F HRE,

7289: INTO PO_COMMUNICATION_PVT.g_arcBuyer_fname, PO_COMMUNICATION_PVT.g_arcBuyer_lname,
7290: PO_COMMUNICATION_PVT.g_arcBuyer_title, PO_COMMUNICATION_PVT.g_arcAgent_id
7291:
7292: FROM
7293: PER_ALL_PEOPLE_F HRE,
7294: PO_HEADERS_ARCHIVE_ALL PHA,
7295: HR_LOOKUPS HRL
7296: WHERE HRL.LOOKUP_CODE(+) = HRE.TITLE AND
7297: HRL.LOOKUP_TYPE(+) = 'TITLE' AND

Line 7342: PER_ALL_PEOPLE_F HRE,

7338: PHA.AGENT_ID
7339: INTO PO_COMMUNICATION_PVT.g_arcBuyer_fname, PO_COMMUNICATION_PVT.g_arcBuyer_lname, PO_COMMUNICATION_PVT.g_arcAgent_id
7340:
7341: FROM
7342: PER_ALL_PEOPLE_F HRE,
7343: PO_RELEASES_ARCHIVE_ALL PHA
7344: WHERE
7345: HRE.PERSON_ID = PHA.AGENT_ID AND
7346: -- HRE.EMPLOYEE_NUMBER IS NOT NULL AND --