1: PACKAGE BODY jtf_rs_resource_pub AS
2: /* $Header: jtfrsprb.pls 120.5 2006/03/14 17:26:49 nsinghai ship $ */
3:
4: /*****************************************************************************************
5: This package body defines the procedures for managing resources.
13:
14:
15: /* Package variables. */
16:
17: G_PKG_NAME CONSTANT VARCHAR2(30) := 'JTF_RS_RESOURCE_PUB';
18:
19:
20: /* Procedure to create the resource based on input values
21: passed by calling routines. */
1186: X_MSG_COUNT => x_msg_count,
1187: X_MSG_DATA => x_msg_data,
1188: X_RESOURCE_ID => x_resource_id,
1189: X_RESOURCE_NUMBER => x_resource_number,
1190: P_RESOURCE_NAME => JTF_RS_RESOURCE_PUB.G_RESOURCE_NAME ,
1191: P_SOURCE_NAME => JTF_RS_RESOURCE_PUB.G_SOURCE_NAME,
1192: P_SOURCE_NUMBER => JTF_RS_RESOURCE_PUB.G_SOURCE_NUMBER,
1193: P_SOURCE_JOB_TITLE => JTF_RS_RESOURCE_PUB.G_SOURCE_JOB_TITLE,
1194: P_SOURCE_EMAIL => JTF_RS_RESOURCE_PUB.G_SOURCE_EMAIL,
1187: X_MSG_DATA => x_msg_data,
1188: X_RESOURCE_ID => x_resource_id,
1189: X_RESOURCE_NUMBER => x_resource_number,
1190: P_RESOURCE_NAME => JTF_RS_RESOURCE_PUB.G_RESOURCE_NAME ,
1191: P_SOURCE_NAME => JTF_RS_RESOURCE_PUB.G_SOURCE_NAME,
1192: P_SOURCE_NUMBER => JTF_RS_RESOURCE_PUB.G_SOURCE_NUMBER,
1193: P_SOURCE_JOB_TITLE => JTF_RS_RESOURCE_PUB.G_SOURCE_JOB_TITLE,
1194: P_SOURCE_EMAIL => JTF_RS_RESOURCE_PUB.G_SOURCE_EMAIL,
1195: P_SOURCE_PHONE => JTF_RS_RESOURCE_PUB.G_SOURCE_PHONE,
1188: X_RESOURCE_ID => x_resource_id,
1189: X_RESOURCE_NUMBER => x_resource_number,
1190: P_RESOURCE_NAME => JTF_RS_RESOURCE_PUB.G_RESOURCE_NAME ,
1191: P_SOURCE_NAME => JTF_RS_RESOURCE_PUB.G_SOURCE_NAME,
1192: P_SOURCE_NUMBER => JTF_RS_RESOURCE_PUB.G_SOURCE_NUMBER,
1193: P_SOURCE_JOB_TITLE => JTF_RS_RESOURCE_PUB.G_SOURCE_JOB_TITLE,
1194: P_SOURCE_EMAIL => JTF_RS_RESOURCE_PUB.G_SOURCE_EMAIL,
1195: P_SOURCE_PHONE => JTF_RS_RESOURCE_PUB.G_SOURCE_PHONE,
1196: P_SOURCE_ORG_ID => JTF_RS_RESOURCE_PUB.G_SOURCE_ORG_ID,
1189: X_RESOURCE_NUMBER => x_resource_number,
1190: P_RESOURCE_NAME => JTF_RS_RESOURCE_PUB.G_RESOURCE_NAME ,
1191: P_SOURCE_NAME => JTF_RS_RESOURCE_PUB.G_SOURCE_NAME,
1192: P_SOURCE_NUMBER => JTF_RS_RESOURCE_PUB.G_SOURCE_NUMBER,
1193: P_SOURCE_JOB_TITLE => JTF_RS_RESOURCE_PUB.G_SOURCE_JOB_TITLE,
1194: P_SOURCE_EMAIL => JTF_RS_RESOURCE_PUB.G_SOURCE_EMAIL,
1195: P_SOURCE_PHONE => JTF_RS_RESOURCE_PUB.G_SOURCE_PHONE,
1196: P_SOURCE_ORG_ID => JTF_RS_RESOURCE_PUB.G_SOURCE_ORG_ID,
1197: P_SOURCE_ORG_NAME => JTF_RS_RESOURCE_PUB.G_SOURCE_ORG_NAME,
1190: P_RESOURCE_NAME => JTF_RS_RESOURCE_PUB.G_RESOURCE_NAME ,
1191: P_SOURCE_NAME => JTF_RS_RESOURCE_PUB.G_SOURCE_NAME,
1192: P_SOURCE_NUMBER => JTF_RS_RESOURCE_PUB.G_SOURCE_NUMBER,
1193: P_SOURCE_JOB_TITLE => JTF_RS_RESOURCE_PUB.G_SOURCE_JOB_TITLE,
1194: P_SOURCE_EMAIL => JTF_RS_RESOURCE_PUB.G_SOURCE_EMAIL,
1195: P_SOURCE_PHONE => JTF_RS_RESOURCE_PUB.G_SOURCE_PHONE,
1196: P_SOURCE_ORG_ID => JTF_RS_RESOURCE_PUB.G_SOURCE_ORG_ID,
1197: P_SOURCE_ORG_NAME => JTF_RS_RESOURCE_PUB.G_SOURCE_ORG_NAME,
1198: P_SOURCE_ADDRESS1 => JTF_RS_RESOURCE_PUB.G_SOURCE_ADDRESS1,
1191: P_SOURCE_NAME => JTF_RS_RESOURCE_PUB.G_SOURCE_NAME,
1192: P_SOURCE_NUMBER => JTF_RS_RESOURCE_PUB.G_SOURCE_NUMBER,
1193: P_SOURCE_JOB_TITLE => JTF_RS_RESOURCE_PUB.G_SOURCE_JOB_TITLE,
1194: P_SOURCE_EMAIL => JTF_RS_RESOURCE_PUB.G_SOURCE_EMAIL,
1195: P_SOURCE_PHONE => JTF_RS_RESOURCE_PUB.G_SOURCE_PHONE,
1196: P_SOURCE_ORG_ID => JTF_RS_RESOURCE_PUB.G_SOURCE_ORG_ID,
1197: P_SOURCE_ORG_NAME => JTF_RS_RESOURCE_PUB.G_SOURCE_ORG_NAME,
1198: P_SOURCE_ADDRESS1 => JTF_RS_RESOURCE_PUB.G_SOURCE_ADDRESS1,
1199: P_SOURCE_ADDRESS2 => JTF_RS_RESOURCE_PUB.G_SOURCE_ADDRESS2,
1192: P_SOURCE_NUMBER => JTF_RS_RESOURCE_PUB.G_SOURCE_NUMBER,
1193: P_SOURCE_JOB_TITLE => JTF_RS_RESOURCE_PUB.G_SOURCE_JOB_TITLE,
1194: P_SOURCE_EMAIL => JTF_RS_RESOURCE_PUB.G_SOURCE_EMAIL,
1195: P_SOURCE_PHONE => JTF_RS_RESOURCE_PUB.G_SOURCE_PHONE,
1196: P_SOURCE_ORG_ID => JTF_RS_RESOURCE_PUB.G_SOURCE_ORG_ID,
1197: P_SOURCE_ORG_NAME => JTF_RS_RESOURCE_PUB.G_SOURCE_ORG_NAME,
1198: P_SOURCE_ADDRESS1 => JTF_RS_RESOURCE_PUB.G_SOURCE_ADDRESS1,
1199: P_SOURCE_ADDRESS2 => JTF_RS_RESOURCE_PUB.G_SOURCE_ADDRESS2,
1200: P_SOURCE_ADDRESS3 => JTF_RS_RESOURCE_PUB.G_SOURCE_ADDRESS3,
1193: P_SOURCE_JOB_TITLE => JTF_RS_RESOURCE_PUB.G_SOURCE_JOB_TITLE,
1194: P_SOURCE_EMAIL => JTF_RS_RESOURCE_PUB.G_SOURCE_EMAIL,
1195: P_SOURCE_PHONE => JTF_RS_RESOURCE_PUB.G_SOURCE_PHONE,
1196: P_SOURCE_ORG_ID => JTF_RS_RESOURCE_PUB.G_SOURCE_ORG_ID,
1197: P_SOURCE_ORG_NAME => JTF_RS_RESOURCE_PUB.G_SOURCE_ORG_NAME,
1198: P_SOURCE_ADDRESS1 => JTF_RS_RESOURCE_PUB.G_SOURCE_ADDRESS1,
1199: P_SOURCE_ADDRESS2 => JTF_RS_RESOURCE_PUB.G_SOURCE_ADDRESS2,
1200: P_SOURCE_ADDRESS3 => JTF_RS_RESOURCE_PUB.G_SOURCE_ADDRESS3,
1201: P_SOURCE_ADDRESS4 => JTF_RS_RESOURCE_PUB.G_SOURCE_ADDRESS4,
1194: P_SOURCE_EMAIL => JTF_RS_RESOURCE_PUB.G_SOURCE_EMAIL,
1195: P_SOURCE_PHONE => JTF_RS_RESOURCE_PUB.G_SOURCE_PHONE,
1196: P_SOURCE_ORG_ID => JTF_RS_RESOURCE_PUB.G_SOURCE_ORG_ID,
1197: P_SOURCE_ORG_NAME => JTF_RS_RESOURCE_PUB.G_SOURCE_ORG_NAME,
1198: P_SOURCE_ADDRESS1 => JTF_RS_RESOURCE_PUB.G_SOURCE_ADDRESS1,
1199: P_SOURCE_ADDRESS2 => JTF_RS_RESOURCE_PUB.G_SOURCE_ADDRESS2,
1200: P_SOURCE_ADDRESS3 => JTF_RS_RESOURCE_PUB.G_SOURCE_ADDRESS3,
1201: P_SOURCE_ADDRESS4 => JTF_RS_RESOURCE_PUB.G_SOURCE_ADDRESS4,
1202: P_SOURCE_CITY => JTF_RS_RESOURCE_PUB.G_SOURCE_CITY,
1195: P_SOURCE_PHONE => JTF_RS_RESOURCE_PUB.G_SOURCE_PHONE,
1196: P_SOURCE_ORG_ID => JTF_RS_RESOURCE_PUB.G_SOURCE_ORG_ID,
1197: P_SOURCE_ORG_NAME => JTF_RS_RESOURCE_PUB.G_SOURCE_ORG_NAME,
1198: P_SOURCE_ADDRESS1 => JTF_RS_RESOURCE_PUB.G_SOURCE_ADDRESS1,
1199: P_SOURCE_ADDRESS2 => JTF_RS_RESOURCE_PUB.G_SOURCE_ADDRESS2,
1200: P_SOURCE_ADDRESS3 => JTF_RS_RESOURCE_PUB.G_SOURCE_ADDRESS3,
1201: P_SOURCE_ADDRESS4 => JTF_RS_RESOURCE_PUB.G_SOURCE_ADDRESS4,
1202: P_SOURCE_CITY => JTF_RS_RESOURCE_PUB.G_SOURCE_CITY,
1203: P_SOURCE_POSTAL_CODE => JTF_RS_RESOURCE_PUB.G_SOURCE_POSTAL_CODE,
1196: P_SOURCE_ORG_ID => JTF_RS_RESOURCE_PUB.G_SOURCE_ORG_ID,
1197: P_SOURCE_ORG_NAME => JTF_RS_RESOURCE_PUB.G_SOURCE_ORG_NAME,
1198: P_SOURCE_ADDRESS1 => JTF_RS_RESOURCE_PUB.G_SOURCE_ADDRESS1,
1199: P_SOURCE_ADDRESS2 => JTF_RS_RESOURCE_PUB.G_SOURCE_ADDRESS2,
1200: P_SOURCE_ADDRESS3 => JTF_RS_RESOURCE_PUB.G_SOURCE_ADDRESS3,
1201: P_SOURCE_ADDRESS4 => JTF_RS_RESOURCE_PUB.G_SOURCE_ADDRESS4,
1202: P_SOURCE_CITY => JTF_RS_RESOURCE_PUB.G_SOURCE_CITY,
1203: P_SOURCE_POSTAL_CODE => JTF_RS_RESOURCE_PUB.G_SOURCE_POSTAL_CODE,
1204: P_SOURCE_STATE => JTF_RS_RESOURCE_PUB.G_SOURCE_STATE,
1197: P_SOURCE_ORG_NAME => JTF_RS_RESOURCE_PUB.G_SOURCE_ORG_NAME,
1198: P_SOURCE_ADDRESS1 => JTF_RS_RESOURCE_PUB.G_SOURCE_ADDRESS1,
1199: P_SOURCE_ADDRESS2 => JTF_RS_RESOURCE_PUB.G_SOURCE_ADDRESS2,
1200: P_SOURCE_ADDRESS3 => JTF_RS_RESOURCE_PUB.G_SOURCE_ADDRESS3,
1201: P_SOURCE_ADDRESS4 => JTF_RS_RESOURCE_PUB.G_SOURCE_ADDRESS4,
1202: P_SOURCE_CITY => JTF_RS_RESOURCE_PUB.G_SOURCE_CITY,
1203: P_SOURCE_POSTAL_CODE => JTF_RS_RESOURCE_PUB.G_SOURCE_POSTAL_CODE,
1204: P_SOURCE_STATE => JTF_RS_RESOURCE_PUB.G_SOURCE_STATE,
1205: P_SOURCE_PROVINCE => JTF_RS_RESOURCE_PUB.G_SOURCE_PROVINCE,
1198: P_SOURCE_ADDRESS1 => JTF_RS_RESOURCE_PUB.G_SOURCE_ADDRESS1,
1199: P_SOURCE_ADDRESS2 => JTF_RS_RESOURCE_PUB.G_SOURCE_ADDRESS2,
1200: P_SOURCE_ADDRESS3 => JTF_RS_RESOURCE_PUB.G_SOURCE_ADDRESS3,
1201: P_SOURCE_ADDRESS4 => JTF_RS_RESOURCE_PUB.G_SOURCE_ADDRESS4,
1202: P_SOURCE_CITY => JTF_RS_RESOURCE_PUB.G_SOURCE_CITY,
1203: P_SOURCE_POSTAL_CODE => JTF_RS_RESOURCE_PUB.G_SOURCE_POSTAL_CODE,
1204: P_SOURCE_STATE => JTF_RS_RESOURCE_PUB.G_SOURCE_STATE,
1205: P_SOURCE_PROVINCE => JTF_RS_RESOURCE_PUB.G_SOURCE_PROVINCE,
1206: P_SOURCE_COUNTY => JTF_RS_RESOURCE_PUB.G_SOURCE_COUNTY,
1199: P_SOURCE_ADDRESS2 => JTF_RS_RESOURCE_PUB.G_SOURCE_ADDRESS2,
1200: P_SOURCE_ADDRESS3 => JTF_RS_RESOURCE_PUB.G_SOURCE_ADDRESS3,
1201: P_SOURCE_ADDRESS4 => JTF_RS_RESOURCE_PUB.G_SOURCE_ADDRESS4,
1202: P_SOURCE_CITY => JTF_RS_RESOURCE_PUB.G_SOURCE_CITY,
1203: P_SOURCE_POSTAL_CODE => JTF_RS_RESOURCE_PUB.G_SOURCE_POSTAL_CODE,
1204: P_SOURCE_STATE => JTF_RS_RESOURCE_PUB.G_SOURCE_STATE,
1205: P_SOURCE_PROVINCE => JTF_RS_RESOURCE_PUB.G_SOURCE_PROVINCE,
1206: P_SOURCE_COUNTY => JTF_RS_RESOURCE_PUB.G_SOURCE_COUNTY,
1207: P_SOURCE_COUNTRY => JTF_RS_RESOURCE_PUB.G_SOURCE_COUNTRY
1200: P_SOURCE_ADDRESS3 => JTF_RS_RESOURCE_PUB.G_SOURCE_ADDRESS3,
1201: P_SOURCE_ADDRESS4 => JTF_RS_RESOURCE_PUB.G_SOURCE_ADDRESS4,
1202: P_SOURCE_CITY => JTF_RS_RESOURCE_PUB.G_SOURCE_CITY,
1203: P_SOURCE_POSTAL_CODE => JTF_RS_RESOURCE_PUB.G_SOURCE_POSTAL_CODE,
1204: P_SOURCE_STATE => JTF_RS_RESOURCE_PUB.G_SOURCE_STATE,
1205: P_SOURCE_PROVINCE => JTF_RS_RESOURCE_PUB.G_SOURCE_PROVINCE,
1206: P_SOURCE_COUNTY => JTF_RS_RESOURCE_PUB.G_SOURCE_COUNTY,
1207: P_SOURCE_COUNTRY => JTF_RS_RESOURCE_PUB.G_SOURCE_COUNTRY
1208: );
1201: P_SOURCE_ADDRESS4 => JTF_RS_RESOURCE_PUB.G_SOURCE_ADDRESS4,
1202: P_SOURCE_CITY => JTF_RS_RESOURCE_PUB.G_SOURCE_CITY,
1203: P_SOURCE_POSTAL_CODE => JTF_RS_RESOURCE_PUB.G_SOURCE_POSTAL_CODE,
1204: P_SOURCE_STATE => JTF_RS_RESOURCE_PUB.G_SOURCE_STATE,
1205: P_SOURCE_PROVINCE => JTF_RS_RESOURCE_PUB.G_SOURCE_PROVINCE,
1206: P_SOURCE_COUNTY => JTF_RS_RESOURCE_PUB.G_SOURCE_COUNTY,
1207: P_SOURCE_COUNTRY => JTF_RS_RESOURCE_PUB.G_SOURCE_COUNTRY
1208: );
1209:
1202: P_SOURCE_CITY => JTF_RS_RESOURCE_PUB.G_SOURCE_CITY,
1203: P_SOURCE_POSTAL_CODE => JTF_RS_RESOURCE_PUB.G_SOURCE_POSTAL_CODE,
1204: P_SOURCE_STATE => JTF_RS_RESOURCE_PUB.G_SOURCE_STATE,
1205: P_SOURCE_PROVINCE => JTF_RS_RESOURCE_PUB.G_SOURCE_PROVINCE,
1206: P_SOURCE_COUNTY => JTF_RS_RESOURCE_PUB.G_SOURCE_COUNTY,
1207: P_SOURCE_COUNTRY => JTF_RS_RESOURCE_PUB.G_SOURCE_COUNTRY
1208: );
1209:
1210: */
1203: P_SOURCE_POSTAL_CODE => JTF_RS_RESOURCE_PUB.G_SOURCE_POSTAL_CODE,
1204: P_SOURCE_STATE => JTF_RS_RESOURCE_PUB.G_SOURCE_STATE,
1205: P_SOURCE_PROVINCE => JTF_RS_RESOURCE_PUB.G_SOURCE_PROVINCE,
1206: P_SOURCE_COUNTY => JTF_RS_RESOURCE_PUB.G_SOURCE_COUNTY,
1207: P_SOURCE_COUNTRY => JTF_RS_RESOURCE_PUB.G_SOURCE_COUNTRY
1208: );
1209:
1210: */
1211:
1383:
1384: JTF_RESOURCE_UTL.G_SOURCE_NAME := NULL;
1385:
1386:
1387: JTF_RS_RESOURCE_PUB.G_RS_ID_PUB_FLAG := 'N';
1388: JTF_RS_RESOURCE_PUB.G_RESOURCE_ID := P_RESOURCE_ID;
1389: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE1 := P_ATTRIBUTE1;
1390: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE2 := P_ATTRIBUTE2;
1391: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE3 := P_ATTRIBUTE3;
1384: JTF_RESOURCE_UTL.G_SOURCE_NAME := NULL;
1385:
1386:
1387: JTF_RS_RESOURCE_PUB.G_RS_ID_PUB_FLAG := 'N';
1388: JTF_RS_RESOURCE_PUB.G_RESOURCE_ID := P_RESOURCE_ID;
1389: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE1 := P_ATTRIBUTE1;
1390: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE2 := P_ATTRIBUTE2;
1391: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE3 := P_ATTRIBUTE3;
1392: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE4 := P_ATTRIBUTE4;
1385:
1386:
1387: JTF_RS_RESOURCE_PUB.G_RS_ID_PUB_FLAG := 'N';
1388: JTF_RS_RESOURCE_PUB.G_RESOURCE_ID := P_RESOURCE_ID;
1389: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE1 := P_ATTRIBUTE1;
1390: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE2 := P_ATTRIBUTE2;
1391: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE3 := P_ATTRIBUTE3;
1392: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE4 := P_ATTRIBUTE4;
1393: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE5 := P_ATTRIBUTE5;
1386:
1387: JTF_RS_RESOURCE_PUB.G_RS_ID_PUB_FLAG := 'N';
1388: JTF_RS_RESOURCE_PUB.G_RESOURCE_ID := P_RESOURCE_ID;
1389: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE1 := P_ATTRIBUTE1;
1390: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE2 := P_ATTRIBUTE2;
1391: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE3 := P_ATTRIBUTE3;
1392: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE4 := P_ATTRIBUTE4;
1393: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE5 := P_ATTRIBUTE5;
1394: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE6 := P_ATTRIBUTE6;
1387: JTF_RS_RESOURCE_PUB.G_RS_ID_PUB_FLAG := 'N';
1388: JTF_RS_RESOURCE_PUB.G_RESOURCE_ID := P_RESOURCE_ID;
1389: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE1 := P_ATTRIBUTE1;
1390: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE2 := P_ATTRIBUTE2;
1391: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE3 := P_ATTRIBUTE3;
1392: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE4 := P_ATTRIBUTE4;
1393: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE5 := P_ATTRIBUTE5;
1394: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE6 := P_ATTRIBUTE6;
1395: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE7 := P_ATTRIBUTE7;
1388: JTF_RS_RESOURCE_PUB.G_RESOURCE_ID := P_RESOURCE_ID;
1389: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE1 := P_ATTRIBUTE1;
1390: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE2 := P_ATTRIBUTE2;
1391: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE3 := P_ATTRIBUTE3;
1392: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE4 := P_ATTRIBUTE4;
1393: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE5 := P_ATTRIBUTE5;
1394: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE6 := P_ATTRIBUTE6;
1395: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE7 := P_ATTRIBUTE7;
1396: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE8 := P_ATTRIBUTE8;
1389: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE1 := P_ATTRIBUTE1;
1390: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE2 := P_ATTRIBUTE2;
1391: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE3 := P_ATTRIBUTE3;
1392: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE4 := P_ATTRIBUTE4;
1393: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE5 := P_ATTRIBUTE5;
1394: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE6 := P_ATTRIBUTE6;
1395: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE7 := P_ATTRIBUTE7;
1396: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE8 := P_ATTRIBUTE8;
1397: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE9 := P_ATTRIBUTE9;
1390: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE2 := P_ATTRIBUTE2;
1391: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE3 := P_ATTRIBUTE3;
1392: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE4 := P_ATTRIBUTE4;
1393: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE5 := P_ATTRIBUTE5;
1394: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE6 := P_ATTRIBUTE6;
1395: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE7 := P_ATTRIBUTE7;
1396: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE8 := P_ATTRIBUTE8;
1397: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE9 := P_ATTRIBUTE9;
1398: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE10 := P_ATTRIBUTE10;
1391: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE3 := P_ATTRIBUTE3;
1392: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE4 := P_ATTRIBUTE4;
1393: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE5 := P_ATTRIBUTE5;
1394: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE6 := P_ATTRIBUTE6;
1395: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE7 := P_ATTRIBUTE7;
1396: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE8 := P_ATTRIBUTE8;
1397: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE9 := P_ATTRIBUTE9;
1398: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE10 := P_ATTRIBUTE10;
1399: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE11 := P_ATTRIBUTE11;
1392: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE4 := P_ATTRIBUTE4;
1393: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE5 := P_ATTRIBUTE5;
1394: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE6 := P_ATTRIBUTE6;
1395: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE7 := P_ATTRIBUTE7;
1396: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE8 := P_ATTRIBUTE8;
1397: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE9 := P_ATTRIBUTE9;
1398: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE10 := P_ATTRIBUTE10;
1399: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE11 := P_ATTRIBUTE11;
1400: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE12 := P_ATTRIBUTE12;
1393: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE5 := P_ATTRIBUTE5;
1394: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE6 := P_ATTRIBUTE6;
1395: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE7 := P_ATTRIBUTE7;
1396: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE8 := P_ATTRIBUTE8;
1397: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE9 := P_ATTRIBUTE9;
1398: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE10 := P_ATTRIBUTE10;
1399: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE11 := P_ATTRIBUTE11;
1400: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE12 := P_ATTRIBUTE12;
1401: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE13 := P_ATTRIBUTE13;
1394: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE6 := P_ATTRIBUTE6;
1395: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE7 := P_ATTRIBUTE7;
1396: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE8 := P_ATTRIBUTE8;
1397: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE9 := P_ATTRIBUTE9;
1398: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE10 := P_ATTRIBUTE10;
1399: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE11 := P_ATTRIBUTE11;
1400: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE12 := P_ATTRIBUTE12;
1401: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE13 := P_ATTRIBUTE13;
1402: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE14 := P_ATTRIBUTE14;
1395: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE7 := P_ATTRIBUTE7;
1396: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE8 := P_ATTRIBUTE8;
1397: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE9 := P_ATTRIBUTE9;
1398: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE10 := P_ATTRIBUTE10;
1399: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE11 := P_ATTRIBUTE11;
1400: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE12 := P_ATTRIBUTE12;
1401: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE13 := P_ATTRIBUTE13;
1402: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE14 := P_ATTRIBUTE14;
1403: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE15 := P_ATTRIBUTE15;
1396: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE8 := P_ATTRIBUTE8;
1397: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE9 := P_ATTRIBUTE9;
1398: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE10 := P_ATTRIBUTE10;
1399: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE11 := P_ATTRIBUTE11;
1400: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE12 := P_ATTRIBUTE12;
1401: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE13 := P_ATTRIBUTE13;
1402: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE14 := P_ATTRIBUTE14;
1403: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE15 := P_ATTRIBUTE15;
1404: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE_CATEGORY := P_ATTRIBUTE_CATEGORY;
1397: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE9 := P_ATTRIBUTE9;
1398: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE10 := P_ATTRIBUTE10;
1399: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE11 := P_ATTRIBUTE11;
1400: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE12 := P_ATTRIBUTE12;
1401: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE13 := P_ATTRIBUTE13;
1402: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE14 := P_ATTRIBUTE14;
1403: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE15 := P_ATTRIBUTE15;
1404: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE_CATEGORY := P_ATTRIBUTE_CATEGORY;
1405:
1398: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE10 := P_ATTRIBUTE10;
1399: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE11 := P_ATTRIBUTE11;
1400: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE12 := P_ATTRIBUTE12;
1401: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE13 := P_ATTRIBUTE13;
1402: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE14 := P_ATTRIBUTE14;
1403: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE15 := P_ATTRIBUTE15;
1404: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE_CATEGORY := P_ATTRIBUTE_CATEGORY;
1405:
1406: --dbms_output.put_line ('After assigning values to the Global variables');
1399: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE11 := P_ATTRIBUTE11;
1400: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE12 := P_ATTRIBUTE12;
1401: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE13 := P_ATTRIBUTE13;
1402: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE14 := P_ATTRIBUTE14;
1403: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE15 := P_ATTRIBUTE15;
1404: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE_CATEGORY := P_ATTRIBUTE_CATEGORY;
1405:
1406: --dbms_output.put_line ('After assigning values to the Global variables');
1407:
1400: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE12 := P_ATTRIBUTE12;
1401: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE13 := P_ATTRIBUTE13;
1402: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE14 := P_ATTRIBUTE14;
1403: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE15 := P_ATTRIBUTE15;
1404: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE_CATEGORY := P_ATTRIBUTE_CATEGORY;
1405:
1406: --dbms_output.put_line ('After assigning values to the Global variables');
1407:
1408: jtf_rs_resource_pub.create_resource (
1404: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE_CATEGORY := P_ATTRIBUTE_CATEGORY;
1405:
1406: --dbms_output.put_line ('After assigning values to the Global variables');
1407:
1408: jtf_rs_resource_pub.create_resource (
1409: P_API_VERSION => P_API_VERSION,
1410: P_INIT_MSG_LIST => P_INIT_MSG_LIST,
1411: P_COMMIT => P_COMMIT,
1412: P_CATEGORY => P_CATEGORY,
3489: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
3490: p_data => x_msg_data);
3491:
3492: END;
3493: END jtf_rs_resource_pub;