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_TERRITORY_GET_PUB dependencies on DBMS_SQL

Line 110: dbms_sql.define_column(p_dsql_csr, 1, p_terr_header_rec.TERR_ID);

106: FND_MSG_PUB.Add;
107: END IF;
108:
109: /* define all columns */
110: dbms_sql.define_column(p_dsql_csr, 1, p_terr_header_rec.TERR_ID);
111: dbms_sql.define_column(p_dsql_csr, 2, p_terr_header_rec.TERR_NAME, 2000);
112: dbms_sql.define_column(p_dsql_csr, 3, p_terr_header_rec.TERR_USAGE, 30);
113: dbms_sql.define_column(p_dsql_csr, 4, p_terr_header_rec.START_DATE_ACTIVE);
114: dbms_sql.define_column(p_dsql_csr, 5, p_terr_header_rec.END_DATE_ACTIVE);

Line 111: dbms_sql.define_column(p_dsql_csr, 2, p_terr_header_rec.TERR_NAME, 2000);

107: END IF;
108:
109: /* define all columns */
110: dbms_sql.define_column(p_dsql_csr, 1, p_terr_header_rec.TERR_ID);
111: dbms_sql.define_column(p_dsql_csr, 2, p_terr_header_rec.TERR_NAME, 2000);
112: dbms_sql.define_column(p_dsql_csr, 3, p_terr_header_rec.TERR_USAGE, 30);
113: dbms_sql.define_column(p_dsql_csr, 4, p_terr_header_rec.START_DATE_ACTIVE);
114: dbms_sql.define_column(p_dsql_csr, 5, p_terr_header_rec.END_DATE_ACTIVE);
115: dbms_sql.define_column(p_dsql_csr, 6, p_terr_header_rec.TEMPLATE_FLAG, 1);

Line 112: dbms_sql.define_column(p_dsql_csr, 3, p_terr_header_rec.TERR_USAGE, 30);

108:
109: /* define all columns */
110: dbms_sql.define_column(p_dsql_csr, 1, p_terr_header_rec.TERR_ID);
111: dbms_sql.define_column(p_dsql_csr, 2, p_terr_header_rec.TERR_NAME, 2000);
112: dbms_sql.define_column(p_dsql_csr, 3, p_terr_header_rec.TERR_USAGE, 30);
113: dbms_sql.define_column(p_dsql_csr, 4, p_terr_header_rec.START_DATE_ACTIVE);
114: dbms_sql.define_column(p_dsql_csr, 5, p_terr_header_rec.END_DATE_ACTIVE);
115: dbms_sql.define_column(p_dsql_csr, 6, p_terr_header_rec.TEMPLATE_FLAG, 1);
116: dbms_sql.define_column(p_dsql_csr, 7, p_terr_header_rec.ESCALATION_TERRITORY_FLAG, 1);

Line 113: dbms_sql.define_column(p_dsql_csr, 4, p_terr_header_rec.START_DATE_ACTIVE);

109: /* define all columns */
110: dbms_sql.define_column(p_dsql_csr, 1, p_terr_header_rec.TERR_ID);
111: dbms_sql.define_column(p_dsql_csr, 2, p_terr_header_rec.TERR_NAME, 2000);
112: dbms_sql.define_column(p_dsql_csr, 3, p_terr_header_rec.TERR_USAGE, 30);
113: dbms_sql.define_column(p_dsql_csr, 4, p_terr_header_rec.START_DATE_ACTIVE);
114: dbms_sql.define_column(p_dsql_csr, 5, p_terr_header_rec.END_DATE_ACTIVE);
115: dbms_sql.define_column(p_dsql_csr, 6, p_terr_header_rec.TEMPLATE_FLAG, 1);
116: dbms_sql.define_column(p_dsql_csr, 7, p_terr_header_rec.ESCALATION_TERRITORY_FLAG, 1);
117: dbms_sql.define_column(p_dsql_csr, 8, p_terr_header_rec.PARENT_TERR_NAME, 2000);

Line 114: dbms_sql.define_column(p_dsql_csr, 5, p_terr_header_rec.END_DATE_ACTIVE);

110: dbms_sql.define_column(p_dsql_csr, 1, p_terr_header_rec.TERR_ID);
111: dbms_sql.define_column(p_dsql_csr, 2, p_terr_header_rec.TERR_NAME, 2000);
112: dbms_sql.define_column(p_dsql_csr, 3, p_terr_header_rec.TERR_USAGE, 30);
113: dbms_sql.define_column(p_dsql_csr, 4, p_terr_header_rec.START_DATE_ACTIVE);
114: dbms_sql.define_column(p_dsql_csr, 5, p_terr_header_rec.END_DATE_ACTIVE);
115: dbms_sql.define_column(p_dsql_csr, 6, p_terr_header_rec.TEMPLATE_FLAG, 1);
116: dbms_sql.define_column(p_dsql_csr, 7, p_terr_header_rec.ESCALATION_TERRITORY_FLAG, 1);
117: dbms_sql.define_column(p_dsql_csr, 8, p_terr_header_rec.PARENT_TERR_NAME, 2000);
118: dbms_sql.define_column(p_dsql_csr, 9, p_terr_header_rec.TERR_TYPE_NAME, 60);

Line 115: dbms_sql.define_column(p_dsql_csr, 6, p_terr_header_rec.TEMPLATE_FLAG, 1);

111: dbms_sql.define_column(p_dsql_csr, 2, p_terr_header_rec.TERR_NAME, 2000);
112: dbms_sql.define_column(p_dsql_csr, 3, p_terr_header_rec.TERR_USAGE, 30);
113: dbms_sql.define_column(p_dsql_csr, 4, p_terr_header_rec.START_DATE_ACTIVE);
114: dbms_sql.define_column(p_dsql_csr, 5, p_terr_header_rec.END_DATE_ACTIVE);
115: dbms_sql.define_column(p_dsql_csr, 6, p_terr_header_rec.TEMPLATE_FLAG, 1);
116: dbms_sql.define_column(p_dsql_csr, 7, p_terr_header_rec.ESCALATION_TERRITORY_FLAG, 1);
117: dbms_sql.define_column(p_dsql_csr, 8, p_terr_header_rec.PARENT_TERR_NAME, 2000);
118: dbms_sql.define_column(p_dsql_csr, 9, p_terr_header_rec.TERR_TYPE_NAME, 60);
119:

Line 116: dbms_sql.define_column(p_dsql_csr, 7, p_terr_header_rec.ESCALATION_TERRITORY_FLAG, 1);

112: dbms_sql.define_column(p_dsql_csr, 3, p_terr_header_rec.TERR_USAGE, 30);
113: dbms_sql.define_column(p_dsql_csr, 4, p_terr_header_rec.START_DATE_ACTIVE);
114: dbms_sql.define_column(p_dsql_csr, 5, p_terr_header_rec.END_DATE_ACTIVE);
115: dbms_sql.define_column(p_dsql_csr, 6, p_terr_header_rec.TEMPLATE_FLAG, 1);
116: dbms_sql.define_column(p_dsql_csr, 7, p_terr_header_rec.ESCALATION_TERRITORY_FLAG, 1);
117: dbms_sql.define_column(p_dsql_csr, 8, p_terr_header_rec.PARENT_TERR_NAME, 2000);
118: dbms_sql.define_column(p_dsql_csr, 9, p_terr_header_rec.TERR_TYPE_NAME, 60);
119:
120: /* Debug Message */

Line 117: dbms_sql.define_column(p_dsql_csr, 8, p_terr_header_rec.PARENT_TERR_NAME, 2000);

113: dbms_sql.define_column(p_dsql_csr, 4, p_terr_header_rec.START_DATE_ACTIVE);
114: dbms_sql.define_column(p_dsql_csr, 5, p_terr_header_rec.END_DATE_ACTIVE);
115: dbms_sql.define_column(p_dsql_csr, 6, p_terr_header_rec.TEMPLATE_FLAG, 1);
116: dbms_sql.define_column(p_dsql_csr, 7, p_terr_header_rec.ESCALATION_TERRITORY_FLAG, 1);
117: dbms_sql.define_column(p_dsql_csr, 8, p_terr_header_rec.PARENT_TERR_NAME, 2000);
118: dbms_sql.define_column(p_dsql_csr, 9, p_terr_header_rec.TERR_TYPE_NAME, 60);
119:
120: /* Debug Message */
121: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

Line 118: dbms_sql.define_column(p_dsql_csr, 9, p_terr_header_rec.TERR_TYPE_NAME, 60);

114: dbms_sql.define_column(p_dsql_csr, 5, p_terr_header_rec.END_DATE_ACTIVE);
115: dbms_sql.define_column(p_dsql_csr, 6, p_terr_header_rec.TEMPLATE_FLAG, 1);
116: dbms_sql.define_column(p_dsql_csr, 7, p_terr_header_rec.ESCALATION_TERRITORY_FLAG, 1);
117: dbms_sql.define_column(p_dsql_csr, 8, p_terr_header_rec.PARENT_TERR_NAME, 2000);
118: dbms_sql.define_column(p_dsql_csr, 9, p_terr_header_rec.TERR_TYPE_NAME, 60);
119:
120: /* Debug Message */
121: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
122: THEN

Line 147: dbms_sql.column_value(p_dsql_csr, 1, x_terr_header_rec.TERR_ID);

143: FND_MSG_PUB.Add;
144: END IF;
145:
146: /* get all columns */
147: dbms_sql.column_value(p_dsql_csr, 1, x_terr_header_rec.TERR_ID);
148: dbms_sql.column_value(p_dsql_csr, 2, x_terr_header_rec.TERR_NAME);
149: dbms_sql.column_value(p_dsql_csr, 3, x_terr_header_rec.TERR_USAGE);
150: dbms_sql.column_value(p_dsql_csr, 4, x_terr_header_rec.START_DATE_ACTIVE);
151: dbms_sql.column_value(p_dsql_csr, 5, x_terr_header_rec.END_DATE_ACTIVE);

Line 148: dbms_sql.column_value(p_dsql_csr, 2, x_terr_header_rec.TERR_NAME);

144: END IF;
145:
146: /* get all columns */
147: dbms_sql.column_value(p_dsql_csr, 1, x_terr_header_rec.TERR_ID);
148: dbms_sql.column_value(p_dsql_csr, 2, x_terr_header_rec.TERR_NAME);
149: dbms_sql.column_value(p_dsql_csr, 3, x_terr_header_rec.TERR_USAGE);
150: dbms_sql.column_value(p_dsql_csr, 4, x_terr_header_rec.START_DATE_ACTIVE);
151: dbms_sql.column_value(p_dsql_csr, 5, x_terr_header_rec.END_DATE_ACTIVE);
152: dbms_sql.column_value(p_dsql_csr, 6, x_terr_header_rec.TEMPLATE_FLAG);

Line 149: dbms_sql.column_value(p_dsql_csr, 3, x_terr_header_rec.TERR_USAGE);

145:
146: /* get all columns */
147: dbms_sql.column_value(p_dsql_csr, 1, x_terr_header_rec.TERR_ID);
148: dbms_sql.column_value(p_dsql_csr, 2, x_terr_header_rec.TERR_NAME);
149: dbms_sql.column_value(p_dsql_csr, 3, x_terr_header_rec.TERR_USAGE);
150: dbms_sql.column_value(p_dsql_csr, 4, x_terr_header_rec.START_DATE_ACTIVE);
151: dbms_sql.column_value(p_dsql_csr, 5, x_terr_header_rec.END_DATE_ACTIVE);
152: dbms_sql.column_value(p_dsql_csr, 6, x_terr_header_rec.TEMPLATE_FLAG);
153: dbms_sql.column_value(p_dsql_csr, 7, x_terr_header_rec.ESCALATION_TERRITORY_FLAG);

Line 150: dbms_sql.column_value(p_dsql_csr, 4, x_terr_header_rec.START_DATE_ACTIVE);

146: /* get all columns */
147: dbms_sql.column_value(p_dsql_csr, 1, x_terr_header_rec.TERR_ID);
148: dbms_sql.column_value(p_dsql_csr, 2, x_terr_header_rec.TERR_NAME);
149: dbms_sql.column_value(p_dsql_csr, 3, x_terr_header_rec.TERR_USAGE);
150: dbms_sql.column_value(p_dsql_csr, 4, x_terr_header_rec.START_DATE_ACTIVE);
151: dbms_sql.column_value(p_dsql_csr, 5, x_terr_header_rec.END_DATE_ACTIVE);
152: dbms_sql.column_value(p_dsql_csr, 6, x_terr_header_rec.TEMPLATE_FLAG);
153: dbms_sql.column_value(p_dsql_csr, 7, x_terr_header_rec.ESCALATION_TERRITORY_FLAG);
154: dbms_sql.column_value(p_dsql_csr, 8, x_terr_header_rec.PARENT_TERR_NAME);

Line 151: dbms_sql.column_value(p_dsql_csr, 5, x_terr_header_rec.END_DATE_ACTIVE);

147: dbms_sql.column_value(p_dsql_csr, 1, x_terr_header_rec.TERR_ID);
148: dbms_sql.column_value(p_dsql_csr, 2, x_terr_header_rec.TERR_NAME);
149: dbms_sql.column_value(p_dsql_csr, 3, x_terr_header_rec.TERR_USAGE);
150: dbms_sql.column_value(p_dsql_csr, 4, x_terr_header_rec.START_DATE_ACTIVE);
151: dbms_sql.column_value(p_dsql_csr, 5, x_terr_header_rec.END_DATE_ACTIVE);
152: dbms_sql.column_value(p_dsql_csr, 6, x_terr_header_rec.TEMPLATE_FLAG);
153: dbms_sql.column_value(p_dsql_csr, 7, x_terr_header_rec.ESCALATION_TERRITORY_FLAG);
154: dbms_sql.column_value(p_dsql_csr, 8, x_terr_header_rec.PARENT_TERR_NAME);
155: dbms_sql.column_value(p_dsql_csr, 9, x_terr_header_rec.TERR_TYPE_NAME);

Line 152: dbms_sql.column_value(p_dsql_csr, 6, x_terr_header_rec.TEMPLATE_FLAG);

148: dbms_sql.column_value(p_dsql_csr, 2, x_terr_header_rec.TERR_NAME);
149: dbms_sql.column_value(p_dsql_csr, 3, x_terr_header_rec.TERR_USAGE);
150: dbms_sql.column_value(p_dsql_csr, 4, x_terr_header_rec.START_DATE_ACTIVE);
151: dbms_sql.column_value(p_dsql_csr, 5, x_terr_header_rec.END_DATE_ACTIVE);
152: dbms_sql.column_value(p_dsql_csr, 6, x_terr_header_rec.TEMPLATE_FLAG);
153: dbms_sql.column_value(p_dsql_csr, 7, x_terr_header_rec.ESCALATION_TERRITORY_FLAG);
154: dbms_sql.column_value(p_dsql_csr, 8, x_terr_header_rec.PARENT_TERR_NAME);
155: dbms_sql.column_value(p_dsql_csr, 9, x_terr_header_rec.TERR_TYPE_NAME);
156:

Line 153: dbms_sql.column_value(p_dsql_csr, 7, x_terr_header_rec.ESCALATION_TERRITORY_FLAG);

149: dbms_sql.column_value(p_dsql_csr, 3, x_terr_header_rec.TERR_USAGE);
150: dbms_sql.column_value(p_dsql_csr, 4, x_terr_header_rec.START_DATE_ACTIVE);
151: dbms_sql.column_value(p_dsql_csr, 5, x_terr_header_rec.END_DATE_ACTIVE);
152: dbms_sql.column_value(p_dsql_csr, 6, x_terr_header_rec.TEMPLATE_FLAG);
153: dbms_sql.column_value(p_dsql_csr, 7, x_terr_header_rec.ESCALATION_TERRITORY_FLAG);
154: dbms_sql.column_value(p_dsql_csr, 8, x_terr_header_rec.PARENT_TERR_NAME);
155: dbms_sql.column_value(p_dsql_csr, 9, x_terr_header_rec.TERR_TYPE_NAME);
156:
157:

Line 154: dbms_sql.column_value(p_dsql_csr, 8, x_terr_header_rec.PARENT_TERR_NAME);

150: dbms_sql.column_value(p_dsql_csr, 4, x_terr_header_rec.START_DATE_ACTIVE);
151: dbms_sql.column_value(p_dsql_csr, 5, x_terr_header_rec.END_DATE_ACTIVE);
152: dbms_sql.column_value(p_dsql_csr, 6, x_terr_header_rec.TEMPLATE_FLAG);
153: dbms_sql.column_value(p_dsql_csr, 7, x_terr_header_rec.ESCALATION_TERRITORY_FLAG);
154: dbms_sql.column_value(p_dsql_csr, 8, x_terr_header_rec.PARENT_TERR_NAME);
155: dbms_sql.column_value(p_dsql_csr, 9, x_terr_header_rec.TERR_TYPE_NAME);
156:
157:
158: /* Debug Message */

Line 155: dbms_sql.column_value(p_dsql_csr, 9, x_terr_header_rec.TERR_TYPE_NAME);

151: dbms_sql.column_value(p_dsql_csr, 5, x_terr_header_rec.END_DATE_ACTIVE);
152: dbms_sql.column_value(p_dsql_csr, 6, x_terr_header_rec.TEMPLATE_FLAG);
153: dbms_sql.column_value(p_dsql_csr, 7, x_terr_header_rec.ESCALATION_TERRITORY_FLAG);
154: dbms_sql.column_value(p_dsql_csr, 8, x_terr_header_rec.PARENT_TERR_NAME);
155: dbms_sql.column_value(p_dsql_csr, 9, x_terr_header_rec.TERR_TYPE_NAME);
156:
157:
158: /* Debug Message */
159: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

Line 539: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_1', p_TERR_rec.TERR_ID);

535:
536: --dbms_output.put_line('Binding p_TERR_rec.TERR_ID to :p_Terr_1');
537:
538: -- bind the input variables
539: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_1', p_TERR_rec.TERR_ID);
540:
541: END IF;
542:
543: IF ( (p_TERR_rec.NAME IS NOT NULL) AND

Line 547: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_12', p_TERR_rec.NAME);

543: IF ( (p_TERR_rec.NAME IS NOT NULL) AND
544: (p_TERR_rec.NAME <> FND_API.G_MISS_CHAR) ) THEN
545:
546: -- bind the input variables
547: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_12', p_TERR_rec.NAME);
548:
549: END IF;
550:
551: IF ( (p_TERR_rec.START_DATE_ACTIVE IS NOT NULL) AND

Line 555: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_14', p_TERR_rec.START_DATE_ACTIVE);

551: IF ( (p_TERR_rec.START_DATE_ACTIVE IS NOT NULL) AND
552: (p_TERR_rec.START_DATE_ACTIVE <> FND_API.G_MISS_DATE) ) THEN
553:
554: -- bind the input variables
555: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_14', p_TERR_rec.START_DATE_ACTIVE);
556:
557: END IF;
558:
559: IF ( (p_TERR_rec.END_DATE_ACTIVE IS NOT NULL) AND

Line 563: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_15', p_TERR_rec.END_DATE_ACTIVE);

559: IF ( (p_TERR_rec.END_DATE_ACTIVE IS NOT NULL) AND
560: (p_TERR_rec.END_DATE_ACTIVE <> FND_API.G_MISS_DATE) ) THEN
561:
562: -- bind the input variables
563: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_15', p_TERR_rec.END_DATE_ACTIVE);
564:
565: END IF;
566:
567:

Line 572: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_17', p_TERR_rec.PARENT_TERRITORY_ID);

568: IF ( (p_TERR_rec.PARENT_TERRITORY_ID IS NOT NULL) AND
569: (p_TERR_rec.PARENT_TERRITORY_ID <> FND_API.G_MISS_NUM) ) THEN
570:
571: -- bind the input variables
572: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_17', p_TERR_rec.PARENT_TERRITORY_ID);
573:
574: END IF;
575:
576: IF ( (p_TERR_rec.TERRITORY_TYPE_ID IS NOT NULL) AND

Line 580: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_18', p_TERR_rec.TERRITORY_TYPE_ID);

576: IF ( (p_TERR_rec.TERRITORY_TYPE_ID IS NOT NULL) AND
577: (p_TERR_rec.TERRITORY_TYPE_ID <> FND_API.G_MISS_NUM) ) THEN
578:
579: -- bind the input variables
580: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_18', p_TERR_rec.TERRITORY_TYPE_ID);
581:
582: END IF;
583:
584: IF ( (p_TERR_rec.TEMPLATE_TERRITORY_ID IS NOT NULL) AND

Line 588: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_19', p_TERR_rec.TEMPLATE_TERRITORY_ID);

584: IF ( (p_TERR_rec.TEMPLATE_TERRITORY_ID IS NOT NULL) AND
585: (p_TERR_rec.TEMPLATE_TERRITORY_ID <> FND_API.G_MISS_NUM) ) THEN
586:
587: -- bind the input variables
588: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_19', p_TERR_rec.TEMPLATE_TERRITORY_ID);
589:
590: END IF;
591:
592: IF ( (p_TERR_rec.TEMPLATE_FLAG IS NOT NULL) AND

Line 596: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_20', p_TERR_rec.TEMPLATE_FLAG);

592: IF ( (p_TERR_rec.TEMPLATE_FLAG IS NOT NULL) AND
593: (p_TERR_rec.TEMPLATE_FLAG <> FND_API.G_MISS_CHAR) ) THEN
594:
595: -- bind the input variables
596: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_20', p_TERR_rec.TEMPLATE_FLAG);
597:
598: END IF;
599:
600: IF ( (p_TERR_rec.ESCALATION_TERRITORY_ID IS NOT NULL) AND

Line 604: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_21', p_TERR_rec.ESCALATION_TERRITORY_ID);

600: IF ( (p_TERR_rec.ESCALATION_TERRITORY_ID IS NOT NULL) AND
601: (p_TERR_rec.ESCALATION_TERRITORY_ID <> FND_API.G_MISS_NUM) ) THEN
602:
603: -- bind the input variables
604: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_21', p_TERR_rec.ESCALATION_TERRITORY_ID);
605:
606: END IF;
607:
608: IF ( (p_TERR_rec.ESCALATION_TERRITORY_FLAG IS NOT NULL) AND

Line 612: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_22', p_TERR_rec.ESCALATION_TERRITORY_FLAG);

608: IF ( (p_TERR_rec.ESCALATION_TERRITORY_FLAG IS NOT NULL) AND
609: (p_TERR_rec.ESCALATION_TERRITORY_FLAG <> FND_API.G_MISS_CHAR) ) THEN
610:
611: -- bind the input variables
612: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_22', p_TERR_rec.ESCALATION_TERRITORY_FLAG);
613:
614: END IF;
615:
616: IF ( (p_TERR_rec.OVERLAP_ALLOWED_FLAG IS NOT NULL) AND

Line 620: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_23', p_TERR_rec.OVERLAP_ALLOWED_FLAG);

616: IF ( (p_TERR_rec.OVERLAP_ALLOWED_FLAG IS NOT NULL) AND
617: (p_TERR_rec.OVERLAP_ALLOWED_FLAG <> FND_API.G_MISS_CHAR) ) THEN
618:
619: -- bind the input variables
620: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_23', p_TERR_rec.OVERLAP_ALLOWED_FLAG);
621:
622: END IF;
623:
624: IF ( (p_TERR_rec.RANK IS NOT NULL) AND

Line 628: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_24', p_TERR_rec.RANK);

624: IF ( (p_TERR_rec.RANK IS NOT NULL) AND
625: (p_TERR_rec.RANK <> FND_API.G_MISS_NUM) ) THEN
626:
627: -- bind the input variables
628: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_24', p_TERR_rec.RANK);
629:
630: END IF;
631:
632: IF ( (p_TERR_rec.DESCRIPTION IS NOT NULL) AND

Line 636: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_25', p_TERR_rec.DESCRIPTION);

632: IF ( (p_TERR_rec.DESCRIPTION IS NOT NULL) AND
633: (p_TERR_rec.DESCRIPTION <> FND_API.G_MISS_CHAR) ) THEN
634:
635: -- bind the input variables
636: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_25', p_TERR_rec.DESCRIPTION);
637:
638: END IF;
639:
640: IF ( (p_TERR_rec.PARENT_TERR_NAME IS NOT NULL) AND

Line 644: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_26', p_TERR_rec.PARENT_TERR_NAME);

640: IF ( (p_TERR_rec.PARENT_TERR_NAME IS NOT NULL) AND
641: (p_TERR_rec.PARENT_TERR_NAME <> FND_API.G_MISS_CHAR) ) THEN
642:
643: -- bind the input variables
644: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_26', p_TERR_rec.PARENT_TERR_NAME);
645:
646: END IF;
647:
648: IF ( (p_TERR_rec.ESCALATION_TERR_NAME IS NOT NULL) AND

Line 652: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_27', p_TERR_rec.ESCALATION_TERR_NAME);

648: IF ( (p_TERR_rec.ESCALATION_TERR_NAME IS NOT NULL) AND
649: (p_TERR_rec.ESCALATION_TERR_NAME <> FND_API.G_MISS_CHAR) ) THEN
650:
651: -- bind the input variables
652: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_27', p_TERR_rec.ESCALATION_TERR_NAME);
653:
654: END IF;
655:
656: IF ( (p_TERR_rec.TEMPLATE_TERR_NAME IS NOT NULL) AND

Line 660: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_28', p_TERR_rec.TEMPLATE_TERR_NAME);

656: IF ( (p_TERR_rec.TEMPLATE_TERR_NAME IS NOT NULL) AND
657: (p_TERR_rec.TEMPLATE_TERR_NAME <> FND_API.G_MISS_CHAR) ) THEN
658:
659: -- bind the input variables
660: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_28', p_TERR_rec.TEMPLATE_TERR_NAME);
661:
662: END IF;
663:
664: /* Debug Message */

Line 798: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_USGS_1', p_TERR_USGS_rec.TERR_USG_ID);

794: IF ( (p_TERR_USGS_rec.TERR_USG_ID IS NOT NULL) AND
795: (p_TERR_USGS_rec.TERR_USG_ID <> FND_API.G_MISS_NUM) ) THEN
796:
797: -- bind the input variables
798: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_USGS_1', p_TERR_USGS_rec.TERR_USG_ID);
799:
800: END IF;
801:
802: IF ( (p_TERR_USGS_rec.TERR_ID IS NOT NULL) AND

Line 806: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_USGS_7', p_TERR_USGS_rec.TERR_ID);

802: IF ( (p_TERR_USGS_rec.TERR_ID IS NOT NULL) AND
803: (p_TERR_USGS_rec.TERR_ID <> FND_API.G_MISS_NUM) ) THEN
804:
805: -- bind the input variables
806: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_USGS_7', p_TERR_USGS_rec.TERR_ID);
807:
808: END IF;
809:
810: IF ( (p_TERR_USGS_rec.SOURCE_ID IS NOT NULL) AND

Line 814: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_USGS_8', p_TERR_USGS_rec.SOURCE_ID);

810: IF ( (p_TERR_USGS_rec.SOURCE_ID IS NOT NULL) AND
811: (p_TERR_USGS_rec.SOURCE_ID <> FND_API.G_MISS_NUM) ) THEN
812:
813: -- bind the input variables
814: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_USGS_8', p_TERR_USGS_rec.SOURCE_ID);
815:
816: END IF;
817:
818: IF ( (p_TERR_USGS_rec.USAGE IS NOT NULL) AND

Line 822: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_USGS_9', p_TERR_USGS_rec.USAGE);

818: IF ( (p_TERR_USGS_rec.USAGE IS NOT NULL) AND
819: (p_TERR_USGS_rec.USAGE <> FND_API.G_MISS_CHAR) ) THEN
820:
821: -- bind the input variables
822: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_USGS_9', p_TERR_USGS_rec.USAGE);
823:
824: END IF;
825:
826: /* Debug Message */

Line 1036: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_TYPES_1', p_TERR_TYPES_rec.TERR_TYPE_ID);

1032: IF ( (p_TERR_TYPES_rec.TERR_TYPE_ID IS NOT NULL) AND
1033: (p_TERR_TYPES_rec.TERR_TYPE_ID <> FND_API.G_MISS_NUM) ) THEN
1034:
1035: -- bind the input variables
1036: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_TYPES_1', p_TERR_TYPES_rec.TERR_TYPE_ID);
1037:
1038: END IF;
1039:
1040:

Line 1045: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_TYPES_8', p_TERR_TYPES_rec.NAME);

1041: IF ( (p_TERR_TYPES_rec.NAME IS NOT NULL) AND
1042: (p_TERR_TYPES_rec.NAME <> FND_API.G_MISS_CHAR) ) THEN
1043:
1044: -- bind the input variables
1045: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_TYPES_8', p_TERR_TYPES_rec.NAME);
1046:
1047: END IF;
1048:
1049:

Line 1054: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_TYPES_10', p_TERR_TYPES_rec.DESCRIPTION);

1050: IF ( (p_TERR_TYPES_rec.DESCRIPTION IS NOT NULL) AND
1051: (p_TERR_TYPES_rec.DESCRIPTION <> FND_API.G_MISS_CHAR) ) THEN
1052:
1053: -- bind the input variables
1054: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_TYPES_10', p_TERR_TYPES_rec.DESCRIPTION);
1055:
1056: END IF;
1057:
1058: IF ( (p_TERR_TYPES_rec.START_DATE_ACTIVE IS NOT NULL) AND

Line 1062: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_TYPES_11', p_TERR_TYPES_rec.START_DATE_ACTIVE);

1058: IF ( (p_TERR_TYPES_rec.START_DATE_ACTIVE IS NOT NULL) AND
1059: (p_TERR_TYPES_rec.START_DATE_ACTIVE <> FND_API.G_MISS_DATE) ) THEN
1060:
1061: -- bind the input variables
1062: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_TYPES_11', p_TERR_TYPES_rec.START_DATE_ACTIVE);
1063:
1064: END IF;
1065:
1066: IF ( (p_TERR_TYPES_rec.END_DATE_ACTIVE IS NOT NULL) AND

Line 1070: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_TYPES_12', p_TERR_TYPES_rec.END_DATE_ACTIVE);

1066: IF ( (p_TERR_TYPES_rec.END_DATE_ACTIVE IS NOT NULL) AND
1067: (p_TERR_TYPES_rec.END_DATE_ACTIVE <> FND_API.G_MISS_DATE) ) THEN
1068:
1069: -- bind the input variables
1070: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_TYPES_12', p_TERR_TYPES_rec.END_DATE_ACTIVE);
1071:
1072: END IF;
1073:
1074: /* Debug Message */

Line 1256: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_QTYPE_USGS_1', p_TERR_QTYPE_USGS_rec.TERR_QTYPE_USG_ID);

1252: IF ( (p_TERR_QTYPE_USGS_REC.TERR_QTYPE_USG_ID IS NOT NULL) AND
1253: (p_TERR_QTYPE_USGS_REC.TERR_QTYPE_USG_ID <> FND_API.G_MISS_NUM) ) THEN
1254:
1255: -- bind the input variables
1256: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_QTYPE_USGS_1', p_TERR_QTYPE_USGS_rec.TERR_QTYPE_USG_ID);
1257:
1258: END IF;
1259:
1260: IF ( (p_TERR_QTYPE_USGS_REC.TERR_ID IS NOT NULL) AND

Line 1264: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_QTYPE_USGS_7', p_TERR_QTYPE_USGS_rec.TERR_ID);

1260: IF ( (p_TERR_QTYPE_USGS_REC.TERR_ID IS NOT NULL) AND
1261: (p_TERR_QTYPE_USGS_REC.TERR_ID <> FND_API.G_MISS_NUM) ) THEN
1262:
1263: -- bind the input variables
1264: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_QTYPE_USGS_7', p_TERR_QTYPE_USGS_rec.TERR_ID);
1265:
1266: END IF;
1267:
1268: IF ( (p_TERR_QTYPE_USGS_REC.QUAL_TYPE_USG_ID IS NOT NULL) AND

Line 1272: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_QTYPE_USGS_8', p_TERR_QTYPE_USGS_rec.QUAL_TYPE_USG_ID);

1268: IF ( (p_TERR_QTYPE_USGS_REC.QUAL_TYPE_USG_ID IS NOT NULL) AND
1269: (p_TERR_QTYPE_USGS_REC.QUAL_TYPE_USG_ID <> FND_API.G_MISS_NUM) ) THEN
1270:
1271: -- bind the input variables
1272: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_QTYPE_USGS_8', p_TERR_QTYPE_USGS_rec.QUAL_TYPE_USG_ID);
1273:
1274: END IF;
1275:
1276: IF ( (p_TERR_QTYPE_USGS_REC.SOURCE_ID IS NOT NULL) AND

Line 1280: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_QTYPE_USGS_10', p_TERR_QTYPE_USGS_rec.SOURCE_ID);

1276: IF ( (p_TERR_QTYPE_USGS_REC.SOURCE_ID IS NOT NULL) AND
1277: (p_TERR_QTYPE_USGS_REC.SOURCE_ID <> FND_API.G_MISS_NUM) ) THEN
1278:
1279: -- bind the input variables
1280: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_QTYPE_USGS_10', p_TERR_QTYPE_USGS_rec.SOURCE_ID);
1281:
1282: END IF;
1283:
1284: IF ( (p_TERR_QTYPE_USGS_REC.QUAL_TYPE_ID IS NOT NULL) AND

Line 1288: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_QTYPE_USGS_11', p_TERR_QTYPE_USGS_rec.QUAL_TYPE_ID);

1284: IF ( (p_TERR_QTYPE_USGS_REC.QUAL_TYPE_ID IS NOT NULL) AND
1285: (p_TERR_QTYPE_USGS_REC.QUAL_TYPE_ID <> FND_API.G_MISS_NUM) ) THEN
1286:
1287: -- bind the input variables
1288: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_QTYPE_USGS_11', p_TERR_QTYPE_USGS_rec.QUAL_TYPE_ID);
1289:
1290: END IF;
1291:
1292: IF ( (p_TERR_QTYPE_USGS_REC.QUALIFIER_TYPE_NAME IS NOT NULL) AND

Line 1296: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_QTYPE_USGS_12', p_TERR_QTYPE_USGS_rec.QUALIFIER_TYPE_NAME);

1292: IF ( (p_TERR_QTYPE_USGS_REC.QUALIFIER_TYPE_NAME IS NOT NULL) AND
1293: (p_TERR_QTYPE_USGS_REC.QUALIFIER_TYPE_NAME <> FND_API.G_MISS_CHAR) ) THEN
1294:
1295: -- bind the input variables
1296: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_QTYPE_USGS_12', p_TERR_QTYPE_USGS_rec.QUALIFIER_TYPE_NAME);
1297:
1298: END IF;
1299:
1300: IF ( (p_TERR_QTYPE_USGS_REC.QUALIFIER_TYPE_DESCRIPTION IS NOT NULL) AND

Line 1304: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_QTYPE_USGS_13', p_TERR_QTYPE_USGS_rec.QUALIFIER_TYPE_DESCRIPTION);

1300: IF ( (p_TERR_QTYPE_USGS_REC.QUALIFIER_TYPE_DESCRIPTION IS NOT NULL) AND
1301: (p_TERR_QTYPE_USGS_REC.QUALIFIER_TYPE_DESCRIPTION <> FND_API.G_MISS_CHAR) ) THEN
1302:
1303: -- bind the input variables
1304: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_QTYPE_USGS_13', p_TERR_QTYPE_USGS_rec.QUALIFIER_TYPE_DESCRIPTION);
1305:
1306: END IF;
1307:
1308:

Line 1629: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_QUAL_1', p_TERR_QUAL_rec.TERR_QUAL_ID);

1625: IF ( (p_TERR_QUAL_rec.TERR_QUAL_ID IS NOT NULL) AND
1626: (p_TERR_QUAL_rec.TERR_QUAL_ID <> FND_API.G_MISS_NUM) ) THEN
1627:
1628: -- bind the input variables
1629: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_QUAL_1', p_TERR_QUAL_rec.TERR_QUAL_ID);
1630:
1631: END IF;
1632:
1633: IF ( (p_TERR_QUAL_rec.TERR_ID IS NOT NULL) AND

Line 1637: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_QUAL_7', p_TERR_QUAL_rec.TERR_ID);

1633: IF ( (p_TERR_QUAL_rec.TERR_ID IS NOT NULL) AND
1634: (p_TERR_QUAL_rec.TERR_ID <> FND_API.G_MISS_NUM) ) THEN
1635:
1636: -- bind the input variables
1637: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_QUAL_7', p_TERR_QUAL_rec.TERR_ID);
1638:
1639: END IF;
1640:
1641: IF ( (p_TERR_QUAL_rec.QUAL_USG_ID IS NOT NULL) AND

Line 1645: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_QUAL_8', p_TERR_QUAL_rec.QUAL_USG_ID);

1641: IF ( (p_TERR_QUAL_rec.QUAL_USG_ID IS NOT NULL) AND
1642: (p_TERR_QUAL_rec.QUAL_USG_ID <> FND_API.G_MISS_NUM) ) THEN
1643:
1644: -- bind the input variables
1645: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_QUAL_8', p_TERR_QUAL_rec.QUAL_USG_ID);
1646:
1647: END IF;
1648:
1649: IF ( (p_TERR_QUAL_rec.OVERLAP_ALLOWED_FLAG IS NOT NULL) AND

Line 1653: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_QUAL_11', p_TERR_QUAL_rec.OVERLAP_ALLOWED_FLAG);

1649: IF ( (p_TERR_QUAL_rec.OVERLAP_ALLOWED_FLAG IS NOT NULL) AND
1650: (p_TERR_QUAL_rec.OVERLAP_ALLOWED_FLAG <> FND_API.G_MISS_CHAR) ) THEN
1651:
1652: -- bind the input variables
1653: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_QUAL_11', p_TERR_QUAL_rec.OVERLAP_ALLOWED_FLAG);
1654:
1655: END IF;
1656:
1657: IF ( (p_TERR_QUAL_rec.QUALIFIER_MODE IS NOT NULL) AND

Line 1661: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_QUAL_13', p_TERR_QUAL_rec.QUALIFIER_MODE);

1657: IF ( (p_TERR_QUAL_rec.QUALIFIER_MODE IS NOT NULL) AND
1658: (p_TERR_QUAL_rec.QUALIFIER_MODE <> FND_API.G_MISS_CHAR) ) THEN
1659:
1660: -- bind the input variables
1661: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_QUAL_13', p_TERR_QUAL_rec.QUALIFIER_MODE);
1662:
1663: END IF;
1664:
1665: IF ( (p_TERR_QUAL_rec.DISPLAY_TYPE IS NOT NULL) AND

Line 1669: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_QUAL_14', p_TERR_QUAL_rec.DISPLAY_TYPE);

1665: IF ( (p_TERR_QUAL_rec.DISPLAY_TYPE IS NOT NULL) AND
1666: (p_TERR_QUAL_rec.DISPLAY_TYPE <> FND_API.G_MISS_CHAR) ) THEN
1667:
1668: -- bind the input variables
1669: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_QUAL_14', p_TERR_QUAL_rec.DISPLAY_TYPE);
1670:
1671: END IF;
1672:
1673: IF ( (p_TERR_QUAL_rec.LOV_SQL IS NOT NULL) AND

Line 1677: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_QUAL_15', p_TERR_QUAL_rec.LOV_SQL);

1673: IF ( (p_TERR_QUAL_rec.LOV_SQL IS NOT NULL) AND
1674: (p_TERR_QUAL_rec.LOV_SQL <> FND_API.G_MISS_CHAR) ) THEN
1675:
1676: -- bind the input variables
1677: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_QUAL_15', p_TERR_QUAL_rec.LOV_SQL);
1678:
1679: END IF;
1680:
1681: IF ( (p_TERR_QUAL_rec.CONVERT_TO_ID_FLAG IS NOT NULL) AND

Line 1686: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_QUAL_16', p_TERR_QUAL_rec.CONVERT_TO_ID_FLAG);

1682: (p_TERR_QUAL_rec.CONVERT_TO_ID_FLAG <> FND_API.G_MISS_CHAR) ) THEN
1683:
1684:
1685: -- bind the input variables
1686: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_QUAL_16', p_TERR_QUAL_rec.CONVERT_TO_ID_FLAG);
1687:
1688: END IF;
1689:
1690: IF ( (p_TERR_QUAL_rec.QUAL_TYPE_ID IS NOT NULL) AND

Line 1694: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_QUAL_17', p_TERR_QUAL_rec.QUAL_TYPE_ID);

1690: IF ( (p_TERR_QUAL_rec.QUAL_TYPE_ID IS NOT NULL) AND
1691: (p_TERR_QUAL_rec.QUAL_TYPE_ID <> FND_API.G_MISS_NUM) ) THEN
1692:
1693: -- bind the input variables
1694: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_QUAL_17', p_TERR_QUAL_rec.QUAL_TYPE_ID);
1695:
1696: END IF;
1697:
1698: IF ( (p_TERR_QUAL_rec.QUALIFIER_TYPE_NAME IS NOT NULL) AND

Line 1702: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_QUAL_18', p_TERR_QUAL_rec.QUALIFIER_TYPE_NAME);

1698: IF ( (p_TERR_QUAL_rec.QUALIFIER_TYPE_NAME IS NOT NULL) AND
1699: (p_TERR_QUAL_rec.QUALIFIER_TYPE_NAME <> FND_API.G_MISS_CHAR) ) THEN
1700:
1701: -- bind the input variables
1702: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_QUAL_18', p_TERR_QUAL_rec.QUALIFIER_TYPE_NAME);
1703:
1704: END IF;
1705:
1706: IF ( (p_TERR_QUAL_rec.QUALIFIER_TYPE_DESCRIPTION IS NOT NULL) AND

Line 1710: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_QUAL_19', p_TERR_QUAL_rec.QUALIFIER_TYPE_DESCRIPTION);

1706: IF ( (p_TERR_QUAL_rec.QUALIFIER_TYPE_DESCRIPTION IS NOT NULL) AND
1707: (p_TERR_QUAL_rec.QUALIFIER_TYPE_DESCRIPTION <> FND_API.G_MISS_CHAR) ) THEN
1708:
1709: -- bind the input variables
1710: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_QUAL_19', p_TERR_QUAL_rec.QUALIFIER_TYPE_DESCRIPTION);
1711:
1712: END IF;
1713:
1714: IF ( (p_TERR_QUAL_rec.QUALIFIER_NAME IS NOT NULL) AND

Line 1718: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_QUAL_20', p_TERR_QUAL_rec.QUALIFIER_NAME);

1714: IF ( (p_TERR_QUAL_rec.QUALIFIER_NAME IS NOT NULL) AND
1715: (p_TERR_QUAL_rec.QUALIFIER_NAME <> FND_API.G_MISS_CHAR) ) THEN
1716:
1717: -- bind the input variables
1718: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_QUAL_20', p_TERR_QUAL_rec.QUALIFIER_NAME);
1719:
1720: END IF;
1721:
1722: /* Debug Message */

Line 2002: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_VALUES_1', p_TERR_VALUES_rec.TERR_VALUE_ID);

1998: IF ( (p_TERR_VALUES_rec.TERR_VALUE_ID IS NOT NULL) AND
1999: (p_TERR_VALUES_rec.TERR_VALUE_ID <> FND_API.G_MISS_NUM) ) THEN
2000:
2001: -- bind the input variables
2002: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_VALUES_1', p_TERR_VALUES_rec.TERR_VALUE_ID);
2003:
2004: END IF;
2005:
2006: IF ( (p_TERR_VALUES_rec.TERR_QUAL_ID IS NOT NULL) AND

Line 2010: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_VALUES_7', p_TERR_VALUES_rec.TERR_QUAL_ID);

2006: IF ( (p_TERR_VALUES_rec.TERR_QUAL_ID IS NOT NULL) AND
2007: (p_TERR_VALUES_rec.TERR_QUAL_ID <> FND_API.G_MISS_NUM) ) THEN
2008:
2009: -- bind the input variables
2010: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_VALUES_7', p_TERR_VALUES_rec.TERR_QUAL_ID);
2011:
2012: END IF;
2013:
2014: IF ( (p_TERR_VALUES_rec.COMPARISON_OPERATOR IS NOT NULL) AND

Line 2018: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_VALUES_9', p_TERR_VALUES_rec.COMPARISON_OPERATOR);

2014: IF ( (p_TERR_VALUES_rec.COMPARISON_OPERATOR IS NOT NULL) AND
2015: (p_TERR_VALUES_rec.COMPARISON_OPERATOR <> FND_API.G_MISS_CHAR) ) THEN
2016:
2017: -- bind the input variables
2018: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_VALUES_9', p_TERR_VALUES_rec.COMPARISON_OPERATOR);
2019:
2020: END IF;
2021:
2022: IF ( (p_TERR_VALUES_rec.LOW_VALUE_CHAR IS NOT NULL) AND

Line 2029: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_VALUES_10', p_TERR_VALUES_rec.LOW_VALUE_CHAR);

2025: --dbms_output.put_line( 'Value of p_TERR_VALUES_rec.LOW_VALUE_CHAR = ' ||
2026: -- p_TERR_VALUES_rec.LOW_VALUE_CHAR);
2027:
2028: -- bind the input variables
2029: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_VALUES_10', p_TERR_VALUES_rec.LOW_VALUE_CHAR);
2030:
2031: END IF;
2032:
2033: IF ( (p_TERR_VALUES_rec.HIGH_VALUE_CHAR IS NOT NULL) AND

Line 2037: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_VALUES_11', p_TERR_VALUES_rec.HIGH_VALUE_CHAR);

2033: IF ( (p_TERR_VALUES_rec.HIGH_VALUE_CHAR IS NOT NULL) AND
2034: (p_TERR_VALUES_rec.HIGH_VALUE_CHAR <> FND_API.G_MISS_CHAR) ) THEN
2035:
2036: -- bind the input variables
2037: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_VALUES_11', p_TERR_VALUES_rec.HIGH_VALUE_CHAR);
2038:
2039: END IF;
2040:
2041: IF ( (p_TERR_VALUES_rec.LOW_VALUE_NUMBER IS NOT NULL) AND

Line 2045: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_VALUES_12', p_TERR_VALUES_rec.LOW_VALUE_NUMBER);

2041: IF ( (p_TERR_VALUES_rec.LOW_VALUE_NUMBER IS NOT NULL) AND
2042: (p_TERR_VALUES_rec.LOW_VALUE_NUMBER <> FND_API.G_MISS_NUM) ) THEN
2043:
2044: -- bind the input variables
2045: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_VALUES_12', p_TERR_VALUES_rec.LOW_VALUE_NUMBER);
2046:
2047: END IF;
2048:
2049: IF ( (p_TERR_VALUES_rec.HIGH_VALUE_NUMBER IS NOT NULL) AND

Line 2053: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_VALUES_13', p_TERR_VALUES_rec.HIGH_VALUE_NUMBER);

2049: IF ( (p_TERR_VALUES_rec.HIGH_VALUE_NUMBER IS NOT NULL) AND
2050: (p_TERR_VALUES_rec.HIGH_VALUE_NUMBER <> FND_API.G_MISS_NUM) ) THEN
2051:
2052: -- bind the input variables
2053: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_VALUES_13', p_TERR_VALUES_rec.HIGH_VALUE_NUMBER);
2054:
2055: END IF;
2056:
2057:

Line 2062: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_VALUES_15', p_TERR_VALUES_rec.INTEREST_TYPE_ID);

2058: IF ( (p_TERR_VALUES_rec.INTEREST_TYPE_ID IS NOT NULL) AND
2059: (p_TERR_VALUES_rec.INTEREST_TYPE_ID <> FND_API.G_MISS_NUM) ) THEN
2060:
2061: -- bind the input variables
2062: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_VALUES_15', p_TERR_VALUES_rec.INTEREST_TYPE_ID);
2063:
2064: END IF;
2065:
2066: IF ( (p_TERR_VALUES_rec.PRIMARY_INTEREST_CODE_ID IS NOT NULL) AND

Line 2070: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_VALUES_16', p_TERR_VALUES_rec.PRIMARY_INTEREST_CODE_ID);

2066: IF ( (p_TERR_VALUES_rec.PRIMARY_INTEREST_CODE_ID IS NOT NULL) AND
2067: (p_TERR_VALUES_rec.PRIMARY_INTEREST_CODE_ID <> FND_API.G_MISS_NUM) ) THEN
2068:
2069: -- bind the input variables
2070: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_VALUES_16', p_TERR_VALUES_rec.PRIMARY_INTEREST_CODE_ID);
2071:
2072: END IF;
2073:
2074: IF ( (p_TERR_VALUES_rec.SECONDARY_INTEREST_CODE_ID IS NOT NULL) AND

Line 2078: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_VALUES_17', p_TERR_VALUES_rec.SECONDARY_INTEREST_CODE_ID);

2074: IF ( (p_TERR_VALUES_rec.SECONDARY_INTEREST_CODE_ID IS NOT NULL) AND
2075: (p_TERR_VALUES_rec.SECONDARY_INTEREST_CODE_ID <> FND_API.G_MISS_NUM) ) THEN
2076:
2077: -- bind the input variables
2078: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_VALUES_17', p_TERR_VALUES_rec.SECONDARY_INTEREST_CODE_ID);
2079:
2080: END IF;
2081:
2082: IF ( (p_TERR_VALUES_rec.CURRENCY_CODE IS NOT NULL) AND

Line 2086: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_VALUES_18', p_TERR_VALUES_rec.CURRENCY_CODE);

2082: IF ( (p_TERR_VALUES_rec.CURRENCY_CODE IS NOT NULL) AND
2083: (p_TERR_VALUES_rec.CURRENCY_CODE <> FND_API.G_MISS_CHAR) ) THEN
2084:
2085: -- bind the input variables
2086: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_VALUES_18', p_TERR_VALUES_rec.CURRENCY_CODE);
2087:
2088: END IF;
2089:
2090: IF ( (p_TERR_VALUES_rec.ID_USED_FLAG IS NOT NULL) AND

Line 2094: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_VALUES_19', p_TERR_VALUES_rec.ID_USED_FLAG);

2090: IF ( (p_TERR_VALUES_rec.ID_USED_FLAG IS NOT NULL) AND
2091: (p_TERR_VALUES_rec.ID_USED_FLAG <> FND_API.G_MISS_CHAR) ) THEN
2092:
2093: -- bind the input variables
2094: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_VALUES_19', p_TERR_VALUES_rec.ID_USED_FLAG);
2095:
2096: END IF;
2097:
2098: IF ( (p_TERR_VALUES_rec.LOW_VALUE_CHAR_ID IS NOT NULL) AND

Line 2102: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_VALUES_20', p_TERR_VALUES_rec.LOW_VALUE_CHAR_ID);

2098: IF ( (p_TERR_VALUES_rec.LOW_VALUE_CHAR_ID IS NOT NULL) AND
2099: (p_TERR_VALUES_rec.LOW_VALUE_CHAR_ID <> FND_API.G_MISS_NUM) ) THEN
2100:
2101: -- bind the input variables
2102: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_VALUES_20', p_TERR_VALUES_rec.LOW_VALUE_CHAR_ID);
2103:
2104: END IF;
2105:
2106: /* Debug Message */

Line 2352: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_RSC_1', p_TERR_RSC_rec.TERR_RSC_ID);

2348: IF ( (p_TERR_RSC_rec.TERR_RSC_ID IS NOT NULL) AND
2349: (p_TERR_RSC_rec.TERR_RSC_ID <> FND_API.G_MISS_NUM) ) THEN
2350:
2351: -- bind the input variables
2352: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_RSC_1', p_TERR_RSC_rec.TERR_RSC_ID);
2353:
2354: END IF;
2355:
2356: IF ( (p_TERR_RSC_rec.TERR_ID IS NOT NULL) AND

Line 2360: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_RSC_7', p_TERR_RSC_rec.TERR_ID);

2356: IF ( (p_TERR_RSC_rec.TERR_ID IS NOT NULL) AND
2357: (p_TERR_RSC_rec.TERR_ID <> FND_API.G_MISS_NUM) ) THEN
2358:
2359: -- bind the input variables
2360: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_RSC_7', p_TERR_RSC_rec.TERR_ID);
2361:
2362: END IF;
2363:
2364: IF ( (p_TERR_RSC_rec.RESOURCE_ID IS NOT NULL) AND

Line 2368: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_RSC_8', p_TERR_RSC_rec.RESOURCE_ID);

2364: IF ( (p_TERR_RSC_rec.RESOURCE_ID IS NOT NULL) AND
2365: (p_TERR_RSC_rec.RESOURCE_ID <> FND_API.G_MISS_NUM) ) THEN
2366:
2367: -- bind the input variables
2368: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_RSC_8', p_TERR_RSC_rec.RESOURCE_ID);
2369:
2370: END IF;
2371:
2372: IF ( (p_TERR_RSC_rec.RESOURCE_TYPE IS NOT NULL) AND

Line 2376: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_RSC_9', p_TERR_RSC_rec.RESOURCE_TYPE);

2372: IF ( (p_TERR_RSC_rec.RESOURCE_TYPE IS NOT NULL) AND
2373: (p_TERR_RSC_rec.RESOURCE_TYPE <> FND_API.G_MISS_CHAR) ) THEN
2374:
2375: -- bind the input variables
2376: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_RSC_9', p_TERR_RSC_rec.RESOURCE_TYPE);
2377:
2378: END IF;
2379:
2380: IF ( (p_TERR_RSC_rec.ROLE IS NOT NULL) AND

Line 2384: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_RSC_10', p_TERR_RSC_rec.ROLE);

2380: IF ( (p_TERR_RSC_rec.ROLE IS NOT NULL) AND
2381: (p_TERR_RSC_rec.ROLE <> FND_API.G_MISS_CHAR) ) THEN
2382:
2383: -- bind the input variables
2384: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_RSC_10', p_TERR_RSC_rec.ROLE);
2385:
2386: END IF;
2387:
2388: IF ( (p_TERR_RSC_rec.PRIMARY_CONTACT_FLAG IS NOT NULL) AND

Line 2392: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_RSC_11', p_TERR_RSC_rec.PRIMARY_CONTACT_FLAG);

2388: IF ( (p_TERR_RSC_rec.PRIMARY_CONTACT_FLAG IS NOT NULL) AND
2389: (p_TERR_RSC_rec.PRIMARY_CONTACT_FLAG <> FND_API.G_MISS_CHAR) ) THEN
2390:
2391: -- bind the input variables
2392: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_RSC_11', p_TERR_RSC_rec.PRIMARY_CONTACT_FLAG);
2393:
2394: END IF;
2395:
2396: IF ( (p_TERR_RSC_rec.START_DATE_ACTIVE IS NOT NULL) AND

Line 2400: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_RSC_12', p_TERR_RSC_rec.START_DATE_ACTIVE);

2396: IF ( (p_TERR_RSC_rec.START_DATE_ACTIVE IS NOT NULL) AND
2397: (p_TERR_RSC_rec.START_DATE_ACTIVE <> FND_API.G_MISS_DATE) ) THEN
2398:
2399: -- bind the input variables
2400: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_RSC_12', p_TERR_RSC_rec.START_DATE_ACTIVE);
2401:
2402: END IF;
2403:
2404: IF ( (p_TERR_RSC_rec.END_DATE_ACTIVE IS NOT NULL) AND

Line 2408: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_RSC_13', p_TERR_RSC_rec.END_DATE_ACTIVE);

2404: IF ( (p_TERR_RSC_rec.END_DATE_ACTIVE IS NOT NULL) AND
2405: (p_TERR_RSC_rec.END_DATE_ACTIVE <> FND_API.G_MISS_DATE) ) THEN
2406:
2407: -- bind the input variables
2408: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_RSC_13', p_TERR_RSC_rec.END_DATE_ACTIVE);
2409:
2410: END IF;
2411:
2412: IF ( (p_TERR_RSC_rec.FULL_ACCESS_FLAG IS NOT NULL) AND

Line 2416: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_RSC_14', p_TERR_RSC_rec.FULL_ACCESS_FLAG);

2412: IF ( (p_TERR_RSC_rec.FULL_ACCESS_FLAG IS NOT NULL) AND
2413: (p_TERR_RSC_rec.FULL_ACCESS_FLAG <> FND_API.G_MISS_CHAR) ) THEN
2414:
2415: -- bind the input variables
2416: DBMS_SQL.BIND_VARIABLE(p_dsql_csr, ':p_TERR_RSC_14', p_TERR_RSC_rec.FULL_ACCESS_FLAG);
2417:
2418: END IF;
2419:
2420: /* Debug Message */

Line 2665: l_dsql_csr := dbms_sql.open_cursor;

2661:
2662: /******************************/
2663: /* OPEN CURSOR for processing */
2664: /******************************/
2665: l_dsql_csr := dbms_sql.open_cursor;
2666:
2667: --dbms_output.put_line('after open dsql cursor');
2668:
2669:

Line 2831: DBMS_SQL.PARSE(l_dsql_csr, l_dsql_str, DBMS_SQL.V7);

2827: --dbms_output.put_line('[9] about to parse query');
2828: /************************/
2829: /* parse the query */
2830: /************************/
2831: DBMS_SQL.PARSE(l_dsql_csr, l_dsql_str, DBMS_SQL.V7);
2832:
2833: /************************/
2834: /* bind input variables */
2835: /************************/

Line 2889: l_dummy := DBMS_SQL.EXECUTE ( l_dsql_csr );

2885: define_dsql_columns ( l_dsql_csr, l_terr_header_rec );
2886:
2887: --dbms_output.put_line('[18] executing query');
2888: /* execute query */
2889: l_dummy := DBMS_SQL.EXECUTE ( l_dsql_csr );
2890:
2891: /* Fetch rows into buffer, and then put in PL/SQL table */
2892: LOOP
2893:

Line 2895: IF (DBMS_SQL.FETCH_ROWS (l_dsql_csr) = 0 ) THEN

2891: /* Fetch rows into buffer, and then put in PL/SQL table */
2892: LOOP
2893:
2894: /* exit at last row in cursor */
2895: IF (DBMS_SQL.FETCH_ROWS (l_dsql_csr) = 0 ) THEN
2896: EXIT;
2897: END IF;
2898:
2899: /* all records are to be returned OR number of records requested is null

Line 2937: DBMS_SQL.CLOSE_CURSOR(l_dsql_csr);

2933:
2934: END LOOP;
2935:
2936: /* close cursor */
2937: DBMS_SQL.CLOSE_CURSOR(l_dsql_csr);
2938:
2939: /* save return variables */
2940: x_num_rec_returned := l_num_rec_returned;
2941: x_next_rec_num := l_next_rec_num;