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_SALESREPS_PUB dependencies on JTF_RS_SALESREPS_PUB

Line 1: PACKAGE BODY jtf_rs_salesreps_pub AS

1: PACKAGE BODY jtf_rs_salesreps_pub AS
2: /* $Header: jtfrspsb.pls 120.4 2005/10/17 17:18:37 nsinghai ship $ */
3:
4: /*****************************************************************************************
5: This package body defines the procedures for managing Salesreps , like

Line 16: G_PKG_NAME VARCHAR2(30) := 'JTF_RS_SALESREPS_PUB';

12: ******************************************************************************************/
13:
14: /* Package Varianles */
15:
16: G_PKG_NAME VARCHAR2(30) := 'JTF_RS_SALESREPS_PUB';
17:
18: /* Procedure to create the Salesreps
19: based on input values passed by calling routines. */
20:

Line 326: JTF_RS_SALESREPS_PUB.G_SRP_ID_PUB_FLAG := 'N';

322: BEGIN
323:
324: --dbms_output.put_line ('Inside the create_salesrep_migrate pub body');
325:
326: JTF_RS_SALESREPS_PUB.G_SRP_ID_PUB_FLAG := 'N';
327: JTF_RS_SALESREPS_PUB.G_SALESREP_ID := P_SALESREP_ID;
328: JTF_RS_SALESREPS_PUB.G_ORG_ID := P_ORG_ID;
329: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE1 := P_ATTRIBUTE1;
330: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE2 := P_ATTRIBUTE2;

Line 327: JTF_RS_SALESREPS_PUB.G_SALESREP_ID := P_SALESREP_ID;

323:
324: --dbms_output.put_line ('Inside the create_salesrep_migrate pub body');
325:
326: JTF_RS_SALESREPS_PUB.G_SRP_ID_PUB_FLAG := 'N';
327: JTF_RS_SALESREPS_PUB.G_SALESREP_ID := P_SALESREP_ID;
328: JTF_RS_SALESREPS_PUB.G_ORG_ID := P_ORG_ID;
329: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE1 := P_ATTRIBUTE1;
330: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE2 := P_ATTRIBUTE2;
331: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE3 := P_ATTRIBUTE3;

Line 328: JTF_RS_SALESREPS_PUB.G_ORG_ID := P_ORG_ID;

324: --dbms_output.put_line ('Inside the create_salesrep_migrate pub body');
325:
326: JTF_RS_SALESREPS_PUB.G_SRP_ID_PUB_FLAG := 'N';
327: JTF_RS_SALESREPS_PUB.G_SALESREP_ID := P_SALESREP_ID;
328: JTF_RS_SALESREPS_PUB.G_ORG_ID := P_ORG_ID;
329: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE1 := P_ATTRIBUTE1;
330: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE2 := P_ATTRIBUTE2;
331: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE3 := P_ATTRIBUTE3;
332: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE4 := P_ATTRIBUTE4;

Line 329: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE1 := P_ATTRIBUTE1;

325:
326: JTF_RS_SALESREPS_PUB.G_SRP_ID_PUB_FLAG := 'N';
327: JTF_RS_SALESREPS_PUB.G_SALESREP_ID := P_SALESREP_ID;
328: JTF_RS_SALESREPS_PUB.G_ORG_ID := P_ORG_ID;
329: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE1 := P_ATTRIBUTE1;
330: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE2 := P_ATTRIBUTE2;
331: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE3 := P_ATTRIBUTE3;
332: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE4 := P_ATTRIBUTE4;
333: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE5 := P_ATTRIBUTE5;

Line 330: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE2 := P_ATTRIBUTE2;

326: JTF_RS_SALESREPS_PUB.G_SRP_ID_PUB_FLAG := 'N';
327: JTF_RS_SALESREPS_PUB.G_SALESREP_ID := P_SALESREP_ID;
328: JTF_RS_SALESREPS_PUB.G_ORG_ID := P_ORG_ID;
329: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE1 := P_ATTRIBUTE1;
330: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE2 := P_ATTRIBUTE2;
331: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE3 := P_ATTRIBUTE3;
332: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE4 := P_ATTRIBUTE4;
333: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE5 := P_ATTRIBUTE5;
334: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE6 := P_ATTRIBUTE6;

Line 331: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE3 := P_ATTRIBUTE3;

327: JTF_RS_SALESREPS_PUB.G_SALESREP_ID := P_SALESREP_ID;
328: JTF_RS_SALESREPS_PUB.G_ORG_ID := P_ORG_ID;
329: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE1 := P_ATTRIBUTE1;
330: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE2 := P_ATTRIBUTE2;
331: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE3 := P_ATTRIBUTE3;
332: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE4 := P_ATTRIBUTE4;
333: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE5 := P_ATTRIBUTE5;
334: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE6 := P_ATTRIBUTE6;
335: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE7 := P_ATTRIBUTE7;

Line 332: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE4 := P_ATTRIBUTE4;

328: JTF_RS_SALESREPS_PUB.G_ORG_ID := P_ORG_ID;
329: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE1 := P_ATTRIBUTE1;
330: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE2 := P_ATTRIBUTE2;
331: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE3 := P_ATTRIBUTE3;
332: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE4 := P_ATTRIBUTE4;
333: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE5 := P_ATTRIBUTE5;
334: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE6 := P_ATTRIBUTE6;
335: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE7 := P_ATTRIBUTE7;
336: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE8 := P_ATTRIBUTE8;

Line 333: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE5 := P_ATTRIBUTE5;

329: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE1 := P_ATTRIBUTE1;
330: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE2 := P_ATTRIBUTE2;
331: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE3 := P_ATTRIBUTE3;
332: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE4 := P_ATTRIBUTE4;
333: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE5 := P_ATTRIBUTE5;
334: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE6 := P_ATTRIBUTE6;
335: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE7 := P_ATTRIBUTE7;
336: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE8 := P_ATTRIBUTE8;
337: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE9 := P_ATTRIBUTE9;

Line 334: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE6 := P_ATTRIBUTE6;

330: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE2 := P_ATTRIBUTE2;
331: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE3 := P_ATTRIBUTE3;
332: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE4 := P_ATTRIBUTE4;
333: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE5 := P_ATTRIBUTE5;
334: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE6 := P_ATTRIBUTE6;
335: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE7 := P_ATTRIBUTE7;
336: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE8 := P_ATTRIBUTE8;
337: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE9 := P_ATTRIBUTE9;
338: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE10 := P_ATTRIBUTE10;

Line 335: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE7 := P_ATTRIBUTE7;

331: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE3 := P_ATTRIBUTE3;
332: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE4 := P_ATTRIBUTE4;
333: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE5 := P_ATTRIBUTE5;
334: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE6 := P_ATTRIBUTE6;
335: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE7 := P_ATTRIBUTE7;
336: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE8 := P_ATTRIBUTE8;
337: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE9 := P_ATTRIBUTE9;
338: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE10 := P_ATTRIBUTE10;
339: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE11 := P_ATTRIBUTE11;

Line 336: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE8 := P_ATTRIBUTE8;

332: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE4 := P_ATTRIBUTE4;
333: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE5 := P_ATTRIBUTE5;
334: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE6 := P_ATTRIBUTE6;
335: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE7 := P_ATTRIBUTE7;
336: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE8 := P_ATTRIBUTE8;
337: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE9 := P_ATTRIBUTE9;
338: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE10 := P_ATTRIBUTE10;
339: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE11 := P_ATTRIBUTE11;
340: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE12 := P_ATTRIBUTE12;

Line 337: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE9 := P_ATTRIBUTE9;

333: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE5 := P_ATTRIBUTE5;
334: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE6 := P_ATTRIBUTE6;
335: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE7 := P_ATTRIBUTE7;
336: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE8 := P_ATTRIBUTE8;
337: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE9 := P_ATTRIBUTE9;
338: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE10 := P_ATTRIBUTE10;
339: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE11 := P_ATTRIBUTE11;
340: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE12 := P_ATTRIBUTE12;
341: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE13 := P_ATTRIBUTE13;

Line 338: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE10 := P_ATTRIBUTE10;

334: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE6 := P_ATTRIBUTE6;
335: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE7 := P_ATTRIBUTE7;
336: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE8 := P_ATTRIBUTE8;
337: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE9 := P_ATTRIBUTE9;
338: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE10 := P_ATTRIBUTE10;
339: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE11 := P_ATTRIBUTE11;
340: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE12 := P_ATTRIBUTE12;
341: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE13 := P_ATTRIBUTE13;
342: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE14 := P_ATTRIBUTE14;

Line 339: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE11 := P_ATTRIBUTE11;

335: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE7 := P_ATTRIBUTE7;
336: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE8 := P_ATTRIBUTE8;
337: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE9 := P_ATTRIBUTE9;
338: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE10 := P_ATTRIBUTE10;
339: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE11 := P_ATTRIBUTE11;
340: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE12 := P_ATTRIBUTE12;
341: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE13 := P_ATTRIBUTE13;
342: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE14 := P_ATTRIBUTE14;
343: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE15 := P_ATTRIBUTE15;

Line 340: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE12 := P_ATTRIBUTE12;

336: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE8 := P_ATTRIBUTE8;
337: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE9 := P_ATTRIBUTE9;
338: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE10 := P_ATTRIBUTE10;
339: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE11 := P_ATTRIBUTE11;
340: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE12 := P_ATTRIBUTE12;
341: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE13 := P_ATTRIBUTE13;
342: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE14 := P_ATTRIBUTE14;
343: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE15 := P_ATTRIBUTE15;
344: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE_CATEGORY := P_ATTRIBUTE_CATEGORY;

Line 341: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE13 := P_ATTRIBUTE13;

337: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE9 := P_ATTRIBUTE9;
338: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE10 := P_ATTRIBUTE10;
339: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE11 := P_ATTRIBUTE11;
340: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE12 := P_ATTRIBUTE12;
341: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE13 := P_ATTRIBUTE13;
342: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE14 := P_ATTRIBUTE14;
343: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE15 := P_ATTRIBUTE15;
344: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE_CATEGORY := P_ATTRIBUTE_CATEGORY;
345:

Line 342: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE14 := P_ATTRIBUTE14;

338: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE10 := P_ATTRIBUTE10;
339: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE11 := P_ATTRIBUTE11;
340: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE12 := P_ATTRIBUTE12;
341: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE13 := P_ATTRIBUTE13;
342: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE14 := P_ATTRIBUTE14;
343: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE15 := P_ATTRIBUTE15;
344: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE_CATEGORY := P_ATTRIBUTE_CATEGORY;
345:
346: --dbms_output.put_line ('After assigning values to the Global variables');

Line 343: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE15 := P_ATTRIBUTE15;

339: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE11 := P_ATTRIBUTE11;
340: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE12 := P_ATTRIBUTE12;
341: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE13 := P_ATTRIBUTE13;
342: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE14 := P_ATTRIBUTE14;
343: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE15 := P_ATTRIBUTE15;
344: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE_CATEGORY := P_ATTRIBUTE_CATEGORY;
345:
346: --dbms_output.put_line ('After assigning values to the Global variables');
347:

Line 344: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE_CATEGORY := P_ATTRIBUTE_CATEGORY;

340: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE12 := P_ATTRIBUTE12;
341: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE13 := P_ATTRIBUTE13;
342: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE14 := P_ATTRIBUTE14;
343: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE15 := P_ATTRIBUTE15;
344: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE_CATEGORY := P_ATTRIBUTE_CATEGORY;
345:
346: --dbms_output.put_line ('After assigning values to the Global variables');
347:
348: jtf_rs_salesreps_pub.create_salesrep (

Line 348: jtf_rs_salesreps_pub.create_salesrep (

344: JTF_RS_SALESREPS_PUB.G_ATTRIBUTE_CATEGORY := P_ATTRIBUTE_CATEGORY;
345:
346: --dbms_output.put_line ('After assigning values to the Global variables');
347:
348: jtf_rs_salesreps_pub.create_salesrep (
349: P_API_VERSION => P_API_VERSION,
350: P_INIT_MSG_LIST => P_INIT_MSG_LIST,
351: P_COMMIT => P_COMMIT,
352: P_RESOURCE_ID => P_RESOURCE_ID,

Line 567: END JTF_RS_SALESREPS_PUB;

563:
564: END update_salesrep;
565:
566:
567: END JTF_RS_SALESREPS_PUB;