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_RS_RESOURCE_PVT dependencies on JTF_RS_RESOURCE_EXTNS_S

Line 75: P_SOURCE_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_ID%TYPE,

71: (P_API_VERSION IN NUMBER,
72: P_INIT_MSG_LIST IN VARCHAR2,
73: P_COMMIT IN VARCHAR2,
74: P_CATEGORY IN JTF_RS_RESOURCE_EXTNS.CATEGORY%TYPE,
75: P_SOURCE_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_ID%TYPE,
76: P_ADDRESS_ID IN JTF_RS_RESOURCE_EXTNS.ADDRESS_ID%TYPE,
77: P_CONTACT_ID IN JTF_RS_RESOURCE_EXTNS.CONTACT_ID%TYPE,
78: P_MANAGING_EMP_ID IN JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE,
79: P_START_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE,

Line 79: P_START_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE,

75: P_SOURCE_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_ID%TYPE,
76: P_ADDRESS_ID IN JTF_RS_RESOURCE_EXTNS.ADDRESS_ID%TYPE,
77: P_CONTACT_ID IN JTF_RS_RESOURCE_EXTNS.CONTACT_ID%TYPE,
78: P_MANAGING_EMP_ID IN JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE,
79: P_START_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE,
80: P_END_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE,
81: P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE,
82: P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE,
83: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE,

Line 84: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE,

80: P_END_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE,
81: P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE,
82: P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE,
83: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE,
84: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE,
85: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE,
86: P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE,
87: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE,
88: P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE,

Line 85: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE,

81: P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE,
82: P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE,
83: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE,
84: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE,
85: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE,
86: P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE,
87: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE,
88: P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE,
89: P_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE,

Line 87: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE,

83: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE,
84: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE,
85: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE,
86: P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE,
87: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE,
88: P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE,
89: P_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE,
90: P_CHARGE_TO_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE,
91: P_COMP_CURRENCY_CODE IN JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE,

Line 126: l_source_id jtf_rs_resource_extns.source_id%TYPE;

122: l_api_version CONSTANT NUMBER := 1.0;
123: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RESOURCE';
124: /* Moved the initial assignment of below variables to inside begin */
125: l_category jtf_rs_resource_extns.category%TYPE;
126: l_source_id jtf_rs_resource_extns.source_id%TYPE;
127: l_address_id jtf_rs_resource_extns.address_id%TYPE;
128: l_contact_id jtf_rs_resource_extns.contact_id%TYPE;
129: l_managing_emp_id jtf_rs_resource_extns.managing_employee_id%TYPE;
130: -- added trunc in both dates feb 6 2002

Line 131: l_start_date_active jtf_rs_resource_extns.start_date_active%TYPE;

127: l_address_id jtf_rs_resource_extns.address_id%TYPE;
128: l_contact_id jtf_rs_resource_extns.contact_id%TYPE;
129: l_managing_emp_id jtf_rs_resource_extns.managing_employee_id%TYPE;
130: -- added trunc in both dates feb 6 2002
131: l_start_date_active jtf_rs_resource_extns.start_date_active%TYPE;
132: l_end_date_active jtf_rs_resource_extns.end_date_active%TYPE;
133: l_time_zone jtf_rs_resource_extns.time_zone%TYPE;
134: l_cost_per_hr jtf_rs_resource_extns.cost_per_hr%TYPE;
135: l_primary_language jtf_rs_resource_extns.primary_language%TYPE;

Line 136: l_secondary_language jtf_rs_resource_extns.secondary_language%TYPE;

132: l_end_date_active jtf_rs_resource_extns.end_date_active%TYPE;
133: l_time_zone jtf_rs_resource_extns.time_zone%TYPE;
134: l_cost_per_hr jtf_rs_resource_extns.cost_per_hr%TYPE;
135: l_primary_language jtf_rs_resource_extns.primary_language%TYPE;
136: l_secondary_language jtf_rs_resource_extns.secondary_language%TYPE;
137: l_support_site_id jtf_rs_resource_extns.support_site_id%TYPE;
138: l_ies_agent_login jtf_rs_resource_extns.ies_agent_login%TYPE;
139: l_server_group_id jtf_rs_resource_extns.server_group_id%TYPE;
140: l_assigned_to_group_id jtf_rs_resource_extns.assigned_to_group_id%TYPE;

Line 137: l_support_site_id jtf_rs_resource_extns.support_site_id%TYPE;

133: l_time_zone jtf_rs_resource_extns.time_zone%TYPE;
134: l_cost_per_hr jtf_rs_resource_extns.cost_per_hr%TYPE;
135: l_primary_language jtf_rs_resource_extns.primary_language%TYPE;
136: l_secondary_language jtf_rs_resource_extns.secondary_language%TYPE;
137: l_support_site_id jtf_rs_resource_extns.support_site_id%TYPE;
138: l_ies_agent_login jtf_rs_resource_extns.ies_agent_login%TYPE;
139: l_server_group_id jtf_rs_resource_extns.server_group_id%TYPE;
140: l_assigned_to_group_id jtf_rs_resource_extns.assigned_to_group_id%TYPE;
141: l_cost_center jtf_rs_resource_extns.cost_center%TYPE;

Line 139: l_server_group_id jtf_rs_resource_extns.server_group_id%TYPE;

135: l_primary_language jtf_rs_resource_extns.primary_language%TYPE;
136: l_secondary_language jtf_rs_resource_extns.secondary_language%TYPE;
137: l_support_site_id jtf_rs_resource_extns.support_site_id%TYPE;
138: l_ies_agent_login jtf_rs_resource_extns.ies_agent_login%TYPE;
139: l_server_group_id jtf_rs_resource_extns.server_group_id%TYPE;
140: l_assigned_to_group_id jtf_rs_resource_extns.assigned_to_group_id%TYPE;
141: l_cost_center jtf_rs_resource_extns.cost_center%TYPE;
142: l_charge_to_cost_center jtf_rs_resource_extns.charge_to_cost_center%TYPE;
143: l_comp_currency_code jtf_rs_resource_extns.compensation_currency_code%TYPE;

Line 468: SELECT jtf_rs_resource_extns_s.nextval

464:
465: /* Get the next value of the Resource_id from the sequence. */
466:
467: LOOP
468: SELECT jtf_rs_resource_extns_s.nextval
469: INTO l_resource_id
470: FROM dual;
471: --dbms_output.put_line ('After Select - Resource ID ' || l_resource_id);
472: OPEN c_dup_resource_id (l_resource_id);

Line 913: P_SOURCE_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_ID%TYPE,

909: (P_API_VERSION IN NUMBER,
910: P_INIT_MSG_LIST IN VARCHAR2,
911: P_COMMIT IN VARCHAR2,
912: P_CATEGORY IN JTF_RS_RESOURCE_EXTNS.CATEGORY%TYPE,
913: P_SOURCE_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_ID%TYPE,
914: P_ADDRESS_ID IN JTF_RS_RESOURCE_EXTNS.ADDRESS_ID%TYPE,
915: P_CONTACT_ID IN JTF_RS_RESOURCE_EXTNS.CONTACT_ID%TYPE,
916: P_MANAGING_EMP_ID IN JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE,
917: P_START_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE,

Line 917: P_START_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE,

913: P_SOURCE_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_ID%TYPE,
914: P_ADDRESS_ID IN JTF_RS_RESOURCE_EXTNS.ADDRESS_ID%TYPE,
915: P_CONTACT_ID IN JTF_RS_RESOURCE_EXTNS.CONTACT_ID%TYPE,
916: P_MANAGING_EMP_ID IN JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE,
917: P_START_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE,
918: P_END_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE,
919: P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE,
920: P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE,
921: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE,

Line 922: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE,

918: P_END_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE,
919: P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE,
920: P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE,
921: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE,
922: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE,
923: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE,
924: P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE,
925: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE,
926: P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE,

Line 923: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE,

919: P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE,
920: P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE,
921: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE,
922: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE,
923: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE,
924: P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE,
925: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE,
926: P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE,
927: P_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE,

Line 925: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE,

921: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE,
922: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE,
923: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE,
924: P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE,
925: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE,
926: P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE,
927: P_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE,
928: P_CHARGE_TO_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE,
929: P_COMP_CURRENCY_CODE IN JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE,

Line 954: P_SOURCE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_NAME%TYPE ,

950: P_ATTRIBUTE14 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE14%TYPE,
951: P_ATTRIBUTE15 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE15%TYPE,
952: P_ATTRIBUTE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE_CATEGORY%TYPE,
953: P_RESOURCE_NAME IN JTF_RS_RESOURCE_EXTNS_TL.RESOURCE_NAME%TYPE,
954: P_SOURCE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_NAME%TYPE ,
955: P_SOURCE_NUMBER IN JTF_RS_RESOURCE_EXTNS.SOURCE_NUMBER%TYPE,
956: P_SOURCE_JOB_TITLE IN JTF_RS_RESOURCE_EXTNS.SOURCE_JOB_TITLE%TYPE,
957: P_SOURCE_EMAIL IN JTF_RS_RESOURCE_EXTNS.SOURCE_EMAIL%TYPE,
958: P_SOURCE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PHONE%TYPE,

Line 955: P_SOURCE_NUMBER IN JTF_RS_RESOURCE_EXTNS.SOURCE_NUMBER%TYPE,

951: P_ATTRIBUTE15 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE15%TYPE,
952: P_ATTRIBUTE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE_CATEGORY%TYPE,
953: P_RESOURCE_NAME IN JTF_RS_RESOURCE_EXTNS_TL.RESOURCE_NAME%TYPE,
954: P_SOURCE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_NAME%TYPE ,
955: P_SOURCE_NUMBER IN JTF_RS_RESOURCE_EXTNS.SOURCE_NUMBER%TYPE,
956: P_SOURCE_JOB_TITLE IN JTF_RS_RESOURCE_EXTNS.SOURCE_JOB_TITLE%TYPE,
957: P_SOURCE_EMAIL IN JTF_RS_RESOURCE_EXTNS.SOURCE_EMAIL%TYPE,
958: P_SOURCE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PHONE%TYPE,
959: P_SOURCE_ORG_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_ORG_ID%TYPE,

Line 956: P_SOURCE_JOB_TITLE IN JTF_RS_RESOURCE_EXTNS.SOURCE_JOB_TITLE%TYPE,

952: P_ATTRIBUTE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE_CATEGORY%TYPE,
953: P_RESOURCE_NAME IN JTF_RS_RESOURCE_EXTNS_TL.RESOURCE_NAME%TYPE,
954: P_SOURCE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_NAME%TYPE ,
955: P_SOURCE_NUMBER IN JTF_RS_RESOURCE_EXTNS.SOURCE_NUMBER%TYPE,
956: P_SOURCE_JOB_TITLE IN JTF_RS_RESOURCE_EXTNS.SOURCE_JOB_TITLE%TYPE,
957: P_SOURCE_EMAIL IN JTF_RS_RESOURCE_EXTNS.SOURCE_EMAIL%TYPE,
958: P_SOURCE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PHONE%TYPE,
959: P_SOURCE_ORG_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_ORG_ID%TYPE,
960: P_SOURCE_ORG_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_ORG_NAME%TYPE,

Line 957: P_SOURCE_EMAIL IN JTF_RS_RESOURCE_EXTNS.SOURCE_EMAIL%TYPE,

953: P_RESOURCE_NAME IN JTF_RS_RESOURCE_EXTNS_TL.RESOURCE_NAME%TYPE,
954: P_SOURCE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_NAME%TYPE ,
955: P_SOURCE_NUMBER IN JTF_RS_RESOURCE_EXTNS.SOURCE_NUMBER%TYPE,
956: P_SOURCE_JOB_TITLE IN JTF_RS_RESOURCE_EXTNS.SOURCE_JOB_TITLE%TYPE,
957: P_SOURCE_EMAIL IN JTF_RS_RESOURCE_EXTNS.SOURCE_EMAIL%TYPE,
958: P_SOURCE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PHONE%TYPE,
959: P_SOURCE_ORG_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_ORG_ID%TYPE,
960: P_SOURCE_ORG_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_ORG_NAME%TYPE,
961: P_SOURCE_ADDRESS1 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS1%TYPE,

Line 958: P_SOURCE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PHONE%TYPE,

954: P_SOURCE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_NAME%TYPE ,
955: P_SOURCE_NUMBER IN JTF_RS_RESOURCE_EXTNS.SOURCE_NUMBER%TYPE,
956: P_SOURCE_JOB_TITLE IN JTF_RS_RESOURCE_EXTNS.SOURCE_JOB_TITLE%TYPE,
957: P_SOURCE_EMAIL IN JTF_RS_RESOURCE_EXTNS.SOURCE_EMAIL%TYPE,
958: P_SOURCE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PHONE%TYPE,
959: P_SOURCE_ORG_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_ORG_ID%TYPE,
960: P_SOURCE_ORG_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_ORG_NAME%TYPE,
961: P_SOURCE_ADDRESS1 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS1%TYPE,
962: P_SOURCE_ADDRESS2 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS2%TYPE,

Line 959: P_SOURCE_ORG_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_ORG_ID%TYPE,

955: P_SOURCE_NUMBER IN JTF_RS_RESOURCE_EXTNS.SOURCE_NUMBER%TYPE,
956: P_SOURCE_JOB_TITLE IN JTF_RS_RESOURCE_EXTNS.SOURCE_JOB_TITLE%TYPE,
957: P_SOURCE_EMAIL IN JTF_RS_RESOURCE_EXTNS.SOURCE_EMAIL%TYPE,
958: P_SOURCE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PHONE%TYPE,
959: P_SOURCE_ORG_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_ORG_ID%TYPE,
960: P_SOURCE_ORG_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_ORG_NAME%TYPE,
961: P_SOURCE_ADDRESS1 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS1%TYPE,
962: P_SOURCE_ADDRESS2 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS2%TYPE,
963: P_SOURCE_ADDRESS3 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS3%TYPE,

Line 960: P_SOURCE_ORG_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_ORG_NAME%TYPE,

956: P_SOURCE_JOB_TITLE IN JTF_RS_RESOURCE_EXTNS.SOURCE_JOB_TITLE%TYPE,
957: P_SOURCE_EMAIL IN JTF_RS_RESOURCE_EXTNS.SOURCE_EMAIL%TYPE,
958: P_SOURCE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PHONE%TYPE,
959: P_SOURCE_ORG_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_ORG_ID%TYPE,
960: P_SOURCE_ORG_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_ORG_NAME%TYPE,
961: P_SOURCE_ADDRESS1 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS1%TYPE,
962: P_SOURCE_ADDRESS2 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS2%TYPE,
963: P_SOURCE_ADDRESS3 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS3%TYPE,
964: P_SOURCE_ADDRESS4 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS4%TYPE,

Line 961: P_SOURCE_ADDRESS1 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS1%TYPE,

957: P_SOURCE_EMAIL IN JTF_RS_RESOURCE_EXTNS.SOURCE_EMAIL%TYPE,
958: P_SOURCE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PHONE%TYPE,
959: P_SOURCE_ORG_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_ORG_ID%TYPE,
960: P_SOURCE_ORG_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_ORG_NAME%TYPE,
961: P_SOURCE_ADDRESS1 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS1%TYPE,
962: P_SOURCE_ADDRESS2 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS2%TYPE,
963: P_SOURCE_ADDRESS3 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS3%TYPE,
964: P_SOURCE_ADDRESS4 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS4%TYPE,
965: P_SOURCE_CITY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CITY%TYPE,

Line 962: P_SOURCE_ADDRESS2 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS2%TYPE,

958: P_SOURCE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PHONE%TYPE,
959: P_SOURCE_ORG_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_ORG_ID%TYPE,
960: P_SOURCE_ORG_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_ORG_NAME%TYPE,
961: P_SOURCE_ADDRESS1 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS1%TYPE,
962: P_SOURCE_ADDRESS2 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS2%TYPE,
963: P_SOURCE_ADDRESS3 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS3%TYPE,
964: P_SOURCE_ADDRESS4 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS4%TYPE,
965: P_SOURCE_CITY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CITY%TYPE,
966: P_SOURCE_POSTAL_CODE IN JTF_RS_RESOURCE_EXTNS.SOURCE_POSTAL_CODE%TYPE,

Line 963: P_SOURCE_ADDRESS3 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS3%TYPE,

959: P_SOURCE_ORG_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_ORG_ID%TYPE,
960: P_SOURCE_ORG_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_ORG_NAME%TYPE,
961: P_SOURCE_ADDRESS1 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS1%TYPE,
962: P_SOURCE_ADDRESS2 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS2%TYPE,
963: P_SOURCE_ADDRESS3 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS3%TYPE,
964: P_SOURCE_ADDRESS4 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS4%TYPE,
965: P_SOURCE_CITY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CITY%TYPE,
966: P_SOURCE_POSTAL_CODE IN JTF_RS_RESOURCE_EXTNS.SOURCE_POSTAL_CODE%TYPE,
967: P_SOURCE_STATE IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATE%TYPE,

Line 964: P_SOURCE_ADDRESS4 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS4%TYPE,

960: P_SOURCE_ORG_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_ORG_NAME%TYPE,
961: P_SOURCE_ADDRESS1 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS1%TYPE,
962: P_SOURCE_ADDRESS2 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS2%TYPE,
963: P_SOURCE_ADDRESS3 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS3%TYPE,
964: P_SOURCE_ADDRESS4 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS4%TYPE,
965: P_SOURCE_CITY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CITY%TYPE,
966: P_SOURCE_POSTAL_CODE IN JTF_RS_RESOURCE_EXTNS.SOURCE_POSTAL_CODE%TYPE,
967: P_SOURCE_STATE IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATE%TYPE,
968: P_SOURCE_PROVINCE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PROVINCE%TYPE,

Line 965: P_SOURCE_CITY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CITY%TYPE,

961: P_SOURCE_ADDRESS1 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS1%TYPE,
962: P_SOURCE_ADDRESS2 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS2%TYPE,
963: P_SOURCE_ADDRESS3 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS3%TYPE,
964: P_SOURCE_ADDRESS4 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS4%TYPE,
965: P_SOURCE_CITY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CITY%TYPE,
966: P_SOURCE_POSTAL_CODE IN JTF_RS_RESOURCE_EXTNS.SOURCE_POSTAL_CODE%TYPE,
967: P_SOURCE_STATE IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATE%TYPE,
968: P_SOURCE_PROVINCE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PROVINCE%TYPE,
969: P_SOURCE_COUNTY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTY%TYPE,

Line 966: P_SOURCE_POSTAL_CODE IN JTF_RS_RESOURCE_EXTNS.SOURCE_POSTAL_CODE%TYPE,

962: P_SOURCE_ADDRESS2 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS2%TYPE,
963: P_SOURCE_ADDRESS3 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS3%TYPE,
964: P_SOURCE_ADDRESS4 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS4%TYPE,
965: P_SOURCE_CITY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CITY%TYPE,
966: P_SOURCE_POSTAL_CODE IN JTF_RS_RESOURCE_EXTNS.SOURCE_POSTAL_CODE%TYPE,
967: P_SOURCE_STATE IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATE%TYPE,
968: P_SOURCE_PROVINCE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PROVINCE%TYPE,
969: P_SOURCE_COUNTY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTY%TYPE,
970: P_SOURCE_COUNTRY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTRY%TYPE,

Line 967: P_SOURCE_STATE IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATE%TYPE,

963: P_SOURCE_ADDRESS3 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS3%TYPE,
964: P_SOURCE_ADDRESS4 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS4%TYPE,
965: P_SOURCE_CITY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CITY%TYPE,
966: P_SOURCE_POSTAL_CODE IN JTF_RS_RESOURCE_EXTNS.SOURCE_POSTAL_CODE%TYPE,
967: P_SOURCE_STATE IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATE%TYPE,
968: P_SOURCE_PROVINCE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PROVINCE%TYPE,
969: P_SOURCE_COUNTY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTY%TYPE,
970: P_SOURCE_COUNTRY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTRY%TYPE,
971: P_SOURCE_MGR_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_ID%type,

Line 968: P_SOURCE_PROVINCE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PROVINCE%TYPE,

964: P_SOURCE_ADDRESS4 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS4%TYPE,
965: P_SOURCE_CITY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CITY%TYPE,
966: P_SOURCE_POSTAL_CODE IN JTF_RS_RESOURCE_EXTNS.SOURCE_POSTAL_CODE%TYPE,
967: P_SOURCE_STATE IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATE%TYPE,
968: P_SOURCE_PROVINCE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PROVINCE%TYPE,
969: P_SOURCE_COUNTY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTY%TYPE,
970: P_SOURCE_COUNTRY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTRY%TYPE,
971: P_SOURCE_MGR_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_ID%type,
972: P_SOURCE_MGR_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_NAME%type,

Line 969: P_SOURCE_COUNTY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTY%TYPE,

965: P_SOURCE_CITY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CITY%TYPE,
966: P_SOURCE_POSTAL_CODE IN JTF_RS_RESOURCE_EXTNS.SOURCE_POSTAL_CODE%TYPE,
967: P_SOURCE_STATE IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATE%TYPE,
968: P_SOURCE_PROVINCE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PROVINCE%TYPE,
969: P_SOURCE_COUNTY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTY%TYPE,
970: P_SOURCE_COUNTRY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTRY%TYPE,
971: P_SOURCE_MGR_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_ID%type,
972: P_SOURCE_MGR_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_NAME%type,
973: P_SOURCE_BUSINESS_GRP_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_ID%type,

Line 970: P_SOURCE_COUNTRY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTRY%TYPE,

966: P_SOURCE_POSTAL_CODE IN JTF_RS_RESOURCE_EXTNS.SOURCE_POSTAL_CODE%TYPE,
967: P_SOURCE_STATE IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATE%TYPE,
968: P_SOURCE_PROVINCE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PROVINCE%TYPE,
969: P_SOURCE_COUNTY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTY%TYPE,
970: P_SOURCE_COUNTRY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTRY%TYPE,
971: P_SOURCE_MGR_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_ID%type,
972: P_SOURCE_MGR_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_NAME%type,
973: P_SOURCE_BUSINESS_GRP_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_ID%type,
974: P_SOURCE_BUSINESS_GRP_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_NAME%type,

Line 971: P_SOURCE_MGR_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_ID%type,

967: P_SOURCE_STATE IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATE%TYPE,
968: P_SOURCE_PROVINCE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PROVINCE%TYPE,
969: P_SOURCE_COUNTY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTY%TYPE,
970: P_SOURCE_COUNTRY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTRY%TYPE,
971: P_SOURCE_MGR_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_ID%type,
972: P_SOURCE_MGR_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_NAME%type,
973: P_SOURCE_BUSINESS_GRP_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_ID%type,
974: P_SOURCE_BUSINESS_GRP_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_NAME%type,
975: P_SOURCE_FIRST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_FIRST_NAME%TYPE,

Line 972: P_SOURCE_MGR_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_NAME%type,

968: P_SOURCE_PROVINCE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PROVINCE%TYPE,
969: P_SOURCE_COUNTY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTY%TYPE,
970: P_SOURCE_COUNTRY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTRY%TYPE,
971: P_SOURCE_MGR_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_ID%type,
972: P_SOURCE_MGR_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_NAME%type,
973: P_SOURCE_BUSINESS_GRP_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_ID%type,
974: P_SOURCE_BUSINESS_GRP_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_NAME%type,
975: P_SOURCE_FIRST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_FIRST_NAME%TYPE,
976: P_SOURCE_LAST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_LAST_NAME%TYPE,

Line 973: P_SOURCE_BUSINESS_GRP_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_ID%type,

969: P_SOURCE_COUNTY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTY%TYPE,
970: P_SOURCE_COUNTRY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTRY%TYPE,
971: P_SOURCE_MGR_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_ID%type,
972: P_SOURCE_MGR_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_NAME%type,
973: P_SOURCE_BUSINESS_GRP_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_ID%type,
974: P_SOURCE_BUSINESS_GRP_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_NAME%type,
975: P_SOURCE_FIRST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_FIRST_NAME%TYPE,
976: P_SOURCE_LAST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_LAST_NAME%TYPE,
977: P_SOURCE_MIDDLE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MIDDLE_NAME%TYPE,

Line 974: P_SOURCE_BUSINESS_GRP_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_NAME%type,

970: P_SOURCE_COUNTRY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTRY%TYPE,
971: P_SOURCE_MGR_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_ID%type,
972: P_SOURCE_MGR_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_NAME%type,
973: P_SOURCE_BUSINESS_GRP_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_ID%type,
974: P_SOURCE_BUSINESS_GRP_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_NAME%type,
975: P_SOURCE_FIRST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_FIRST_NAME%TYPE,
976: P_SOURCE_LAST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_LAST_NAME%TYPE,
977: P_SOURCE_MIDDLE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MIDDLE_NAME%TYPE,
978: P_SOURCE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CATEGORY%TYPE,

Line 975: P_SOURCE_FIRST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_FIRST_NAME%TYPE,

971: P_SOURCE_MGR_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_ID%type,
972: P_SOURCE_MGR_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_NAME%type,
973: P_SOURCE_BUSINESS_GRP_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_ID%type,
974: P_SOURCE_BUSINESS_GRP_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_NAME%type,
975: P_SOURCE_FIRST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_FIRST_NAME%TYPE,
976: P_SOURCE_LAST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_LAST_NAME%TYPE,
977: P_SOURCE_MIDDLE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MIDDLE_NAME%TYPE,
978: P_SOURCE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CATEGORY%TYPE,
979: P_SOURCE_STATUS IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATUS%TYPE,

Line 976: P_SOURCE_LAST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_LAST_NAME%TYPE,

972: P_SOURCE_MGR_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_NAME%type,
973: P_SOURCE_BUSINESS_GRP_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_ID%type,
974: P_SOURCE_BUSINESS_GRP_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_NAME%type,
975: P_SOURCE_FIRST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_FIRST_NAME%TYPE,
976: P_SOURCE_LAST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_LAST_NAME%TYPE,
977: P_SOURCE_MIDDLE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MIDDLE_NAME%TYPE,
978: P_SOURCE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CATEGORY%TYPE,
979: P_SOURCE_STATUS IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATUS%TYPE,
980: P_SOURCE_OFFICE IN JTF_RS_RESOURCE_EXTNS.SOURCE_OFFICE%TYPE,

Line 977: P_SOURCE_MIDDLE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MIDDLE_NAME%TYPE,

973: P_SOURCE_BUSINESS_GRP_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_ID%type,
974: P_SOURCE_BUSINESS_GRP_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_NAME%type,
975: P_SOURCE_FIRST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_FIRST_NAME%TYPE,
976: P_SOURCE_LAST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_LAST_NAME%TYPE,
977: P_SOURCE_MIDDLE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MIDDLE_NAME%TYPE,
978: P_SOURCE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CATEGORY%TYPE,
979: P_SOURCE_STATUS IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATUS%TYPE,
980: P_SOURCE_OFFICE IN JTF_RS_RESOURCE_EXTNS.SOURCE_OFFICE%TYPE,
981: P_SOURCE_LOCATION IN JTF_RS_RESOURCE_EXTNS.SOURCE_LOCATION%TYPE,

Line 978: P_SOURCE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CATEGORY%TYPE,

974: P_SOURCE_BUSINESS_GRP_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_NAME%type,
975: P_SOURCE_FIRST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_FIRST_NAME%TYPE,
976: P_SOURCE_LAST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_LAST_NAME%TYPE,
977: P_SOURCE_MIDDLE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MIDDLE_NAME%TYPE,
978: P_SOURCE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CATEGORY%TYPE,
979: P_SOURCE_STATUS IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATUS%TYPE,
980: P_SOURCE_OFFICE IN JTF_RS_RESOURCE_EXTNS.SOURCE_OFFICE%TYPE,
981: P_SOURCE_LOCATION IN JTF_RS_RESOURCE_EXTNS.SOURCE_LOCATION%TYPE,
982: P_SOURCE_MAILSTOP IN JTF_RS_RESOURCE_EXTNS.SOURCE_MAILSTOP%TYPE,

Line 979: P_SOURCE_STATUS IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATUS%TYPE,

975: P_SOURCE_FIRST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_FIRST_NAME%TYPE,
976: P_SOURCE_LAST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_LAST_NAME%TYPE,
977: P_SOURCE_MIDDLE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MIDDLE_NAME%TYPE,
978: P_SOURCE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CATEGORY%TYPE,
979: P_SOURCE_STATUS IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATUS%TYPE,
980: P_SOURCE_OFFICE IN JTF_RS_RESOURCE_EXTNS.SOURCE_OFFICE%TYPE,
981: P_SOURCE_LOCATION IN JTF_RS_RESOURCE_EXTNS.SOURCE_LOCATION%TYPE,
982: P_SOURCE_MAILSTOP IN JTF_RS_RESOURCE_EXTNS.SOURCE_MAILSTOP%TYPE,
983: P_USER_NAME IN VARCHAR2,

Line 980: P_SOURCE_OFFICE IN JTF_RS_RESOURCE_EXTNS.SOURCE_OFFICE%TYPE,

976: P_SOURCE_LAST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_LAST_NAME%TYPE,
977: P_SOURCE_MIDDLE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MIDDLE_NAME%TYPE,
978: P_SOURCE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CATEGORY%TYPE,
979: P_SOURCE_STATUS IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATUS%TYPE,
980: P_SOURCE_OFFICE IN JTF_RS_RESOURCE_EXTNS.SOURCE_OFFICE%TYPE,
981: P_SOURCE_LOCATION IN JTF_RS_RESOURCE_EXTNS.SOURCE_LOCATION%TYPE,
982: P_SOURCE_MAILSTOP IN JTF_RS_RESOURCE_EXTNS.SOURCE_MAILSTOP%TYPE,
983: P_USER_NAME IN VARCHAR2,
984: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 981: P_SOURCE_LOCATION IN JTF_RS_RESOURCE_EXTNS.SOURCE_LOCATION%TYPE,

977: P_SOURCE_MIDDLE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MIDDLE_NAME%TYPE,
978: P_SOURCE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CATEGORY%TYPE,
979: P_SOURCE_STATUS IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATUS%TYPE,
980: P_SOURCE_OFFICE IN JTF_RS_RESOURCE_EXTNS.SOURCE_OFFICE%TYPE,
981: P_SOURCE_LOCATION IN JTF_RS_RESOURCE_EXTNS.SOURCE_LOCATION%TYPE,
982: P_SOURCE_MAILSTOP IN JTF_RS_RESOURCE_EXTNS.SOURCE_MAILSTOP%TYPE,
983: P_USER_NAME IN VARCHAR2,
984: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
985: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 982: P_SOURCE_MAILSTOP IN JTF_RS_RESOURCE_EXTNS.SOURCE_MAILSTOP%TYPE,

978: P_SOURCE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CATEGORY%TYPE,
979: P_SOURCE_STATUS IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATUS%TYPE,
980: P_SOURCE_OFFICE IN JTF_RS_RESOURCE_EXTNS.SOURCE_OFFICE%TYPE,
981: P_SOURCE_LOCATION IN JTF_RS_RESOURCE_EXTNS.SOURCE_LOCATION%TYPE,
982: P_SOURCE_MAILSTOP IN JTF_RS_RESOURCE_EXTNS.SOURCE_MAILSTOP%TYPE,
983: P_USER_NAME IN VARCHAR2,
984: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
985: X_MSG_COUNT OUT NOCOPY NUMBER,
986: X_MSG_DATA OUT NOCOPY VARCHAR2,

Line 989: P_SOURCE_MOBILE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_MOBILE_PHONE%TYPE,

985: X_MSG_COUNT OUT NOCOPY NUMBER,
986: X_MSG_DATA OUT NOCOPY VARCHAR2,
987: X_RESOURCE_ID OUT NOCOPY JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,
988: X_RESOURCE_NUMBER OUT NOCOPY JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE,
989: P_SOURCE_MOBILE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_MOBILE_PHONE%TYPE,
990: P_SOURCE_PAGER IN JTF_RS_RESOURCE_EXTNS.SOURCE_PAGER%TYPE
991: ) IS
992:
993: l_api_version CONSTANT NUMBER := 1.0;

Line 990: P_SOURCE_PAGER IN JTF_RS_RESOURCE_EXTNS.SOURCE_PAGER%TYPE

986: X_MSG_DATA OUT NOCOPY VARCHAR2,
987: X_RESOURCE_ID OUT NOCOPY JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,
988: X_RESOURCE_NUMBER OUT NOCOPY JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE,
989: P_SOURCE_MOBILE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_MOBILE_PHONE%TYPE,
990: P_SOURCE_PAGER IN JTF_RS_RESOURCE_EXTNS.SOURCE_PAGER%TYPE
991: ) IS
992:
993: l_api_version CONSTANT NUMBER := 1.0;
994: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RESOURCE';

Line 997: l_source_id jtf_rs_resource_extns.source_id%TYPE;

993: l_api_version CONSTANT NUMBER := 1.0;
994: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RESOURCE';
995: /* Moved the initial assignment of below variables to inside begin */
996: l_category jtf_rs_resource_extns.category%TYPE;
997: l_source_id jtf_rs_resource_extns.source_id%TYPE;
998: l_address_id jtf_rs_resource_extns.address_id%TYPE;
999: l_contact_id jtf_rs_resource_extns.contact_id%TYPE;
1000: l_managing_emp_id jtf_rs_resource_extns.managing_employee_id%TYPE;
1001: l_start_date_active jtf_rs_resource_extns.start_date_active%TYPE;

Line 1001: l_start_date_active jtf_rs_resource_extns.start_date_active%TYPE;

997: l_source_id jtf_rs_resource_extns.source_id%TYPE;
998: l_address_id jtf_rs_resource_extns.address_id%TYPE;
999: l_contact_id jtf_rs_resource_extns.contact_id%TYPE;
1000: l_managing_emp_id jtf_rs_resource_extns.managing_employee_id%TYPE;
1001: l_start_date_active jtf_rs_resource_extns.start_date_active%TYPE;
1002: l_end_date_active jtf_rs_resource_extns.end_date_active%TYPE;
1003: l_time_zone jtf_rs_resource_extns.time_zone%TYPE;
1004: l_cost_per_hr jtf_rs_resource_extns.cost_per_hr%TYPE;
1005: l_primary_language jtf_rs_resource_extns.primary_language%TYPE;

Line 1006: l_secondary_language jtf_rs_resource_extns.secondary_language%TYPE;

1002: l_end_date_active jtf_rs_resource_extns.end_date_active%TYPE;
1003: l_time_zone jtf_rs_resource_extns.time_zone%TYPE;
1004: l_cost_per_hr jtf_rs_resource_extns.cost_per_hr%TYPE;
1005: l_primary_language jtf_rs_resource_extns.primary_language%TYPE;
1006: l_secondary_language jtf_rs_resource_extns.secondary_language%TYPE;
1007: l_support_site_id jtf_rs_resource_extns.support_site_id%TYPE;
1008: l_ies_agent_login jtf_rs_resource_extns.ies_agent_login%TYPE;
1009: l_server_group_id jtf_rs_resource_extns.server_group_id%TYPE;
1010: l_assigned_to_group_id jtf_rs_resource_extns.assigned_to_group_id%TYPE;

Line 1007: l_support_site_id jtf_rs_resource_extns.support_site_id%TYPE;

1003: l_time_zone jtf_rs_resource_extns.time_zone%TYPE;
1004: l_cost_per_hr jtf_rs_resource_extns.cost_per_hr%TYPE;
1005: l_primary_language jtf_rs_resource_extns.primary_language%TYPE;
1006: l_secondary_language jtf_rs_resource_extns.secondary_language%TYPE;
1007: l_support_site_id jtf_rs_resource_extns.support_site_id%TYPE;
1008: l_ies_agent_login jtf_rs_resource_extns.ies_agent_login%TYPE;
1009: l_server_group_id jtf_rs_resource_extns.server_group_id%TYPE;
1010: l_assigned_to_group_id jtf_rs_resource_extns.assigned_to_group_id%TYPE;
1011: l_cost_center jtf_rs_resource_extns.cost_center%TYPE;

Line 1009: l_server_group_id jtf_rs_resource_extns.server_group_id%TYPE;

1005: l_primary_language jtf_rs_resource_extns.primary_language%TYPE;
1006: l_secondary_language jtf_rs_resource_extns.secondary_language%TYPE;
1007: l_support_site_id jtf_rs_resource_extns.support_site_id%TYPE;
1008: l_ies_agent_login jtf_rs_resource_extns.ies_agent_login%TYPE;
1009: l_server_group_id jtf_rs_resource_extns.server_group_id%TYPE;
1010: l_assigned_to_group_id jtf_rs_resource_extns.assigned_to_group_id%TYPE;
1011: l_cost_center jtf_rs_resource_extns.cost_center%TYPE;
1012: l_charge_to_cost_center jtf_rs_resource_extns.charge_to_cost_center%TYPE;
1013: l_comp_currency_code jtf_rs_resource_extns.compensation_currency_code%TYPE;

Line 1031: l_source_name jtf_rs_resource_extns.source_name%type;

1027: l_bind_data_id NUMBER;
1028:
1029: /* Moved the initial assignment of below variables to inside begin */
1030: l_resource_name jtf_rs_resource_extns_tl.resource_name%type;
1031: l_source_name jtf_rs_resource_extns.source_name%type;
1032: l_source_number jtf_rs_resource_extns.source_number%type;
1033: l_source_job_title jtf_rs_resource_extns.source_job_title%type;
1034: l_source_email jtf_rs_resource_extns.source_email%type;
1035: l_source_phone jtf_rs_resource_extns.source_phone%type;

Line 1032: l_source_number jtf_rs_resource_extns.source_number%type;

1028:
1029: /* Moved the initial assignment of below variables to inside begin */
1030: l_resource_name jtf_rs_resource_extns_tl.resource_name%type;
1031: l_source_name jtf_rs_resource_extns.source_name%type;
1032: l_source_number jtf_rs_resource_extns.source_number%type;
1033: l_source_job_title jtf_rs_resource_extns.source_job_title%type;
1034: l_source_email jtf_rs_resource_extns.source_email%type;
1035: l_source_phone jtf_rs_resource_extns.source_phone%type;
1036: l_source_org_id jtf_rs_resource_extns.source_org_id%type;

Line 1033: l_source_job_title jtf_rs_resource_extns.source_job_title%type;

1029: /* Moved the initial assignment of below variables to inside begin */
1030: l_resource_name jtf_rs_resource_extns_tl.resource_name%type;
1031: l_source_name jtf_rs_resource_extns.source_name%type;
1032: l_source_number jtf_rs_resource_extns.source_number%type;
1033: l_source_job_title jtf_rs_resource_extns.source_job_title%type;
1034: l_source_email jtf_rs_resource_extns.source_email%type;
1035: l_source_phone jtf_rs_resource_extns.source_phone%type;
1036: l_source_org_id jtf_rs_resource_extns.source_org_id%type;
1037: l_source_org_name jtf_rs_resource_extns.source_org_name%type;

Line 1034: l_source_email jtf_rs_resource_extns.source_email%type;

1030: l_resource_name jtf_rs_resource_extns_tl.resource_name%type;
1031: l_source_name jtf_rs_resource_extns.source_name%type;
1032: l_source_number jtf_rs_resource_extns.source_number%type;
1033: l_source_job_title jtf_rs_resource_extns.source_job_title%type;
1034: l_source_email jtf_rs_resource_extns.source_email%type;
1035: l_source_phone jtf_rs_resource_extns.source_phone%type;
1036: l_source_org_id jtf_rs_resource_extns.source_org_id%type;
1037: l_source_org_name jtf_rs_resource_extns.source_org_name%type;
1038: l_source_address1 jtf_rs_resource_extns.source_address1%type;

Line 1035: l_source_phone jtf_rs_resource_extns.source_phone%type;

1031: l_source_name jtf_rs_resource_extns.source_name%type;
1032: l_source_number jtf_rs_resource_extns.source_number%type;
1033: l_source_job_title jtf_rs_resource_extns.source_job_title%type;
1034: l_source_email jtf_rs_resource_extns.source_email%type;
1035: l_source_phone jtf_rs_resource_extns.source_phone%type;
1036: l_source_org_id jtf_rs_resource_extns.source_org_id%type;
1037: l_source_org_name jtf_rs_resource_extns.source_org_name%type;
1038: l_source_address1 jtf_rs_resource_extns.source_address1%type;
1039: l_source_address2 jtf_rs_resource_extns.source_address2%type;

Line 1036: l_source_org_id jtf_rs_resource_extns.source_org_id%type;

1032: l_source_number jtf_rs_resource_extns.source_number%type;
1033: l_source_job_title jtf_rs_resource_extns.source_job_title%type;
1034: l_source_email jtf_rs_resource_extns.source_email%type;
1035: l_source_phone jtf_rs_resource_extns.source_phone%type;
1036: l_source_org_id jtf_rs_resource_extns.source_org_id%type;
1037: l_source_org_name jtf_rs_resource_extns.source_org_name%type;
1038: l_source_address1 jtf_rs_resource_extns.source_address1%type;
1039: l_source_address2 jtf_rs_resource_extns.source_address2%type;
1040: l_source_address3 jtf_rs_resource_extns.source_address3%type;

Line 1037: l_source_org_name jtf_rs_resource_extns.source_org_name%type;

1033: l_source_job_title jtf_rs_resource_extns.source_job_title%type;
1034: l_source_email jtf_rs_resource_extns.source_email%type;
1035: l_source_phone jtf_rs_resource_extns.source_phone%type;
1036: l_source_org_id jtf_rs_resource_extns.source_org_id%type;
1037: l_source_org_name jtf_rs_resource_extns.source_org_name%type;
1038: l_source_address1 jtf_rs_resource_extns.source_address1%type;
1039: l_source_address2 jtf_rs_resource_extns.source_address2%type;
1040: l_source_address3 jtf_rs_resource_extns.source_address3%type;
1041: l_source_address4 jtf_rs_resource_extns.source_address4%type;

Line 1038: l_source_address1 jtf_rs_resource_extns.source_address1%type;

1034: l_source_email jtf_rs_resource_extns.source_email%type;
1035: l_source_phone jtf_rs_resource_extns.source_phone%type;
1036: l_source_org_id jtf_rs_resource_extns.source_org_id%type;
1037: l_source_org_name jtf_rs_resource_extns.source_org_name%type;
1038: l_source_address1 jtf_rs_resource_extns.source_address1%type;
1039: l_source_address2 jtf_rs_resource_extns.source_address2%type;
1040: l_source_address3 jtf_rs_resource_extns.source_address3%type;
1041: l_source_address4 jtf_rs_resource_extns.source_address4%type;
1042: l_source_city jtf_rs_resource_extns.source_city%type;

Line 1039: l_source_address2 jtf_rs_resource_extns.source_address2%type;

1035: l_source_phone jtf_rs_resource_extns.source_phone%type;
1036: l_source_org_id jtf_rs_resource_extns.source_org_id%type;
1037: l_source_org_name jtf_rs_resource_extns.source_org_name%type;
1038: l_source_address1 jtf_rs_resource_extns.source_address1%type;
1039: l_source_address2 jtf_rs_resource_extns.source_address2%type;
1040: l_source_address3 jtf_rs_resource_extns.source_address3%type;
1041: l_source_address4 jtf_rs_resource_extns.source_address4%type;
1042: l_source_city jtf_rs_resource_extns.source_city%type;
1043: l_source_postal_code jtf_rs_resource_extns.source_postal_code%type;

Line 1040: l_source_address3 jtf_rs_resource_extns.source_address3%type;

1036: l_source_org_id jtf_rs_resource_extns.source_org_id%type;
1037: l_source_org_name jtf_rs_resource_extns.source_org_name%type;
1038: l_source_address1 jtf_rs_resource_extns.source_address1%type;
1039: l_source_address2 jtf_rs_resource_extns.source_address2%type;
1040: l_source_address3 jtf_rs_resource_extns.source_address3%type;
1041: l_source_address4 jtf_rs_resource_extns.source_address4%type;
1042: l_source_city jtf_rs_resource_extns.source_city%type;
1043: l_source_postal_code jtf_rs_resource_extns.source_postal_code%type;
1044: l_source_state jtf_rs_resource_extns.source_state%type;

Line 1041: l_source_address4 jtf_rs_resource_extns.source_address4%type;

1037: l_source_org_name jtf_rs_resource_extns.source_org_name%type;
1038: l_source_address1 jtf_rs_resource_extns.source_address1%type;
1039: l_source_address2 jtf_rs_resource_extns.source_address2%type;
1040: l_source_address3 jtf_rs_resource_extns.source_address3%type;
1041: l_source_address4 jtf_rs_resource_extns.source_address4%type;
1042: l_source_city jtf_rs_resource_extns.source_city%type;
1043: l_source_postal_code jtf_rs_resource_extns.source_postal_code%type;
1044: l_source_state jtf_rs_resource_extns.source_state%type;
1045: l_source_province jtf_rs_resource_extns.source_province%type;

Line 1042: l_source_city jtf_rs_resource_extns.source_city%type;

1038: l_source_address1 jtf_rs_resource_extns.source_address1%type;
1039: l_source_address2 jtf_rs_resource_extns.source_address2%type;
1040: l_source_address3 jtf_rs_resource_extns.source_address3%type;
1041: l_source_address4 jtf_rs_resource_extns.source_address4%type;
1042: l_source_city jtf_rs_resource_extns.source_city%type;
1043: l_source_postal_code jtf_rs_resource_extns.source_postal_code%type;
1044: l_source_state jtf_rs_resource_extns.source_state%type;
1045: l_source_province jtf_rs_resource_extns.source_province%type;
1046: l_source_county jtf_rs_resource_extns.source_county%type;

Line 1043: l_source_postal_code jtf_rs_resource_extns.source_postal_code%type;

1039: l_source_address2 jtf_rs_resource_extns.source_address2%type;
1040: l_source_address3 jtf_rs_resource_extns.source_address3%type;
1041: l_source_address4 jtf_rs_resource_extns.source_address4%type;
1042: l_source_city jtf_rs_resource_extns.source_city%type;
1043: l_source_postal_code jtf_rs_resource_extns.source_postal_code%type;
1044: l_source_state jtf_rs_resource_extns.source_state%type;
1045: l_source_province jtf_rs_resource_extns.source_province%type;
1046: l_source_county jtf_rs_resource_extns.source_county%type;
1047: l_source_country jtf_rs_resource_extns.source_country%type;

Line 1044: l_source_state jtf_rs_resource_extns.source_state%type;

1040: l_source_address3 jtf_rs_resource_extns.source_address3%type;
1041: l_source_address4 jtf_rs_resource_extns.source_address4%type;
1042: l_source_city jtf_rs_resource_extns.source_city%type;
1043: l_source_postal_code jtf_rs_resource_extns.source_postal_code%type;
1044: l_source_state jtf_rs_resource_extns.source_state%type;
1045: l_source_province jtf_rs_resource_extns.source_province%type;
1046: l_source_county jtf_rs_resource_extns.source_county%type;
1047: l_source_country jtf_rs_resource_extns.source_country%type;
1048: l_source_mgr_id jtf_rs_resource_extns.source_mgr_id%type;

Line 1045: l_source_province jtf_rs_resource_extns.source_province%type;

1041: l_source_address4 jtf_rs_resource_extns.source_address4%type;
1042: l_source_city jtf_rs_resource_extns.source_city%type;
1043: l_source_postal_code jtf_rs_resource_extns.source_postal_code%type;
1044: l_source_state jtf_rs_resource_extns.source_state%type;
1045: l_source_province jtf_rs_resource_extns.source_province%type;
1046: l_source_county jtf_rs_resource_extns.source_county%type;
1047: l_source_country jtf_rs_resource_extns.source_country%type;
1048: l_source_mgr_id jtf_rs_resource_extns.source_mgr_id%type;
1049: l_source_mgr_name jtf_rs_resource_extns.source_mgr_name%type;

Line 1046: l_source_county jtf_rs_resource_extns.source_county%type;

1042: l_source_city jtf_rs_resource_extns.source_city%type;
1043: l_source_postal_code jtf_rs_resource_extns.source_postal_code%type;
1044: l_source_state jtf_rs_resource_extns.source_state%type;
1045: l_source_province jtf_rs_resource_extns.source_province%type;
1046: l_source_county jtf_rs_resource_extns.source_county%type;
1047: l_source_country jtf_rs_resource_extns.source_country%type;
1048: l_source_mgr_id jtf_rs_resource_extns.source_mgr_id%type;
1049: l_source_mgr_name jtf_rs_resource_extns.source_mgr_name%type;
1050: l_source_business_grp_id jtf_rs_resource_extns.source_business_grp_id%type;

Line 1047: l_source_country jtf_rs_resource_extns.source_country%type;

1043: l_source_postal_code jtf_rs_resource_extns.source_postal_code%type;
1044: l_source_state jtf_rs_resource_extns.source_state%type;
1045: l_source_province jtf_rs_resource_extns.source_province%type;
1046: l_source_county jtf_rs_resource_extns.source_county%type;
1047: l_source_country jtf_rs_resource_extns.source_country%type;
1048: l_source_mgr_id jtf_rs_resource_extns.source_mgr_id%type;
1049: l_source_mgr_name jtf_rs_resource_extns.source_mgr_name%type;
1050: l_source_business_grp_id jtf_rs_resource_extns.source_business_grp_id%type;
1051: l_source_business_grp_name jtf_rs_resource_extns.source_business_grp_name%type;

Line 1048: l_source_mgr_id jtf_rs_resource_extns.source_mgr_id%type;

1044: l_source_state jtf_rs_resource_extns.source_state%type;
1045: l_source_province jtf_rs_resource_extns.source_province%type;
1046: l_source_county jtf_rs_resource_extns.source_county%type;
1047: l_source_country jtf_rs_resource_extns.source_country%type;
1048: l_source_mgr_id jtf_rs_resource_extns.source_mgr_id%type;
1049: l_source_mgr_name jtf_rs_resource_extns.source_mgr_name%type;
1050: l_source_business_grp_id jtf_rs_resource_extns.source_business_grp_id%type;
1051: l_source_business_grp_name jtf_rs_resource_extns.source_business_grp_name%type;
1052: l_source_first_name jtf_rs_resource_extns.source_first_name%type;

Line 1049: l_source_mgr_name jtf_rs_resource_extns.source_mgr_name%type;

1045: l_source_province jtf_rs_resource_extns.source_province%type;
1046: l_source_county jtf_rs_resource_extns.source_county%type;
1047: l_source_country jtf_rs_resource_extns.source_country%type;
1048: l_source_mgr_id jtf_rs_resource_extns.source_mgr_id%type;
1049: l_source_mgr_name jtf_rs_resource_extns.source_mgr_name%type;
1050: l_source_business_grp_id jtf_rs_resource_extns.source_business_grp_id%type;
1051: l_source_business_grp_name jtf_rs_resource_extns.source_business_grp_name%type;
1052: l_source_first_name jtf_rs_resource_extns.source_first_name%type;
1053: l_source_last_name jtf_rs_resource_extns.source_last_name%type;

Line 1050: l_source_business_grp_id jtf_rs_resource_extns.source_business_grp_id%type;

1046: l_source_county jtf_rs_resource_extns.source_county%type;
1047: l_source_country jtf_rs_resource_extns.source_country%type;
1048: l_source_mgr_id jtf_rs_resource_extns.source_mgr_id%type;
1049: l_source_mgr_name jtf_rs_resource_extns.source_mgr_name%type;
1050: l_source_business_grp_id jtf_rs_resource_extns.source_business_grp_id%type;
1051: l_source_business_grp_name jtf_rs_resource_extns.source_business_grp_name%type;
1052: l_source_first_name jtf_rs_resource_extns.source_first_name%type;
1053: l_source_last_name jtf_rs_resource_extns.source_last_name%type;
1054: l_source_middle_name jtf_rs_resource_extns.source_middle_name%type;

Line 1051: l_source_business_grp_name jtf_rs_resource_extns.source_business_grp_name%type;

1047: l_source_country jtf_rs_resource_extns.source_country%type;
1048: l_source_mgr_id jtf_rs_resource_extns.source_mgr_id%type;
1049: l_source_mgr_name jtf_rs_resource_extns.source_mgr_name%type;
1050: l_source_business_grp_id jtf_rs_resource_extns.source_business_grp_id%type;
1051: l_source_business_grp_name jtf_rs_resource_extns.source_business_grp_name%type;
1052: l_source_first_name jtf_rs_resource_extns.source_first_name%type;
1053: l_source_last_name jtf_rs_resource_extns.source_last_name%type;
1054: l_source_middle_name jtf_rs_resource_extns.source_middle_name%type;
1055: l_source_category jtf_rs_resource_extns.source_category%type;

Line 1052: l_source_first_name jtf_rs_resource_extns.source_first_name%type;

1048: l_source_mgr_id jtf_rs_resource_extns.source_mgr_id%type;
1049: l_source_mgr_name jtf_rs_resource_extns.source_mgr_name%type;
1050: l_source_business_grp_id jtf_rs_resource_extns.source_business_grp_id%type;
1051: l_source_business_grp_name jtf_rs_resource_extns.source_business_grp_name%type;
1052: l_source_first_name jtf_rs_resource_extns.source_first_name%type;
1053: l_source_last_name jtf_rs_resource_extns.source_last_name%type;
1054: l_source_middle_name jtf_rs_resource_extns.source_middle_name%type;
1055: l_source_category jtf_rs_resource_extns.source_category%type;
1056: l_source_status jtf_rs_resource_extns.source_status%type;

Line 1053: l_source_last_name jtf_rs_resource_extns.source_last_name%type;

1049: l_source_mgr_name jtf_rs_resource_extns.source_mgr_name%type;
1050: l_source_business_grp_id jtf_rs_resource_extns.source_business_grp_id%type;
1051: l_source_business_grp_name jtf_rs_resource_extns.source_business_grp_name%type;
1052: l_source_first_name jtf_rs_resource_extns.source_first_name%type;
1053: l_source_last_name jtf_rs_resource_extns.source_last_name%type;
1054: l_source_middle_name jtf_rs_resource_extns.source_middle_name%type;
1055: l_source_category jtf_rs_resource_extns.source_category%type;
1056: l_source_status jtf_rs_resource_extns.source_status%type;
1057: l_source_office jtf_rs_resource_extns.source_office%type;

Line 1054: l_source_middle_name jtf_rs_resource_extns.source_middle_name%type;

1050: l_source_business_grp_id jtf_rs_resource_extns.source_business_grp_id%type;
1051: l_source_business_grp_name jtf_rs_resource_extns.source_business_grp_name%type;
1052: l_source_first_name jtf_rs_resource_extns.source_first_name%type;
1053: l_source_last_name jtf_rs_resource_extns.source_last_name%type;
1054: l_source_middle_name jtf_rs_resource_extns.source_middle_name%type;
1055: l_source_category jtf_rs_resource_extns.source_category%type;
1056: l_source_status jtf_rs_resource_extns.source_status%type;
1057: l_source_office jtf_rs_resource_extns.source_office%type;
1058: l_source_location jtf_rs_resource_extns.source_location%type;

Line 1055: l_source_category jtf_rs_resource_extns.source_category%type;

1051: l_source_business_grp_name jtf_rs_resource_extns.source_business_grp_name%type;
1052: l_source_first_name jtf_rs_resource_extns.source_first_name%type;
1053: l_source_last_name jtf_rs_resource_extns.source_last_name%type;
1054: l_source_middle_name jtf_rs_resource_extns.source_middle_name%type;
1055: l_source_category jtf_rs_resource_extns.source_category%type;
1056: l_source_status jtf_rs_resource_extns.source_status%type;
1057: l_source_office jtf_rs_resource_extns.source_office%type;
1058: l_source_location jtf_rs_resource_extns.source_location%type;
1059: l_source_mailstop jtf_rs_resource_extns.source_mailstop%type;

Line 1056: l_source_status jtf_rs_resource_extns.source_status%type;

1052: l_source_first_name jtf_rs_resource_extns.source_first_name%type;
1053: l_source_last_name jtf_rs_resource_extns.source_last_name%type;
1054: l_source_middle_name jtf_rs_resource_extns.source_middle_name%type;
1055: l_source_category jtf_rs_resource_extns.source_category%type;
1056: l_source_status jtf_rs_resource_extns.source_status%type;
1057: l_source_office jtf_rs_resource_extns.source_office%type;
1058: l_source_location jtf_rs_resource_extns.source_location%type;
1059: l_source_mailstop jtf_rs_resource_extns.source_mailstop%type;
1060: l_source_mobile_phone jtf_rs_resource_extns.source_mobile_phone%type;

Line 1057: l_source_office jtf_rs_resource_extns.source_office%type;

1053: l_source_last_name jtf_rs_resource_extns.source_last_name%type;
1054: l_source_middle_name jtf_rs_resource_extns.source_middle_name%type;
1055: l_source_category jtf_rs_resource_extns.source_category%type;
1056: l_source_status jtf_rs_resource_extns.source_status%type;
1057: l_source_office jtf_rs_resource_extns.source_office%type;
1058: l_source_location jtf_rs_resource_extns.source_location%type;
1059: l_source_mailstop jtf_rs_resource_extns.source_mailstop%type;
1060: l_source_mobile_phone jtf_rs_resource_extns.source_mobile_phone%type;
1061: l_source_pager jtf_rs_resource_extns.source_pager%type;

Line 1058: l_source_location jtf_rs_resource_extns.source_location%type;

1054: l_source_middle_name jtf_rs_resource_extns.source_middle_name%type;
1055: l_source_category jtf_rs_resource_extns.source_category%type;
1056: l_source_status jtf_rs_resource_extns.source_status%type;
1057: l_source_office jtf_rs_resource_extns.source_office%type;
1058: l_source_location jtf_rs_resource_extns.source_location%type;
1059: l_source_mailstop jtf_rs_resource_extns.source_mailstop%type;
1060: l_source_mobile_phone jtf_rs_resource_extns.source_mobile_phone%type;
1061: l_source_pager jtf_rs_resource_extns.source_pager%type;
1062: l_user_name jtf_rs_resource_extns.user_name%type;

Line 1059: l_source_mailstop jtf_rs_resource_extns.source_mailstop%type;

1055: l_source_category jtf_rs_resource_extns.source_category%type;
1056: l_source_status jtf_rs_resource_extns.source_status%type;
1057: l_source_office jtf_rs_resource_extns.source_office%type;
1058: l_source_location jtf_rs_resource_extns.source_location%type;
1059: l_source_mailstop jtf_rs_resource_extns.source_mailstop%type;
1060: l_source_mobile_phone jtf_rs_resource_extns.source_mobile_phone%type;
1061: l_source_pager jtf_rs_resource_extns.source_pager%type;
1062: l_user_name jtf_rs_resource_extns.user_name%type;
1063: l_source_job_id jtf_rs_resource_extns.source_job_id%type;

Line 1060: l_source_mobile_phone jtf_rs_resource_extns.source_mobile_phone%type;

1056: l_source_status jtf_rs_resource_extns.source_status%type;
1057: l_source_office jtf_rs_resource_extns.source_office%type;
1058: l_source_location jtf_rs_resource_extns.source_location%type;
1059: l_source_mailstop jtf_rs_resource_extns.source_mailstop%type;
1060: l_source_mobile_phone jtf_rs_resource_extns.source_mobile_phone%type;
1061: l_source_pager jtf_rs_resource_extns.source_pager%type;
1062: l_user_name jtf_rs_resource_extns.user_name%type;
1063: l_source_job_id jtf_rs_resource_extns.source_job_id%type;
1064: l_party_id jtf_rs_resource_extns.person_party_id%type;

Line 1061: l_source_pager jtf_rs_resource_extns.source_pager%type;

1057: l_source_office jtf_rs_resource_extns.source_office%type;
1058: l_source_location jtf_rs_resource_extns.source_location%type;
1059: l_source_mailstop jtf_rs_resource_extns.source_mailstop%type;
1060: l_source_mobile_phone jtf_rs_resource_extns.source_mobile_phone%type;
1061: l_source_pager jtf_rs_resource_extns.source_pager%type;
1062: l_user_name jtf_rs_resource_extns.user_name%type;
1063: l_source_job_id jtf_rs_resource_extns.source_job_id%type;
1064: l_party_id jtf_rs_resource_extns.person_party_id%type;
1065:

Line 1063: l_source_job_id jtf_rs_resource_extns.source_job_id%type;

1059: l_source_mailstop jtf_rs_resource_extns.source_mailstop%type;
1060: l_source_mobile_phone jtf_rs_resource_extns.source_mobile_phone%type;
1061: l_source_pager jtf_rs_resource_extns.source_pager%type;
1062: l_user_name jtf_rs_resource_extns.user_name%type;
1063: l_source_job_id jtf_rs_resource_extns.source_job_id%type;
1064: l_party_id jtf_rs_resource_extns.person_party_id%type;
1065:
1066: l_return_status VARCHAR2(2000);
1067: l_msg_count NUMBER;

Line 1426: SELECT jtf_rs_resource_extns_s.nextval

1422:
1423: /* Get the next value of the Resource_id from the sequence. */
1424:
1425: LOOP
1426: SELECT jtf_rs_resource_extns_s.nextval
1427: INTO l_resource_id
1428: FROM dual;
1429: --dbms_output.put_line ('After Select - Resource ID ' || l_resource_id);
1430: OPEN c_dup_resource_id (l_resource_id);

Line 1988: P_SOURCE_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_ID%TYPE,

1984: P_API_VERSION IN NUMBER,
1985: P_INIT_MSG_LIST IN VARCHAR2,
1986: P_COMMIT IN VARCHAR2,
1987: P_CATEGORY IN JTF_RS_RESOURCE_EXTNS.CATEGORY%TYPE,
1988: P_SOURCE_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_ID%TYPE,
1989: P_ADDRESS_ID IN JTF_RS_RESOURCE_EXTNS.ADDRESS_ID%TYPE,
1990: P_CONTACT_ID IN JTF_RS_RESOURCE_EXTNS.CONTACT_ID%TYPE,
1991: P_MANAGING_EMP_ID IN JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE,
1992: P_START_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE,

Line 1992: P_START_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE,

1988: P_SOURCE_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_ID%TYPE,
1989: P_ADDRESS_ID IN JTF_RS_RESOURCE_EXTNS.ADDRESS_ID%TYPE,
1990: P_CONTACT_ID IN JTF_RS_RESOURCE_EXTNS.CONTACT_ID%TYPE,
1991: P_MANAGING_EMP_ID IN JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE,
1992: P_START_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE,
1993: P_END_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE,
1994: P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE,
1995: P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE,
1996: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE,

Line 1997: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE,

1993: P_END_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE,
1994: P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE,
1995: P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE,
1996: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE,
1997: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE,
1998: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE,
1999: P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE,
2000: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE,
2001: P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE,

Line 1998: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE,

1994: P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE,
1995: P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE,
1996: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE,
1997: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE,
1998: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE,
1999: P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE,
2000: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE,
2001: P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE,
2002: P_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE,

Line 2000: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE,

1996: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE,
1997: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE,
1998: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE,
1999: P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE,
2000: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE,
2001: P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE,
2002: P_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE,
2003: P_CHARGE_TO_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE,
2004: P_COMP_CURRENCY_CODE IN JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE,

Line 2105: P_START_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE,

2101: P_INIT_MSG_LIST IN VARCHAR2,
2102: P_COMMIT IN VARCHAR2,
2103: P_RESOURCE_ID IN JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,
2104: P_MANAGING_EMP_ID IN JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE,
2105: P_START_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE,
2106: P_END_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE,
2107: P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE,
2108: P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE,
2109: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE,

Line 2110: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE,

2106: P_END_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE,
2107: P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE,
2108: P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE,
2109: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE,
2110: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE,
2111: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE,
2112: P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE,
2113: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE,
2114: P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE,

Line 2111: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE,

2107: P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE,
2108: P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE,
2109: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE,
2110: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE,
2111: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE,
2112: P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE,
2113: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE,
2114: P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE,
2115: P_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE,

Line 2113: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE,

2109: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE,
2110: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE,
2111: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE,
2112: P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE,
2113: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE,
2114: P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE,
2115: P_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE,
2116: P_CHARGE_TO_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE,
2117: P_COMP_CURRENCY_CODE IN JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE,

Line 2152: l_start_date_active jtf_rs_resource_extns.start_date_active%TYPE;

2148: /* Moved the initial assignment of below variables to inside begin */
2149: l_resource_id jtf_rs_resource_extns.resource_id%TYPE;
2150: l_managing_emp_id jtf_rs_resource_extns.managing_employee_id%TYPE;
2151: -- added trunc for the dates 6feb2002
2152: l_start_date_active jtf_rs_resource_extns.start_date_active%TYPE;
2153: l_end_date_active jtf_rs_resource_extns.end_date_active%TYPE;
2154: l_time_zone jtf_rs_resource_extns.time_zone%TYPE;
2155: l_cost_per_hr jtf_rs_resource_extns.cost_per_hr%TYPE;
2156: l_primary_language jtf_rs_resource_extns.primary_language%TYPE;

Line 2157: l_secondary_language jtf_rs_resource_extns.secondary_language%TYPE;

2153: l_end_date_active jtf_rs_resource_extns.end_date_active%TYPE;
2154: l_time_zone jtf_rs_resource_extns.time_zone%TYPE;
2155: l_cost_per_hr jtf_rs_resource_extns.cost_per_hr%TYPE;
2156: l_primary_language jtf_rs_resource_extns.primary_language%TYPE;
2157: l_secondary_language jtf_rs_resource_extns.secondary_language%TYPE;
2158: l_support_site_id jtf_rs_resource_extns.support_site_id%TYPE;
2159: l_ies_agent_login jtf_rs_resource_extns.ies_agent_login%TYPE;
2160: l_server_group_id jtf_rs_resource_extns.server_group_id%TYPE;
2161: l_assigned_to_group_id jtf_rs_resource_extns.assigned_to_group_id%TYPE;

Line 2158: l_support_site_id jtf_rs_resource_extns.support_site_id%TYPE;

2154: l_time_zone jtf_rs_resource_extns.time_zone%TYPE;
2155: l_cost_per_hr jtf_rs_resource_extns.cost_per_hr%TYPE;
2156: l_primary_language jtf_rs_resource_extns.primary_language%TYPE;
2157: l_secondary_language jtf_rs_resource_extns.secondary_language%TYPE;
2158: l_support_site_id jtf_rs_resource_extns.support_site_id%TYPE;
2159: l_ies_agent_login jtf_rs_resource_extns.ies_agent_login%TYPE;
2160: l_server_group_id jtf_rs_resource_extns.server_group_id%TYPE;
2161: l_assigned_to_group_id jtf_rs_resource_extns.assigned_to_group_id%TYPE;
2162: l_cost_center jtf_rs_resource_extns.cost_center%TYPE;

Line 2160: l_server_group_id jtf_rs_resource_extns.server_group_id%TYPE;

2156: l_primary_language jtf_rs_resource_extns.primary_language%TYPE;
2157: l_secondary_language jtf_rs_resource_extns.secondary_language%TYPE;
2158: l_support_site_id jtf_rs_resource_extns.support_site_id%TYPE;
2159: l_ies_agent_login jtf_rs_resource_extns.ies_agent_login%TYPE;
2160: l_server_group_id jtf_rs_resource_extns.server_group_id%TYPE;
2161: l_assigned_to_group_id jtf_rs_resource_extns.assigned_to_group_id%TYPE;
2162: l_cost_center jtf_rs_resource_extns.cost_center%TYPE;
2163: l_charge_to_cost_center jtf_rs_resource_extns.charge_to_cost_center%TYPE;
2164: l_comp_currency_code jtf_rs_resource_extns.compensation_currency_code%TYPE;

Line 2175: l_server_group_id_out jtf_rs_resource_extns.server_group_id%TYPE ;

2171: l_object_version_num jtf_rs_resource_extns.object_version_number%TYPE;
2172:
2173: -- added for NOCOPY to handle in JTF_RESOURCE_UTL
2174: l_managing_emp_id_out jtf_rs_resource_extns.managing_employee_id%TYPE ;
2175: l_server_group_id_out jtf_rs_resource_extns.server_group_id%TYPE ;
2176: l_comp_service_team_id_out jtf_rs_resource_extns.comp_service_team_id%TYPE;
2177:
2178: l_max_end_date DATE;
2179: l_min_start_date DATE;

Line 3934: P_START_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE,

3930: P_INIT_MSG_LIST IN VARCHAR2,
3931: P_COMMIT IN VARCHAR2,
3932: P_RESOURCE_ID IN JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,
3933: P_MANAGING_EMP_ID IN JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE,
3934: P_START_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE,
3935: P_END_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE,
3936: P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE,
3937: P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE,
3938: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE,

Line 3939: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE,

3935: P_END_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE,
3936: P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE,
3937: P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE,
3938: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE,
3939: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE,
3940: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE,
3941: P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE,
3942: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE,
3943: P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE,

Line 3940: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE,

3936: P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE,
3937: P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE,
3938: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE,
3939: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE,
3940: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE,
3941: P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE,
3942: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE,
3943: P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE,
3944: P_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE,

Line 3942: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE,

3938: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE,
3939: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE,
3940: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE,
3941: P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE,
3942: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE,
3943: P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE,
3944: P_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE,
3945: P_CHARGE_TO_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE,
3946: P_COMP_CURRENCY_CODE IN JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE,

Line 3970: P_SOURCE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_NAME%TYPE,

3966: P_ATTRIBUTE14 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE14%TYPE,
3967: P_ATTRIBUTE15 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE15%TYPE,
3968: P_ATTRIBUTE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE_CATEGORY%TYPE,
3969: P_RESOURCE_NAME IN JTF_RS_RESOURCE_EXTNS_TL.RESOURCE_NAME%TYPE,
3970: P_SOURCE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_NAME%TYPE,
3971: P_SOURCE_NUMBER IN JTF_RS_RESOURCE_EXTNS.SOURCE_NUMBER%TYPE,
3972: P_SOURCE_JOB_TITLE IN JTF_RS_RESOURCE_EXTNS.SOURCE_JOB_TITLE%TYPE,
3973: P_SOURCE_EMAIL IN JTF_RS_RESOURCE_EXTNS.SOURCE_EMAIL%TYPE,
3974: P_SOURCE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PHONE%TYPE,

Line 3971: P_SOURCE_NUMBER IN JTF_RS_RESOURCE_EXTNS.SOURCE_NUMBER%TYPE,

3967: P_ATTRIBUTE15 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE15%TYPE,
3968: P_ATTRIBUTE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE_CATEGORY%TYPE,
3969: P_RESOURCE_NAME IN JTF_RS_RESOURCE_EXTNS_TL.RESOURCE_NAME%TYPE,
3970: P_SOURCE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_NAME%TYPE,
3971: P_SOURCE_NUMBER IN JTF_RS_RESOURCE_EXTNS.SOURCE_NUMBER%TYPE,
3972: P_SOURCE_JOB_TITLE IN JTF_RS_RESOURCE_EXTNS.SOURCE_JOB_TITLE%TYPE,
3973: P_SOURCE_EMAIL IN JTF_RS_RESOURCE_EXTNS.SOURCE_EMAIL%TYPE,
3974: P_SOURCE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PHONE%TYPE,
3975: P_SOURCE_ORG_ID IN NUMBER,

Line 3972: P_SOURCE_JOB_TITLE IN JTF_RS_RESOURCE_EXTNS.SOURCE_JOB_TITLE%TYPE,

3968: P_ATTRIBUTE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE_CATEGORY%TYPE,
3969: P_RESOURCE_NAME IN JTF_RS_RESOURCE_EXTNS_TL.RESOURCE_NAME%TYPE,
3970: P_SOURCE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_NAME%TYPE,
3971: P_SOURCE_NUMBER IN JTF_RS_RESOURCE_EXTNS.SOURCE_NUMBER%TYPE,
3972: P_SOURCE_JOB_TITLE IN JTF_RS_RESOURCE_EXTNS.SOURCE_JOB_TITLE%TYPE,
3973: P_SOURCE_EMAIL IN JTF_RS_RESOURCE_EXTNS.SOURCE_EMAIL%TYPE,
3974: P_SOURCE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PHONE%TYPE,
3975: P_SOURCE_ORG_ID IN NUMBER,
3976: P_SOURCE_ORG_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_ORG_NAME%TYPE,

Line 3973: P_SOURCE_EMAIL IN JTF_RS_RESOURCE_EXTNS.SOURCE_EMAIL%TYPE,

3969: P_RESOURCE_NAME IN JTF_RS_RESOURCE_EXTNS_TL.RESOURCE_NAME%TYPE,
3970: P_SOURCE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_NAME%TYPE,
3971: P_SOURCE_NUMBER IN JTF_RS_RESOURCE_EXTNS.SOURCE_NUMBER%TYPE,
3972: P_SOURCE_JOB_TITLE IN JTF_RS_RESOURCE_EXTNS.SOURCE_JOB_TITLE%TYPE,
3973: P_SOURCE_EMAIL IN JTF_RS_RESOURCE_EXTNS.SOURCE_EMAIL%TYPE,
3974: P_SOURCE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PHONE%TYPE,
3975: P_SOURCE_ORG_ID IN NUMBER,
3976: P_SOURCE_ORG_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_ORG_NAME%TYPE,
3977: P_SOURCE_ADDRESS1 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS1%TYPE,

Line 3974: P_SOURCE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PHONE%TYPE,

3970: P_SOURCE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_NAME%TYPE,
3971: P_SOURCE_NUMBER IN JTF_RS_RESOURCE_EXTNS.SOURCE_NUMBER%TYPE,
3972: P_SOURCE_JOB_TITLE IN JTF_RS_RESOURCE_EXTNS.SOURCE_JOB_TITLE%TYPE,
3973: P_SOURCE_EMAIL IN JTF_RS_RESOURCE_EXTNS.SOURCE_EMAIL%TYPE,
3974: P_SOURCE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PHONE%TYPE,
3975: P_SOURCE_ORG_ID IN NUMBER,
3976: P_SOURCE_ORG_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_ORG_NAME%TYPE,
3977: P_SOURCE_ADDRESS1 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS1%TYPE,
3978: P_SOURCE_ADDRESS2 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS2%TYPE,

Line 3976: P_SOURCE_ORG_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_ORG_NAME%TYPE,

3972: P_SOURCE_JOB_TITLE IN JTF_RS_RESOURCE_EXTNS.SOURCE_JOB_TITLE%TYPE,
3973: P_SOURCE_EMAIL IN JTF_RS_RESOURCE_EXTNS.SOURCE_EMAIL%TYPE,
3974: P_SOURCE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PHONE%TYPE,
3975: P_SOURCE_ORG_ID IN NUMBER,
3976: P_SOURCE_ORG_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_ORG_NAME%TYPE,
3977: P_SOURCE_ADDRESS1 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS1%TYPE,
3978: P_SOURCE_ADDRESS2 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS2%TYPE,
3979: P_SOURCE_ADDRESS3 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS3%TYPE,
3980: P_SOURCE_ADDRESS4 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS4%TYPE,

Line 3977: P_SOURCE_ADDRESS1 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS1%TYPE,

3973: P_SOURCE_EMAIL IN JTF_RS_RESOURCE_EXTNS.SOURCE_EMAIL%TYPE,
3974: P_SOURCE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PHONE%TYPE,
3975: P_SOURCE_ORG_ID IN NUMBER,
3976: P_SOURCE_ORG_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_ORG_NAME%TYPE,
3977: P_SOURCE_ADDRESS1 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS1%TYPE,
3978: P_SOURCE_ADDRESS2 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS2%TYPE,
3979: P_SOURCE_ADDRESS3 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS3%TYPE,
3980: P_SOURCE_ADDRESS4 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS4%TYPE,
3981: P_SOURCE_CITY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CITY%TYPE,

Line 3978: P_SOURCE_ADDRESS2 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS2%TYPE,

3974: P_SOURCE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PHONE%TYPE,
3975: P_SOURCE_ORG_ID IN NUMBER,
3976: P_SOURCE_ORG_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_ORG_NAME%TYPE,
3977: P_SOURCE_ADDRESS1 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS1%TYPE,
3978: P_SOURCE_ADDRESS2 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS2%TYPE,
3979: P_SOURCE_ADDRESS3 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS3%TYPE,
3980: P_SOURCE_ADDRESS4 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS4%TYPE,
3981: P_SOURCE_CITY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CITY%TYPE,
3982: P_SOURCE_POSTAL_CODE IN JTF_RS_RESOURCE_EXTNS.SOURCE_POSTAL_CODE%TYPE,

Line 3979: P_SOURCE_ADDRESS3 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS3%TYPE,

3975: P_SOURCE_ORG_ID IN NUMBER,
3976: P_SOURCE_ORG_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_ORG_NAME%TYPE,
3977: P_SOURCE_ADDRESS1 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS1%TYPE,
3978: P_SOURCE_ADDRESS2 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS2%TYPE,
3979: P_SOURCE_ADDRESS3 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS3%TYPE,
3980: P_SOURCE_ADDRESS4 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS4%TYPE,
3981: P_SOURCE_CITY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CITY%TYPE,
3982: P_SOURCE_POSTAL_CODE IN JTF_RS_RESOURCE_EXTNS.SOURCE_POSTAL_CODE%TYPE,
3983: P_SOURCE_STATE IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATE%TYPE,

Line 3980: P_SOURCE_ADDRESS4 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS4%TYPE,

3976: P_SOURCE_ORG_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_ORG_NAME%TYPE,
3977: P_SOURCE_ADDRESS1 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS1%TYPE,
3978: P_SOURCE_ADDRESS2 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS2%TYPE,
3979: P_SOURCE_ADDRESS3 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS3%TYPE,
3980: P_SOURCE_ADDRESS4 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS4%TYPE,
3981: P_SOURCE_CITY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CITY%TYPE,
3982: P_SOURCE_POSTAL_CODE IN JTF_RS_RESOURCE_EXTNS.SOURCE_POSTAL_CODE%TYPE,
3983: P_SOURCE_STATE IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATE%TYPE,
3984: P_SOURCE_PROVINCE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PROVINCE%TYPE,

Line 3981: P_SOURCE_CITY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CITY%TYPE,

3977: P_SOURCE_ADDRESS1 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS1%TYPE,
3978: P_SOURCE_ADDRESS2 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS2%TYPE,
3979: P_SOURCE_ADDRESS3 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS3%TYPE,
3980: P_SOURCE_ADDRESS4 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS4%TYPE,
3981: P_SOURCE_CITY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CITY%TYPE,
3982: P_SOURCE_POSTAL_CODE IN JTF_RS_RESOURCE_EXTNS.SOURCE_POSTAL_CODE%TYPE,
3983: P_SOURCE_STATE IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATE%TYPE,
3984: P_SOURCE_PROVINCE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PROVINCE%TYPE,
3985: P_SOURCE_COUNTY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTY%TYPE,

Line 3982: P_SOURCE_POSTAL_CODE IN JTF_RS_RESOURCE_EXTNS.SOURCE_POSTAL_CODE%TYPE,

3978: P_SOURCE_ADDRESS2 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS2%TYPE,
3979: P_SOURCE_ADDRESS3 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS3%TYPE,
3980: P_SOURCE_ADDRESS4 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS4%TYPE,
3981: P_SOURCE_CITY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CITY%TYPE,
3982: P_SOURCE_POSTAL_CODE IN JTF_RS_RESOURCE_EXTNS.SOURCE_POSTAL_CODE%TYPE,
3983: P_SOURCE_STATE IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATE%TYPE,
3984: P_SOURCE_PROVINCE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PROVINCE%TYPE,
3985: P_SOURCE_COUNTY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTY%TYPE,
3986: P_SOURCE_COUNTRY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTRY%TYPE,

Line 3983: P_SOURCE_STATE IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATE%TYPE,

3979: P_SOURCE_ADDRESS3 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS3%TYPE,
3980: P_SOURCE_ADDRESS4 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS4%TYPE,
3981: P_SOURCE_CITY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CITY%TYPE,
3982: P_SOURCE_POSTAL_CODE IN JTF_RS_RESOURCE_EXTNS.SOURCE_POSTAL_CODE%TYPE,
3983: P_SOURCE_STATE IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATE%TYPE,
3984: P_SOURCE_PROVINCE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PROVINCE%TYPE,
3985: P_SOURCE_COUNTY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTY%TYPE,
3986: P_SOURCE_COUNTRY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTRY%TYPE,
3987: P_SOURCE_MGR_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_ID%type,

Line 3984: P_SOURCE_PROVINCE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PROVINCE%TYPE,

3980: P_SOURCE_ADDRESS4 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS4%TYPE,
3981: P_SOURCE_CITY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CITY%TYPE,
3982: P_SOURCE_POSTAL_CODE IN JTF_RS_RESOURCE_EXTNS.SOURCE_POSTAL_CODE%TYPE,
3983: P_SOURCE_STATE IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATE%TYPE,
3984: P_SOURCE_PROVINCE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PROVINCE%TYPE,
3985: P_SOURCE_COUNTY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTY%TYPE,
3986: P_SOURCE_COUNTRY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTRY%TYPE,
3987: P_SOURCE_MGR_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_ID%type,
3988: P_SOURCE_MGR_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_NAME%type,

Line 3985: P_SOURCE_COUNTY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTY%TYPE,

3981: P_SOURCE_CITY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CITY%TYPE,
3982: P_SOURCE_POSTAL_CODE IN JTF_RS_RESOURCE_EXTNS.SOURCE_POSTAL_CODE%TYPE,
3983: P_SOURCE_STATE IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATE%TYPE,
3984: P_SOURCE_PROVINCE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PROVINCE%TYPE,
3985: P_SOURCE_COUNTY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTY%TYPE,
3986: P_SOURCE_COUNTRY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTRY%TYPE,
3987: P_SOURCE_MGR_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_ID%type,
3988: P_SOURCE_MGR_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_NAME%type,
3989: P_SOURCE_BUSINESS_GRP_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_ID%type,

Line 3986: P_SOURCE_COUNTRY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTRY%TYPE,

3982: P_SOURCE_POSTAL_CODE IN JTF_RS_RESOURCE_EXTNS.SOURCE_POSTAL_CODE%TYPE,
3983: P_SOURCE_STATE IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATE%TYPE,
3984: P_SOURCE_PROVINCE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PROVINCE%TYPE,
3985: P_SOURCE_COUNTY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTY%TYPE,
3986: P_SOURCE_COUNTRY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTRY%TYPE,
3987: P_SOURCE_MGR_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_ID%type,
3988: P_SOURCE_MGR_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_NAME%type,
3989: P_SOURCE_BUSINESS_GRP_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_ID%type,
3990: P_SOURCE_BUSINESS_GRP_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_NAME%type,

Line 3987: P_SOURCE_MGR_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_ID%type,

3983: P_SOURCE_STATE IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATE%TYPE,
3984: P_SOURCE_PROVINCE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PROVINCE%TYPE,
3985: P_SOURCE_COUNTY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTY%TYPE,
3986: P_SOURCE_COUNTRY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTRY%TYPE,
3987: P_SOURCE_MGR_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_ID%type,
3988: P_SOURCE_MGR_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_NAME%type,
3989: P_SOURCE_BUSINESS_GRP_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_ID%type,
3990: P_SOURCE_BUSINESS_GRP_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_NAME%type,
3991: P_SOURCE_FIRST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_FIRST_NAME%TYPE,

Line 3988: P_SOURCE_MGR_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_NAME%type,

3984: P_SOURCE_PROVINCE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PROVINCE%TYPE,
3985: P_SOURCE_COUNTY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTY%TYPE,
3986: P_SOURCE_COUNTRY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTRY%TYPE,
3987: P_SOURCE_MGR_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_ID%type,
3988: P_SOURCE_MGR_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_NAME%type,
3989: P_SOURCE_BUSINESS_GRP_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_ID%type,
3990: P_SOURCE_BUSINESS_GRP_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_NAME%type,
3991: P_SOURCE_FIRST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_FIRST_NAME%TYPE,
3992: P_SOURCE_LAST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_LAST_NAME%TYPE,

Line 3989: P_SOURCE_BUSINESS_GRP_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_ID%type,

3985: P_SOURCE_COUNTY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTY%TYPE,
3986: P_SOURCE_COUNTRY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTRY%TYPE,
3987: P_SOURCE_MGR_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_ID%type,
3988: P_SOURCE_MGR_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_NAME%type,
3989: P_SOURCE_BUSINESS_GRP_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_ID%type,
3990: P_SOURCE_BUSINESS_GRP_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_NAME%type,
3991: P_SOURCE_FIRST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_FIRST_NAME%TYPE,
3992: P_SOURCE_LAST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_LAST_NAME%TYPE,
3993: P_SOURCE_MIDDLE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MIDDLE_NAME%TYPE,

Line 3990: P_SOURCE_BUSINESS_GRP_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_NAME%type,

3986: P_SOURCE_COUNTRY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTRY%TYPE,
3987: P_SOURCE_MGR_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_ID%type,
3988: P_SOURCE_MGR_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_NAME%type,
3989: P_SOURCE_BUSINESS_GRP_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_ID%type,
3990: P_SOURCE_BUSINESS_GRP_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_NAME%type,
3991: P_SOURCE_FIRST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_FIRST_NAME%TYPE,
3992: P_SOURCE_LAST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_LAST_NAME%TYPE,
3993: P_SOURCE_MIDDLE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MIDDLE_NAME%TYPE,
3994: P_SOURCE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CATEGORY%TYPE,

Line 3991: P_SOURCE_FIRST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_FIRST_NAME%TYPE,

3987: P_SOURCE_MGR_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_ID%type,
3988: P_SOURCE_MGR_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_NAME%type,
3989: P_SOURCE_BUSINESS_GRP_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_ID%type,
3990: P_SOURCE_BUSINESS_GRP_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_NAME%type,
3991: P_SOURCE_FIRST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_FIRST_NAME%TYPE,
3992: P_SOURCE_LAST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_LAST_NAME%TYPE,
3993: P_SOURCE_MIDDLE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MIDDLE_NAME%TYPE,
3994: P_SOURCE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CATEGORY%TYPE,
3995: P_SOURCE_STATUS IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATUS%TYPE,

Line 3992: P_SOURCE_LAST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_LAST_NAME%TYPE,

3988: P_SOURCE_MGR_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_NAME%type,
3989: P_SOURCE_BUSINESS_GRP_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_ID%type,
3990: P_SOURCE_BUSINESS_GRP_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_NAME%type,
3991: P_SOURCE_FIRST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_FIRST_NAME%TYPE,
3992: P_SOURCE_LAST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_LAST_NAME%TYPE,
3993: P_SOURCE_MIDDLE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MIDDLE_NAME%TYPE,
3994: P_SOURCE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CATEGORY%TYPE,
3995: P_SOURCE_STATUS IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATUS%TYPE,
3996: P_SOURCE_OFFICE IN JTF_RS_RESOURCE_EXTNS.SOURCE_OFFICE%TYPE,

Line 3993: P_SOURCE_MIDDLE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MIDDLE_NAME%TYPE,

3989: P_SOURCE_BUSINESS_GRP_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_ID%type,
3990: P_SOURCE_BUSINESS_GRP_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_NAME%type,
3991: P_SOURCE_FIRST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_FIRST_NAME%TYPE,
3992: P_SOURCE_LAST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_LAST_NAME%TYPE,
3993: P_SOURCE_MIDDLE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MIDDLE_NAME%TYPE,
3994: P_SOURCE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CATEGORY%TYPE,
3995: P_SOURCE_STATUS IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATUS%TYPE,
3996: P_SOURCE_OFFICE IN JTF_RS_RESOURCE_EXTNS.SOURCE_OFFICE%TYPE,
3997: P_SOURCE_LOCATION IN JTF_RS_RESOURCE_EXTNS.SOURCE_LOCATION%TYPE,

Line 3994: P_SOURCE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CATEGORY%TYPE,

3990: P_SOURCE_BUSINESS_GRP_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_NAME%type,
3991: P_SOURCE_FIRST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_FIRST_NAME%TYPE,
3992: P_SOURCE_LAST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_LAST_NAME%TYPE,
3993: P_SOURCE_MIDDLE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MIDDLE_NAME%TYPE,
3994: P_SOURCE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CATEGORY%TYPE,
3995: P_SOURCE_STATUS IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATUS%TYPE,
3996: P_SOURCE_OFFICE IN JTF_RS_RESOURCE_EXTNS.SOURCE_OFFICE%TYPE,
3997: P_SOURCE_LOCATION IN JTF_RS_RESOURCE_EXTNS.SOURCE_LOCATION%TYPE,
3998: P_SOURCE_MAILSTOP IN JTF_RS_RESOURCE_EXTNS.SOURCE_MAILSTOP%TYPE,

Line 3995: P_SOURCE_STATUS IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATUS%TYPE,

3991: P_SOURCE_FIRST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_FIRST_NAME%TYPE,
3992: P_SOURCE_LAST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_LAST_NAME%TYPE,
3993: P_SOURCE_MIDDLE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MIDDLE_NAME%TYPE,
3994: P_SOURCE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CATEGORY%TYPE,
3995: P_SOURCE_STATUS IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATUS%TYPE,
3996: P_SOURCE_OFFICE IN JTF_RS_RESOURCE_EXTNS.SOURCE_OFFICE%TYPE,
3997: P_SOURCE_LOCATION IN JTF_RS_RESOURCE_EXTNS.SOURCE_LOCATION%TYPE,
3998: P_SOURCE_MAILSTOP IN JTF_RS_RESOURCE_EXTNS.SOURCE_MAILSTOP%TYPE,
3999: P_ADDRESS_ID IN JTF_RS_RESOURCE_EXTNS.ADDRESS_ID%TYPE,

Line 3996: P_SOURCE_OFFICE IN JTF_RS_RESOURCE_EXTNS.SOURCE_OFFICE%TYPE,

3992: P_SOURCE_LAST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_LAST_NAME%TYPE,
3993: P_SOURCE_MIDDLE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MIDDLE_NAME%TYPE,
3994: P_SOURCE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CATEGORY%TYPE,
3995: P_SOURCE_STATUS IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATUS%TYPE,
3996: P_SOURCE_OFFICE IN JTF_RS_RESOURCE_EXTNS.SOURCE_OFFICE%TYPE,
3997: P_SOURCE_LOCATION IN JTF_RS_RESOURCE_EXTNS.SOURCE_LOCATION%TYPE,
3998: P_SOURCE_MAILSTOP IN JTF_RS_RESOURCE_EXTNS.SOURCE_MAILSTOP%TYPE,
3999: P_ADDRESS_ID IN JTF_RS_RESOURCE_EXTNS.ADDRESS_ID%TYPE,
4000: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_RESOURCE_EXTNS.OBJECT_VERSION_NUMBER%TYPE,

Line 3997: P_SOURCE_LOCATION IN JTF_RS_RESOURCE_EXTNS.SOURCE_LOCATION%TYPE,

3993: P_SOURCE_MIDDLE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MIDDLE_NAME%TYPE,
3994: P_SOURCE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CATEGORY%TYPE,
3995: P_SOURCE_STATUS IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATUS%TYPE,
3996: P_SOURCE_OFFICE IN JTF_RS_RESOURCE_EXTNS.SOURCE_OFFICE%TYPE,
3997: P_SOURCE_LOCATION IN JTF_RS_RESOURCE_EXTNS.SOURCE_LOCATION%TYPE,
3998: P_SOURCE_MAILSTOP IN JTF_RS_RESOURCE_EXTNS.SOURCE_MAILSTOP%TYPE,
3999: P_ADDRESS_ID IN JTF_RS_RESOURCE_EXTNS.ADDRESS_ID%TYPE,
4000: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_RESOURCE_EXTNS.OBJECT_VERSION_NUMBER%TYPE,
4001: P_USER_NAME IN VARCHAR2,

Line 3998: P_SOURCE_MAILSTOP IN JTF_RS_RESOURCE_EXTNS.SOURCE_MAILSTOP%TYPE,

3994: P_SOURCE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CATEGORY%TYPE,
3995: P_SOURCE_STATUS IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATUS%TYPE,
3996: P_SOURCE_OFFICE IN JTF_RS_RESOURCE_EXTNS.SOURCE_OFFICE%TYPE,
3997: P_SOURCE_LOCATION IN JTF_RS_RESOURCE_EXTNS.SOURCE_LOCATION%TYPE,
3998: P_SOURCE_MAILSTOP IN JTF_RS_RESOURCE_EXTNS.SOURCE_MAILSTOP%TYPE,
3999: P_ADDRESS_ID IN JTF_RS_RESOURCE_EXTNS.ADDRESS_ID%TYPE,
4000: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_RESOURCE_EXTNS.OBJECT_VERSION_NUMBER%TYPE,
4001: P_USER_NAME IN VARCHAR2,
4002: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 4005: P_SOURCE_MOBILE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_MOBILE_PHONE%TYPE,

4001: P_USER_NAME IN VARCHAR2,
4002: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
4003: X_MSG_COUNT OUT NOCOPY NUMBER,
4004: X_MSG_DATA OUT NOCOPY VARCHAR2,
4005: P_SOURCE_MOBILE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_MOBILE_PHONE%TYPE,
4006: P_SOURCE_PAGER IN JTF_RS_RESOURCE_EXTNS.SOURCE_PAGER%TYPE,
4007: P_FS_SETUP_COMPLETE IN JTF_RS_RESOURCE_EXTNS.FS_SETUP_COMPLETE%TYPE
4008: ) IS
4009:

Line 4006: P_SOURCE_PAGER IN JTF_RS_RESOURCE_EXTNS.SOURCE_PAGER%TYPE,

4002: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
4003: X_MSG_COUNT OUT NOCOPY NUMBER,
4004: X_MSG_DATA OUT NOCOPY VARCHAR2,
4005: P_SOURCE_MOBILE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_MOBILE_PHONE%TYPE,
4006: P_SOURCE_PAGER IN JTF_RS_RESOURCE_EXTNS.SOURCE_PAGER%TYPE,
4007: P_FS_SETUP_COMPLETE IN JTF_RS_RESOURCE_EXTNS.FS_SETUP_COMPLETE%TYPE
4008: ) IS
4009:
4010: l_api_version CONSTANT NUMBER := 1.0;

Line 4015: l_start_date_active jtf_rs_resource_extns.start_date_active%TYPE;

4011: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_RESOURCE';
4012: /* Moved the initial assignment of below variables to inside begin */
4013: l_resource_id jtf_rs_resource_extns.resource_id%TYPE;
4014: l_managing_emp_id jtf_rs_resource_extns.managing_employee_id%TYPE;
4015: l_start_date_active jtf_rs_resource_extns.start_date_active%TYPE;
4016: l_end_date_active jtf_rs_resource_extns.end_date_active%TYPE;
4017: l_time_zone jtf_rs_resource_extns.time_zone%TYPE;
4018: l_cost_per_hr jtf_rs_resource_extns.cost_per_hr%TYPE;
4019: l_primary_language jtf_rs_resource_extns.primary_language%TYPE;

Line 4020: l_secondary_language jtf_rs_resource_extns.secondary_language%TYPE;

4016: l_end_date_active jtf_rs_resource_extns.end_date_active%TYPE;
4017: l_time_zone jtf_rs_resource_extns.time_zone%TYPE;
4018: l_cost_per_hr jtf_rs_resource_extns.cost_per_hr%TYPE;
4019: l_primary_language jtf_rs_resource_extns.primary_language%TYPE;
4020: l_secondary_language jtf_rs_resource_extns.secondary_language%TYPE;
4021: l_support_site_id jtf_rs_resource_extns.support_site_id%TYPE;
4022: l_ies_agent_login jtf_rs_resource_extns.ies_agent_login%TYPE;
4023: l_server_group_id jtf_rs_resource_extns.server_group_id%TYPE;
4024: l_assigned_to_group_id jtf_rs_resource_extns.assigned_to_group_id%TYPE;

Line 4021: l_support_site_id jtf_rs_resource_extns.support_site_id%TYPE;

4017: l_time_zone jtf_rs_resource_extns.time_zone%TYPE;
4018: l_cost_per_hr jtf_rs_resource_extns.cost_per_hr%TYPE;
4019: l_primary_language jtf_rs_resource_extns.primary_language%TYPE;
4020: l_secondary_language jtf_rs_resource_extns.secondary_language%TYPE;
4021: l_support_site_id jtf_rs_resource_extns.support_site_id%TYPE;
4022: l_ies_agent_login jtf_rs_resource_extns.ies_agent_login%TYPE;
4023: l_server_group_id jtf_rs_resource_extns.server_group_id%TYPE;
4024: l_assigned_to_group_id jtf_rs_resource_extns.assigned_to_group_id%TYPE;
4025: l_cost_center jtf_rs_resource_extns.cost_center%TYPE;

Line 4023: l_server_group_id jtf_rs_resource_extns.server_group_id%TYPE;

4019: l_primary_language jtf_rs_resource_extns.primary_language%TYPE;
4020: l_secondary_language jtf_rs_resource_extns.secondary_language%TYPE;
4021: l_support_site_id jtf_rs_resource_extns.support_site_id%TYPE;
4022: l_ies_agent_login jtf_rs_resource_extns.ies_agent_login%TYPE;
4023: l_server_group_id jtf_rs_resource_extns.server_group_id%TYPE;
4024: l_assigned_to_group_id jtf_rs_resource_extns.assigned_to_group_id%TYPE;
4025: l_cost_center jtf_rs_resource_extns.cost_center%TYPE;
4026: l_charge_to_cost_center jtf_rs_resource_extns.charge_to_cost_center%TYPE;
4027: l_comp_currency_code jtf_rs_resource_extns.compensation_currency_code%TYPE;

Line 4043: l_source_name jtf_rs_resource_extns.source_name%type;

4039: l_check_flag VARCHAR2(1);
4040:
4041: /* Moved the initial assignment of below variables to inside begin */
4042: l_resource_name jtf_rs_resource_extns_tl.resource_name%type;
4043: l_source_name jtf_rs_resource_extns.source_name%type;
4044: l_source_number jtf_rs_resource_extns.source_number%type;
4045: l_source_job_title jtf_rs_resource_extns.source_job_title%type;
4046: l_source_email jtf_rs_resource_extns.source_email%type;
4047: l_source_phone jtf_rs_resource_extns.source_phone%type;

Line 4044: l_source_number jtf_rs_resource_extns.source_number%type;

4040:
4041: /* Moved the initial assignment of below variables to inside begin */
4042: l_resource_name jtf_rs_resource_extns_tl.resource_name%type;
4043: l_source_name jtf_rs_resource_extns.source_name%type;
4044: l_source_number jtf_rs_resource_extns.source_number%type;
4045: l_source_job_title jtf_rs_resource_extns.source_job_title%type;
4046: l_source_email jtf_rs_resource_extns.source_email%type;
4047: l_source_phone jtf_rs_resource_extns.source_phone%type;
4048: l_source_org_id number;

Line 4045: l_source_job_title jtf_rs_resource_extns.source_job_title%type;

4041: /* Moved the initial assignment of below variables to inside begin */
4042: l_resource_name jtf_rs_resource_extns_tl.resource_name%type;
4043: l_source_name jtf_rs_resource_extns.source_name%type;
4044: l_source_number jtf_rs_resource_extns.source_number%type;
4045: l_source_job_title jtf_rs_resource_extns.source_job_title%type;
4046: l_source_email jtf_rs_resource_extns.source_email%type;
4047: l_source_phone jtf_rs_resource_extns.source_phone%type;
4048: l_source_org_id number;
4049: l_source_org_name jtf_rs_resource_extns.source_org_name%type;

Line 4046: l_source_email jtf_rs_resource_extns.source_email%type;

4042: l_resource_name jtf_rs_resource_extns_tl.resource_name%type;
4043: l_source_name jtf_rs_resource_extns.source_name%type;
4044: l_source_number jtf_rs_resource_extns.source_number%type;
4045: l_source_job_title jtf_rs_resource_extns.source_job_title%type;
4046: l_source_email jtf_rs_resource_extns.source_email%type;
4047: l_source_phone jtf_rs_resource_extns.source_phone%type;
4048: l_source_org_id number;
4049: l_source_org_name jtf_rs_resource_extns.source_org_name%type;
4050: l_source_address1 jtf_rs_resource_extns.source_address1%type;

Line 4047: l_source_phone jtf_rs_resource_extns.source_phone%type;

4043: l_source_name jtf_rs_resource_extns.source_name%type;
4044: l_source_number jtf_rs_resource_extns.source_number%type;
4045: l_source_job_title jtf_rs_resource_extns.source_job_title%type;
4046: l_source_email jtf_rs_resource_extns.source_email%type;
4047: l_source_phone jtf_rs_resource_extns.source_phone%type;
4048: l_source_org_id number;
4049: l_source_org_name jtf_rs_resource_extns.source_org_name%type;
4050: l_source_address1 jtf_rs_resource_extns.source_address1%type;
4051: l_source_address2 jtf_rs_resource_extns.source_address2%type;

Line 4049: l_source_org_name jtf_rs_resource_extns.source_org_name%type;

4045: l_source_job_title jtf_rs_resource_extns.source_job_title%type;
4046: l_source_email jtf_rs_resource_extns.source_email%type;
4047: l_source_phone jtf_rs_resource_extns.source_phone%type;
4048: l_source_org_id number;
4049: l_source_org_name jtf_rs_resource_extns.source_org_name%type;
4050: l_source_address1 jtf_rs_resource_extns.source_address1%type;
4051: l_source_address2 jtf_rs_resource_extns.source_address2%type;
4052: l_source_address3 jtf_rs_resource_extns.source_address3%type;
4053: l_source_address4 jtf_rs_resource_extns.source_address4%type;

Line 4050: l_source_address1 jtf_rs_resource_extns.source_address1%type;

4046: l_source_email jtf_rs_resource_extns.source_email%type;
4047: l_source_phone jtf_rs_resource_extns.source_phone%type;
4048: l_source_org_id number;
4049: l_source_org_name jtf_rs_resource_extns.source_org_name%type;
4050: l_source_address1 jtf_rs_resource_extns.source_address1%type;
4051: l_source_address2 jtf_rs_resource_extns.source_address2%type;
4052: l_source_address3 jtf_rs_resource_extns.source_address3%type;
4053: l_source_address4 jtf_rs_resource_extns.source_address4%type;
4054: l_source_city jtf_rs_resource_extns.source_city%type;

Line 4051: l_source_address2 jtf_rs_resource_extns.source_address2%type;

4047: l_source_phone jtf_rs_resource_extns.source_phone%type;
4048: l_source_org_id number;
4049: l_source_org_name jtf_rs_resource_extns.source_org_name%type;
4050: l_source_address1 jtf_rs_resource_extns.source_address1%type;
4051: l_source_address2 jtf_rs_resource_extns.source_address2%type;
4052: l_source_address3 jtf_rs_resource_extns.source_address3%type;
4053: l_source_address4 jtf_rs_resource_extns.source_address4%type;
4054: l_source_city jtf_rs_resource_extns.source_city%type;
4055: l_source_postal_code jtf_rs_resource_extns.source_postal_code%type;

Line 4052: l_source_address3 jtf_rs_resource_extns.source_address3%type;

4048: l_source_org_id number;
4049: l_source_org_name jtf_rs_resource_extns.source_org_name%type;
4050: l_source_address1 jtf_rs_resource_extns.source_address1%type;
4051: l_source_address2 jtf_rs_resource_extns.source_address2%type;
4052: l_source_address3 jtf_rs_resource_extns.source_address3%type;
4053: l_source_address4 jtf_rs_resource_extns.source_address4%type;
4054: l_source_city jtf_rs_resource_extns.source_city%type;
4055: l_source_postal_code jtf_rs_resource_extns.source_postal_code%type;
4056: l_source_state jtf_rs_resource_extns.source_state%type;

Line 4053: l_source_address4 jtf_rs_resource_extns.source_address4%type;

4049: l_source_org_name jtf_rs_resource_extns.source_org_name%type;
4050: l_source_address1 jtf_rs_resource_extns.source_address1%type;
4051: l_source_address2 jtf_rs_resource_extns.source_address2%type;
4052: l_source_address3 jtf_rs_resource_extns.source_address3%type;
4053: l_source_address4 jtf_rs_resource_extns.source_address4%type;
4054: l_source_city jtf_rs_resource_extns.source_city%type;
4055: l_source_postal_code jtf_rs_resource_extns.source_postal_code%type;
4056: l_source_state jtf_rs_resource_extns.source_state%type;
4057: l_source_province jtf_rs_resource_extns.source_province%type;

Line 4054: l_source_city jtf_rs_resource_extns.source_city%type;

4050: l_source_address1 jtf_rs_resource_extns.source_address1%type;
4051: l_source_address2 jtf_rs_resource_extns.source_address2%type;
4052: l_source_address3 jtf_rs_resource_extns.source_address3%type;
4053: l_source_address4 jtf_rs_resource_extns.source_address4%type;
4054: l_source_city jtf_rs_resource_extns.source_city%type;
4055: l_source_postal_code jtf_rs_resource_extns.source_postal_code%type;
4056: l_source_state jtf_rs_resource_extns.source_state%type;
4057: l_source_province jtf_rs_resource_extns.source_province%type;
4058: l_source_county jtf_rs_resource_extns.source_county%type;

Line 4055: l_source_postal_code jtf_rs_resource_extns.source_postal_code%type;

4051: l_source_address2 jtf_rs_resource_extns.source_address2%type;
4052: l_source_address3 jtf_rs_resource_extns.source_address3%type;
4053: l_source_address4 jtf_rs_resource_extns.source_address4%type;
4054: l_source_city jtf_rs_resource_extns.source_city%type;
4055: l_source_postal_code jtf_rs_resource_extns.source_postal_code%type;
4056: l_source_state jtf_rs_resource_extns.source_state%type;
4057: l_source_province jtf_rs_resource_extns.source_province%type;
4058: l_source_county jtf_rs_resource_extns.source_county%type;
4059: l_source_country jtf_rs_resource_extns.source_country%type;

Line 4056: l_source_state jtf_rs_resource_extns.source_state%type;

4052: l_source_address3 jtf_rs_resource_extns.source_address3%type;
4053: l_source_address4 jtf_rs_resource_extns.source_address4%type;
4054: l_source_city jtf_rs_resource_extns.source_city%type;
4055: l_source_postal_code jtf_rs_resource_extns.source_postal_code%type;
4056: l_source_state jtf_rs_resource_extns.source_state%type;
4057: l_source_province jtf_rs_resource_extns.source_province%type;
4058: l_source_county jtf_rs_resource_extns.source_county%type;
4059: l_source_country jtf_rs_resource_extns.source_country%type;
4060: l_source_mgr_id jtf_rs_resource_extns.source_mgr_id%type;

Line 4057: l_source_province jtf_rs_resource_extns.source_province%type;

4053: l_source_address4 jtf_rs_resource_extns.source_address4%type;
4054: l_source_city jtf_rs_resource_extns.source_city%type;
4055: l_source_postal_code jtf_rs_resource_extns.source_postal_code%type;
4056: l_source_state jtf_rs_resource_extns.source_state%type;
4057: l_source_province jtf_rs_resource_extns.source_province%type;
4058: l_source_county jtf_rs_resource_extns.source_county%type;
4059: l_source_country jtf_rs_resource_extns.source_country%type;
4060: l_source_mgr_id jtf_rs_resource_extns.source_mgr_id%type;
4061: l_source_mgr_name jtf_rs_resource_extns.source_mgr_name%type;

Line 4058: l_source_county jtf_rs_resource_extns.source_county%type;

4054: l_source_city jtf_rs_resource_extns.source_city%type;
4055: l_source_postal_code jtf_rs_resource_extns.source_postal_code%type;
4056: l_source_state jtf_rs_resource_extns.source_state%type;
4057: l_source_province jtf_rs_resource_extns.source_province%type;
4058: l_source_county jtf_rs_resource_extns.source_county%type;
4059: l_source_country jtf_rs_resource_extns.source_country%type;
4060: l_source_mgr_id jtf_rs_resource_extns.source_mgr_id%type;
4061: l_source_mgr_name jtf_rs_resource_extns.source_mgr_name%type;
4062: l_source_business_grp_id jtf_rs_resource_extns.source_business_grp_id%type;

Line 4059: l_source_country jtf_rs_resource_extns.source_country%type;

4055: l_source_postal_code jtf_rs_resource_extns.source_postal_code%type;
4056: l_source_state jtf_rs_resource_extns.source_state%type;
4057: l_source_province jtf_rs_resource_extns.source_province%type;
4058: l_source_county jtf_rs_resource_extns.source_county%type;
4059: l_source_country jtf_rs_resource_extns.source_country%type;
4060: l_source_mgr_id jtf_rs_resource_extns.source_mgr_id%type;
4061: l_source_mgr_name jtf_rs_resource_extns.source_mgr_name%type;
4062: l_source_business_grp_id jtf_rs_resource_extns.source_business_grp_id%type;
4063: l_source_business_grp_name jtf_rs_resource_extns.source_business_grp_name%type;

Line 4060: l_source_mgr_id jtf_rs_resource_extns.source_mgr_id%type;

4056: l_source_state jtf_rs_resource_extns.source_state%type;
4057: l_source_province jtf_rs_resource_extns.source_province%type;
4058: l_source_county jtf_rs_resource_extns.source_county%type;
4059: l_source_country jtf_rs_resource_extns.source_country%type;
4060: l_source_mgr_id jtf_rs_resource_extns.source_mgr_id%type;
4061: l_source_mgr_name jtf_rs_resource_extns.source_mgr_name%type;
4062: l_source_business_grp_id jtf_rs_resource_extns.source_business_grp_id%type;
4063: l_source_business_grp_name jtf_rs_resource_extns.source_business_grp_name%type;
4064: l_source_first_name jtf_rs_resource_extns.source_first_name%type;

Line 4061: l_source_mgr_name jtf_rs_resource_extns.source_mgr_name%type;

4057: l_source_province jtf_rs_resource_extns.source_province%type;
4058: l_source_county jtf_rs_resource_extns.source_county%type;
4059: l_source_country jtf_rs_resource_extns.source_country%type;
4060: l_source_mgr_id jtf_rs_resource_extns.source_mgr_id%type;
4061: l_source_mgr_name jtf_rs_resource_extns.source_mgr_name%type;
4062: l_source_business_grp_id jtf_rs_resource_extns.source_business_grp_id%type;
4063: l_source_business_grp_name jtf_rs_resource_extns.source_business_grp_name%type;
4064: l_source_first_name jtf_rs_resource_extns.source_first_name%type;
4065: l_source_last_name jtf_rs_resource_extns.source_last_name%type;

Line 4062: l_source_business_grp_id jtf_rs_resource_extns.source_business_grp_id%type;

4058: l_source_county jtf_rs_resource_extns.source_county%type;
4059: l_source_country jtf_rs_resource_extns.source_country%type;
4060: l_source_mgr_id jtf_rs_resource_extns.source_mgr_id%type;
4061: l_source_mgr_name jtf_rs_resource_extns.source_mgr_name%type;
4062: l_source_business_grp_id jtf_rs_resource_extns.source_business_grp_id%type;
4063: l_source_business_grp_name jtf_rs_resource_extns.source_business_grp_name%type;
4064: l_source_first_name jtf_rs_resource_extns.source_first_name%type;
4065: l_source_last_name jtf_rs_resource_extns.source_last_name%type;
4066: l_source_middle_name jtf_rs_resource_extns.source_middle_name%type;

Line 4063: l_source_business_grp_name jtf_rs_resource_extns.source_business_grp_name%type;

4059: l_source_country jtf_rs_resource_extns.source_country%type;
4060: l_source_mgr_id jtf_rs_resource_extns.source_mgr_id%type;
4061: l_source_mgr_name jtf_rs_resource_extns.source_mgr_name%type;
4062: l_source_business_grp_id jtf_rs_resource_extns.source_business_grp_id%type;
4063: l_source_business_grp_name jtf_rs_resource_extns.source_business_grp_name%type;
4064: l_source_first_name jtf_rs_resource_extns.source_first_name%type;
4065: l_source_last_name jtf_rs_resource_extns.source_last_name%type;
4066: l_source_middle_name jtf_rs_resource_extns.source_middle_name%type;
4067: l_source_status jtf_rs_resource_extns.source_status%type;

Line 4064: l_source_first_name jtf_rs_resource_extns.source_first_name%type;

4060: l_source_mgr_id jtf_rs_resource_extns.source_mgr_id%type;
4061: l_source_mgr_name jtf_rs_resource_extns.source_mgr_name%type;
4062: l_source_business_grp_id jtf_rs_resource_extns.source_business_grp_id%type;
4063: l_source_business_grp_name jtf_rs_resource_extns.source_business_grp_name%type;
4064: l_source_first_name jtf_rs_resource_extns.source_first_name%type;
4065: l_source_last_name jtf_rs_resource_extns.source_last_name%type;
4066: l_source_middle_name jtf_rs_resource_extns.source_middle_name%type;
4067: l_source_status jtf_rs_resource_extns.source_status%type;
4068: l_source_office jtf_rs_resource_extns.source_office%type;

Line 4065: l_source_last_name jtf_rs_resource_extns.source_last_name%type;

4061: l_source_mgr_name jtf_rs_resource_extns.source_mgr_name%type;
4062: l_source_business_grp_id jtf_rs_resource_extns.source_business_grp_id%type;
4063: l_source_business_grp_name jtf_rs_resource_extns.source_business_grp_name%type;
4064: l_source_first_name jtf_rs_resource_extns.source_first_name%type;
4065: l_source_last_name jtf_rs_resource_extns.source_last_name%type;
4066: l_source_middle_name jtf_rs_resource_extns.source_middle_name%type;
4067: l_source_status jtf_rs_resource_extns.source_status%type;
4068: l_source_office jtf_rs_resource_extns.source_office%type;
4069: l_source_location jtf_rs_resource_extns.source_location%type;

Line 4066: l_source_middle_name jtf_rs_resource_extns.source_middle_name%type;

4062: l_source_business_grp_id jtf_rs_resource_extns.source_business_grp_id%type;
4063: l_source_business_grp_name jtf_rs_resource_extns.source_business_grp_name%type;
4064: l_source_first_name jtf_rs_resource_extns.source_first_name%type;
4065: l_source_last_name jtf_rs_resource_extns.source_last_name%type;
4066: l_source_middle_name jtf_rs_resource_extns.source_middle_name%type;
4067: l_source_status jtf_rs_resource_extns.source_status%type;
4068: l_source_office jtf_rs_resource_extns.source_office%type;
4069: l_source_location jtf_rs_resource_extns.source_location%type;
4070: l_source_mailstop jtf_rs_resource_extns.source_mailstop%type;

Line 4067: l_source_status jtf_rs_resource_extns.source_status%type;

4063: l_source_business_grp_name jtf_rs_resource_extns.source_business_grp_name%type;
4064: l_source_first_name jtf_rs_resource_extns.source_first_name%type;
4065: l_source_last_name jtf_rs_resource_extns.source_last_name%type;
4066: l_source_middle_name jtf_rs_resource_extns.source_middle_name%type;
4067: l_source_status jtf_rs_resource_extns.source_status%type;
4068: l_source_office jtf_rs_resource_extns.source_office%type;
4069: l_source_location jtf_rs_resource_extns.source_location%type;
4070: l_source_mailstop jtf_rs_resource_extns.source_mailstop%type;
4071: l_source_mobile_phone jtf_rs_resource_extns.source_mobile_phone%type;

Line 4068: l_source_office jtf_rs_resource_extns.source_office%type;

4064: l_source_first_name jtf_rs_resource_extns.source_first_name%type;
4065: l_source_last_name jtf_rs_resource_extns.source_last_name%type;
4066: l_source_middle_name jtf_rs_resource_extns.source_middle_name%type;
4067: l_source_status jtf_rs_resource_extns.source_status%type;
4068: l_source_office jtf_rs_resource_extns.source_office%type;
4069: l_source_location jtf_rs_resource_extns.source_location%type;
4070: l_source_mailstop jtf_rs_resource_extns.source_mailstop%type;
4071: l_source_mobile_phone jtf_rs_resource_extns.source_mobile_phone%type;
4072: l_source_pager jtf_rs_resource_extns.source_pager%type;

Line 4069: l_source_location jtf_rs_resource_extns.source_location%type;

4065: l_source_last_name jtf_rs_resource_extns.source_last_name%type;
4066: l_source_middle_name jtf_rs_resource_extns.source_middle_name%type;
4067: l_source_status jtf_rs_resource_extns.source_status%type;
4068: l_source_office jtf_rs_resource_extns.source_office%type;
4069: l_source_location jtf_rs_resource_extns.source_location%type;
4070: l_source_mailstop jtf_rs_resource_extns.source_mailstop%type;
4071: l_source_mobile_phone jtf_rs_resource_extns.source_mobile_phone%type;
4072: l_source_pager jtf_rs_resource_extns.source_pager%type;
4073: l_address_id jtf_rs_resource_extns.address_id%type;

Line 4070: l_source_mailstop jtf_rs_resource_extns.source_mailstop%type;

4066: l_source_middle_name jtf_rs_resource_extns.source_middle_name%type;
4067: l_source_status jtf_rs_resource_extns.source_status%type;
4068: l_source_office jtf_rs_resource_extns.source_office%type;
4069: l_source_location jtf_rs_resource_extns.source_location%type;
4070: l_source_mailstop jtf_rs_resource_extns.source_mailstop%type;
4071: l_source_mobile_phone jtf_rs_resource_extns.source_mobile_phone%type;
4072: l_source_pager jtf_rs_resource_extns.source_pager%type;
4073: l_address_id jtf_rs_resource_extns.address_id%type;
4074: l_source_category jtf_rs_resource_extns.source_category%type;

Line 4071: l_source_mobile_phone jtf_rs_resource_extns.source_mobile_phone%type;

4067: l_source_status jtf_rs_resource_extns.source_status%type;
4068: l_source_office jtf_rs_resource_extns.source_office%type;
4069: l_source_location jtf_rs_resource_extns.source_location%type;
4070: l_source_mailstop jtf_rs_resource_extns.source_mailstop%type;
4071: l_source_mobile_phone jtf_rs_resource_extns.source_mobile_phone%type;
4072: l_source_pager jtf_rs_resource_extns.source_pager%type;
4073: l_address_id jtf_rs_resource_extns.address_id%type;
4074: l_source_category jtf_rs_resource_extns.source_category%type;
4075: l_user_name jtf_rs_resource_extns.user_name%type;

Line 4072: l_source_pager jtf_rs_resource_extns.source_pager%type;

4068: l_source_office jtf_rs_resource_extns.source_office%type;
4069: l_source_location jtf_rs_resource_extns.source_location%type;
4070: l_source_mailstop jtf_rs_resource_extns.source_mailstop%type;
4071: l_source_mobile_phone jtf_rs_resource_extns.source_mobile_phone%type;
4072: l_source_pager jtf_rs_resource_extns.source_pager%type;
4073: l_address_id jtf_rs_resource_extns.address_id%type;
4074: l_source_category jtf_rs_resource_extns.source_category%type;
4075: l_user_name jtf_rs_resource_extns.user_name%type;
4076:

Line 4074: l_source_category jtf_rs_resource_extns.source_category%type;

4070: l_source_mailstop jtf_rs_resource_extns.source_mailstop%type;
4071: l_source_mobile_phone jtf_rs_resource_extns.source_mobile_phone%type;
4072: l_source_pager jtf_rs_resource_extns.source_pager%type;
4073: l_address_id jtf_rs_resource_extns.address_id%type;
4074: l_source_category jtf_rs_resource_extns.source_category%type;
4075: l_user_name jtf_rs_resource_extns.user_name%type;
4076:
4077:
4078: --added for NOCOPY to handle in JTF_RESOURCE_UTL

Line 4080: l_server_group_id_out jtf_rs_resource_extns.server_group_id%TYPE ;

4076:
4077:
4078: --added for NOCOPY to handle in JTF_RESOURCE_UTL
4079: l_managing_emp_id_out jtf_rs_resource_extns.managing_employee_id%TYPE ;
4080: l_server_group_id_out jtf_rs_resource_extns.server_group_id%TYPE ;
4081: l_comp_service_team_id_out jtf_rs_resource_extns.comp_service_team_id%TYPE;
4082: l_fs_setup_complete jtf_rs_resource_extns.fs_setup_complete%type;
4083:
4084: CURSOR c_resource_update(

Line 6075: P_START_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE,

6071: P_INIT_MSG_LIST IN VARCHAR2,
6072: P_COMMIT IN VARCHAR2,
6073: P_RESOURCE_ID IN JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,
6074: P_MANAGING_EMP_ID IN JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE,
6075: P_START_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE,
6076: P_END_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE,
6077: P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE,
6078: P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE,
6079: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE,

Line 6080: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE,

6076: P_END_DATE_ACTIVE IN JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE,
6077: P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE,
6078: P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE,
6079: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE,
6080: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE,
6081: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE,
6082: P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE,
6083: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE,
6084: P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE,

Line 6081: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE,

6077: P_TIME_ZONE IN JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE,
6078: P_COST_PER_HR IN JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE,
6079: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE,
6080: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE,
6081: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE,
6082: P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE,
6083: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE,
6084: P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE,
6085: P_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE,

Line 6083: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE,

6079: P_PRIMARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE,
6080: P_SECONDARY_LANGUAGE IN JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE,
6081: P_SUPPORT_SITE_ID IN JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE,
6082: P_IES_AGENT_LOGIN IN JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE,
6083: P_SERVER_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE,
6084: P_ASSIGNED_TO_GROUP_ID IN JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE,
6085: P_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE,
6086: P_CHARGE_TO_COST_CENTER IN JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE,
6087: P_COMP_CURRENCY_CODE IN JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE,

Line 6111: P_SOURCE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_NAME%TYPE,

6107: P_ATTRIBUTE14 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE14%TYPE,
6108: P_ATTRIBUTE15 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE15%TYPE,
6109: P_ATTRIBUTE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE_CATEGORY%TYPE,
6110: P_RESOURCE_NAME IN JTF_RS_RESOURCE_EXTNS_TL.RESOURCE_NAME%TYPE,
6111: P_SOURCE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_NAME%TYPE,
6112: P_SOURCE_NUMBER IN JTF_RS_RESOURCE_EXTNS.SOURCE_NUMBER%TYPE,
6113: P_SOURCE_JOB_TITLE IN JTF_RS_RESOURCE_EXTNS.SOURCE_JOB_TITLE%TYPE,
6114: P_SOURCE_EMAIL IN JTF_RS_RESOURCE_EXTNS.SOURCE_EMAIL%TYPE,
6115: P_SOURCE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PHONE%TYPE,

Line 6112: P_SOURCE_NUMBER IN JTF_RS_RESOURCE_EXTNS.SOURCE_NUMBER%TYPE,

6108: P_ATTRIBUTE15 IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE15%TYPE,
6109: P_ATTRIBUTE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE_CATEGORY%TYPE,
6110: P_RESOURCE_NAME IN JTF_RS_RESOURCE_EXTNS_TL.RESOURCE_NAME%TYPE,
6111: P_SOURCE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_NAME%TYPE,
6112: P_SOURCE_NUMBER IN JTF_RS_RESOURCE_EXTNS.SOURCE_NUMBER%TYPE,
6113: P_SOURCE_JOB_TITLE IN JTF_RS_RESOURCE_EXTNS.SOURCE_JOB_TITLE%TYPE,
6114: P_SOURCE_EMAIL IN JTF_RS_RESOURCE_EXTNS.SOURCE_EMAIL%TYPE,
6115: P_SOURCE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PHONE%TYPE,
6116: P_SOURCE_ORG_ID IN NUMBER,

Line 6113: P_SOURCE_JOB_TITLE IN JTF_RS_RESOURCE_EXTNS.SOURCE_JOB_TITLE%TYPE,

6109: P_ATTRIBUTE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.ATTRIBUTE_CATEGORY%TYPE,
6110: P_RESOURCE_NAME IN JTF_RS_RESOURCE_EXTNS_TL.RESOURCE_NAME%TYPE,
6111: P_SOURCE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_NAME%TYPE,
6112: P_SOURCE_NUMBER IN JTF_RS_RESOURCE_EXTNS.SOURCE_NUMBER%TYPE,
6113: P_SOURCE_JOB_TITLE IN JTF_RS_RESOURCE_EXTNS.SOURCE_JOB_TITLE%TYPE,
6114: P_SOURCE_EMAIL IN JTF_RS_RESOURCE_EXTNS.SOURCE_EMAIL%TYPE,
6115: P_SOURCE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PHONE%TYPE,
6116: P_SOURCE_ORG_ID IN NUMBER,
6117: P_SOURCE_ORG_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_ORG_NAME%TYPE,

Line 6114: P_SOURCE_EMAIL IN JTF_RS_RESOURCE_EXTNS.SOURCE_EMAIL%TYPE,

6110: P_RESOURCE_NAME IN JTF_RS_RESOURCE_EXTNS_TL.RESOURCE_NAME%TYPE,
6111: P_SOURCE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_NAME%TYPE,
6112: P_SOURCE_NUMBER IN JTF_RS_RESOURCE_EXTNS.SOURCE_NUMBER%TYPE,
6113: P_SOURCE_JOB_TITLE IN JTF_RS_RESOURCE_EXTNS.SOURCE_JOB_TITLE%TYPE,
6114: P_SOURCE_EMAIL IN JTF_RS_RESOURCE_EXTNS.SOURCE_EMAIL%TYPE,
6115: P_SOURCE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PHONE%TYPE,
6116: P_SOURCE_ORG_ID IN NUMBER,
6117: P_SOURCE_ORG_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_ORG_NAME%TYPE,
6118: P_SOURCE_ADDRESS1 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS1%TYPE,

Line 6115: P_SOURCE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PHONE%TYPE,

6111: P_SOURCE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_NAME%TYPE,
6112: P_SOURCE_NUMBER IN JTF_RS_RESOURCE_EXTNS.SOURCE_NUMBER%TYPE,
6113: P_SOURCE_JOB_TITLE IN JTF_RS_RESOURCE_EXTNS.SOURCE_JOB_TITLE%TYPE,
6114: P_SOURCE_EMAIL IN JTF_RS_RESOURCE_EXTNS.SOURCE_EMAIL%TYPE,
6115: P_SOURCE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PHONE%TYPE,
6116: P_SOURCE_ORG_ID IN NUMBER,
6117: P_SOURCE_ORG_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_ORG_NAME%TYPE,
6118: P_SOURCE_ADDRESS1 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS1%TYPE,
6119: P_SOURCE_ADDRESS2 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS2%TYPE,

Line 6117: P_SOURCE_ORG_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_ORG_NAME%TYPE,

6113: P_SOURCE_JOB_TITLE IN JTF_RS_RESOURCE_EXTNS.SOURCE_JOB_TITLE%TYPE,
6114: P_SOURCE_EMAIL IN JTF_RS_RESOURCE_EXTNS.SOURCE_EMAIL%TYPE,
6115: P_SOURCE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PHONE%TYPE,
6116: P_SOURCE_ORG_ID IN NUMBER,
6117: P_SOURCE_ORG_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_ORG_NAME%TYPE,
6118: P_SOURCE_ADDRESS1 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS1%TYPE,
6119: P_SOURCE_ADDRESS2 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS2%TYPE,
6120: P_SOURCE_ADDRESS3 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS3%TYPE,
6121: P_SOURCE_ADDRESS4 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS4%TYPE,

Line 6118: P_SOURCE_ADDRESS1 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS1%TYPE,

6114: P_SOURCE_EMAIL IN JTF_RS_RESOURCE_EXTNS.SOURCE_EMAIL%TYPE,
6115: P_SOURCE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PHONE%TYPE,
6116: P_SOURCE_ORG_ID IN NUMBER,
6117: P_SOURCE_ORG_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_ORG_NAME%TYPE,
6118: P_SOURCE_ADDRESS1 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS1%TYPE,
6119: P_SOURCE_ADDRESS2 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS2%TYPE,
6120: P_SOURCE_ADDRESS3 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS3%TYPE,
6121: P_SOURCE_ADDRESS4 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS4%TYPE,
6122: P_SOURCE_CITY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CITY%TYPE,

Line 6119: P_SOURCE_ADDRESS2 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS2%TYPE,

6115: P_SOURCE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PHONE%TYPE,
6116: P_SOURCE_ORG_ID IN NUMBER,
6117: P_SOURCE_ORG_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_ORG_NAME%TYPE,
6118: P_SOURCE_ADDRESS1 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS1%TYPE,
6119: P_SOURCE_ADDRESS2 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS2%TYPE,
6120: P_SOURCE_ADDRESS3 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS3%TYPE,
6121: P_SOURCE_ADDRESS4 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS4%TYPE,
6122: P_SOURCE_CITY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CITY%TYPE,
6123: P_SOURCE_POSTAL_CODE IN JTF_RS_RESOURCE_EXTNS.SOURCE_POSTAL_CODE%TYPE,

Line 6120: P_SOURCE_ADDRESS3 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS3%TYPE,

6116: P_SOURCE_ORG_ID IN NUMBER,
6117: P_SOURCE_ORG_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_ORG_NAME%TYPE,
6118: P_SOURCE_ADDRESS1 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS1%TYPE,
6119: P_SOURCE_ADDRESS2 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS2%TYPE,
6120: P_SOURCE_ADDRESS3 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS3%TYPE,
6121: P_SOURCE_ADDRESS4 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS4%TYPE,
6122: P_SOURCE_CITY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CITY%TYPE,
6123: P_SOURCE_POSTAL_CODE IN JTF_RS_RESOURCE_EXTNS.SOURCE_POSTAL_CODE%TYPE,
6124: P_SOURCE_STATE IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATE%TYPE,

Line 6121: P_SOURCE_ADDRESS4 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS4%TYPE,

6117: P_SOURCE_ORG_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_ORG_NAME%TYPE,
6118: P_SOURCE_ADDRESS1 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS1%TYPE,
6119: P_SOURCE_ADDRESS2 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS2%TYPE,
6120: P_SOURCE_ADDRESS3 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS3%TYPE,
6121: P_SOURCE_ADDRESS4 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS4%TYPE,
6122: P_SOURCE_CITY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CITY%TYPE,
6123: P_SOURCE_POSTAL_CODE IN JTF_RS_RESOURCE_EXTNS.SOURCE_POSTAL_CODE%TYPE,
6124: P_SOURCE_STATE IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATE%TYPE,
6125: P_SOURCE_PROVINCE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PROVINCE%TYPE,

Line 6122: P_SOURCE_CITY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CITY%TYPE,

6118: P_SOURCE_ADDRESS1 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS1%TYPE,
6119: P_SOURCE_ADDRESS2 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS2%TYPE,
6120: P_SOURCE_ADDRESS3 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS3%TYPE,
6121: P_SOURCE_ADDRESS4 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS4%TYPE,
6122: P_SOURCE_CITY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CITY%TYPE,
6123: P_SOURCE_POSTAL_CODE IN JTF_RS_RESOURCE_EXTNS.SOURCE_POSTAL_CODE%TYPE,
6124: P_SOURCE_STATE IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATE%TYPE,
6125: P_SOURCE_PROVINCE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PROVINCE%TYPE,
6126: P_SOURCE_COUNTY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTY%TYPE,

Line 6123: P_SOURCE_POSTAL_CODE IN JTF_RS_RESOURCE_EXTNS.SOURCE_POSTAL_CODE%TYPE,

6119: P_SOURCE_ADDRESS2 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS2%TYPE,
6120: P_SOURCE_ADDRESS3 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS3%TYPE,
6121: P_SOURCE_ADDRESS4 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS4%TYPE,
6122: P_SOURCE_CITY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CITY%TYPE,
6123: P_SOURCE_POSTAL_CODE IN JTF_RS_RESOURCE_EXTNS.SOURCE_POSTAL_CODE%TYPE,
6124: P_SOURCE_STATE IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATE%TYPE,
6125: P_SOURCE_PROVINCE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PROVINCE%TYPE,
6126: P_SOURCE_COUNTY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTY%TYPE,
6127: P_SOURCE_COUNTRY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTRY%TYPE,

Line 6124: P_SOURCE_STATE IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATE%TYPE,

6120: P_SOURCE_ADDRESS3 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS3%TYPE,
6121: P_SOURCE_ADDRESS4 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS4%TYPE,
6122: P_SOURCE_CITY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CITY%TYPE,
6123: P_SOURCE_POSTAL_CODE IN JTF_RS_RESOURCE_EXTNS.SOURCE_POSTAL_CODE%TYPE,
6124: P_SOURCE_STATE IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATE%TYPE,
6125: P_SOURCE_PROVINCE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PROVINCE%TYPE,
6126: P_SOURCE_COUNTY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTY%TYPE,
6127: P_SOURCE_COUNTRY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTRY%TYPE,
6128: P_SOURCE_MGR_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_ID%type,

Line 6125: P_SOURCE_PROVINCE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PROVINCE%TYPE,

6121: P_SOURCE_ADDRESS4 IN JTF_RS_RESOURCE_EXTNS.SOURCE_ADDRESS4%TYPE,
6122: P_SOURCE_CITY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CITY%TYPE,
6123: P_SOURCE_POSTAL_CODE IN JTF_RS_RESOURCE_EXTNS.SOURCE_POSTAL_CODE%TYPE,
6124: P_SOURCE_STATE IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATE%TYPE,
6125: P_SOURCE_PROVINCE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PROVINCE%TYPE,
6126: P_SOURCE_COUNTY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTY%TYPE,
6127: P_SOURCE_COUNTRY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTRY%TYPE,
6128: P_SOURCE_MGR_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_ID%type,
6129: P_SOURCE_MGR_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_NAME%type,

Line 6126: P_SOURCE_COUNTY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTY%TYPE,

6122: P_SOURCE_CITY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CITY%TYPE,
6123: P_SOURCE_POSTAL_CODE IN JTF_RS_RESOURCE_EXTNS.SOURCE_POSTAL_CODE%TYPE,
6124: P_SOURCE_STATE IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATE%TYPE,
6125: P_SOURCE_PROVINCE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PROVINCE%TYPE,
6126: P_SOURCE_COUNTY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTY%TYPE,
6127: P_SOURCE_COUNTRY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTRY%TYPE,
6128: P_SOURCE_MGR_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_ID%type,
6129: P_SOURCE_MGR_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_NAME%type,
6130: P_SOURCE_BUSINESS_GRP_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_ID%type,

Line 6127: P_SOURCE_COUNTRY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTRY%TYPE,

6123: P_SOURCE_POSTAL_CODE IN JTF_RS_RESOURCE_EXTNS.SOURCE_POSTAL_CODE%TYPE,
6124: P_SOURCE_STATE IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATE%TYPE,
6125: P_SOURCE_PROVINCE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PROVINCE%TYPE,
6126: P_SOURCE_COUNTY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTY%TYPE,
6127: P_SOURCE_COUNTRY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTRY%TYPE,
6128: P_SOURCE_MGR_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_ID%type,
6129: P_SOURCE_MGR_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_NAME%type,
6130: P_SOURCE_BUSINESS_GRP_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_ID%type,
6131: P_SOURCE_BUSINESS_GRP_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_NAME%type,

Line 6128: P_SOURCE_MGR_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_ID%type,

6124: P_SOURCE_STATE IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATE%TYPE,
6125: P_SOURCE_PROVINCE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PROVINCE%TYPE,
6126: P_SOURCE_COUNTY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTY%TYPE,
6127: P_SOURCE_COUNTRY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTRY%TYPE,
6128: P_SOURCE_MGR_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_ID%type,
6129: P_SOURCE_MGR_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_NAME%type,
6130: P_SOURCE_BUSINESS_GRP_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_ID%type,
6131: P_SOURCE_BUSINESS_GRP_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_NAME%type,
6132: P_SOURCE_FIRST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_FIRST_NAME%TYPE,

Line 6129: P_SOURCE_MGR_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_NAME%type,

6125: P_SOURCE_PROVINCE IN JTF_RS_RESOURCE_EXTNS.SOURCE_PROVINCE%TYPE,
6126: P_SOURCE_COUNTY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTY%TYPE,
6127: P_SOURCE_COUNTRY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTRY%TYPE,
6128: P_SOURCE_MGR_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_ID%type,
6129: P_SOURCE_MGR_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_NAME%type,
6130: P_SOURCE_BUSINESS_GRP_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_ID%type,
6131: P_SOURCE_BUSINESS_GRP_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_NAME%type,
6132: P_SOURCE_FIRST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_FIRST_NAME%TYPE,
6133: P_SOURCE_LAST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_LAST_NAME%TYPE,

Line 6130: P_SOURCE_BUSINESS_GRP_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_ID%type,

6126: P_SOURCE_COUNTY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTY%TYPE,
6127: P_SOURCE_COUNTRY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTRY%TYPE,
6128: P_SOURCE_MGR_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_ID%type,
6129: P_SOURCE_MGR_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_NAME%type,
6130: P_SOURCE_BUSINESS_GRP_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_ID%type,
6131: P_SOURCE_BUSINESS_GRP_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_NAME%type,
6132: P_SOURCE_FIRST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_FIRST_NAME%TYPE,
6133: P_SOURCE_LAST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_LAST_NAME%TYPE,
6134: P_SOURCE_MIDDLE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MIDDLE_NAME%TYPE,

Line 6131: P_SOURCE_BUSINESS_GRP_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_NAME%type,

6127: P_SOURCE_COUNTRY IN JTF_RS_RESOURCE_EXTNS.SOURCE_COUNTRY%TYPE,
6128: P_SOURCE_MGR_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_ID%type,
6129: P_SOURCE_MGR_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_NAME%type,
6130: P_SOURCE_BUSINESS_GRP_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_ID%type,
6131: P_SOURCE_BUSINESS_GRP_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_NAME%type,
6132: P_SOURCE_FIRST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_FIRST_NAME%TYPE,
6133: P_SOURCE_LAST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_LAST_NAME%TYPE,
6134: P_SOURCE_MIDDLE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MIDDLE_NAME%TYPE,
6135: P_SOURCE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CATEGORY%TYPE,

Line 6132: P_SOURCE_FIRST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_FIRST_NAME%TYPE,

6128: P_SOURCE_MGR_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_ID%type,
6129: P_SOURCE_MGR_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_NAME%type,
6130: P_SOURCE_BUSINESS_GRP_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_ID%type,
6131: P_SOURCE_BUSINESS_GRP_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_NAME%type,
6132: P_SOURCE_FIRST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_FIRST_NAME%TYPE,
6133: P_SOURCE_LAST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_LAST_NAME%TYPE,
6134: P_SOURCE_MIDDLE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MIDDLE_NAME%TYPE,
6135: P_SOURCE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CATEGORY%TYPE,
6136: P_SOURCE_STATUS IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATUS%TYPE,

Line 6133: P_SOURCE_LAST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_LAST_NAME%TYPE,

6129: P_SOURCE_MGR_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MGR_NAME%type,
6130: P_SOURCE_BUSINESS_GRP_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_ID%type,
6131: P_SOURCE_BUSINESS_GRP_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_NAME%type,
6132: P_SOURCE_FIRST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_FIRST_NAME%TYPE,
6133: P_SOURCE_LAST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_LAST_NAME%TYPE,
6134: P_SOURCE_MIDDLE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MIDDLE_NAME%TYPE,
6135: P_SOURCE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CATEGORY%TYPE,
6136: P_SOURCE_STATUS IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATUS%TYPE,
6137: P_SOURCE_OFFICE IN JTF_RS_RESOURCE_EXTNS.SOURCE_OFFICE%TYPE,

Line 6134: P_SOURCE_MIDDLE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MIDDLE_NAME%TYPE,

6130: P_SOURCE_BUSINESS_GRP_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_ID%type,
6131: P_SOURCE_BUSINESS_GRP_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_NAME%type,
6132: P_SOURCE_FIRST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_FIRST_NAME%TYPE,
6133: P_SOURCE_LAST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_LAST_NAME%TYPE,
6134: P_SOURCE_MIDDLE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MIDDLE_NAME%TYPE,
6135: P_SOURCE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CATEGORY%TYPE,
6136: P_SOURCE_STATUS IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATUS%TYPE,
6137: P_SOURCE_OFFICE IN JTF_RS_RESOURCE_EXTNS.SOURCE_OFFICE%TYPE,
6138: P_SOURCE_LOCATION IN JTF_RS_RESOURCE_EXTNS.SOURCE_LOCATION%TYPE,

Line 6135: P_SOURCE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CATEGORY%TYPE,

6131: P_SOURCE_BUSINESS_GRP_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_BUSINESS_GRP_NAME%type,
6132: P_SOURCE_FIRST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_FIRST_NAME%TYPE,
6133: P_SOURCE_LAST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_LAST_NAME%TYPE,
6134: P_SOURCE_MIDDLE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MIDDLE_NAME%TYPE,
6135: P_SOURCE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CATEGORY%TYPE,
6136: P_SOURCE_STATUS IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATUS%TYPE,
6137: P_SOURCE_OFFICE IN JTF_RS_RESOURCE_EXTNS.SOURCE_OFFICE%TYPE,
6138: P_SOURCE_LOCATION IN JTF_RS_RESOURCE_EXTNS.SOURCE_LOCATION%TYPE,
6139: P_SOURCE_MAILSTOP IN JTF_RS_RESOURCE_EXTNS.SOURCE_MAILSTOP%TYPE,

Line 6136: P_SOURCE_STATUS IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATUS%TYPE,

6132: P_SOURCE_FIRST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_FIRST_NAME%TYPE,
6133: P_SOURCE_LAST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_LAST_NAME%TYPE,
6134: P_SOURCE_MIDDLE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MIDDLE_NAME%TYPE,
6135: P_SOURCE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CATEGORY%TYPE,
6136: P_SOURCE_STATUS IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATUS%TYPE,
6137: P_SOURCE_OFFICE IN JTF_RS_RESOURCE_EXTNS.SOURCE_OFFICE%TYPE,
6138: P_SOURCE_LOCATION IN JTF_RS_RESOURCE_EXTNS.SOURCE_LOCATION%TYPE,
6139: P_SOURCE_MAILSTOP IN JTF_RS_RESOURCE_EXTNS.SOURCE_MAILSTOP%TYPE,
6140: P_ADDRESS_ID IN JTF_RS_RESOURCE_EXTNS.ADDRESS_ID%TYPE,

Line 6137: P_SOURCE_OFFICE IN JTF_RS_RESOURCE_EXTNS.SOURCE_OFFICE%TYPE,

6133: P_SOURCE_LAST_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_LAST_NAME%TYPE,
6134: P_SOURCE_MIDDLE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MIDDLE_NAME%TYPE,
6135: P_SOURCE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CATEGORY%TYPE,
6136: P_SOURCE_STATUS IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATUS%TYPE,
6137: P_SOURCE_OFFICE IN JTF_RS_RESOURCE_EXTNS.SOURCE_OFFICE%TYPE,
6138: P_SOURCE_LOCATION IN JTF_RS_RESOURCE_EXTNS.SOURCE_LOCATION%TYPE,
6139: P_SOURCE_MAILSTOP IN JTF_RS_RESOURCE_EXTNS.SOURCE_MAILSTOP%TYPE,
6140: P_ADDRESS_ID IN JTF_RS_RESOURCE_EXTNS.ADDRESS_ID%TYPE,
6141: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_RESOURCE_EXTNS.OBJECT_VERSION_NUMBER%TYPE,

Line 6138: P_SOURCE_LOCATION IN JTF_RS_RESOURCE_EXTNS.SOURCE_LOCATION%TYPE,

6134: P_SOURCE_MIDDLE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_MIDDLE_NAME%TYPE,
6135: P_SOURCE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CATEGORY%TYPE,
6136: P_SOURCE_STATUS IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATUS%TYPE,
6137: P_SOURCE_OFFICE IN JTF_RS_RESOURCE_EXTNS.SOURCE_OFFICE%TYPE,
6138: P_SOURCE_LOCATION IN JTF_RS_RESOURCE_EXTNS.SOURCE_LOCATION%TYPE,
6139: P_SOURCE_MAILSTOP IN JTF_RS_RESOURCE_EXTNS.SOURCE_MAILSTOP%TYPE,
6140: P_ADDRESS_ID IN JTF_RS_RESOURCE_EXTNS.ADDRESS_ID%TYPE,
6141: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_RESOURCE_EXTNS.OBJECT_VERSION_NUMBER%TYPE,
6142: P_USER_NAME IN VARCHAR2,

Line 6139: P_SOURCE_MAILSTOP IN JTF_RS_RESOURCE_EXTNS.SOURCE_MAILSTOP%TYPE,

6135: P_SOURCE_CATEGORY IN JTF_RS_RESOURCE_EXTNS.SOURCE_CATEGORY%TYPE,
6136: P_SOURCE_STATUS IN JTF_RS_RESOURCE_EXTNS.SOURCE_STATUS%TYPE,
6137: P_SOURCE_OFFICE IN JTF_RS_RESOURCE_EXTNS.SOURCE_OFFICE%TYPE,
6138: P_SOURCE_LOCATION IN JTF_RS_RESOURCE_EXTNS.SOURCE_LOCATION%TYPE,
6139: P_SOURCE_MAILSTOP IN JTF_RS_RESOURCE_EXTNS.SOURCE_MAILSTOP%TYPE,
6140: P_ADDRESS_ID IN JTF_RS_RESOURCE_EXTNS.ADDRESS_ID%TYPE,
6141: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_RESOURCE_EXTNS.OBJECT_VERSION_NUMBER%TYPE,
6142: P_USER_NAME IN VARCHAR2,
6143: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 6146: P_SOURCE_MOBILE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_MOBILE_PHONE%TYPE,

6142: P_USER_NAME IN VARCHAR2,
6143: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
6144: X_MSG_COUNT OUT NOCOPY NUMBER,
6145: X_MSG_DATA OUT NOCOPY VARCHAR2,
6146: P_SOURCE_MOBILE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_MOBILE_PHONE%TYPE,
6147: P_SOURCE_PAGER IN JTF_RS_RESOURCE_EXTNS.SOURCE_PAGER%TYPE
6148: ) IS
6149: BEGIN
6150: UPDATE_RESOURCE(

Line 6147: P_SOURCE_PAGER IN JTF_RS_RESOURCE_EXTNS.SOURCE_PAGER%TYPE

6143: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
6144: X_MSG_COUNT OUT NOCOPY NUMBER,
6145: X_MSG_DATA OUT NOCOPY VARCHAR2,
6146: P_SOURCE_MOBILE_PHONE IN JTF_RS_RESOURCE_EXTNS.SOURCE_MOBILE_PHONE%TYPE,
6147: P_SOURCE_PAGER IN JTF_RS_RESOURCE_EXTNS.SOURCE_PAGER%TYPE
6148: ) IS
6149: BEGIN
6150: UPDATE_RESOURCE(
6151: P_API_VERSION => P_API_VERSION,