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_PUB dependencies on JTF_RS_RESOURCE_PUB

Line 1: PACKAGE BODY jtf_rs_resource_pub AS

1: PACKAGE BODY jtf_rs_resource_pub AS
2: /* $Header: jtfrsprb.pls 120.7 2011/03/04 11:27:21 rgokavar ship $ */
3:
4: /*****************************************************************************************
5: This package body defines the procedures for managing resources.

Line 17: G_PKG_NAME CONSTANT VARCHAR2(30) := 'JTF_RS_RESOURCE_PUB';

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. */

Line 1190: P_RESOURCE_NAME => JTF_RS_RESOURCE_PUB.G_RESOURCE_NAME ,

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,

Line 1191: P_SOURCE_NAME => JTF_RS_RESOURCE_PUB.G_SOURCE_NAME,

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,

Line 1192: P_SOURCE_NUMBER => JTF_RS_RESOURCE_PUB.G_SOURCE_NUMBER,

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,

Line 1193: P_SOURCE_JOB_TITLE => JTF_RS_RESOURCE_PUB.G_SOURCE_JOB_TITLE,

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,

Line 1194: P_SOURCE_EMAIL => JTF_RS_RESOURCE_PUB.G_SOURCE_EMAIL,

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,

Line 1195: P_SOURCE_PHONE => JTF_RS_RESOURCE_PUB.G_SOURCE_PHONE,

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,

Line 1196: P_SOURCE_ORG_ID => JTF_RS_RESOURCE_PUB.G_SOURCE_ORG_ID,

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,

Line 1197: P_SOURCE_ORG_NAME => JTF_RS_RESOURCE_PUB.G_SOURCE_ORG_NAME,

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,

Line 1198: P_SOURCE_ADDRESS1 => JTF_RS_RESOURCE_PUB.G_SOURCE_ADDRESS1,

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,

Line 1199: P_SOURCE_ADDRESS2 => JTF_RS_RESOURCE_PUB.G_SOURCE_ADDRESS2,

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,

Line 1200: P_SOURCE_ADDRESS3 => JTF_RS_RESOURCE_PUB.G_SOURCE_ADDRESS3,

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,

Line 1201: P_SOURCE_ADDRESS4 => JTF_RS_RESOURCE_PUB.G_SOURCE_ADDRESS4,

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,

Line 1202: P_SOURCE_CITY => JTF_RS_RESOURCE_PUB.G_SOURCE_CITY,

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,

Line 1203: P_SOURCE_POSTAL_CODE => JTF_RS_RESOURCE_PUB.G_SOURCE_POSTAL_CODE,

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

Line 1204: P_SOURCE_STATE => JTF_RS_RESOURCE_PUB.G_SOURCE_STATE,

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: );

Line 1205: P_SOURCE_PROVINCE => JTF_RS_RESOURCE_PUB.G_SOURCE_PROVINCE,

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:

Line 1206: P_SOURCE_COUNTY => JTF_RS_RESOURCE_PUB.G_SOURCE_COUNTY,

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: */

Line 1207: P_SOURCE_COUNTRY => JTF_RS_RESOURCE_PUB.G_SOURCE_COUNTRY

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:

Line 1387: JTF_RS_RESOURCE_PUB.G_RS_ID_PUB_FLAG := 'N';

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;

Line 1388: JTF_RS_RESOURCE_PUB.G_RESOURCE_ID := P_RESOURCE_ID;

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;

Line 1389: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE1 := P_ATTRIBUTE1;

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;

Line 1390: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE2 := P_ATTRIBUTE2;

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;

Line 1391: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE3 := P_ATTRIBUTE3;

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;

Line 1392: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE4 := P_ATTRIBUTE4;

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;

Line 1393: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE5 := P_ATTRIBUTE5;

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;

Line 1394: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE6 := P_ATTRIBUTE6;

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;

Line 1395: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE7 := P_ATTRIBUTE7;

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;

Line 1396: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE8 := P_ATTRIBUTE8;

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;

Line 1397: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE9 := P_ATTRIBUTE9;

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;

Line 1398: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE10 := P_ATTRIBUTE10;

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;

Line 1399: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE11 := P_ATTRIBUTE11;

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;

Line 1400: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE12 := P_ATTRIBUTE12;

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;

Line 1401: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE13 := P_ATTRIBUTE13;

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:

Line 1402: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE14 := P_ATTRIBUTE14;

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');

Line 1403: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE15 := P_ATTRIBUTE15;

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:

Line 1404: JTF_RS_RESOURCE_PUB.G_ATTRIBUTE_CATEGORY := P_ATTRIBUTE_CATEGORY;

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 (

Line 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,

Line 3712: END jtf_rs_resource_pub;

3708: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
3709: p_data => x_msg_data);
3710:
3711: END;
3712: END jtf_rs_resource_pub;