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.OE_PC_CONSTRAINTS_ADMIN_PVT dependencies on OE_PC_GLOBALS

Line 146: ' ' ||val_rec.validation_op || ' ' || l_value_string || OE_PC_GLOBALS.NEWLINE;

142:
143: if (i = 1) and (p_use_where) then
144: -- where clause only for the first one
145: l_vc_sql := l_vc_sql || ' WHERE a.' || val_rec.column_name ||
146: ' ' ||val_rec.validation_op || ' ' || l_value_string || OE_PC_GLOBALS.NEWLINE;
147: else
148: l_vc_sql := l_vc_sql || ' AND a.' || val_rec.column_name ||
149: ' ' ||val_rec.validation_op || ' ' || l_value_string || OE_PC_GLOBALS.NEWLINE;
150: end if;

Line 149: ' ' ||val_rec.validation_op || ' ' || l_value_string || OE_PC_GLOBALS.NEWLINE;

145: l_vc_sql := l_vc_sql || ' WHERE a.' || val_rec.column_name ||
146: ' ' ||val_rec.validation_op || ' ' || l_value_string || OE_PC_GLOBALS.NEWLINE;
147: else
148: l_vc_sql := l_vc_sql || ' AND a.' || val_rec.column_name ||
149: ' ' ||val_rec.validation_op || ' ' || l_value_string || OE_PC_GLOBALS.NEWLINE;
150: end if;
151: i := i + 1;
152:
153: end loop;

Line 182: ''''|| p_wf_item_type||''';' || OE_PC_GLOBALS.NEWLINE;

178: -- validation cursor
179:
180: x_bind_var_stmt := x_bind_var_stmt||
181: ' l_wf_item_type varchar2(8) :='||
182: ''''|| p_wf_item_type||''';' || OE_PC_GLOBALS.NEWLINE;
183: x_bind_var_stmt := x_bind_var_stmt||
184: ' l_wf_activity_name varchar2(30) :='||
185: ''''||p_wf_activity_name||''';' || OE_PC_GLOBALS.NEWLINE;
186:

Line 185: ''''||p_wf_activity_name||''';' || OE_PC_GLOBALS.NEWLINE;

181: ' l_wf_item_type varchar2(8) :='||
182: ''''|| p_wf_item_type||''';' || OE_PC_GLOBALS.NEWLINE;
183: x_bind_var_stmt := x_bind_var_stmt||
184: ' l_wf_activity_name varchar2(30) :='||
185: ''''||p_wf_activity_name||''';' || OE_PC_GLOBALS.NEWLINE;
186:
187: l_vc_sql := l_vc_sql || ' FROM wf_item_activity_statuses w, wf_process_activities wpa'
188: || OE_PC_GLOBALS.NEWLINE;
189:

Line 188: || OE_PC_GLOBALS.NEWLINE;

184: ' l_wf_activity_name varchar2(30) :='||
185: ''''||p_wf_activity_name||''';' || OE_PC_GLOBALS.NEWLINE;
186:
187: l_vc_sql := l_vc_sql || ' FROM wf_item_activity_statuses w, wf_process_activities wpa'
188: || OE_PC_GLOBALS.NEWLINE;
189:
190: IF p_validation_db_object_name IS NOT NULL THEN
191: l_vc_sql := l_vc_sql || ' ,' || p_validation_db_object_name
192: ||' a ' || OE_PC_GLOBALS.NEWLINE;

Line 192: ||' a ' || OE_PC_GLOBALS.NEWLINE;

188: || OE_PC_GLOBALS.NEWLINE;
189:
190: IF p_validation_db_object_name IS NOT NULL THEN
191: l_vc_sql := l_vc_sql || ' ,' || p_validation_db_object_name
192: ||' a ' || OE_PC_GLOBALS.NEWLINE;
193: END IF;
194:
195: IF (p_use_where) THEN
196: l_vc_sql := l_vc_sql || ' WHERE w.item_type = l_wf_item_type'

Line 197: || OE_PC_GLOBALS.NEWLINE;

193: END IF;
194:
195: IF (p_use_where) THEN
196: l_vc_sql := l_vc_sql || ' WHERE w.item_type = l_wf_item_type'
197: || OE_PC_GLOBALS.NEWLINE;
198: ELSE
199: l_vc_sql := l_vc_sql || ' AND w.item_type = l_wf_item_type'
200: || OE_PC_GLOBALS.NEWLINE;
201: END IF;

Line 200: || OE_PC_GLOBALS.NEWLINE;

196: l_vc_sql := l_vc_sql || ' WHERE w.item_type = l_wf_item_type'
197: || OE_PC_GLOBALS.NEWLINE;
198: ELSE
199: l_vc_sql := l_vc_sql || ' AND w.item_type = l_wf_item_type'
200: || OE_PC_GLOBALS.NEWLINE;
201: END IF;
202:
203: l_vc_sql := l_vc_sql || ' AND w.process_activity = wpa.instance_id'
204: || OE_PC_GLOBALS.NEWLINE;

Line 204: || OE_PC_GLOBALS.NEWLINE;

200: || OE_PC_GLOBALS.NEWLINE;
201: END IF;
202:
203: l_vc_sql := l_vc_sql || ' AND w.process_activity = wpa.instance_id'
204: || OE_PC_GLOBALS.NEWLINE;
205:
206: l_vc_sql := l_vc_sql || ' AND wpa.activity_name = l_wf_activity_name'
207: || OE_PC_GLOBALS.NEWLINE;
208:

Line 207: || OE_PC_GLOBALS.NEWLINE;

203: l_vc_sql := l_vc_sql || ' AND w.process_activity = wpa.instance_id'
204: || OE_PC_GLOBALS.NEWLINE;
205:
206: l_vc_sql := l_vc_sql || ' AND wpa.activity_name = l_wf_activity_name'
207: || OE_PC_GLOBALS.NEWLINE;
208:
209: IF p_wf_activity_status_code IS NOT NULL THEN
210: x_bind_var_stmt := x_bind_var_stmt||
211: ' l_wf_activity_status_code varchar2(8) :='||

Line 212: ''''||p_wf_activity_status_code||''';' || OE_PC_GLOBALS.NEWLINE;

208:
209: IF p_wf_activity_status_code IS NOT NULL THEN
210: x_bind_var_stmt := x_bind_var_stmt||
211: ' l_wf_activity_status_code varchar2(8) :='||
212: ''''||p_wf_activity_status_code||''';' || OE_PC_GLOBALS.NEWLINE;
213: l_vc_sql := l_vc_sql || ' AND w.activity_status = l_wf_activity_status_code'
214: || OE_PC_GLOBALS.NEWLINE;
215: END IF;
216:

Line 214: || OE_PC_GLOBALS.NEWLINE;

210: x_bind_var_stmt := x_bind_var_stmt||
211: ' l_wf_activity_status_code varchar2(8) :='||
212: ''''||p_wf_activity_status_code||''';' || OE_PC_GLOBALS.NEWLINE;
213: l_vc_sql := l_vc_sql || ' AND w.activity_status = l_wf_activity_status_code'
214: || OE_PC_GLOBALS.NEWLINE;
215: END IF;
216:
217: IF p_wf_activity_result_code IS NOT NULL THEN
218: x_bind_var_stmt := x_bind_var_stmt||

Line 220: ''''||p_wf_activity_result_code||''';' || OE_PC_GLOBALS.NEWLINE;

216:
217: IF p_wf_activity_result_code IS NOT NULL THEN
218: x_bind_var_stmt := x_bind_var_stmt||
219: ' l_wf_activity_result_code varchar2(30) :='||
220: ''''||p_wf_activity_result_code||''';' || OE_PC_GLOBALS.NEWLINE;
221: l_vc_sql := l_vc_sql || ' AND w.activity_result_code = l_wf_activity_result_code'
222: || OE_PC_GLOBALS.NEWLINE;
223: END IF;
224:

Line 222: || OE_PC_GLOBALS.NEWLINE;

218: x_bind_var_stmt := x_bind_var_stmt||
219: ' l_wf_activity_result_code varchar2(30) :='||
220: ''''||p_wf_activity_result_code||''';' || OE_PC_GLOBALS.NEWLINE;
221: l_vc_sql := l_vc_sql || ' AND w.activity_result_code = l_wf_activity_result_code'
222: || OE_PC_GLOBALS.NEWLINE;
223: END IF;
224:
225: RETURN l_vc_sql;
226:

Line 461: if(l_validation_type = OE_PC_GLOBALS.WF_VALIDATION) then

457: IF l_debug_level > 0 THEN
458: oe_debug_pub.add( 'ENTITY ID = VALIDATION ENTITY ID' , 2 ) ;
459: END IF;
460: --
461: if(l_validation_type = OE_PC_GLOBALS.WF_VALIDATION) then
462: --
463: IF l_debug_level > 0 THEN
464: oe_debug_pub.add( 'VALIDATION TYPE = WF' , 2 ) ;
465: END IF;

Line 468: if(l_pk_record_set_flag = OE_PC_GLOBALS.YES_FLAG) then

464: oe_debug_pub.add( 'VALIDATION TYPE = WF' , 2 ) ;
465: END IF;
466: --
467:
468: if(l_pk_record_set_flag = OE_PC_GLOBALS.YES_FLAG) then
469: --
470: IF l_debug_level > 0 THEN
471: oe_debug_pub.add( 'PK_RECORD_SET_FLAG = Y' , 2 ) ;
472: END IF;

Line 517: l_concatenated_itemkey_columns || OE_PC_GLOBALS.NEWLINE;

513: ,x_bind_var_stmt => x_bind_var_stmt
514: );
515:
516: l_vc_sql := l_vc_sql || ' AND w.item_key = ' ||
517: l_concatenated_itemkey_columns || OE_PC_GLOBALS.NEWLINE;
518:
519:
520: else
521:

Line 526: -- l_pk_record_set_flag <> OE_PC_GLOBALS.YES_FLAG)

522: --
523: IF l_debug_level > 0 THEN
524: oe_debug_pub.add( 'PK_RECORD_SET_FLAG <> Y' , 2 ) ;
525: END IF;
526: -- l_pk_record_set_flag <> OE_PC_GLOBALS.YES_FLAG)
527: -- mult record set
528: ---------------------------------------------------------------------
529: -- 2. e.g. for validation_type = 'WF' and
530: -- entity = LINE; validation_entity = LINE (SAME)

Line 578: l_rs_sql := ' FROM ' || l_validation_db_object_name ||' b ' || OE_PC_GLOBALS.NEWLINE;

574: ,x_conc_string => l_concatenated_itemkey_columns);
575:
576:
577: -- first let's make the record set sql
578: l_rs_sql := ' FROM ' || l_validation_db_object_name ||' b ' || OE_PC_GLOBALS.NEWLINE;
579:
580:
581: -- add logic to select the record set
582: i := 1;

Line 586: l_rs_sql := l_rs_sql || ' WHERE b.' || rs_rec.column_name || ' = '||p_global_record_name||'.' || rs_rec.column_name || OE_PC_GLOBALS.NEWLINE;

582: i := 1;
583: for rs_rec in C_RSCOLS loop
584: if (i = 1) then
585: -- where clause only for the first one
586: l_rs_sql := l_rs_sql || ' WHERE b.' || rs_rec.column_name || ' = '||p_global_record_name||'.' || rs_rec.column_name || OE_PC_GLOBALS.NEWLINE;
587: else
588: l_rs_sql := l_rs_sql || ' AND b.' || rs_rec.column_name || ' = '||p_global_record_name||'.' || rs_rec.column_name || OE_PC_GLOBALS.NEWLINE;
589: end if;
590: i := i+ 1;

Line 588: l_rs_sql := l_rs_sql || ' AND b.' || rs_rec.column_name || ' = '||p_global_record_name||'.' || rs_rec.column_name || OE_PC_GLOBALS.NEWLINE;

584: if (i = 1) then
585: -- where clause only for the first one
586: l_rs_sql := l_rs_sql || ' WHERE b.' || rs_rec.column_name || ' = '||p_global_record_name||'.' || rs_rec.column_name || OE_PC_GLOBALS.NEWLINE;
587: else
588: l_rs_sql := l_rs_sql || ' AND b.' || rs_rec.column_name || ' = '||p_global_record_name||'.' || rs_rec.column_name || OE_PC_GLOBALS.NEWLINE;
589: end if;
590: i := i+ 1;
591: end loop;
592:

Line 605: l_vc_sql := l_vc_sql || ' AND w.item_key IN ' || OE_PC_GLOBALS.NEWLINE;

601: ,p_wf_activity_result_code => l_wf_activity_result_code
602: ,x_bind_var_stmt => x_bind_var_stmt
603: );
604:
605: l_vc_sql := l_vc_sql || ' AND w.item_key IN ' || OE_PC_GLOBALS.NEWLINE;
606: l_vc_sql := l_vc_sql || ' ( SELECT ' || l_concatenated_itemkey_columns || OE_PC_GLOBALS.NEWLINE;
607: l_vc_sql := l_vc_sql || ' ' || l_rs_sql || OE_PC_GLOBALS.NEWLINE;
608: l_vc_sql := l_vc_sql || ' )';
609:

Line 606: l_vc_sql := l_vc_sql || ' ( SELECT ' || l_concatenated_itemkey_columns || OE_PC_GLOBALS.NEWLINE;

602: ,x_bind_var_stmt => x_bind_var_stmt
603: );
604:
605: l_vc_sql := l_vc_sql || ' AND w.item_key IN ' || OE_PC_GLOBALS.NEWLINE;
606: l_vc_sql := l_vc_sql || ' ( SELECT ' || l_concatenated_itemkey_columns || OE_PC_GLOBALS.NEWLINE;
607: l_vc_sql := l_vc_sql || ' ' || l_rs_sql || OE_PC_GLOBALS.NEWLINE;
608: l_vc_sql := l_vc_sql || ' )';
609:
610: end if;

Line 607: l_vc_sql := l_vc_sql || ' ' || l_rs_sql || OE_PC_GLOBALS.NEWLINE;

603: );
604:
605: l_vc_sql := l_vc_sql || ' AND w.item_key IN ' || OE_PC_GLOBALS.NEWLINE;
606: l_vc_sql := l_vc_sql || ' ( SELECT ' || l_concatenated_itemkey_columns || OE_PC_GLOBALS.NEWLINE;
607: l_vc_sql := l_vc_sql || ' ' || l_rs_sql || OE_PC_GLOBALS.NEWLINE;
608: l_vc_sql := l_vc_sql || ' )';
609:
610: end if;
611:

Line 614: -- l_validation_type <> OE_PC_GLOBALS.WF_VALIDATION

610: end if;
611:
612: else
613:
614: -- l_validation_type <> OE_PC_GLOBALS.WF_VALIDATION
615: -- validation type is database column validation
616: if(l_pk_record_set_flag = OE_PC_GLOBALS.YES_FLAG) then
617: ---------------------------------------------------------------------
618: -- 3. e.g. for p_validation_type = 'COLS' and

Line 616: if(l_pk_record_set_flag = OE_PC_GLOBALS.YES_FLAG) then

612: else
613:
614: -- l_validation_type <> OE_PC_GLOBALS.WF_VALIDATION
615: -- validation type is database column validation
616: if(l_pk_record_set_flag = OE_PC_GLOBALS.YES_FLAG) then
617: ---------------------------------------------------------------------
618: -- 3. e.g. for p_validation_type = 'COLS' and
619: -- entity = LINE; validation_entity = LINE (SAME)
620: -- validation_tmplt = 'Prorated Price Exists'

Line 653: ' a ' || OE_PC_GLOBALS.NEWLINE;

649: -- If state attribute THEN FROM cursor selects from the database object
650: IF val_rec.state_attribute = 0 THEN
651:
652: l_vc_sql := ' FROM '|| l_validation_db_object_name ||
653: ' a ' || OE_PC_GLOBALS.NEWLINE;
654: -- IF state attribute THEN add logic to get to the DB record
655: -- E.g. WHERE a.line_id = '||p_global_record_name||'.line_id
656: j := 1;
657: FOR pk_rec in C_PKCOLS (l_validation_appln_id, l_validation_db_object_name, l_validation_db_object_type) loop

Line 659: l_vc_sql := l_vc_sql || ' WHERE a.' || pk_rec.pk_column_name || ' = '||p_global_record_name||'.'||pk_rec.pk_column_name || OE_PC_GLOBALS.NEWLINE;

655: -- E.g. WHERE a.line_id = '||p_global_record_name||'.line_id
656: j := 1;
657: FOR pk_rec in C_PKCOLS (l_validation_appln_id, l_validation_db_object_name, l_validation_db_object_type) loop
658: IF j= 1 THEN
659: l_vc_sql := l_vc_sql || ' WHERE a.' || pk_rec.pk_column_name || ' = '||p_global_record_name||'.'||pk_rec.pk_column_name || OE_PC_GLOBALS.NEWLINE;
660: ELSE
661: l_vc_sql := l_vc_sql || ' AND a.' || pk_rec.pk_column_name || ' = '||p_global_record_name||'.' ||pk_rec.pk_column_name|| OE_PC_GLOBALS.NEWLINE;
662: END IF;
663: j:= j + 1;

Line 661: l_vc_sql := l_vc_sql || ' AND a.' || pk_rec.pk_column_name || ' = '||p_global_record_name||'.' ||pk_rec.pk_column_name|| OE_PC_GLOBALS.NEWLINE;

657: FOR pk_rec in C_PKCOLS (l_validation_appln_id, l_validation_db_object_name, l_validation_db_object_type) loop
658: IF j= 1 THEN
659: l_vc_sql := l_vc_sql || ' WHERE a.' || pk_rec.pk_column_name || ' = '||p_global_record_name||'.'||pk_rec.pk_column_name || OE_PC_GLOBALS.NEWLINE;
660: ELSE
661: l_vc_sql := l_vc_sql || ' AND a.' || pk_rec.pk_column_name || ' = '||p_global_record_name||'.' ||pk_rec.pk_column_name|| OE_PC_GLOBALS.NEWLINE;
662: END IF;
663: j:= j + 1;
664: END LOOP;
665:

Line 667: ' ' || val_rec.validation_op || ' ' || l_value_string || OE_PC_GLOBALS.NEWLINE;

663: j:= j + 1;
664: END LOOP;
665:
666: l_vc_sql := l_vc_sql || ' AND a.' || val_rec.column_name ||
667: ' ' || val_rec.validation_op || ' ' || l_value_string || OE_PC_GLOBALS.NEWLINE;
668:
669: -- If first attribute NOT state attribute THEN there are no state attributes
670: -- on this validation template, hence select FROM SYS.DUAL
671: ELSE

Line 674: ' ' || val_rec.validation_op || ' ' || l_value_string || OE_PC_GLOBALS.NEWLINE;

670: -- on this validation template, hence select FROM SYS.DUAL
671: ELSE
672: l_condn_logic_only := TRUE;
673: l_vc_sql := ' IF '||p_global_record_name||'.' || val_rec.column_name ||
674: ' ' || val_rec.validation_op || ' ' || l_value_string || OE_PC_GLOBALS.NEWLINE;
675: /*
676: l_vc_sql := ' FROM SYS.DUAL' || OE_PC_GLOBALS.NEWLINE;
677: l_vc_sql := l_vc_sql || ' WHERE '||p_global_record_name||'.' || val_rec.column_name ||
678: ' ' || val_rec.validation_op || ' ' || l_value_string || OE_PC_GLOBALS.NEWLINE;

Line 676: l_vc_sql := ' FROM SYS.DUAL' || OE_PC_GLOBALS.NEWLINE;

672: l_condn_logic_only := TRUE;
673: l_vc_sql := ' IF '||p_global_record_name||'.' || val_rec.column_name ||
674: ' ' || val_rec.validation_op || ' ' || l_value_string || OE_PC_GLOBALS.NEWLINE;
675: /*
676: l_vc_sql := ' FROM SYS.DUAL' || OE_PC_GLOBALS.NEWLINE;
677: l_vc_sql := l_vc_sql || ' WHERE '||p_global_record_name||'.' || val_rec.column_name ||
678: ' ' || val_rec.validation_op || ' ' || l_value_string || OE_PC_GLOBALS.NEWLINE;
679: */
680: END IF;

Line 678: ' ' || val_rec.validation_op || ' ' || l_value_string || OE_PC_GLOBALS.NEWLINE;

674: ' ' || val_rec.validation_op || ' ' || l_value_string || OE_PC_GLOBALS.NEWLINE;
675: /*
676: l_vc_sql := ' FROM SYS.DUAL' || OE_PC_GLOBALS.NEWLINE;
677: l_vc_sql := l_vc_sql || ' WHERE '||p_global_record_name||'.' || val_rec.column_name ||
678: ' ' || val_rec.validation_op || ' ' || l_value_string || OE_PC_GLOBALS.NEWLINE;
679: */
680: END IF;
681:
682: -- AND clause if not the first attribute

Line 686: l_vc_sql := l_vc_sql || ' AND a.' || val_rec.column_name || ' ' || val_rec.validation_op || ' ' || l_value_string || OE_PC_GLOBALS.NEWLINE;

682: -- AND clause if not the first attribute
683: ELSE
684:
685: IF val_rec.state_attribute = 0 THEN
686: l_vc_sql := l_vc_sql || ' AND a.' || val_rec.column_name || ' ' || val_rec.validation_op || ' ' || l_value_string || OE_PC_GLOBALS.NEWLINE;
687: ELSE
688: l_vc_sql := l_vc_sql || ' AND '||p_global_record_name||'.' || val_rec.column_name || ' ' || val_rec.validation_op || ' ' || l_value_string || OE_PC_GLOBALS.NEWLINE;
689: END IF;
690:

Line 688: l_vc_sql := l_vc_sql || ' AND '||p_global_record_name||'.' || val_rec.column_name || ' ' || val_rec.validation_op || ' ' || l_value_string || OE_PC_GLOBALS.NEWLINE;

684:
685: IF val_rec.state_attribute = 0 THEN
686: l_vc_sql := l_vc_sql || ' AND a.' || val_rec.column_name || ' ' || val_rec.validation_op || ' ' || l_value_string || OE_PC_GLOBALS.NEWLINE;
687: ELSE
688: l_vc_sql := l_vc_sql || ' AND '||p_global_record_name||'.' || val_rec.column_name || ' ' || val_rec.validation_op || ' ' || l_value_string || OE_PC_GLOBALS.NEWLINE;
689: END IF;
690:
691: END IF; -- end of check to see if i= 1
692: i := i + 1;

Line 697: -- l_pk_record_set_flag <> OE_PC_GLOBALS.YES_FLAG)

693:
694: END LOOP;
695:
696: else
697: -- l_pk_record_set_flag <> OE_PC_GLOBALS.YES_FLAG)
698: -- mult record set
699: ---------------------------------------------------------------------
700: -- 4. e.g. for p_validation_type = 'COLS' and
701: -- entity = LINE; validation_entity = LINE (SAME)

Line 738: l_rs_sql := ' FROM ' || l_validation_db_object_name ||' b ' || OE_PC_GLOBALS.NEWLINE;

734: --------------------------------------------------------------------
735: -- first let's make the record set sql
736:
737: -- first let's make the record set sql
738: l_rs_sql := ' FROM ' || l_validation_db_object_name ||' b ' || OE_PC_GLOBALS.NEWLINE;
739:
740: -- add logic to get to the intented record
741: i := 1;
742: for pk_rec in C_PKCOLS (l_validation_appln_id, l_validation_db_object_name, l_validation_db_object_type) loop

Line 757: l_rs_sql := l_rs_sql || ' WHERE b.' || rs_rec.column_name || ' = '||p_global_record_name||'.' || rs_rec.column_name || OE_PC_GLOBALS.NEWLINE;

753: -- add logic to select the record set
754: i := 1;
755: for rs_rec in C_RSCOLS loop
756: if (i = 1) then
757: l_rs_sql := l_rs_sql || ' WHERE b.' || rs_rec.column_name || ' = '||p_global_record_name||'.' || rs_rec.column_name || OE_PC_GLOBALS.NEWLINE;
758: else
759: l_rs_sql := l_rs_sql || ' AND b.' || rs_rec.column_name || ' = '||p_global_record_name||'.' || rs_rec.column_name || OE_PC_GLOBALS.NEWLINE;
760: end if;
761: i := i + 1;

Line 759: l_rs_sql := l_rs_sql || ' AND b.' || rs_rec.column_name || ' = '||p_global_record_name||'.' || rs_rec.column_name || OE_PC_GLOBALS.NEWLINE;

755: for rs_rec in C_RSCOLS loop
756: if (i = 1) then
757: l_rs_sql := l_rs_sql || ' WHERE b.' || rs_rec.column_name || ' = '||p_global_record_name||'.' || rs_rec.column_name || OE_PC_GLOBALS.NEWLINE;
758: else
759: l_rs_sql := l_rs_sql || ' AND b.' || rs_rec.column_name || ' = '||p_global_record_name||'.' || rs_rec.column_name || OE_PC_GLOBALS.NEWLINE;
760: end if;
761: i := i + 1;
762: end loop;
763:

Line 766: l_vc_sql := ' FROM '|| l_validation_db_object_name ||' a ' || OE_PC_GLOBALS.NEWLINE;

762: end loop;
763:
764:
765: -- make the validation sql
766: l_vc_sql := ' FROM '|| l_validation_db_object_name ||' a ' || OE_PC_GLOBALS.NEWLINE;
767:
768: l_vc_sql := Concatenate_VTMPLTCOL_Sql(l_vc_sql, p_validation_tmplt_id);
769:
770: -- add logic to get to the intented record

Line 771: l_vc_sql := l_vc_sql || ' AND ( ' || l_vc_pk_list || ' ) IN ' || OE_PC_GLOBALS.NEWLINE;

767:
768: l_vc_sql := Concatenate_VTMPLTCOL_Sql(l_vc_sql, p_validation_tmplt_id);
769:
770: -- add logic to get to the intented record
771: l_vc_sql := l_vc_sql || ' AND ( ' || l_vc_pk_list || ' ) IN ' || OE_PC_GLOBALS.NEWLINE;
772: l_vc_sql := l_vc_sql || ' ( SELECT ' || l_rs_pk_list || OE_PC_GLOBALS.NEWLINE;
773: l_vc_sql := l_vc_sql || l_rs_sql || OE_PC_GLOBALS.NEWLINE;
774: l_vc_sql := l_vc_sql || ' )';
775:

Line 772: l_vc_sql := l_vc_sql || ' ( SELECT ' || l_rs_pk_list || OE_PC_GLOBALS.NEWLINE;

768: l_vc_sql := Concatenate_VTMPLTCOL_Sql(l_vc_sql, p_validation_tmplt_id);
769:
770: -- add logic to get to the intented record
771: l_vc_sql := l_vc_sql || ' AND ( ' || l_vc_pk_list || ' ) IN ' || OE_PC_GLOBALS.NEWLINE;
772: l_vc_sql := l_vc_sql || ' ( SELECT ' || l_rs_pk_list || OE_PC_GLOBALS.NEWLINE;
773: l_vc_sql := l_vc_sql || l_rs_sql || OE_PC_GLOBALS.NEWLINE;
774: l_vc_sql := l_vc_sql || ' )';
775:
776: end if;

Line 773: l_vc_sql := l_vc_sql || l_rs_sql || OE_PC_GLOBALS.NEWLINE;

769:
770: -- add logic to get to the intented record
771: l_vc_sql := l_vc_sql || ' AND ( ' || l_vc_pk_list || ' ) IN ' || OE_PC_GLOBALS.NEWLINE;
772: l_vc_sql := l_vc_sql || ' ( SELECT ' || l_rs_pk_list || OE_PC_GLOBALS.NEWLINE;
773: l_vc_sql := l_vc_sql || l_rs_sql || OE_PC_GLOBALS.NEWLINE;
774: l_vc_sql := l_vc_sql || ' )';
775:
776: end if;
777: end if;

Line 806: if(l_validation_type = OE_PC_GLOBALS.WF_VALIDATION) then

802: oe_debug_pub.add( 'L_DRIVER_ENTITY_FK_FLAG IS ' || L_DRIVER_ENTITY_FK_FLAG , 2 ) ;
803: END IF;
804:
805:
806: if(l_validation_type = OE_PC_GLOBALS.WF_VALIDATION) then
807:
808: if(l_driver_entity_fk_flag = 'Y') then
809:
810: IF l_debug_level > 0 THEN

Line 868: l_vc_sql := l_vc_sql || ' AND w.item_key = ' || l_concatenated_itemkey_columns || OE_PC_GLOBALS.NEWLINE;

864: ,p_validation_db_object_name => l_validation_db_object_name
865: ,x_bind_var_stmt => x_bind_var_stmt
866: );
867:
868: l_vc_sql := l_vc_sql || ' AND w.item_key = ' || l_concatenated_itemkey_columns || OE_PC_GLOBALS.NEWLINE;
869:
870:
871: -- navigate to the validation table
872: -- note that here the fk is defined on the driver entity

Line 880: l_vc_sql := l_vc_sql || ' AND a.' || fk_rec.uk_column_name || ' = '||p_global_record_name||'.' || fk_rec.fk_column_name || OE_PC_GLOBALS.NEWLINE;

876:
877: for fk_rec in C_FKCOLS (l_driver_appln_id, l_driver_db_object_name,
878: l_validation_appln_id, l_validation_db_object_name, l_driver_db_object_type) loop
879:
880: l_vc_sql := l_vc_sql || ' AND a.' || fk_rec.uk_column_name || ' = '||p_global_record_name||'.' || fk_rec.fk_column_name || OE_PC_GLOBALS.NEWLINE;
881: end loop;
882:
883: else
884:

Line 889: -- l_driver_entity_fk_flag <> OE_PC_GLOBALS.YES_FLAG

885: IF l_debug_level > 0 THEN
886: oe_debug_pub.add( 'L_DRIVER_ENTITY_FK_FLAG =N AND L_VALIDATION_TYPE =WF' , 2 ) ;
887: END IF;
888:
889: -- l_driver_entity_fk_flag <> OE_PC_GLOBALS.YES_FLAG
890: ---------------------------------------------------------------------
891: -- 7. e.g. entity = HEADER; validation_entity = LINE (DIFFERENT)
892: -- validation_type = 'WF' and
893: -- validation_tmplt = 'Invoice Complete'

Line 954: l_vc_sql := l_vc_sql || ' AND w.item_key IN ' || OE_PC_GLOBALS.NEWLINE;

950: ,p_wf_activity_result_code => l_wf_activity_result_code
951: ,x_bind_var_stmt => x_bind_var_stmt
952: );
953:
954: l_vc_sql := l_vc_sql || ' AND w.item_key IN ' || OE_PC_GLOBALS.NEWLINE;
955: l_vc_sql := l_vc_sql || ' ( SELECT '|| l_concatenated_itemkey_columns || OE_PC_GLOBALS.NEWLINE;
956:
957: -- (ii) make the record set sql
958: l_rs_sql := ' FROM ' || l_validation_db_object_name ||' a ' || OE_PC_GLOBALS.NEWLINE;

Line 955: l_vc_sql := l_vc_sql || ' ( SELECT '|| l_concatenated_itemkey_columns || OE_PC_GLOBALS.NEWLINE;

951: ,x_bind_var_stmt => x_bind_var_stmt
952: );
953:
954: l_vc_sql := l_vc_sql || ' AND w.item_key IN ' || OE_PC_GLOBALS.NEWLINE;
955: l_vc_sql := l_vc_sql || ' ( SELECT '|| l_concatenated_itemkey_columns || OE_PC_GLOBALS.NEWLINE;
956:
957: -- (ii) make the record set sql
958: l_rs_sql := ' FROM ' || l_validation_db_object_name ||' a ' || OE_PC_GLOBALS.NEWLINE;
959: use_where := TRUE;

Line 958: l_rs_sql := ' FROM ' || l_validation_db_object_name ||' a ' || OE_PC_GLOBALS.NEWLINE;

954: l_vc_sql := l_vc_sql || ' AND w.item_key IN ' || OE_PC_GLOBALS.NEWLINE;
955: l_vc_sql := l_vc_sql || ' ( SELECT '|| l_concatenated_itemkey_columns || OE_PC_GLOBALS.NEWLINE;
956:
957: -- (ii) make the record set sql
958: l_rs_sql := ' FROM ' || l_validation_db_object_name ||' a ' || OE_PC_GLOBALS.NEWLINE;
959: use_where := TRUE;
960: if l_pk_record_set_flag = 'N' then
961: l_rs_sql := l_rs_sql ||' ,' || l_validation_db_object_name ||' b ' || OE_PC_GLOBALS.NEWLINE;
962: i := 1;

Line 961: l_rs_sql := l_rs_sql ||' ,' || l_validation_db_object_name ||' b ' || OE_PC_GLOBALS.NEWLINE;

957: -- (ii) make the record set sql
958: l_rs_sql := ' FROM ' || l_validation_db_object_name ||' a ' || OE_PC_GLOBALS.NEWLINE;
959: use_where := TRUE;
960: if l_pk_record_set_flag = 'N' then
961: l_rs_sql := l_rs_sql ||' ,' || l_validation_db_object_name ||' b ' || OE_PC_GLOBALS.NEWLINE;
962: i := 1;
963: for rs_rec in C_RSCOLS loop
964: if (i=1) then
965: l_rs_sql := l_rs_sql || ' WHERE b.'

Line 966: || rs_rec.column_name || ' = a.' || rs_rec.column_name || OE_PC_GLOBALS.NEWLINE;

962: i := 1;
963: for rs_rec in C_RSCOLS loop
964: if (i=1) then
965: l_rs_sql := l_rs_sql || ' WHERE b.'
966: || rs_rec.column_name || ' = a.' || rs_rec.column_name || OE_PC_GLOBALS.NEWLINE;
967: use_where := FALSE;
968: else
969: l_rs_sql := l_rs_sql || ' AND b.'
970: || rs_rec.column_name || ' = a.' || rs_rec.column_name || OE_PC_GLOBALS.NEWLINE;

Line 970: || rs_rec.column_name || ' = a.' || rs_rec.column_name || OE_PC_GLOBALS.NEWLINE;

966: || rs_rec.column_name || ' = a.' || rs_rec.column_name || OE_PC_GLOBALS.NEWLINE;
967: use_where := FALSE;
968: else
969: l_rs_sql := l_rs_sql || ' AND b.'
970: || rs_rec.column_name || ' = a.' || rs_rec.column_name || OE_PC_GLOBALS.NEWLINE;
971: end if;
972: i := i+1;
973: end loop;
974: end if;

Line 982: ' = '||p_global_record_name||'.' || fk_rec.uk_column_name || OE_PC_GLOBALS.NEWLINE;

978: l_driver_appln_id, l_driver_db_object_name, l_driver_db_object_type )
979: loop
980: if (use_where) then
981: l_rs_sql := l_rs_sql || ' WHERE a.' || fk_rec.fk_column_name ||
982: ' = '||p_global_record_name||'.' || fk_rec.uk_column_name || OE_PC_GLOBALS.NEWLINE;
983: use_where := FALSE;
984: else
985: l_rs_sql := l_rs_sql || ' AND a.' || fk_rec.fk_column_name ||
986: ' = '||p_global_record_name||'.' || fk_rec.uk_column_name || OE_PC_GLOBALS.NEWLINE;

Line 986: ' = '||p_global_record_name||'.' || fk_rec.uk_column_name || OE_PC_GLOBALS.NEWLINE;

982: ' = '||p_global_record_name||'.' || fk_rec.uk_column_name || OE_PC_GLOBALS.NEWLINE;
983: use_where := FALSE;
984: else
985: l_rs_sql := l_rs_sql || ' AND a.' || fk_rec.fk_column_name ||
986: ' = '||p_global_record_name||'.' || fk_rec.uk_column_name || OE_PC_GLOBALS.NEWLINE;
987: end if;
988: end loop;
989:
990: l_vc_sql := l_vc_sql || ' ' || l_rs_sql || OE_PC_GLOBALS.NEWLINE;

Line 990: l_vc_sql := l_vc_sql || ' ' || l_rs_sql || OE_PC_GLOBALS.NEWLINE;

986: ' = '||p_global_record_name||'.' || fk_rec.uk_column_name || OE_PC_GLOBALS.NEWLINE;
987: end if;
988: end loop;
989:
990: l_vc_sql := l_vc_sql || ' ' || l_rs_sql || OE_PC_GLOBALS.NEWLINE;
991: l_vc_sql := l_vc_sql || ' )'|| OE_PC_GLOBALS.NEWLINE;
992:
993: end if;
994:

Line 991: l_vc_sql := l_vc_sql || ' )'|| OE_PC_GLOBALS.NEWLINE;

987: end if;
988: end loop;
989:
990: l_vc_sql := l_vc_sql || ' ' || l_rs_sql || OE_PC_GLOBALS.NEWLINE;
991: l_vc_sql := l_vc_sql || ' )'|| OE_PC_GLOBALS.NEWLINE;
992:
993: end if;
994:
995: else

Line 997: -- l_validation_type <> OE_PC_GLOBALS.WF_VALIDATION

993: end if;
994:
995: else
996:
997: -- l_validation_type <> OE_PC_GLOBALS.WF_VALIDATION
998: -- validation type is database column validation
999:
1000: if(l_driver_entity_fk_flag = 'Y') then
1001: --

Line 1038: l_vc_sql := ' FROM '|| l_validation_db_object_name ||' a ' || OE_PC_GLOBALS.NEWLINE;

1034: oe_debug_pub.add( 'VALIDATION OBJ: '||L_VALIDATION_DB_OBJECT_NAME , 2 ) ;
1035: END IF;
1036:
1037: -- make the validation sql
1038: l_vc_sql := ' FROM '|| l_validation_db_object_name ||' a ' || OE_PC_GLOBALS.NEWLINE;
1039:
1040:
1041: -- add navigate to the validation tbl
1042: i:= 1;

Line 1048: l_vc_sql := l_vc_sql || ' WHERE a.' || fk_rec.uk_column_name || ' = '||p_global_record_name||'.' || fk_rec.fk_column_name || OE_PC_GLOBALS.NEWLINE;

1044: for fk_rec in C_FKCOLS (l_driver_appln_id, l_driver_db_object_name,
1045: l_validation_appln_id, l_validation_db_object_name, l_driver_db_object_type)loop
1046: if (use_where) then
1047: -- where clause only for the first one
1048: l_vc_sql := l_vc_sql || ' WHERE a.' || fk_rec.uk_column_name || ' = '||p_global_record_name||'.' || fk_rec.fk_column_name || OE_PC_GLOBALS.NEWLINE;
1049: else
1050: l_vc_sql := l_vc_sql || ' AND a.' || fk_rec.uk_column_name || ' = '||p_global_record_name||'.' || fk_rec.fk_column_name || OE_PC_GLOBALS.NEWLINE;
1051: end if;
1052: i := i + 1;

Line 1050: l_vc_sql := l_vc_sql || ' AND a.' || fk_rec.uk_column_name || ' = '||p_global_record_name||'.' || fk_rec.fk_column_name || OE_PC_GLOBALS.NEWLINE;

1046: if (use_where) then
1047: -- where clause only for the first one
1048: l_vc_sql := l_vc_sql || ' WHERE a.' || fk_rec.uk_column_name || ' = '||p_global_record_name||'.' || fk_rec.fk_column_name || OE_PC_GLOBALS.NEWLINE;
1049: else
1050: l_vc_sql := l_vc_sql || ' AND a.' || fk_rec.uk_column_name || ' = '||p_global_record_name||'.' || fk_rec.fk_column_name || OE_PC_GLOBALS.NEWLINE;
1051: end if;
1052: i := i + 1;
1053: use_where := FALSE;
1054:

Line 1114: l_rs_sql := ' FROM ' || l_validation_db_object_name ||' a ' || OE_PC_GLOBALS.NEWLINE;

1110: oe_debug_pub.add( 'VALIDATION OBJ NAME: '||L_VALIDATION_DB_OBJECT_NAME , 2 ) ;
1111: END IF;
1112:
1113: -- first let's make the record set sql
1114: l_rs_sql := ' FROM ' || l_validation_db_object_name ||' a ' || OE_PC_GLOBALS.NEWLINE;
1115:
1116: if l_pk_record_set_flag = 'N' then
1117: l_rs_sql := l_rs_sql ||' ,' || l_validation_db_object_name ||' b ' || OE_PC_GLOBALS.NEWLINE;
1118: end if;

Line 1117: l_rs_sql := l_rs_sql ||' ,' || l_validation_db_object_name ||' b ' || OE_PC_GLOBALS.NEWLINE;

1113: -- first let's make the record set sql
1114: l_rs_sql := ' FROM ' || l_validation_db_object_name ||' a ' || OE_PC_GLOBALS.NEWLINE;
1115:
1116: if l_pk_record_set_flag = 'N' then
1117: l_rs_sql := l_rs_sql ||' ,' || l_validation_db_object_name ||' b ' || OE_PC_GLOBALS.NEWLINE;
1118: end if;
1119:
1120: use_where := TRUE;
1121: -- add navigate to the validation tbl

Line 1127: ' = '||p_global_record_name||'.' || fk_rec.uk_column_name || OE_PC_GLOBALS.NEWLINE;

1123: for fk_rec in C_FKCOLS (l_validation_appln_id, l_validation_db_object_name,
1124: l_driver_appln_id, l_driver_db_object_name, l_driver_db_object_type )loop
1125: if (i = 1) then
1126: l_ve_condn_sql := ' WHERE a.' || fk_rec.fk_column_name ||
1127: ' = '||p_global_record_name||'.' || fk_rec.uk_column_name || OE_PC_GLOBALS.NEWLINE;
1128: use_where := FALSE;
1129: else
1130: l_ve_condn_sql := l_ve_condn_sql || ' AND a.' || fk_rec.fk_column_name ||
1131: ' = '||p_global_record_name||'.' || fk_rec.uk_column_name || OE_PC_GLOBALS.NEWLINE;

Line 1131: ' = '||p_global_record_name||'.' || fk_rec.uk_column_name || OE_PC_GLOBALS.NEWLINE;

1127: ' = '||p_global_record_name||'.' || fk_rec.uk_column_name || OE_PC_GLOBALS.NEWLINE;
1128: use_where := FALSE;
1129: else
1130: l_ve_condn_sql := l_ve_condn_sql || ' AND a.' || fk_rec.fk_column_name ||
1131: ' = '||p_global_record_name||'.' || fk_rec.uk_column_name || OE_PC_GLOBALS.NEWLINE;
1132: end if;
1133: i := i + 1;
1134: end loop;
1135: l_rs_sql := l_rs_sql || l_ve_condn_sql;

Line 1138: l_vc_sql := ' FROM ' || l_validation_db_object_name ||' a ' || OE_PC_GLOBALS.NEWLINE;

1134: end loop;
1135: l_rs_sql := l_rs_sql || l_ve_condn_sql;
1136:
1137: -- make the validation sql
1138: l_vc_sql := ' FROM ' || l_validation_db_object_name ||' a ' || OE_PC_GLOBALS.NEWLINE;
1139: l_vc_sql := l_vc_sql || l_ve_condn_sql;
1140: l_vc_sql := Concatenate_VTMPLTCOL_Sql(l_vc_sql
1141: , p_validation_tmplt_id
1142: , use_where);

Line 1165: l_rs_pk_list|| OE_PC_GLOBALS.NEWLINE;

1161: oe_debug_pub.add( 'NOT PK RECORD SET' ) ;
1162: END IF;
1163: -- add logic to select the record set
1164: l_vc_sql := l_vc_sql || ' AND ('||l_vc_pk_list||') IN ( SELECT '||
1165: l_rs_pk_list|| OE_PC_GLOBALS.NEWLINE;
1166: l_vc_sql := l_vc_sql || ' FROM '||
1167: l_validation_db_object_name||' b'||OE_PC_GLOBALS.NEWLINE;
1168: i := 1;
1169: for rs_rec in C_RSCOLS loop

Line 1167: l_validation_db_object_name||' b'||OE_PC_GLOBALS.NEWLINE;

1163: -- add logic to select the record set
1164: l_vc_sql := l_vc_sql || ' AND ('||l_vc_pk_list||') IN ( SELECT '||
1165: l_rs_pk_list|| OE_PC_GLOBALS.NEWLINE;
1166: l_vc_sql := l_vc_sql || ' FROM '||
1167: l_validation_db_object_name||' b'||OE_PC_GLOBALS.NEWLINE;
1168: i := 1;
1169: for rs_rec in C_RSCOLS loop
1170: if (i=1) then
1171: l_vc_sql := l_vc_sql || ' WHERE b.'

Line 1172: || rs_rec.column_name || ' = a.' || rs_rec.column_name || OE_PC_GLOBALS.NEWLINE;

1168: i := 1;
1169: for rs_rec in C_RSCOLS loop
1170: if (i=1) then
1171: l_vc_sql := l_vc_sql || ' WHERE b.'
1172: || rs_rec.column_name || ' = a.' || rs_rec.column_name || OE_PC_GLOBALS.NEWLINE;
1173: else
1174: l_vc_sql := l_vc_sql || ' AND b.'
1175: || rs_rec.column_name || ' = a.' || rs_rec.column_name || OE_PC_GLOBALS.NEWLINE;
1176: end if;

Line 1175: || rs_rec.column_name || ' = a.' || rs_rec.column_name || OE_PC_GLOBALS.NEWLINE;

1171: l_vc_sql := l_vc_sql || ' WHERE b.'
1172: || rs_rec.column_name || ' = a.' || rs_rec.column_name || OE_PC_GLOBALS.NEWLINE;
1173: else
1174: l_vc_sql := l_vc_sql || ' AND b.'
1175: || rs_rec.column_name || ' = a.' || rs_rec.column_name || OE_PC_GLOBALS.NEWLINE;
1176: end if;
1177: l_rs_sql := l_rs_sql || ' AND b.'
1178: || rs_rec.column_name || ' = a.' || rs_rec.column_name || OE_PC_GLOBALS.NEWLINE;
1179: i := i+1;

Line 1178: || rs_rec.column_name || ' = a.' || rs_rec.column_name || OE_PC_GLOBALS.NEWLINE;

1174: l_vc_sql := l_vc_sql || ' AND b.'
1175: || rs_rec.column_name || ' = a.' || rs_rec.column_name || OE_PC_GLOBALS.NEWLINE;
1176: end if;
1177: l_rs_sql := l_rs_sql || ' AND b.'
1178: || rs_rec.column_name || ' = a.' || rs_rec.column_name || OE_PC_GLOBALS.NEWLINE;
1179: i := i+1;
1180: end loop;
1181: l_vc_sql := l_vc_sql || ' )'
1182: || OE_PC_GLOBALS.NEWLINE;

Line 1182: || OE_PC_GLOBALS.NEWLINE;

1178: || rs_rec.column_name || ' = a.' || rs_rec.column_name || OE_PC_GLOBALS.NEWLINE;
1179: i := i+1;
1180: end loop;
1181: l_vc_sql := l_vc_sql || ' )'
1182: || OE_PC_GLOBALS.NEWLINE;
1183: end if;
1184:
1185: end if;
1186: end if;

Line 1192: x_valid_count_cursor := ' CURSOR C_VC IS ' || OE_PC_GLOBALS.NEWLINE ||

1188:
1189: IF (l_condn_logic_only) THEN
1190: x_validation_stmt := l_vc_sql;
1191: ELSE
1192: x_valid_count_cursor := ' CURSOR C_VC IS ' || OE_PC_GLOBALS.NEWLINE ||
1193: ' SELECT count(*) ' || OE_PC_GLOBALS.NEWLINE || l_vc_sql || ';';
1194: END IF;
1195:
1196: IF l_rs_sql is not null THEN

Line 1193: ' SELECT count(*) ' || OE_PC_GLOBALS.NEWLINE || l_vc_sql || ';';

1189: IF (l_condn_logic_only) THEN
1190: x_validation_stmt := l_vc_sql;
1191: ELSE
1192: x_valid_count_cursor := ' CURSOR C_VC IS ' || OE_PC_GLOBALS.NEWLINE ||
1193: ' SELECT count(*) ' || OE_PC_GLOBALS.NEWLINE || l_vc_sql || ';';
1194: END IF;
1195:
1196: IF l_rs_sql is not null THEN
1197: x_set_count_cursor := ' CURSOR C_RSC IS ' || OE_PC_GLOBALS.NEWLINE ||

Line 1197: x_set_count_cursor := ' CURSOR C_RSC IS ' || OE_PC_GLOBALS.NEWLINE ||

1193: ' SELECT count(*) ' || OE_PC_GLOBALS.NEWLINE || l_vc_sql || ';';
1194: END IF;
1195:
1196: IF l_rs_sql is not null THEN
1197: x_set_count_cursor := ' CURSOR C_RSC IS ' || OE_PC_GLOBALS.NEWLINE ||
1198: ' SELECT count(*) ' || OE_PC_GLOBALS.NEWLINE || l_rs_sql || ';';
1199: END IF;
1200:
1201: IF l_debug_level > 0 THEN

Line 1198: ' SELECT count(*) ' || OE_PC_GLOBALS.NEWLINE || l_rs_sql || ';';

1194: END IF;
1195:
1196: IF l_rs_sql is not null THEN
1197: x_set_count_cursor := ' CURSOR C_RSC IS ' || OE_PC_GLOBALS.NEWLINE ||
1198: ' SELECT count(*) ' || OE_PC_GLOBALS.NEWLINE || l_rs_sql || ';';
1199: END IF;
1200:
1201: IF l_debug_level > 0 THEN
1202: oe_debug_pub.add( 'VALID COUNT CURSOR: '||X_VALID_COUNT_CURSOR , 2 ) ;

Line 1254: l_sql := 'UPDATE OE_PC_VALIDATION_PKGS SET last_update_date = sysdate ' || OE_PC_GLOBALS.NEWLINE;

1250: -- OEXPCRQB.pls which does not have visibility to p_proc_name value.
1251:
1252: if (l_update = 'Y') then
1253: -- make update statement
1254: l_sql := 'UPDATE OE_PC_VALIDATION_PKGS SET last_update_date = sysdate ' || OE_PC_GLOBALS.NEWLINE;
1255: l_sql := l_sql || ' WHERE validating_entity_id = :b1 '||OE_PC_GLOBALS.NEWLINE;
1256: l_sql := l_sql || ' AND validation_entity_id = :b2 '||OE_PC_GLOBALS.NEWLINE;
1257: l_sql := l_sql || ' AND validation_tmplt_id = :b3 '||OE_PC_GLOBALS.NEWLINE;
1258: l_sql := l_sql || ' AND record_set_id = :b4 '||OE_PC_GLOBALS.NEWLINE;

Line 1255: l_sql := l_sql || ' WHERE validating_entity_id = :b1 '||OE_PC_GLOBALS.NEWLINE;

1251:
1252: if (l_update = 'Y') then
1253: -- make update statement
1254: l_sql := 'UPDATE OE_PC_VALIDATION_PKGS SET last_update_date = sysdate ' || OE_PC_GLOBALS.NEWLINE;
1255: l_sql := l_sql || ' WHERE validating_entity_id = :b1 '||OE_PC_GLOBALS.NEWLINE;
1256: l_sql := l_sql || ' AND validation_entity_id = :b2 '||OE_PC_GLOBALS.NEWLINE;
1257: l_sql := l_sql || ' AND validation_tmplt_id = :b3 '||OE_PC_GLOBALS.NEWLINE;
1258: l_sql := l_sql || ' AND record_set_id = :b4 '||OE_PC_GLOBALS.NEWLINE;
1259: l_sql := l_sql || ' AND EXISTS (SELECT 1 '|| OE_PC_GLOBALS.NEWLINE;

Line 1256: l_sql := l_sql || ' AND validation_entity_id = :b2 '||OE_PC_GLOBALS.NEWLINE;

1252: if (l_update = 'Y') then
1253: -- make update statement
1254: l_sql := 'UPDATE OE_PC_VALIDATION_PKGS SET last_update_date = sysdate ' || OE_PC_GLOBALS.NEWLINE;
1255: l_sql := l_sql || ' WHERE validating_entity_id = :b1 '||OE_PC_GLOBALS.NEWLINE;
1256: l_sql := l_sql || ' AND validation_entity_id = :b2 '||OE_PC_GLOBALS.NEWLINE;
1257: l_sql := l_sql || ' AND validation_tmplt_id = :b3 '||OE_PC_GLOBALS.NEWLINE;
1258: l_sql := l_sql || ' AND record_set_id = :b4 '||OE_PC_GLOBALS.NEWLINE;
1259: l_sql := l_sql || ' AND EXISTS (SELECT 1 '|| OE_PC_GLOBALS.NEWLINE;
1260: l_sql := l_sql || ' FROM USER_OBJECTS u '|| OE_PC_GLOBALS.NEWLINE;

Line 1257: l_sql := l_sql || ' AND validation_tmplt_id = :b3 '||OE_PC_GLOBALS.NEWLINE;

1253: -- make update statement
1254: l_sql := 'UPDATE OE_PC_VALIDATION_PKGS SET last_update_date = sysdate ' || OE_PC_GLOBALS.NEWLINE;
1255: l_sql := l_sql || ' WHERE validating_entity_id = :b1 '||OE_PC_GLOBALS.NEWLINE;
1256: l_sql := l_sql || ' AND validation_entity_id = :b2 '||OE_PC_GLOBALS.NEWLINE;
1257: l_sql := l_sql || ' AND validation_tmplt_id = :b3 '||OE_PC_GLOBALS.NEWLINE;
1258: l_sql := l_sql || ' AND record_set_id = :b4 '||OE_PC_GLOBALS.NEWLINE;
1259: l_sql := l_sql || ' AND EXISTS (SELECT 1 '|| OE_PC_GLOBALS.NEWLINE;
1260: l_sql := l_sql || ' FROM USER_OBJECTS u '|| OE_PC_GLOBALS.NEWLINE;
1261: l_sql := l_sql || ' WHERE OBJECT_NAME = :b5 '||OE_PC_GLOBALS.NEWLINE;

Line 1258: l_sql := l_sql || ' AND record_set_id = :b4 '||OE_PC_GLOBALS.NEWLINE;

1254: l_sql := 'UPDATE OE_PC_VALIDATION_PKGS SET last_update_date = sysdate ' || OE_PC_GLOBALS.NEWLINE;
1255: l_sql := l_sql || ' WHERE validating_entity_id = :b1 '||OE_PC_GLOBALS.NEWLINE;
1256: l_sql := l_sql || ' AND validation_entity_id = :b2 '||OE_PC_GLOBALS.NEWLINE;
1257: l_sql := l_sql || ' AND validation_tmplt_id = :b3 '||OE_PC_GLOBALS.NEWLINE;
1258: l_sql := l_sql || ' AND record_set_id = :b4 '||OE_PC_GLOBALS.NEWLINE;
1259: l_sql := l_sql || ' AND EXISTS (SELECT 1 '|| OE_PC_GLOBALS.NEWLINE;
1260: l_sql := l_sql || ' FROM USER_OBJECTS u '|| OE_PC_GLOBALS.NEWLINE;
1261: l_sql := l_sql || ' WHERE OBJECT_NAME = :b5 '||OE_PC_GLOBALS.NEWLINE;
1262: l_sql := l_sql || ' AND OBJECT_TYPE = '|| Q || 'PACKAGE BODY'|| Q || OE_PC_GLOBALS.NEWLINE;

Line 1259: l_sql := l_sql || ' AND EXISTS (SELECT 1 '|| OE_PC_GLOBALS.NEWLINE;

1255: l_sql := l_sql || ' WHERE validating_entity_id = :b1 '||OE_PC_GLOBALS.NEWLINE;
1256: l_sql := l_sql || ' AND validation_entity_id = :b2 '||OE_PC_GLOBALS.NEWLINE;
1257: l_sql := l_sql || ' AND validation_tmplt_id = :b3 '||OE_PC_GLOBALS.NEWLINE;
1258: l_sql := l_sql || ' AND record_set_id = :b4 '||OE_PC_GLOBALS.NEWLINE;
1259: l_sql := l_sql || ' AND EXISTS (SELECT 1 '|| OE_PC_GLOBALS.NEWLINE;
1260: l_sql := l_sql || ' FROM USER_OBJECTS u '|| OE_PC_GLOBALS.NEWLINE;
1261: l_sql := l_sql || ' WHERE OBJECT_NAME = :b5 '||OE_PC_GLOBALS.NEWLINE;
1262: l_sql := l_sql || ' AND OBJECT_TYPE = '|| Q || 'PACKAGE BODY'|| Q || OE_PC_GLOBALS.NEWLINE;
1263: l_sql := l_sql || ' AND STATUS = '|| Q || 'VALID'|| Q || OE_PC_GLOBALS.NEWLINE;

Line 1260: l_sql := l_sql || ' FROM USER_OBJECTS u '|| OE_PC_GLOBALS.NEWLINE;

1256: l_sql := l_sql || ' AND validation_entity_id = :b2 '||OE_PC_GLOBALS.NEWLINE;
1257: l_sql := l_sql || ' AND validation_tmplt_id = :b3 '||OE_PC_GLOBALS.NEWLINE;
1258: l_sql := l_sql || ' AND record_set_id = :b4 '||OE_PC_GLOBALS.NEWLINE;
1259: l_sql := l_sql || ' AND EXISTS (SELECT 1 '|| OE_PC_GLOBALS.NEWLINE;
1260: l_sql := l_sql || ' FROM USER_OBJECTS u '|| OE_PC_GLOBALS.NEWLINE;
1261: l_sql := l_sql || ' WHERE OBJECT_NAME = :b5 '||OE_PC_GLOBALS.NEWLINE;
1262: l_sql := l_sql || ' AND OBJECT_TYPE = '|| Q || 'PACKAGE BODY'|| Q || OE_PC_GLOBALS.NEWLINE;
1263: l_sql := l_sql || ' AND STATUS = '|| Q || 'VALID'|| Q || OE_PC_GLOBALS.NEWLINE;
1264: l_sql := l_sql || ' ) ' || OE_PC_GLOBALS.NEWLINE;

Line 1261: l_sql := l_sql || ' WHERE OBJECT_NAME = :b5 '||OE_PC_GLOBALS.NEWLINE;

1257: l_sql := l_sql || ' AND validation_tmplt_id = :b3 '||OE_PC_GLOBALS.NEWLINE;
1258: l_sql := l_sql || ' AND record_set_id = :b4 '||OE_PC_GLOBALS.NEWLINE;
1259: l_sql := l_sql || ' AND EXISTS (SELECT 1 '|| OE_PC_GLOBALS.NEWLINE;
1260: l_sql := l_sql || ' FROM USER_OBJECTS u '|| OE_PC_GLOBALS.NEWLINE;
1261: l_sql := l_sql || ' WHERE OBJECT_NAME = :b5 '||OE_PC_GLOBALS.NEWLINE;
1262: l_sql := l_sql || ' AND OBJECT_TYPE = '|| Q || 'PACKAGE BODY'|| Q || OE_PC_GLOBALS.NEWLINE;
1263: l_sql := l_sql || ' AND STATUS = '|| Q || 'VALID'|| Q || OE_PC_GLOBALS.NEWLINE;
1264: l_sql := l_sql || ' ) ' || OE_PC_GLOBALS.NEWLINE;
1265:

Line 1262: l_sql := l_sql || ' AND OBJECT_TYPE = '|| Q || 'PACKAGE BODY'|| Q || OE_PC_GLOBALS.NEWLINE;

1258: l_sql := l_sql || ' AND record_set_id = :b4 '||OE_PC_GLOBALS.NEWLINE;
1259: l_sql := l_sql || ' AND EXISTS (SELECT 1 '|| OE_PC_GLOBALS.NEWLINE;
1260: l_sql := l_sql || ' FROM USER_OBJECTS u '|| OE_PC_GLOBALS.NEWLINE;
1261: l_sql := l_sql || ' WHERE OBJECT_NAME = :b5 '||OE_PC_GLOBALS.NEWLINE;
1262: l_sql := l_sql || ' AND OBJECT_TYPE = '|| Q || 'PACKAGE BODY'|| Q || OE_PC_GLOBALS.NEWLINE;
1263: l_sql := l_sql || ' AND STATUS = '|| Q || 'VALID'|| Q || OE_PC_GLOBALS.NEWLINE;
1264: l_sql := l_sql || ' ) ' || OE_PC_GLOBALS.NEWLINE;
1265:
1266:

Line 1263: l_sql := l_sql || ' AND STATUS = '|| Q || 'VALID'|| Q || OE_PC_GLOBALS.NEWLINE;

1259: l_sql := l_sql || ' AND EXISTS (SELECT 1 '|| OE_PC_GLOBALS.NEWLINE;
1260: l_sql := l_sql || ' FROM USER_OBJECTS u '|| OE_PC_GLOBALS.NEWLINE;
1261: l_sql := l_sql || ' WHERE OBJECT_NAME = :b5 '||OE_PC_GLOBALS.NEWLINE;
1262: l_sql := l_sql || ' AND OBJECT_TYPE = '|| Q || 'PACKAGE BODY'|| Q || OE_PC_GLOBALS.NEWLINE;
1263: l_sql := l_sql || ' AND STATUS = '|| Q || 'VALID'|| Q || OE_PC_GLOBALS.NEWLINE;
1264: l_sql := l_sql || ' ) ' || OE_PC_GLOBALS.NEWLINE;
1265:
1266:
1267: else

Line 1264: l_sql := l_sql || ' ) ' || OE_PC_GLOBALS.NEWLINE;

1260: l_sql := l_sql || ' FROM USER_OBJECTS u '|| OE_PC_GLOBALS.NEWLINE;
1261: l_sql := l_sql || ' WHERE OBJECT_NAME = :b5 '||OE_PC_GLOBALS.NEWLINE;
1262: l_sql := l_sql || ' AND OBJECT_TYPE = '|| Q || 'PACKAGE BODY'|| Q || OE_PC_GLOBALS.NEWLINE;
1263: l_sql := l_sql || ' AND STATUS = '|| Q || 'VALID'|| Q || OE_PC_GLOBALS.NEWLINE;
1264: l_sql := l_sql || ' ) ' || OE_PC_GLOBALS.NEWLINE;
1265:
1266:
1267: else
1268: -- make insert statement

Line 1270: l_sql := l_sql || '( ' || OE_PC_GLOBALS.NEWLINE;

1266:
1267: else
1268: -- make insert statement
1269: l_sql := l_sql || 'INSERT INTO OE_PC_VALIDATION_PKGS ';
1270: l_sql := l_sql || '( ' || OE_PC_GLOBALS.NEWLINE;
1271: l_sql := l_sql || ' validating_entity_id ' || OE_PC_GLOBALS.NEWLINE;
1272: l_sql := l_sql || ' ,validation_entity_id ' || OE_PC_GLOBALS.NEWLINE;
1273: l_sql := l_sql || ' ,validation_tmplt_id ' || OE_PC_GLOBALS.NEWLINE;
1274: l_sql := l_sql || ' ,record_set_id ' || OE_PC_GLOBALS.NEWLINE;

Line 1271: l_sql := l_sql || ' validating_entity_id ' || OE_PC_GLOBALS.NEWLINE;

1267: else
1268: -- make insert statement
1269: l_sql := l_sql || 'INSERT INTO OE_PC_VALIDATION_PKGS ';
1270: l_sql := l_sql || '( ' || OE_PC_GLOBALS.NEWLINE;
1271: l_sql := l_sql || ' validating_entity_id ' || OE_PC_GLOBALS.NEWLINE;
1272: l_sql := l_sql || ' ,validation_entity_id ' || OE_PC_GLOBALS.NEWLINE;
1273: l_sql := l_sql || ' ,validation_tmplt_id ' || OE_PC_GLOBALS.NEWLINE;
1274: l_sql := l_sql || ' ,record_set_id ' || OE_PC_GLOBALS.NEWLINE;
1275: l_sql := l_sql || ' ,validation_pkg ' || OE_PC_GLOBALS.NEWLINE;

Line 1272: l_sql := l_sql || ' ,validation_entity_id ' || OE_PC_GLOBALS.NEWLINE;

1268: -- make insert statement
1269: l_sql := l_sql || 'INSERT INTO OE_PC_VALIDATION_PKGS ';
1270: l_sql := l_sql || '( ' || OE_PC_GLOBALS.NEWLINE;
1271: l_sql := l_sql || ' validating_entity_id ' || OE_PC_GLOBALS.NEWLINE;
1272: l_sql := l_sql || ' ,validation_entity_id ' || OE_PC_GLOBALS.NEWLINE;
1273: l_sql := l_sql || ' ,validation_tmplt_id ' || OE_PC_GLOBALS.NEWLINE;
1274: l_sql := l_sql || ' ,record_set_id ' || OE_PC_GLOBALS.NEWLINE;
1275: l_sql := l_sql || ' ,validation_pkg ' || OE_PC_GLOBALS.NEWLINE;
1276: l_sql := l_sql || ' ,validation_proc ' || OE_PC_GLOBALS.NEWLINE;

Line 1273: l_sql := l_sql || ' ,validation_tmplt_id ' || OE_PC_GLOBALS.NEWLINE;

1269: l_sql := l_sql || 'INSERT INTO OE_PC_VALIDATION_PKGS ';
1270: l_sql := l_sql || '( ' || OE_PC_GLOBALS.NEWLINE;
1271: l_sql := l_sql || ' validating_entity_id ' || OE_PC_GLOBALS.NEWLINE;
1272: l_sql := l_sql || ' ,validation_entity_id ' || OE_PC_GLOBALS.NEWLINE;
1273: l_sql := l_sql || ' ,validation_tmplt_id ' || OE_PC_GLOBALS.NEWLINE;
1274: l_sql := l_sql || ' ,record_set_id ' || OE_PC_GLOBALS.NEWLINE;
1275: l_sql := l_sql || ' ,validation_pkg ' || OE_PC_GLOBALS.NEWLINE;
1276: l_sql := l_sql || ' ,validation_proc ' || OE_PC_GLOBALS.NEWLINE;
1277: l_sql := l_sql || ' ,created_by ' || OE_PC_GLOBALS.NEWLINE;

Line 1274: l_sql := l_sql || ' ,record_set_id ' || OE_PC_GLOBALS.NEWLINE;

1270: l_sql := l_sql || '( ' || OE_PC_GLOBALS.NEWLINE;
1271: l_sql := l_sql || ' validating_entity_id ' || OE_PC_GLOBALS.NEWLINE;
1272: l_sql := l_sql || ' ,validation_entity_id ' || OE_PC_GLOBALS.NEWLINE;
1273: l_sql := l_sql || ' ,validation_tmplt_id ' || OE_PC_GLOBALS.NEWLINE;
1274: l_sql := l_sql || ' ,record_set_id ' || OE_PC_GLOBALS.NEWLINE;
1275: l_sql := l_sql || ' ,validation_pkg ' || OE_PC_GLOBALS.NEWLINE;
1276: l_sql := l_sql || ' ,validation_proc ' || OE_PC_GLOBALS.NEWLINE;
1277: l_sql := l_sql || ' ,created_by ' || OE_PC_GLOBALS.NEWLINE;
1278: l_sql := l_sql || ' ,creation_date ' || OE_PC_GLOBALS.NEWLINE;

Line 1275: l_sql := l_sql || ' ,validation_pkg ' || OE_PC_GLOBALS.NEWLINE;

1271: l_sql := l_sql || ' validating_entity_id ' || OE_PC_GLOBALS.NEWLINE;
1272: l_sql := l_sql || ' ,validation_entity_id ' || OE_PC_GLOBALS.NEWLINE;
1273: l_sql := l_sql || ' ,validation_tmplt_id ' || OE_PC_GLOBALS.NEWLINE;
1274: l_sql := l_sql || ' ,record_set_id ' || OE_PC_GLOBALS.NEWLINE;
1275: l_sql := l_sql || ' ,validation_pkg ' || OE_PC_GLOBALS.NEWLINE;
1276: l_sql := l_sql || ' ,validation_proc ' || OE_PC_GLOBALS.NEWLINE;
1277: l_sql := l_sql || ' ,created_by ' || OE_PC_GLOBALS.NEWLINE;
1278: l_sql := l_sql || ' ,creation_date ' || OE_PC_GLOBALS.NEWLINE;
1279: l_sql := l_sql || ' ,last_updated_by ' || OE_PC_GLOBALS.NEWLINE;

Line 1276: l_sql := l_sql || ' ,validation_proc ' || OE_PC_GLOBALS.NEWLINE;

1272: l_sql := l_sql || ' ,validation_entity_id ' || OE_PC_GLOBALS.NEWLINE;
1273: l_sql := l_sql || ' ,validation_tmplt_id ' || OE_PC_GLOBALS.NEWLINE;
1274: l_sql := l_sql || ' ,record_set_id ' || OE_PC_GLOBALS.NEWLINE;
1275: l_sql := l_sql || ' ,validation_pkg ' || OE_PC_GLOBALS.NEWLINE;
1276: l_sql := l_sql || ' ,validation_proc ' || OE_PC_GLOBALS.NEWLINE;
1277: l_sql := l_sql || ' ,created_by ' || OE_PC_GLOBALS.NEWLINE;
1278: l_sql := l_sql || ' ,creation_date ' || OE_PC_GLOBALS.NEWLINE;
1279: l_sql := l_sql || ' ,last_updated_by ' || OE_PC_GLOBALS.NEWLINE;
1280: l_sql := l_sql || ' ,last_update_date ' || OE_PC_GLOBALS.NEWLINE;

Line 1277: l_sql := l_sql || ' ,created_by ' || OE_PC_GLOBALS.NEWLINE;

1273: l_sql := l_sql || ' ,validation_tmplt_id ' || OE_PC_GLOBALS.NEWLINE;
1274: l_sql := l_sql || ' ,record_set_id ' || OE_PC_GLOBALS.NEWLINE;
1275: l_sql := l_sql || ' ,validation_pkg ' || OE_PC_GLOBALS.NEWLINE;
1276: l_sql := l_sql || ' ,validation_proc ' || OE_PC_GLOBALS.NEWLINE;
1277: l_sql := l_sql || ' ,created_by ' || OE_PC_GLOBALS.NEWLINE;
1278: l_sql := l_sql || ' ,creation_date ' || OE_PC_GLOBALS.NEWLINE;
1279: l_sql := l_sql || ' ,last_updated_by ' || OE_PC_GLOBALS.NEWLINE;
1280: l_sql := l_sql || ' ,last_update_date ' || OE_PC_GLOBALS.NEWLINE;
1281: l_sql := l_sql || ' ,last_update_login ' || OE_PC_GLOBALS.NEWLINE;

Line 1278: l_sql := l_sql || ' ,creation_date ' || OE_PC_GLOBALS.NEWLINE;

1274: l_sql := l_sql || ' ,record_set_id ' || OE_PC_GLOBALS.NEWLINE;
1275: l_sql := l_sql || ' ,validation_pkg ' || OE_PC_GLOBALS.NEWLINE;
1276: l_sql := l_sql || ' ,validation_proc ' || OE_PC_GLOBALS.NEWLINE;
1277: l_sql := l_sql || ' ,created_by ' || OE_PC_GLOBALS.NEWLINE;
1278: l_sql := l_sql || ' ,creation_date ' || OE_PC_GLOBALS.NEWLINE;
1279: l_sql := l_sql || ' ,last_updated_by ' || OE_PC_GLOBALS.NEWLINE;
1280: l_sql := l_sql || ' ,last_update_date ' || OE_PC_GLOBALS.NEWLINE;
1281: l_sql := l_sql || ' ,last_update_login ' || OE_PC_GLOBALS.NEWLINE;
1282: l_sql := l_sql || ') ' || OE_PC_GLOBALS.NEWLINE;

Line 1279: l_sql := l_sql || ' ,last_updated_by ' || OE_PC_GLOBALS.NEWLINE;

1275: l_sql := l_sql || ' ,validation_pkg ' || OE_PC_GLOBALS.NEWLINE;
1276: l_sql := l_sql || ' ,validation_proc ' || OE_PC_GLOBALS.NEWLINE;
1277: l_sql := l_sql || ' ,created_by ' || OE_PC_GLOBALS.NEWLINE;
1278: l_sql := l_sql || ' ,creation_date ' || OE_PC_GLOBALS.NEWLINE;
1279: l_sql := l_sql || ' ,last_updated_by ' || OE_PC_GLOBALS.NEWLINE;
1280: l_sql := l_sql || ' ,last_update_date ' || OE_PC_GLOBALS.NEWLINE;
1281: l_sql := l_sql || ' ,last_update_login ' || OE_PC_GLOBALS.NEWLINE;
1282: l_sql := l_sql || ') ' || OE_PC_GLOBALS.NEWLINE;
1283: l_sql := l_sql || 'SELECT ' || OE_PC_GLOBALS.NEWLINE;

Line 1280: l_sql := l_sql || ' ,last_update_date ' || OE_PC_GLOBALS.NEWLINE;

1276: l_sql := l_sql || ' ,validation_proc ' || OE_PC_GLOBALS.NEWLINE;
1277: l_sql := l_sql || ' ,created_by ' || OE_PC_GLOBALS.NEWLINE;
1278: l_sql := l_sql || ' ,creation_date ' || OE_PC_GLOBALS.NEWLINE;
1279: l_sql := l_sql || ' ,last_updated_by ' || OE_PC_GLOBALS.NEWLINE;
1280: l_sql := l_sql || ' ,last_update_date ' || OE_PC_GLOBALS.NEWLINE;
1281: l_sql := l_sql || ' ,last_update_login ' || OE_PC_GLOBALS.NEWLINE;
1282: l_sql := l_sql || ') ' || OE_PC_GLOBALS.NEWLINE;
1283: l_sql := l_sql || 'SELECT ' || OE_PC_GLOBALS.NEWLINE;
1284: l_sql := l_sql || ' :b1 '|| OE_PC_GLOBALS.NEWLINE;

Line 1281: l_sql := l_sql || ' ,last_update_login ' || OE_PC_GLOBALS.NEWLINE;

1277: l_sql := l_sql || ' ,created_by ' || OE_PC_GLOBALS.NEWLINE;
1278: l_sql := l_sql || ' ,creation_date ' || OE_PC_GLOBALS.NEWLINE;
1279: l_sql := l_sql || ' ,last_updated_by ' || OE_PC_GLOBALS.NEWLINE;
1280: l_sql := l_sql || ' ,last_update_date ' || OE_PC_GLOBALS.NEWLINE;
1281: l_sql := l_sql || ' ,last_update_login ' || OE_PC_GLOBALS.NEWLINE;
1282: l_sql := l_sql || ') ' || OE_PC_GLOBALS.NEWLINE;
1283: l_sql := l_sql || 'SELECT ' || OE_PC_GLOBALS.NEWLINE;
1284: l_sql := l_sql || ' :b1 '|| OE_PC_GLOBALS.NEWLINE;
1285: l_sql := l_sql || COMMA ||' :b2 '|| OE_PC_GLOBALS.NEWLINE;

Line 1282: l_sql := l_sql || ') ' || OE_PC_GLOBALS.NEWLINE;

1278: l_sql := l_sql || ' ,creation_date ' || OE_PC_GLOBALS.NEWLINE;
1279: l_sql := l_sql || ' ,last_updated_by ' || OE_PC_GLOBALS.NEWLINE;
1280: l_sql := l_sql || ' ,last_update_date ' || OE_PC_GLOBALS.NEWLINE;
1281: l_sql := l_sql || ' ,last_update_login ' || OE_PC_GLOBALS.NEWLINE;
1282: l_sql := l_sql || ') ' || OE_PC_GLOBALS.NEWLINE;
1283: l_sql := l_sql || 'SELECT ' || OE_PC_GLOBALS.NEWLINE;
1284: l_sql := l_sql || ' :b1 '|| OE_PC_GLOBALS.NEWLINE;
1285: l_sql := l_sql || COMMA ||' :b2 '|| OE_PC_GLOBALS.NEWLINE;
1286: l_sql := l_sql || COMMA ||' :b3 '|| OE_PC_GLOBALS.NEWLINE;

Line 1283: l_sql := l_sql || 'SELECT ' || OE_PC_GLOBALS.NEWLINE;

1279: l_sql := l_sql || ' ,last_updated_by ' || OE_PC_GLOBALS.NEWLINE;
1280: l_sql := l_sql || ' ,last_update_date ' || OE_PC_GLOBALS.NEWLINE;
1281: l_sql := l_sql || ' ,last_update_login ' || OE_PC_GLOBALS.NEWLINE;
1282: l_sql := l_sql || ') ' || OE_PC_GLOBALS.NEWLINE;
1283: l_sql := l_sql || 'SELECT ' || OE_PC_GLOBALS.NEWLINE;
1284: l_sql := l_sql || ' :b1 '|| OE_PC_GLOBALS.NEWLINE;
1285: l_sql := l_sql || COMMA ||' :b2 '|| OE_PC_GLOBALS.NEWLINE;
1286: l_sql := l_sql || COMMA ||' :b3 '|| OE_PC_GLOBALS.NEWLINE;
1287: l_sql := l_sql || COMMA ||' :b4 '|| OE_PC_GLOBALS.NEWLINE;

Line 1284: l_sql := l_sql || ' :b1 '|| OE_PC_GLOBALS.NEWLINE;

1280: l_sql := l_sql || ' ,last_update_date ' || OE_PC_GLOBALS.NEWLINE;
1281: l_sql := l_sql || ' ,last_update_login ' || OE_PC_GLOBALS.NEWLINE;
1282: l_sql := l_sql || ') ' || OE_PC_GLOBALS.NEWLINE;
1283: l_sql := l_sql || 'SELECT ' || OE_PC_GLOBALS.NEWLINE;
1284: l_sql := l_sql || ' :b1 '|| OE_PC_GLOBALS.NEWLINE;
1285: l_sql := l_sql || COMMA ||' :b2 '|| OE_PC_GLOBALS.NEWLINE;
1286: l_sql := l_sql || COMMA ||' :b3 '|| OE_PC_GLOBALS.NEWLINE;
1287: l_sql := l_sql || COMMA ||' :b4 '|| OE_PC_GLOBALS.NEWLINE;
1288: l_sql := l_sql || COMMA ||' :b5 '|| OE_PC_GLOBALS.NEWLINE;

Line 1285: l_sql := l_sql || COMMA ||' :b2 '|| OE_PC_GLOBALS.NEWLINE;

1281: l_sql := l_sql || ' ,last_update_login ' || OE_PC_GLOBALS.NEWLINE;
1282: l_sql := l_sql || ') ' || OE_PC_GLOBALS.NEWLINE;
1283: l_sql := l_sql || 'SELECT ' || OE_PC_GLOBALS.NEWLINE;
1284: l_sql := l_sql || ' :b1 '|| OE_PC_GLOBALS.NEWLINE;
1285: l_sql := l_sql || COMMA ||' :b2 '|| OE_PC_GLOBALS.NEWLINE;
1286: l_sql := l_sql || COMMA ||' :b3 '|| OE_PC_GLOBALS.NEWLINE;
1287: l_sql := l_sql || COMMA ||' :b4 '|| OE_PC_GLOBALS.NEWLINE;
1288: l_sql := l_sql || COMMA ||' :b5 '|| OE_PC_GLOBALS.NEWLINE;
1289: l_sql := l_sql || COMMA || Q || p_proc_name || Q || OE_PC_GLOBALS.NEWLINE;

Line 1286: l_sql := l_sql || COMMA ||' :b3 '|| OE_PC_GLOBALS.NEWLINE;

1282: l_sql := l_sql || ') ' || OE_PC_GLOBALS.NEWLINE;
1283: l_sql := l_sql || 'SELECT ' || OE_PC_GLOBALS.NEWLINE;
1284: l_sql := l_sql || ' :b1 '|| OE_PC_GLOBALS.NEWLINE;
1285: l_sql := l_sql || COMMA ||' :b2 '|| OE_PC_GLOBALS.NEWLINE;
1286: l_sql := l_sql || COMMA ||' :b3 '|| OE_PC_GLOBALS.NEWLINE;
1287: l_sql := l_sql || COMMA ||' :b4 '|| OE_PC_GLOBALS.NEWLINE;
1288: l_sql := l_sql || COMMA ||' :b5 '|| OE_PC_GLOBALS.NEWLINE;
1289: l_sql := l_sql || COMMA || Q || p_proc_name || Q || OE_PC_GLOBALS.NEWLINE;
1290: l_sql := l_sql || ',1' || OE_PC_GLOBALS.NEWLINE;

Line 1287: l_sql := l_sql || COMMA ||' :b4 '|| OE_PC_GLOBALS.NEWLINE;

1283: l_sql := l_sql || 'SELECT ' || OE_PC_GLOBALS.NEWLINE;
1284: l_sql := l_sql || ' :b1 '|| OE_PC_GLOBALS.NEWLINE;
1285: l_sql := l_sql || COMMA ||' :b2 '|| OE_PC_GLOBALS.NEWLINE;
1286: l_sql := l_sql || COMMA ||' :b3 '|| OE_PC_GLOBALS.NEWLINE;
1287: l_sql := l_sql || COMMA ||' :b4 '|| OE_PC_GLOBALS.NEWLINE;
1288: l_sql := l_sql || COMMA ||' :b5 '|| OE_PC_GLOBALS.NEWLINE;
1289: l_sql := l_sql || COMMA || Q || p_proc_name || Q || OE_PC_GLOBALS.NEWLINE;
1290: l_sql := l_sql || ',1' || OE_PC_GLOBALS.NEWLINE;
1291: l_sql := l_sql || ',sysdate' || OE_PC_GLOBALS.NEWLINE;

Line 1288: l_sql := l_sql || COMMA ||' :b5 '|| OE_PC_GLOBALS.NEWLINE;

1284: l_sql := l_sql || ' :b1 '|| OE_PC_GLOBALS.NEWLINE;
1285: l_sql := l_sql || COMMA ||' :b2 '|| OE_PC_GLOBALS.NEWLINE;
1286: l_sql := l_sql || COMMA ||' :b3 '|| OE_PC_GLOBALS.NEWLINE;
1287: l_sql := l_sql || COMMA ||' :b4 '|| OE_PC_GLOBALS.NEWLINE;
1288: l_sql := l_sql || COMMA ||' :b5 '|| OE_PC_GLOBALS.NEWLINE;
1289: l_sql := l_sql || COMMA || Q || p_proc_name || Q || OE_PC_GLOBALS.NEWLINE;
1290: l_sql := l_sql || ',1' || OE_PC_GLOBALS.NEWLINE;
1291: l_sql := l_sql || ',sysdate' || OE_PC_GLOBALS.NEWLINE;
1292: l_sql := l_sql || ',1' || OE_PC_GLOBALS.NEWLINE;

Line 1289: l_sql := l_sql || COMMA || Q || p_proc_name || Q || OE_PC_GLOBALS.NEWLINE;

1285: l_sql := l_sql || COMMA ||' :b2 '|| OE_PC_GLOBALS.NEWLINE;
1286: l_sql := l_sql || COMMA ||' :b3 '|| OE_PC_GLOBALS.NEWLINE;
1287: l_sql := l_sql || COMMA ||' :b4 '|| OE_PC_GLOBALS.NEWLINE;
1288: l_sql := l_sql || COMMA ||' :b5 '|| OE_PC_GLOBALS.NEWLINE;
1289: l_sql := l_sql || COMMA || Q || p_proc_name || Q || OE_PC_GLOBALS.NEWLINE;
1290: l_sql := l_sql || ',1' || OE_PC_GLOBALS.NEWLINE;
1291: l_sql := l_sql || ',sysdate' || OE_PC_GLOBALS.NEWLINE;
1292: l_sql := l_sql || ',1' || OE_PC_GLOBALS.NEWLINE;
1293: l_sql := l_sql || ',sysdate' || OE_PC_GLOBALS.NEWLINE;

Line 1290: l_sql := l_sql || ',1' || OE_PC_GLOBALS.NEWLINE;

1286: l_sql := l_sql || COMMA ||' :b3 '|| OE_PC_GLOBALS.NEWLINE;
1287: l_sql := l_sql || COMMA ||' :b4 '|| OE_PC_GLOBALS.NEWLINE;
1288: l_sql := l_sql || COMMA ||' :b5 '|| OE_PC_GLOBALS.NEWLINE;
1289: l_sql := l_sql || COMMA || Q || p_proc_name || Q || OE_PC_GLOBALS.NEWLINE;
1290: l_sql := l_sql || ',1' || OE_PC_GLOBALS.NEWLINE;
1291: l_sql := l_sql || ',sysdate' || OE_PC_GLOBALS.NEWLINE;
1292: l_sql := l_sql || ',1' || OE_PC_GLOBALS.NEWLINE;
1293: l_sql := l_sql || ',sysdate' || OE_PC_GLOBALS.NEWLINE;
1294: l_sql := l_sql || ',1' || OE_PC_GLOBALS.NEWLINE;

Line 1291: l_sql := l_sql || ',sysdate' || OE_PC_GLOBALS.NEWLINE;

1287: l_sql := l_sql || COMMA ||' :b4 '|| OE_PC_GLOBALS.NEWLINE;
1288: l_sql := l_sql || COMMA ||' :b5 '|| OE_PC_GLOBALS.NEWLINE;
1289: l_sql := l_sql || COMMA || Q || p_proc_name || Q || OE_PC_GLOBALS.NEWLINE;
1290: l_sql := l_sql || ',1' || OE_PC_GLOBALS.NEWLINE;
1291: l_sql := l_sql || ',sysdate' || OE_PC_GLOBALS.NEWLINE;
1292: l_sql := l_sql || ',1' || OE_PC_GLOBALS.NEWLINE;
1293: l_sql := l_sql || ',sysdate' || OE_PC_GLOBALS.NEWLINE;
1294: l_sql := l_sql || ',1' || OE_PC_GLOBALS.NEWLINE;
1295: l_sql := l_sql || 'FROM SYS.DUAL' || OE_PC_GLOBALS.NEWLINE;

Line 1292: l_sql := l_sql || ',1' || OE_PC_GLOBALS.NEWLINE;

1288: l_sql := l_sql || COMMA ||' :b5 '|| OE_PC_GLOBALS.NEWLINE;
1289: l_sql := l_sql || COMMA || Q || p_proc_name || Q || OE_PC_GLOBALS.NEWLINE;
1290: l_sql := l_sql || ',1' || OE_PC_GLOBALS.NEWLINE;
1291: l_sql := l_sql || ',sysdate' || OE_PC_GLOBALS.NEWLINE;
1292: l_sql := l_sql || ',1' || OE_PC_GLOBALS.NEWLINE;
1293: l_sql := l_sql || ',sysdate' || OE_PC_GLOBALS.NEWLINE;
1294: l_sql := l_sql || ',1' || OE_PC_GLOBALS.NEWLINE;
1295: l_sql := l_sql || 'FROM SYS.DUAL' || OE_PC_GLOBALS.NEWLINE;
1296: l_sql := l_sql || 'WHERE EXISTS (SELECT ''EXISTS'''|| OE_PC_GLOBALS.NEWLINE;

Line 1293: l_sql := l_sql || ',sysdate' || OE_PC_GLOBALS.NEWLINE;

1289: l_sql := l_sql || COMMA || Q || p_proc_name || Q || OE_PC_GLOBALS.NEWLINE;
1290: l_sql := l_sql || ',1' || OE_PC_GLOBALS.NEWLINE;
1291: l_sql := l_sql || ',sysdate' || OE_PC_GLOBALS.NEWLINE;
1292: l_sql := l_sql || ',1' || OE_PC_GLOBALS.NEWLINE;
1293: l_sql := l_sql || ',sysdate' || OE_PC_GLOBALS.NEWLINE;
1294: l_sql := l_sql || ',1' || OE_PC_GLOBALS.NEWLINE;
1295: l_sql := l_sql || 'FROM SYS.DUAL' || OE_PC_GLOBALS.NEWLINE;
1296: l_sql := l_sql || 'WHERE EXISTS (SELECT ''EXISTS'''|| OE_PC_GLOBALS.NEWLINE;
1297: l_sql := l_sql || ' FROM USER_OBJECTS u '|| OE_PC_GLOBALS.NEWLINE;

Line 1294: l_sql := l_sql || ',1' || OE_PC_GLOBALS.NEWLINE;

1290: l_sql := l_sql || ',1' || OE_PC_GLOBALS.NEWLINE;
1291: l_sql := l_sql || ',sysdate' || OE_PC_GLOBALS.NEWLINE;
1292: l_sql := l_sql || ',1' || OE_PC_GLOBALS.NEWLINE;
1293: l_sql := l_sql || ',sysdate' || OE_PC_GLOBALS.NEWLINE;
1294: l_sql := l_sql || ',1' || OE_PC_GLOBALS.NEWLINE;
1295: l_sql := l_sql || 'FROM SYS.DUAL' || OE_PC_GLOBALS.NEWLINE;
1296: l_sql := l_sql || 'WHERE EXISTS (SELECT ''EXISTS'''|| OE_PC_GLOBALS.NEWLINE;
1297: l_sql := l_sql || ' FROM USER_OBJECTS u '|| OE_PC_GLOBALS.NEWLINE;
1298: l_sql := l_sql || ' WHERE u.OBJECT_NAME = :b5 '|| OE_PC_GLOBALS.NEWLINE;

Line 1295: l_sql := l_sql || 'FROM SYS.DUAL' || OE_PC_GLOBALS.NEWLINE;

1291: l_sql := l_sql || ',sysdate' || OE_PC_GLOBALS.NEWLINE;
1292: l_sql := l_sql || ',1' || OE_PC_GLOBALS.NEWLINE;
1293: l_sql := l_sql || ',sysdate' || OE_PC_GLOBALS.NEWLINE;
1294: l_sql := l_sql || ',1' || OE_PC_GLOBALS.NEWLINE;
1295: l_sql := l_sql || 'FROM SYS.DUAL' || OE_PC_GLOBALS.NEWLINE;
1296: l_sql := l_sql || 'WHERE EXISTS (SELECT ''EXISTS'''|| OE_PC_GLOBALS.NEWLINE;
1297: l_sql := l_sql || ' FROM USER_OBJECTS u '|| OE_PC_GLOBALS.NEWLINE;
1298: l_sql := l_sql || ' WHERE u.OBJECT_NAME = :b5 '|| OE_PC_GLOBALS.NEWLINE;
1299: l_sql := l_sql || ' AND u.OBJECT_TYPE = '|| Q || 'PACKAGE BODY'|| Q || OE_PC_GLOBALS.NEWLINE;

Line 1296: l_sql := l_sql || 'WHERE EXISTS (SELECT ''EXISTS'''|| OE_PC_GLOBALS.NEWLINE;

1292: l_sql := l_sql || ',1' || OE_PC_GLOBALS.NEWLINE;
1293: l_sql := l_sql || ',sysdate' || OE_PC_GLOBALS.NEWLINE;
1294: l_sql := l_sql || ',1' || OE_PC_GLOBALS.NEWLINE;
1295: l_sql := l_sql || 'FROM SYS.DUAL' || OE_PC_GLOBALS.NEWLINE;
1296: l_sql := l_sql || 'WHERE EXISTS (SELECT ''EXISTS'''|| OE_PC_GLOBALS.NEWLINE;
1297: l_sql := l_sql || ' FROM USER_OBJECTS u '|| OE_PC_GLOBALS.NEWLINE;
1298: l_sql := l_sql || ' WHERE u.OBJECT_NAME = :b5 '|| OE_PC_GLOBALS.NEWLINE;
1299: l_sql := l_sql || ' AND u.OBJECT_TYPE = '|| Q || 'PACKAGE BODY'|| Q || OE_PC_GLOBALS.NEWLINE;
1300: l_sql := l_sql || ' AND u.STATUS = '|| Q || 'VALID'|| Q || OE_PC_GLOBALS.NEWLINE;

Line 1297: l_sql := l_sql || ' FROM USER_OBJECTS u '|| OE_PC_GLOBALS.NEWLINE;

1293: l_sql := l_sql || ',sysdate' || OE_PC_GLOBALS.NEWLINE;
1294: l_sql := l_sql || ',1' || OE_PC_GLOBALS.NEWLINE;
1295: l_sql := l_sql || 'FROM SYS.DUAL' || OE_PC_GLOBALS.NEWLINE;
1296: l_sql := l_sql || 'WHERE EXISTS (SELECT ''EXISTS'''|| OE_PC_GLOBALS.NEWLINE;
1297: l_sql := l_sql || ' FROM USER_OBJECTS u '|| OE_PC_GLOBALS.NEWLINE;
1298: l_sql := l_sql || ' WHERE u.OBJECT_NAME = :b5 '|| OE_PC_GLOBALS.NEWLINE;
1299: l_sql := l_sql || ' AND u.OBJECT_TYPE = '|| Q || 'PACKAGE BODY'|| Q || OE_PC_GLOBALS.NEWLINE;
1300: l_sql := l_sql || ' AND u.STATUS = '|| Q || 'VALID'|| Q || OE_PC_GLOBALS.NEWLINE;
1301: l_sql := l_sql || ' ) ' || OE_PC_GLOBALS.NEWLINE;

Line 1298: l_sql := l_sql || ' WHERE u.OBJECT_NAME = :b5 '|| OE_PC_GLOBALS.NEWLINE;

1294: l_sql := l_sql || ',1' || OE_PC_GLOBALS.NEWLINE;
1295: l_sql := l_sql || 'FROM SYS.DUAL' || OE_PC_GLOBALS.NEWLINE;
1296: l_sql := l_sql || 'WHERE EXISTS (SELECT ''EXISTS'''|| OE_PC_GLOBALS.NEWLINE;
1297: l_sql := l_sql || ' FROM USER_OBJECTS u '|| OE_PC_GLOBALS.NEWLINE;
1298: l_sql := l_sql || ' WHERE u.OBJECT_NAME = :b5 '|| OE_PC_GLOBALS.NEWLINE;
1299: l_sql := l_sql || ' AND u.OBJECT_TYPE = '|| Q || 'PACKAGE BODY'|| Q || OE_PC_GLOBALS.NEWLINE;
1300: l_sql := l_sql || ' AND u.STATUS = '|| Q || 'VALID'|| Q || OE_PC_GLOBALS.NEWLINE;
1301: l_sql := l_sql || ' ) ' || OE_PC_GLOBALS.NEWLINE;
1302:

Line 1299: l_sql := l_sql || ' AND u.OBJECT_TYPE = '|| Q || 'PACKAGE BODY'|| Q || OE_PC_GLOBALS.NEWLINE;

1295: l_sql := l_sql || 'FROM SYS.DUAL' || OE_PC_GLOBALS.NEWLINE;
1296: l_sql := l_sql || 'WHERE EXISTS (SELECT ''EXISTS'''|| OE_PC_GLOBALS.NEWLINE;
1297: l_sql := l_sql || ' FROM USER_OBJECTS u '|| OE_PC_GLOBALS.NEWLINE;
1298: l_sql := l_sql || ' WHERE u.OBJECT_NAME = :b5 '|| OE_PC_GLOBALS.NEWLINE;
1299: l_sql := l_sql || ' AND u.OBJECT_TYPE = '|| Q || 'PACKAGE BODY'|| Q || OE_PC_GLOBALS.NEWLINE;
1300: l_sql := l_sql || ' AND u.STATUS = '|| Q || 'VALID'|| Q || OE_PC_GLOBALS.NEWLINE;
1301: l_sql := l_sql || ' ) ' || OE_PC_GLOBALS.NEWLINE;
1302:
1303: end if;

Line 1300: l_sql := l_sql || ' AND u.STATUS = '|| Q || 'VALID'|| Q || OE_PC_GLOBALS.NEWLINE;

1296: l_sql := l_sql || 'WHERE EXISTS (SELECT ''EXISTS'''|| OE_PC_GLOBALS.NEWLINE;
1297: l_sql := l_sql || ' FROM USER_OBJECTS u '|| OE_PC_GLOBALS.NEWLINE;
1298: l_sql := l_sql || ' WHERE u.OBJECT_NAME = :b5 '|| OE_PC_GLOBALS.NEWLINE;
1299: l_sql := l_sql || ' AND u.OBJECT_TYPE = '|| Q || 'PACKAGE BODY'|| Q || OE_PC_GLOBALS.NEWLINE;
1300: l_sql := l_sql || ' AND u.STATUS = '|| Q || 'VALID'|| Q || OE_PC_GLOBALS.NEWLINE;
1301: l_sql := l_sql || ' ) ' || OE_PC_GLOBALS.NEWLINE;
1302:
1303: end if;
1304: x_control_tbl_sql := l_sql;

Line 1301: l_sql := l_sql || ' ) ' || OE_PC_GLOBALS.NEWLINE;

1297: l_sql := l_sql || ' FROM USER_OBJECTS u '|| OE_PC_GLOBALS.NEWLINE;
1298: l_sql := l_sql || ' WHERE u.OBJECT_NAME = :b5 '|| OE_PC_GLOBALS.NEWLINE;
1299: l_sql := l_sql || ' AND u.OBJECT_TYPE = '|| Q || 'PACKAGE BODY'|| Q || OE_PC_GLOBALS.NEWLINE;
1300: l_sql := l_sql || ' AND u.STATUS = '|| Q || 'VALID'|| Q || OE_PC_GLOBALS.NEWLINE;
1301: l_sql := l_sql || ' ) ' || OE_PC_GLOBALS.NEWLINE;
1302:
1303: end if;
1304: x_control_tbl_sql := l_sql;
1305: End Make_Control_Tbl_Sql;

Line 1372: l_pkg_spec := 'CREATE OR REPLACE PACKAGE ' || l_pkg_name || ' AS ' || OE_PC_GLOBALS.NEWLINE;

1368: to_char(p_validation_entity_id) || '_' ||
1369: p_record_set_short_name || '_' ||
1370: p_validation_tmplt_short_name;
1371:
1372: l_pkg_spec := 'CREATE OR REPLACE PACKAGE ' || l_pkg_name || ' AS ' || OE_PC_GLOBALS.NEWLINE;
1373: l_pkg_body := 'CREATE OR REPLACE PACKAGE BODY ' || l_pkg_name || ' AS ' || OE_PC_GLOBALS.NEWLINE;
1374: l_pkg_end := 'END ' || l_pkg_name || ';' || OE_PC_GLOBALS.NEWLINE;
1375:
1376:

Line 1373: l_pkg_body := 'CREATE OR REPLACE PACKAGE BODY ' || l_pkg_name || ' AS ' || OE_PC_GLOBALS.NEWLINE;

1369: p_record_set_short_name || '_' ||
1370: p_validation_tmplt_short_name;
1371:
1372: l_pkg_spec := 'CREATE OR REPLACE PACKAGE ' || l_pkg_name || ' AS ' || OE_PC_GLOBALS.NEWLINE;
1373: l_pkg_body := 'CREATE OR REPLACE PACKAGE BODY ' || l_pkg_name || ' AS ' || OE_PC_GLOBALS.NEWLINE;
1374: l_pkg_end := 'END ' || l_pkg_name || ';' || OE_PC_GLOBALS.NEWLINE;
1375:
1376:
1377: l_proc_name := 'Is_Valid';

Line 1374: l_pkg_end := 'END ' || l_pkg_name || ';' || OE_PC_GLOBALS.NEWLINE;

1370: p_validation_tmplt_short_name;
1371:
1372: l_pkg_spec := 'CREATE OR REPLACE PACKAGE ' || l_pkg_name || ' AS ' || OE_PC_GLOBALS.NEWLINE;
1373: l_pkg_body := 'CREATE OR REPLACE PACKAGE BODY ' || l_pkg_name || ' AS ' || OE_PC_GLOBALS.NEWLINE;
1374: l_pkg_end := 'END ' || l_pkg_name || ';' || OE_PC_GLOBALS.NEWLINE;
1375:
1376:
1377: l_proc_name := 'Is_Valid';
1378: l_proc_spec := ' PROCEDURE ' || l_proc_name || OE_PC_GLOBALS.NEWLINE;

Line 1378: l_proc_spec := ' PROCEDURE ' || l_proc_name || OE_PC_GLOBALS.NEWLINE;

1374: l_pkg_end := 'END ' || l_pkg_name || ';' || OE_PC_GLOBALS.NEWLINE;
1375:
1376:
1377: l_proc_name := 'Is_Valid';
1378: l_proc_spec := ' PROCEDURE ' || l_proc_name || OE_PC_GLOBALS.NEWLINE;
1379: l_proc_spec := l_proc_spec || ' ( ' || OE_PC_GLOBALS.NEWLINE;
1380: l_proc_spec := l_proc_spec || ' p_application_id in number,' || OE_PC_GLOBALS.NEWLINE;
1381: l_proc_spec := l_proc_spec || ' p_entity_short_name in varchar2,' || OE_PC_GLOBALS.NEWLINE;
1382: l_proc_spec := l_proc_spec || ' p_validation_entity_short_name in varchar2, ' || OE_PC_GLOBALS.NEWLINE;

Line 1379: l_proc_spec := l_proc_spec || ' ( ' || OE_PC_GLOBALS.NEWLINE;

1375:
1376:
1377: l_proc_name := 'Is_Valid';
1378: l_proc_spec := ' PROCEDURE ' || l_proc_name || OE_PC_GLOBALS.NEWLINE;
1379: l_proc_spec := l_proc_spec || ' ( ' || OE_PC_GLOBALS.NEWLINE;
1380: l_proc_spec := l_proc_spec || ' p_application_id in number,' || OE_PC_GLOBALS.NEWLINE;
1381: l_proc_spec := l_proc_spec || ' p_entity_short_name in varchar2,' || OE_PC_GLOBALS.NEWLINE;
1382: l_proc_spec := l_proc_spec || ' p_validation_entity_short_name in varchar2, ' || OE_PC_GLOBALS.NEWLINE;
1383: l_proc_spec := l_proc_spec || ' p_validation_tmplt_short_name in varchar2,' || OE_PC_GLOBALS.NEWLINE;

Line 1380: l_proc_spec := l_proc_spec || ' p_application_id in number,' || OE_PC_GLOBALS.NEWLINE;

1376:
1377: l_proc_name := 'Is_Valid';
1378: l_proc_spec := ' PROCEDURE ' || l_proc_name || OE_PC_GLOBALS.NEWLINE;
1379: l_proc_spec := l_proc_spec || ' ( ' || OE_PC_GLOBALS.NEWLINE;
1380: l_proc_spec := l_proc_spec || ' p_application_id in number,' || OE_PC_GLOBALS.NEWLINE;
1381: l_proc_spec := l_proc_spec || ' p_entity_short_name in varchar2,' || OE_PC_GLOBALS.NEWLINE;
1382: l_proc_spec := l_proc_spec || ' p_validation_entity_short_name in varchar2, ' || OE_PC_GLOBALS.NEWLINE;
1383: l_proc_spec := l_proc_spec || ' p_validation_tmplt_short_name in varchar2,' || OE_PC_GLOBALS.NEWLINE;
1384: l_proc_spec := l_proc_spec || ' p_record_set_short_name in varchar2,' || OE_PC_GLOBALS.NEWLINE;

Line 1381: l_proc_spec := l_proc_spec || ' p_entity_short_name in varchar2,' || OE_PC_GLOBALS.NEWLINE;

1377: l_proc_name := 'Is_Valid';
1378: l_proc_spec := ' PROCEDURE ' || l_proc_name || OE_PC_GLOBALS.NEWLINE;
1379: l_proc_spec := l_proc_spec || ' ( ' || OE_PC_GLOBALS.NEWLINE;
1380: l_proc_spec := l_proc_spec || ' p_application_id in number,' || OE_PC_GLOBALS.NEWLINE;
1381: l_proc_spec := l_proc_spec || ' p_entity_short_name in varchar2,' || OE_PC_GLOBALS.NEWLINE;
1382: l_proc_spec := l_proc_spec || ' p_validation_entity_short_name in varchar2, ' || OE_PC_GLOBALS.NEWLINE;
1383: l_proc_spec := l_proc_spec || ' p_validation_tmplt_short_name in varchar2,' || OE_PC_GLOBALS.NEWLINE;
1384: l_proc_spec := l_proc_spec || ' p_record_set_short_name in varchar2,' || OE_PC_GLOBALS.NEWLINE;
1385: l_proc_spec := l_proc_spec || ' p_scope in varchar2,' || OE_PC_GLOBALS.NEWLINE;

Line 1382: l_proc_spec := l_proc_spec || ' p_validation_entity_short_name in varchar2, ' || OE_PC_GLOBALS.NEWLINE;

1378: l_proc_spec := ' PROCEDURE ' || l_proc_name || OE_PC_GLOBALS.NEWLINE;
1379: l_proc_spec := l_proc_spec || ' ( ' || OE_PC_GLOBALS.NEWLINE;
1380: l_proc_spec := l_proc_spec || ' p_application_id in number,' || OE_PC_GLOBALS.NEWLINE;
1381: l_proc_spec := l_proc_spec || ' p_entity_short_name in varchar2,' || OE_PC_GLOBALS.NEWLINE;
1382: l_proc_spec := l_proc_spec || ' p_validation_entity_short_name in varchar2, ' || OE_PC_GLOBALS.NEWLINE;
1383: l_proc_spec := l_proc_spec || ' p_validation_tmplt_short_name in varchar2,' || OE_PC_GLOBALS.NEWLINE;
1384: l_proc_spec := l_proc_spec || ' p_record_set_short_name in varchar2,' || OE_PC_GLOBALS.NEWLINE;
1385: l_proc_spec := l_proc_spec || ' p_scope in varchar2,' || OE_PC_GLOBALS.NEWLINE;
1386: l_proc_spec := l_proc_spec || ' x_result out nocopy number' || OE_PC_GLOBALS.NEWLINE;

Line 1383: l_proc_spec := l_proc_spec || ' p_validation_tmplt_short_name in varchar2,' || OE_PC_GLOBALS.NEWLINE;

1379: l_proc_spec := l_proc_spec || ' ( ' || OE_PC_GLOBALS.NEWLINE;
1380: l_proc_spec := l_proc_spec || ' p_application_id in number,' || OE_PC_GLOBALS.NEWLINE;
1381: l_proc_spec := l_proc_spec || ' p_entity_short_name in varchar2,' || OE_PC_GLOBALS.NEWLINE;
1382: l_proc_spec := l_proc_spec || ' p_validation_entity_short_name in varchar2, ' || OE_PC_GLOBALS.NEWLINE;
1383: l_proc_spec := l_proc_spec || ' p_validation_tmplt_short_name in varchar2,' || OE_PC_GLOBALS.NEWLINE;
1384: l_proc_spec := l_proc_spec || ' p_record_set_short_name in varchar2,' || OE_PC_GLOBALS.NEWLINE;
1385: l_proc_spec := l_proc_spec || ' p_scope in varchar2,' || OE_PC_GLOBALS.NEWLINE;
1386: l_proc_spec := l_proc_spec || ' x_result out nocopy number' || OE_PC_GLOBALS.NEWLINE;
1387:

Line 1384: l_proc_spec := l_proc_spec || ' p_record_set_short_name in varchar2,' || OE_PC_GLOBALS.NEWLINE;

1380: l_proc_spec := l_proc_spec || ' p_application_id in number,' || OE_PC_GLOBALS.NEWLINE;
1381: l_proc_spec := l_proc_spec || ' p_entity_short_name in varchar2,' || OE_PC_GLOBALS.NEWLINE;
1382: l_proc_spec := l_proc_spec || ' p_validation_entity_short_name in varchar2, ' || OE_PC_GLOBALS.NEWLINE;
1383: l_proc_spec := l_proc_spec || ' p_validation_tmplt_short_name in varchar2,' || OE_PC_GLOBALS.NEWLINE;
1384: l_proc_spec := l_proc_spec || ' p_record_set_short_name in varchar2,' || OE_PC_GLOBALS.NEWLINE;
1385: l_proc_spec := l_proc_spec || ' p_scope in varchar2,' || OE_PC_GLOBALS.NEWLINE;
1386: l_proc_spec := l_proc_spec || ' x_result out nocopy number' || OE_PC_GLOBALS.NEWLINE;
1387:
1388: l_proc_spec := l_proc_spec || ' )';

Line 1385: l_proc_spec := l_proc_spec || ' p_scope in varchar2,' || OE_PC_GLOBALS.NEWLINE;

1381: l_proc_spec := l_proc_spec || ' p_entity_short_name in varchar2,' || OE_PC_GLOBALS.NEWLINE;
1382: l_proc_spec := l_proc_spec || ' p_validation_entity_short_name in varchar2, ' || OE_PC_GLOBALS.NEWLINE;
1383: l_proc_spec := l_proc_spec || ' p_validation_tmplt_short_name in varchar2,' || OE_PC_GLOBALS.NEWLINE;
1384: l_proc_spec := l_proc_spec || ' p_record_set_short_name in varchar2,' || OE_PC_GLOBALS.NEWLINE;
1385: l_proc_spec := l_proc_spec || ' p_scope in varchar2,' || OE_PC_GLOBALS.NEWLINE;
1386: l_proc_spec := l_proc_spec || ' x_result out nocopy number' || OE_PC_GLOBALS.NEWLINE;
1387:
1388: l_proc_spec := l_proc_spec || ' )';
1389:

Line 1386: l_proc_spec := l_proc_spec || ' x_result out nocopy number' || OE_PC_GLOBALS.NEWLINE;

1382: l_proc_spec := l_proc_spec || ' p_validation_entity_short_name in varchar2, ' || OE_PC_GLOBALS.NEWLINE;
1383: l_proc_spec := l_proc_spec || ' p_validation_tmplt_short_name in varchar2,' || OE_PC_GLOBALS.NEWLINE;
1384: l_proc_spec := l_proc_spec || ' p_record_set_short_name in varchar2,' || OE_PC_GLOBALS.NEWLINE;
1385: l_proc_spec := l_proc_spec || ' p_scope in varchar2,' || OE_PC_GLOBALS.NEWLINE;
1386: l_proc_spec := l_proc_spec || ' x_result out nocopy number' || OE_PC_GLOBALS.NEWLINE;
1387:
1388: l_proc_spec := l_proc_spec || ' )';
1389:
1390: -- add a ; to end the PROCEDURE specs

Line 1391: l_pkg_spec := l_pkg_spec || l_proc_spec || ';' || OE_PC_GLOBALS.NEWLINE;

1387:
1388: l_proc_spec := l_proc_spec || ' )';
1389:
1390: -- add a ; to end the PROCEDURE specs
1391: l_pkg_spec := l_pkg_spec || l_proc_spec || ';' || OE_PC_GLOBALS.NEWLINE;
1392:
1393:
1394: -- continue building procedure body
1395: l_pkg_body := l_pkg_body || l_proc_spec || OE_PC_GLOBALS.NEWLINE || ' IS ' || OE_PC_GLOBALS.NEWLINE;

Line 1395: l_pkg_body := l_pkg_body || l_proc_spec || OE_PC_GLOBALS.NEWLINE || ' IS ' || OE_PC_GLOBALS.NEWLINE;

1391: l_pkg_spec := l_pkg_spec || l_proc_spec || ';' || OE_PC_GLOBALS.NEWLINE;
1392:
1393:
1394: -- continue building procedure body
1395: l_pkg_body := l_pkg_body || l_proc_spec || OE_PC_GLOBALS.NEWLINE || ' IS ' || OE_PC_GLOBALS.NEWLINE;
1396: -- declare local variables
1397: l_pkg_body := l_pkg_body || ' l_valid_count NUMBER := 0; ' || OE_PC_GLOBALS.NEWLINE;
1398: l_pkg_body := l_pkg_body || ' l_set_count NUMBER := 0; ' || OE_PC_GLOBALS.NEWLINE;
1399:

Line 1397: l_pkg_body := l_pkg_body || ' l_valid_count NUMBER := 0; ' || OE_PC_GLOBALS.NEWLINE;

1393:
1394: -- continue building procedure body
1395: l_pkg_body := l_pkg_body || l_proc_spec || OE_PC_GLOBALS.NEWLINE || ' IS ' || OE_PC_GLOBALS.NEWLINE;
1396: -- declare local variables
1397: l_pkg_body := l_pkg_body || ' l_valid_count NUMBER := 0; ' || OE_PC_GLOBALS.NEWLINE;
1398: l_pkg_body := l_pkg_body || ' l_set_count NUMBER := 0; ' || OE_PC_GLOBALS.NEWLINE;
1399:
1400: -- construct the cursor for validating the conditions as well as to count the number of
1401: -- records in the validated record set

Line 1398: l_pkg_body := l_pkg_body || ' l_set_count NUMBER := 0; ' || OE_PC_GLOBALS.NEWLINE;

1394: -- continue building procedure body
1395: l_pkg_body := l_pkg_body || l_proc_spec || OE_PC_GLOBALS.NEWLINE || ' IS ' || OE_PC_GLOBALS.NEWLINE;
1396: -- declare local variables
1397: l_pkg_body := l_pkg_body || ' l_valid_count NUMBER := 0; ' || OE_PC_GLOBALS.NEWLINE;
1398: l_pkg_body := l_pkg_body || ' l_set_count NUMBER := 0; ' || OE_PC_GLOBALS.NEWLINE;
1399:
1400: -- construct the cursor for validating the conditions as well as to count the number of
1401: -- records in the validated record set
1402: --------------------------------------------------------------------------------------

Line 1420: l_pkg_body := l_pkg_body || ' ' || OE_PC_GLOBALS.NEWLINE;

1416: oe_debug_pub.add( 'MAKE_VALIDATION_CURSORS COMPLETE' , 2 ) ;
1417: END IF;
1418: --
1419:
1420: l_pkg_body := l_pkg_body || ' ' || OE_PC_GLOBALS.NEWLINE;
1421: -- Bug 3739681
1422: IF l_bind_var_stmt IS NOT NULL THEN
1423: l_pkg_body := l_pkg_body || l_bind_var_stmt || OE_PC_GLOBALS.NEWLINE;
1424: END IF;

Line 1423: l_pkg_body := l_pkg_body || l_bind_var_stmt || OE_PC_GLOBALS.NEWLINE;

1419:
1420: l_pkg_body := l_pkg_body || ' ' || OE_PC_GLOBALS.NEWLINE;
1421: -- Bug 3739681
1422: IF l_bind_var_stmt IS NOT NULL THEN
1423: l_pkg_body := l_pkg_body || l_bind_var_stmt || OE_PC_GLOBALS.NEWLINE;
1424: END IF;
1425: IF l_valid_count_cursor IS NOT NULL THEN
1426: l_pkg_body := l_pkg_body || l_valid_count_cursor || OE_PC_GLOBALS.NEWLINE;
1427: END IF;

Line 1426: l_pkg_body := l_pkg_body || l_valid_count_cursor || OE_PC_GLOBALS.NEWLINE;

1422: IF l_bind_var_stmt IS NOT NULL THEN
1423: l_pkg_body := l_pkg_body || l_bind_var_stmt || OE_PC_GLOBALS.NEWLINE;
1424: END IF;
1425: IF l_valid_count_cursor IS NOT NULL THEN
1426: l_pkg_body := l_pkg_body || l_valid_count_cursor || OE_PC_GLOBALS.NEWLINE;
1427: END IF;
1428: l_pkg_body := l_pkg_body || ' ' || OE_PC_GLOBALS.NEWLINE;
1429: l_pkg_body := l_pkg_body || l_set_count_cursor || OE_PC_GLOBALS.NEWLINE;
1430: l_pkg_body := l_pkg_body || ' ' || OE_PC_GLOBALS.NEWLINE;

Line 1428: l_pkg_body := l_pkg_body || ' ' || OE_PC_GLOBALS.NEWLINE;

1424: END IF;
1425: IF l_valid_count_cursor IS NOT NULL THEN
1426: l_pkg_body := l_pkg_body || l_valid_count_cursor || OE_PC_GLOBALS.NEWLINE;
1427: END IF;
1428: l_pkg_body := l_pkg_body || ' ' || OE_PC_GLOBALS.NEWLINE;
1429: l_pkg_body := l_pkg_body || l_set_count_cursor || OE_PC_GLOBALS.NEWLINE;
1430: l_pkg_body := l_pkg_body || ' ' || OE_PC_GLOBALS.NEWLINE;
1431:
1432: l_pkg_body := l_pkg_body || 'BEGIN ' || OE_PC_GLOBALS.NEWLINE;

Line 1429: l_pkg_body := l_pkg_body || l_set_count_cursor || OE_PC_GLOBALS.NEWLINE;

1425: IF l_valid_count_cursor IS NOT NULL THEN
1426: l_pkg_body := l_pkg_body || l_valid_count_cursor || OE_PC_GLOBALS.NEWLINE;
1427: END IF;
1428: l_pkg_body := l_pkg_body || ' ' || OE_PC_GLOBALS.NEWLINE;
1429: l_pkg_body := l_pkg_body || l_set_count_cursor || OE_PC_GLOBALS.NEWLINE;
1430: l_pkg_body := l_pkg_body || ' ' || OE_PC_GLOBALS.NEWLINE;
1431:
1432: l_pkg_body := l_pkg_body || 'BEGIN ' || OE_PC_GLOBALS.NEWLINE;
1433:

Line 1430: l_pkg_body := l_pkg_body || ' ' || OE_PC_GLOBALS.NEWLINE;

1426: l_pkg_body := l_pkg_body || l_valid_count_cursor || OE_PC_GLOBALS.NEWLINE;
1427: END IF;
1428: l_pkg_body := l_pkg_body || ' ' || OE_PC_GLOBALS.NEWLINE;
1429: l_pkg_body := l_pkg_body || l_set_count_cursor || OE_PC_GLOBALS.NEWLINE;
1430: l_pkg_body := l_pkg_body || ' ' || OE_PC_GLOBALS.NEWLINE;
1431:
1432: l_pkg_body := l_pkg_body || 'BEGIN ' || OE_PC_GLOBALS.NEWLINE;
1433:
1434: -- now add the procedure logic

Line 1432: l_pkg_body := l_pkg_body || 'BEGIN ' || OE_PC_GLOBALS.NEWLINE;

1428: l_pkg_body := l_pkg_body || ' ' || OE_PC_GLOBALS.NEWLINE;
1429: l_pkg_body := l_pkg_body || l_set_count_cursor || OE_PC_GLOBALS.NEWLINE;
1430: l_pkg_body := l_pkg_body || ' ' || OE_PC_GLOBALS.NEWLINE;
1431:
1432: l_pkg_body := l_pkg_body || 'BEGIN ' || OE_PC_GLOBALS.NEWLINE;
1433:
1434: -- now add the procedure logic
1435:
1436: -- first let's assume that the validation will be false

Line 1437: l_pkg_body := l_pkg_body || ' x_result := 0; ' || OE_PC_GLOBALS.NEWLINE;

1433:
1434: -- now add the procedure logic
1435:
1436: -- first let's assume that the validation will be false
1437: l_pkg_body := l_pkg_body || ' x_result := 0; ' || OE_PC_GLOBALS.NEWLINE;
1438:
1439: -- execute the validation cursor or the validation statement
1440: IF l_valid_count_cursor IS NOT NULL THEN
1441: l_pkg_body := l_pkg_body || ' OPEN C_VC; ' || OE_PC_GLOBALS.NEWLINE;

Line 1441: l_pkg_body := l_pkg_body || ' OPEN C_VC; ' || OE_PC_GLOBALS.NEWLINE;

1437: l_pkg_body := l_pkg_body || ' x_result := 0; ' || OE_PC_GLOBALS.NEWLINE;
1438:
1439: -- execute the validation cursor or the validation statement
1440: IF l_valid_count_cursor IS NOT NULL THEN
1441: l_pkg_body := l_pkg_body || ' OPEN C_VC; ' || OE_PC_GLOBALS.NEWLINE;
1442: l_pkg_body := l_pkg_body || ' FETCH C_VC into l_valid_count; ' || OE_PC_GLOBALS.NEWLINE;
1443: l_pkg_body := l_pkg_body || ' CLOSE C_VC; ' || OE_PC_GLOBALS.NEWLINE;
1444: ELSIF l_validation_stmt IS NOT NULL THEN
1445: l_pkg_body := l_pkg_body || l_validation_stmt;

Line 1442: l_pkg_body := l_pkg_body || ' FETCH C_VC into l_valid_count; ' || OE_PC_GLOBALS.NEWLINE;

1438:
1439: -- execute the validation cursor or the validation statement
1440: IF l_valid_count_cursor IS NOT NULL THEN
1441: l_pkg_body := l_pkg_body || ' OPEN C_VC; ' || OE_PC_GLOBALS.NEWLINE;
1442: l_pkg_body := l_pkg_body || ' FETCH C_VC into l_valid_count; ' || OE_PC_GLOBALS.NEWLINE;
1443: l_pkg_body := l_pkg_body || ' CLOSE C_VC; ' || OE_PC_GLOBALS.NEWLINE;
1444: ELSIF l_validation_stmt IS NOT NULL THEN
1445: l_pkg_body := l_pkg_body || l_validation_stmt;
1446: l_pkg_body := l_pkg_body || ' THEN ' || OE_PC_GLOBALS.NEWLINE;

Line 1443: l_pkg_body := l_pkg_body || ' CLOSE C_VC; ' || OE_PC_GLOBALS.NEWLINE;

1439: -- execute the validation cursor or the validation statement
1440: IF l_valid_count_cursor IS NOT NULL THEN
1441: l_pkg_body := l_pkg_body || ' OPEN C_VC; ' || OE_PC_GLOBALS.NEWLINE;
1442: l_pkg_body := l_pkg_body || ' FETCH C_VC into l_valid_count; ' || OE_PC_GLOBALS.NEWLINE;
1443: l_pkg_body := l_pkg_body || ' CLOSE C_VC; ' || OE_PC_GLOBALS.NEWLINE;
1444: ELSIF l_validation_stmt IS NOT NULL THEN
1445: l_pkg_body := l_pkg_body || l_validation_stmt;
1446: l_pkg_body := l_pkg_body || ' THEN ' || OE_PC_GLOBALS.NEWLINE;
1447: l_pkg_body := l_pkg_body || ' l_valid_count := 1; '|| OE_PC_GLOBALS.NEWLINE;

Line 1446: l_pkg_body := l_pkg_body || ' THEN ' || OE_PC_GLOBALS.NEWLINE;

1442: l_pkg_body := l_pkg_body || ' FETCH C_VC into l_valid_count; ' || OE_PC_GLOBALS.NEWLINE;
1443: l_pkg_body := l_pkg_body || ' CLOSE C_VC; ' || OE_PC_GLOBALS.NEWLINE;
1444: ELSIF l_validation_stmt IS NOT NULL THEN
1445: l_pkg_body := l_pkg_body || l_validation_stmt;
1446: l_pkg_body := l_pkg_body || ' THEN ' || OE_PC_GLOBALS.NEWLINE;
1447: l_pkg_body := l_pkg_body || ' l_valid_count := 1; '|| OE_PC_GLOBALS.NEWLINE;
1448: l_pkg_body := l_pkg_body || ' END IF;' || OE_PC_GLOBALS.NEWLINE;
1449: END IF;
1450:

Line 1447: l_pkg_body := l_pkg_body || ' l_valid_count := 1; '|| OE_PC_GLOBALS.NEWLINE;

1443: l_pkg_body := l_pkg_body || ' CLOSE C_VC; ' || OE_PC_GLOBALS.NEWLINE;
1444: ELSIF l_validation_stmt IS NOT NULL THEN
1445: l_pkg_body := l_pkg_body || l_validation_stmt;
1446: l_pkg_body := l_pkg_body || ' THEN ' || OE_PC_GLOBALS.NEWLINE;
1447: l_pkg_body := l_pkg_body || ' l_valid_count := 1; '|| OE_PC_GLOBALS.NEWLINE;
1448: l_pkg_body := l_pkg_body || ' END IF;' || OE_PC_GLOBALS.NEWLINE;
1449: END IF;
1450:
1451: l_pkg_body := l_pkg_body || ' If (l_valid_count > 0) then ' || OE_PC_GLOBALS.NEWLINE;

Line 1448: l_pkg_body := l_pkg_body || ' END IF;' || OE_PC_GLOBALS.NEWLINE;

1444: ELSIF l_validation_stmt IS NOT NULL THEN
1445: l_pkg_body := l_pkg_body || l_validation_stmt;
1446: l_pkg_body := l_pkg_body || ' THEN ' || OE_PC_GLOBALS.NEWLINE;
1447: l_pkg_body := l_pkg_body || ' l_valid_count := 1; '|| OE_PC_GLOBALS.NEWLINE;
1448: l_pkg_body := l_pkg_body || ' END IF;' || OE_PC_GLOBALS.NEWLINE;
1449: END IF;
1450:
1451: l_pkg_body := l_pkg_body || ' If (l_valid_count > 0) then ' || OE_PC_GLOBALS.NEWLINE;
1452: if (l_set_count_cursor is not null) then

Line 1451: l_pkg_body := l_pkg_body || ' If (l_valid_count > 0) then ' || OE_PC_GLOBALS.NEWLINE;

1447: l_pkg_body := l_pkg_body || ' l_valid_count := 1; '|| OE_PC_GLOBALS.NEWLINE;
1448: l_pkg_body := l_pkg_body || ' END IF;' || OE_PC_GLOBALS.NEWLINE;
1449: END IF;
1450:
1451: l_pkg_body := l_pkg_body || ' If (l_valid_count > 0) then ' || OE_PC_GLOBALS.NEWLINE;
1452: if (l_set_count_cursor is not null) then
1453: l_pkg_body := l_pkg_body || ' If (p_scope = ' || ''''|| 'ALL' ||'''' || ') then ' || OE_PC_GLOBALS.NEWLINE;
1454: l_pkg_body := l_pkg_body || ' OPEN C_RSC; ' || OE_PC_GLOBALS.NEWLINE;
1455: l_pkg_body := l_pkg_body || ' FETCH C_RSC into l_set_count; ' || OE_PC_GLOBALS.NEWLINE;

Line 1453: l_pkg_body := l_pkg_body || ' If (p_scope = ' || ''''|| 'ALL' ||'''' || ') then ' || OE_PC_GLOBALS.NEWLINE;

1449: END IF;
1450:
1451: l_pkg_body := l_pkg_body || ' If (l_valid_count > 0) then ' || OE_PC_GLOBALS.NEWLINE;
1452: if (l_set_count_cursor is not null) then
1453: l_pkg_body := l_pkg_body || ' If (p_scope = ' || ''''|| 'ALL' ||'''' || ') then ' || OE_PC_GLOBALS.NEWLINE;
1454: l_pkg_body := l_pkg_body || ' OPEN C_RSC; ' || OE_PC_GLOBALS.NEWLINE;
1455: l_pkg_body := l_pkg_body || ' FETCH C_RSC into l_set_count; ' || OE_PC_GLOBALS.NEWLINE;
1456: l_pkg_body := l_pkg_body || ' CLOSE C_RSC; ' || OE_PC_GLOBALS.NEWLINE;
1457: l_pkg_body := l_pkg_body || ' If (l_valid_count = l_set_count) then ' || OE_PC_GLOBALS.NEWLINE;

Line 1454: l_pkg_body := l_pkg_body || ' OPEN C_RSC; ' || OE_PC_GLOBALS.NEWLINE;

1450:
1451: l_pkg_body := l_pkg_body || ' If (l_valid_count > 0) then ' || OE_PC_GLOBALS.NEWLINE;
1452: if (l_set_count_cursor is not null) then
1453: l_pkg_body := l_pkg_body || ' If (p_scope = ' || ''''|| 'ALL' ||'''' || ') then ' || OE_PC_GLOBALS.NEWLINE;
1454: l_pkg_body := l_pkg_body || ' OPEN C_RSC; ' || OE_PC_GLOBALS.NEWLINE;
1455: l_pkg_body := l_pkg_body || ' FETCH C_RSC into l_set_count; ' || OE_PC_GLOBALS.NEWLINE;
1456: l_pkg_body := l_pkg_body || ' CLOSE C_RSC; ' || OE_PC_GLOBALS.NEWLINE;
1457: l_pkg_body := l_pkg_body || ' If (l_valid_count = l_set_count) then ' || OE_PC_GLOBALS.NEWLINE;
1458: l_pkg_body := l_pkg_body || ' x_result := 1; ' || OE_PC_GLOBALS.NEWLINE;

Line 1455: l_pkg_body := l_pkg_body || ' FETCH C_RSC into l_set_count; ' || OE_PC_GLOBALS.NEWLINE;

1451: l_pkg_body := l_pkg_body || ' If (l_valid_count > 0) then ' || OE_PC_GLOBALS.NEWLINE;
1452: if (l_set_count_cursor is not null) then
1453: l_pkg_body := l_pkg_body || ' If (p_scope = ' || ''''|| 'ALL' ||'''' || ') then ' || OE_PC_GLOBALS.NEWLINE;
1454: l_pkg_body := l_pkg_body || ' OPEN C_RSC; ' || OE_PC_GLOBALS.NEWLINE;
1455: l_pkg_body := l_pkg_body || ' FETCH C_RSC into l_set_count; ' || OE_PC_GLOBALS.NEWLINE;
1456: l_pkg_body := l_pkg_body || ' CLOSE C_RSC; ' || OE_PC_GLOBALS.NEWLINE;
1457: l_pkg_body := l_pkg_body || ' If (l_valid_count = l_set_count) then ' || OE_PC_GLOBALS.NEWLINE;
1458: l_pkg_body := l_pkg_body || ' x_result := 1; ' || OE_PC_GLOBALS.NEWLINE;
1459: l_pkg_body := l_pkg_body || ' End If; ' || OE_PC_GLOBALS.NEWLINE;

Line 1456: l_pkg_body := l_pkg_body || ' CLOSE C_RSC; ' || OE_PC_GLOBALS.NEWLINE;

1452: if (l_set_count_cursor is not null) then
1453: l_pkg_body := l_pkg_body || ' If (p_scope = ' || ''''|| 'ALL' ||'''' || ') then ' || OE_PC_GLOBALS.NEWLINE;
1454: l_pkg_body := l_pkg_body || ' OPEN C_RSC; ' || OE_PC_GLOBALS.NEWLINE;
1455: l_pkg_body := l_pkg_body || ' FETCH C_RSC into l_set_count; ' || OE_PC_GLOBALS.NEWLINE;
1456: l_pkg_body := l_pkg_body || ' CLOSE C_RSC; ' || OE_PC_GLOBALS.NEWLINE;
1457: l_pkg_body := l_pkg_body || ' If (l_valid_count = l_set_count) then ' || OE_PC_GLOBALS.NEWLINE;
1458: l_pkg_body := l_pkg_body || ' x_result := 1; ' || OE_PC_GLOBALS.NEWLINE;
1459: l_pkg_body := l_pkg_body || ' End If; ' || OE_PC_GLOBALS.NEWLINE;
1460: l_pkg_body := l_pkg_body || ' Else ' || OE_PC_GLOBALS.NEWLINE;

Line 1457: l_pkg_body := l_pkg_body || ' If (l_valid_count = l_set_count) then ' || OE_PC_GLOBALS.NEWLINE;

1453: l_pkg_body := l_pkg_body || ' If (p_scope = ' || ''''|| 'ALL' ||'''' || ') then ' || OE_PC_GLOBALS.NEWLINE;
1454: l_pkg_body := l_pkg_body || ' OPEN C_RSC; ' || OE_PC_GLOBALS.NEWLINE;
1455: l_pkg_body := l_pkg_body || ' FETCH C_RSC into l_set_count; ' || OE_PC_GLOBALS.NEWLINE;
1456: l_pkg_body := l_pkg_body || ' CLOSE C_RSC; ' || OE_PC_GLOBALS.NEWLINE;
1457: l_pkg_body := l_pkg_body || ' If (l_valid_count = l_set_count) then ' || OE_PC_GLOBALS.NEWLINE;
1458: l_pkg_body := l_pkg_body || ' x_result := 1; ' || OE_PC_GLOBALS.NEWLINE;
1459: l_pkg_body := l_pkg_body || ' End If; ' || OE_PC_GLOBALS.NEWLINE;
1460: l_pkg_body := l_pkg_body || ' Else ' || OE_PC_GLOBALS.NEWLINE;
1461: l_pkg_body := l_pkg_body || ' x_result := 1; ' || OE_PC_GLOBALS.NEWLINE;

Line 1458: l_pkg_body := l_pkg_body || ' x_result := 1; ' || OE_PC_GLOBALS.NEWLINE;

1454: l_pkg_body := l_pkg_body || ' OPEN C_RSC; ' || OE_PC_GLOBALS.NEWLINE;
1455: l_pkg_body := l_pkg_body || ' FETCH C_RSC into l_set_count; ' || OE_PC_GLOBALS.NEWLINE;
1456: l_pkg_body := l_pkg_body || ' CLOSE C_RSC; ' || OE_PC_GLOBALS.NEWLINE;
1457: l_pkg_body := l_pkg_body || ' If (l_valid_count = l_set_count) then ' || OE_PC_GLOBALS.NEWLINE;
1458: l_pkg_body := l_pkg_body || ' x_result := 1; ' || OE_PC_GLOBALS.NEWLINE;
1459: l_pkg_body := l_pkg_body || ' End If; ' || OE_PC_GLOBALS.NEWLINE;
1460: l_pkg_body := l_pkg_body || ' Else ' || OE_PC_GLOBALS.NEWLINE;
1461: l_pkg_body := l_pkg_body || ' x_result := 1; ' || OE_PC_GLOBALS.NEWLINE;
1462: l_pkg_body := l_pkg_body || ' End If; ' || OE_PC_GLOBALS.NEWLINE;

Line 1459: l_pkg_body := l_pkg_body || ' End If; ' || OE_PC_GLOBALS.NEWLINE;

1455: l_pkg_body := l_pkg_body || ' FETCH C_RSC into l_set_count; ' || OE_PC_GLOBALS.NEWLINE;
1456: l_pkg_body := l_pkg_body || ' CLOSE C_RSC; ' || OE_PC_GLOBALS.NEWLINE;
1457: l_pkg_body := l_pkg_body || ' If (l_valid_count = l_set_count) then ' || OE_PC_GLOBALS.NEWLINE;
1458: l_pkg_body := l_pkg_body || ' x_result := 1; ' || OE_PC_GLOBALS.NEWLINE;
1459: l_pkg_body := l_pkg_body || ' End If; ' || OE_PC_GLOBALS.NEWLINE;
1460: l_pkg_body := l_pkg_body || ' Else ' || OE_PC_GLOBALS.NEWLINE;
1461: l_pkg_body := l_pkg_body || ' x_result := 1; ' || OE_PC_GLOBALS.NEWLINE;
1462: l_pkg_body := l_pkg_body || ' End If; ' || OE_PC_GLOBALS.NEWLINE;
1463: else

Line 1460: l_pkg_body := l_pkg_body || ' Else ' || OE_PC_GLOBALS.NEWLINE;

1456: l_pkg_body := l_pkg_body || ' CLOSE C_RSC; ' || OE_PC_GLOBALS.NEWLINE;
1457: l_pkg_body := l_pkg_body || ' If (l_valid_count = l_set_count) then ' || OE_PC_GLOBALS.NEWLINE;
1458: l_pkg_body := l_pkg_body || ' x_result := 1; ' || OE_PC_GLOBALS.NEWLINE;
1459: l_pkg_body := l_pkg_body || ' End If; ' || OE_PC_GLOBALS.NEWLINE;
1460: l_pkg_body := l_pkg_body || ' Else ' || OE_PC_GLOBALS.NEWLINE;
1461: l_pkg_body := l_pkg_body || ' x_result := 1; ' || OE_PC_GLOBALS.NEWLINE;
1462: l_pkg_body := l_pkg_body || ' End If; ' || OE_PC_GLOBALS.NEWLINE;
1463: else
1464: l_pkg_body := l_pkg_body || ' x_result := 1; ' || OE_PC_GLOBALS.NEWLINE;

Line 1461: l_pkg_body := l_pkg_body || ' x_result := 1; ' || OE_PC_GLOBALS.NEWLINE;

1457: l_pkg_body := l_pkg_body || ' If (l_valid_count = l_set_count) then ' || OE_PC_GLOBALS.NEWLINE;
1458: l_pkg_body := l_pkg_body || ' x_result := 1; ' || OE_PC_GLOBALS.NEWLINE;
1459: l_pkg_body := l_pkg_body || ' End If; ' || OE_PC_GLOBALS.NEWLINE;
1460: l_pkg_body := l_pkg_body || ' Else ' || OE_PC_GLOBALS.NEWLINE;
1461: l_pkg_body := l_pkg_body || ' x_result := 1; ' || OE_PC_GLOBALS.NEWLINE;
1462: l_pkg_body := l_pkg_body || ' End If; ' || OE_PC_GLOBALS.NEWLINE;
1463: else
1464: l_pkg_body := l_pkg_body || ' x_result := 1; ' || OE_PC_GLOBALS.NEWLINE;
1465: end if;

Line 1462: l_pkg_body := l_pkg_body || ' End If; ' || OE_PC_GLOBALS.NEWLINE;

1458: l_pkg_body := l_pkg_body || ' x_result := 1; ' || OE_PC_GLOBALS.NEWLINE;
1459: l_pkg_body := l_pkg_body || ' End If; ' || OE_PC_GLOBALS.NEWLINE;
1460: l_pkg_body := l_pkg_body || ' Else ' || OE_PC_GLOBALS.NEWLINE;
1461: l_pkg_body := l_pkg_body || ' x_result := 1; ' || OE_PC_GLOBALS.NEWLINE;
1462: l_pkg_body := l_pkg_body || ' End If; ' || OE_PC_GLOBALS.NEWLINE;
1463: else
1464: l_pkg_body := l_pkg_body || ' x_result := 1; ' || OE_PC_GLOBALS.NEWLINE;
1465: end if;
1466: l_pkg_body := l_pkg_body || ' End If; ' || OE_PC_GLOBALS.NEWLINE;

Line 1464: l_pkg_body := l_pkg_body || ' x_result := 1; ' || OE_PC_GLOBALS.NEWLINE;

1460: l_pkg_body := l_pkg_body || ' Else ' || OE_PC_GLOBALS.NEWLINE;
1461: l_pkg_body := l_pkg_body || ' x_result := 1; ' || OE_PC_GLOBALS.NEWLINE;
1462: l_pkg_body := l_pkg_body || ' End If; ' || OE_PC_GLOBALS.NEWLINE;
1463: else
1464: l_pkg_body := l_pkg_body || ' x_result := 1; ' || OE_PC_GLOBALS.NEWLINE;
1465: end if;
1466: l_pkg_body := l_pkg_body || ' End If; ' || OE_PC_GLOBALS.NEWLINE;
1467: l_pkg_body := l_pkg_body || ' Return; ' || OE_PC_GLOBALS.NEWLINE;
1468: l_pkg_body := l_pkg_body || 'END ' || l_proc_name || ';' || OE_PC_GLOBALS.NEWLINE;

Line 1466: l_pkg_body := l_pkg_body || ' End If; ' || OE_PC_GLOBALS.NEWLINE;

1462: l_pkg_body := l_pkg_body || ' End If; ' || OE_PC_GLOBALS.NEWLINE;
1463: else
1464: l_pkg_body := l_pkg_body || ' x_result := 1; ' || OE_PC_GLOBALS.NEWLINE;
1465: end if;
1466: l_pkg_body := l_pkg_body || ' End If; ' || OE_PC_GLOBALS.NEWLINE;
1467: l_pkg_body := l_pkg_body || ' Return; ' || OE_PC_GLOBALS.NEWLINE;
1468: l_pkg_body := l_pkg_body || 'END ' || l_proc_name || ';' || OE_PC_GLOBALS.NEWLINE;
1469:
1470: l_pkg_spec := l_pkg_spec || OE_PC_GLOBALS.NEWLINE || l_pkg_end || OE_PC_GLOBALS.NEWLINE;

Line 1467: l_pkg_body := l_pkg_body || ' Return; ' || OE_PC_GLOBALS.NEWLINE;

1463: else
1464: l_pkg_body := l_pkg_body || ' x_result := 1; ' || OE_PC_GLOBALS.NEWLINE;
1465: end if;
1466: l_pkg_body := l_pkg_body || ' End If; ' || OE_PC_GLOBALS.NEWLINE;
1467: l_pkg_body := l_pkg_body || ' Return; ' || OE_PC_GLOBALS.NEWLINE;
1468: l_pkg_body := l_pkg_body || 'END ' || l_proc_name || ';' || OE_PC_GLOBALS.NEWLINE;
1469:
1470: l_pkg_spec := l_pkg_spec || OE_PC_GLOBALS.NEWLINE || l_pkg_end || OE_PC_GLOBALS.NEWLINE;
1471: l_pkg_body := l_pkg_body || OE_PC_GLOBALS.NEWLINE || l_pkg_end || OE_PC_GLOBALS.NEWLINE;

Line 1468: l_pkg_body := l_pkg_body || 'END ' || l_proc_name || ';' || OE_PC_GLOBALS.NEWLINE;

1464: l_pkg_body := l_pkg_body || ' x_result := 1; ' || OE_PC_GLOBALS.NEWLINE;
1465: end if;
1466: l_pkg_body := l_pkg_body || ' End If; ' || OE_PC_GLOBALS.NEWLINE;
1467: l_pkg_body := l_pkg_body || ' Return; ' || OE_PC_GLOBALS.NEWLINE;
1468: l_pkg_body := l_pkg_body || 'END ' || l_proc_name || ';' || OE_PC_GLOBALS.NEWLINE;
1469:
1470: l_pkg_spec := l_pkg_spec || OE_PC_GLOBALS.NEWLINE || l_pkg_end || OE_PC_GLOBALS.NEWLINE;
1471: l_pkg_body := l_pkg_body || OE_PC_GLOBALS.NEWLINE || l_pkg_end || OE_PC_GLOBALS.NEWLINE;
1472:

Line 1470: l_pkg_spec := l_pkg_spec || OE_PC_GLOBALS.NEWLINE || l_pkg_end || OE_PC_GLOBALS.NEWLINE;

1466: l_pkg_body := l_pkg_body || ' End If; ' || OE_PC_GLOBALS.NEWLINE;
1467: l_pkg_body := l_pkg_body || ' Return; ' || OE_PC_GLOBALS.NEWLINE;
1468: l_pkg_body := l_pkg_body || 'END ' || l_proc_name || ';' || OE_PC_GLOBALS.NEWLINE;
1469:
1470: l_pkg_spec := l_pkg_spec || OE_PC_GLOBALS.NEWLINE || l_pkg_end || OE_PC_GLOBALS.NEWLINE;
1471: l_pkg_body := l_pkg_body || OE_PC_GLOBALS.NEWLINE || l_pkg_end || OE_PC_GLOBALS.NEWLINE;
1472:
1473: -- create the SQL to insert/update a record into OE_PC_VALIDATION_PKGS to timestamp the
1474: -- generated Package.

Line 1471: l_pkg_body := l_pkg_body || OE_PC_GLOBALS.NEWLINE || l_pkg_end || OE_PC_GLOBALS.NEWLINE;

1467: l_pkg_body := l_pkg_body || ' Return; ' || OE_PC_GLOBALS.NEWLINE;
1468: l_pkg_body := l_pkg_body || 'END ' || l_proc_name || ';' || OE_PC_GLOBALS.NEWLINE;
1469:
1470: l_pkg_spec := l_pkg_spec || OE_PC_GLOBALS.NEWLINE || l_pkg_end || OE_PC_GLOBALS.NEWLINE;
1471: l_pkg_body := l_pkg_body || OE_PC_GLOBALS.NEWLINE || l_pkg_end || OE_PC_GLOBALS.NEWLINE;
1472:
1473: -- create the SQL to insert/update a record into OE_PC_VALIDATION_PKGS to timestamp the
1474: -- generated Package.
1475: --------------------------------------------------------------------------------------

Line 1525: AND c.constrained_operation = OE_PC_GLOBALS.UPDATE_OP

1521: c.constraint_id, c.entity_id
1522: ,c.on_operation_action, c.column_name
1523: FROM oe_pc_constraints c
1524: WHERE c.entity_id = P_ENTITY_ID
1525: AND c.constrained_operation = OE_PC_GLOBALS.UPDATE_OP
1526: AND c.check_on_insert_flag = 'Y'
1527: AND nvl(c.enabled_flag, 'Y') = 'Y'
1528: AND EXISTS (
1529: SELECT 'EXISTS'

Line 1848: l_ConstrainedStatus := OE_PC_GLOBALS.NO;

1844: IF l_debug_level > 0 THEN
1845: oe_debug_pub.add( 'CONSTRAINT ID:'||P_CONSTRAINT_ID , 5 ) ;
1846: END IF;
1847:
1848: l_ConstrainedStatus := OE_PC_GLOBALS.NO;
1849: l_rule_count := 0;
1850: i := 0;
1851: l_currGrpNumber := -1;
1852: l_currGrpResult := FALSE;

Line 1881: -- to TRUE (OE_PC_GLOBALS.YES) then no need to evaluvate this group.

1877: IF (l_currGrpNumber <> l_constraintRuleRec.group_number) THEN
1878:
1879: -- we are entering the new group of conditions..
1880: -- groups are ORd together, so if the previous group was evaluated
1881: -- to TRUE (OE_PC_GLOBALS.YES) then no need to evaluvate this group.
1882: IF (l_currGrpResult = TRUE) THEN
1883: l_ConstrainedStatus := OE_PC_GLOBALS.YES;
1884: EXIT; -- exit the loop
1885: END IF;

Line 1883: l_ConstrainedStatus := OE_PC_GLOBALS.YES;

1879: -- we are entering the new group of conditions..
1880: -- groups are ORd together, so if the previous group was evaluated
1881: -- to TRUE (OE_PC_GLOBALS.YES) then no need to evaluvate this group.
1882: IF (l_currGrpResult = TRUE) THEN
1883: l_ConstrainedStatus := OE_PC_GLOBALS.YES;
1884: EXIT; -- exit the loop
1885: END IF;
1886:
1887: -- previous group did not evaluvate to TRUE, so lets pursue this new group

Line 1977: if(l_constraintRuleRec.modifier_flag = OE_PC_GLOBALS.YES_FLAG) then

1973: l_tempResult := TRUE;
1974: END IF;
1975:
1976: -- apply the modifier on the result
1977: if(l_constraintRuleRec.modifier_flag = OE_PC_GLOBALS.YES_FLAG) then
1978: l_tempResult := NOT(l_tempResult);
1979: end if;
1980:
1981: IF (i = 0) THEN

Line 1994: l_ConstrainedStatus := OE_PC_GLOBALS.YES;

1990:
1991: END LOOP; -- end validatate validators
1992:
1993: IF (l_currGrpNumber <> -1 AND l_currGrpResult = TRUE) THEN
1994: l_ConstrainedStatus := OE_PC_GLOBALS.YES;
1995: END IF;
1996:
1997: <>
1998: -- did we validate any constraint rules?. if there is none then the

Line 2003: x_result := OE_PC_GLOBALS.YES;

1999: -- constraint is valid and we will return YES
2000: IF (l_rule_count = 0) THEN
2001: x_condition_count := 0;
2002: x_valid_condition_group := -1;
2003: x_result := OE_PC_GLOBALS.YES;
2004: ELSE
2005: x_condition_count := l_rule_count;
2006: x_valid_condition_group := l_currGrpNumber;
2007: x_result := l_ConstrainedStatus;

Line 2012: x_result := OE_PC_GLOBALS.ERROR;

2008: END IF;
2009:
2010: EXCEPTION
2011: WHEN OTHERS THEN
2012: x_result := OE_PC_GLOBALS.ERROR;
2013: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2014: OE_MSG_PUB.Add_Exc_Msg
2015: ( G_PKG_NAME
2016: , 'Validate_Constraint : '||l_constraintRuleRec.validation_pkg

Line 2066: AND c.constrained_operation = OE_PC_GLOBALS.CREATE_OP

2062: c.constraint_id, c.entity_id
2063: ,c.on_operation_action, c.column_name
2064: FROM oe_pc_constraints c
2065: WHERE c.entity_id = P_ENTITY_ID
2066: AND c.constrained_operation = OE_PC_GLOBALS.CREATE_OP
2067: AND EXISTS (
2068: SELECT 'EXISTS'
2069: FROM OE_PC_ASSIGNMENTS A
2070: WHERE a.constraint_id = c.constraint_id

Line 2097: AND c.constrained_operation = OE_PC_GLOBALS.UPDATE_OP

2093: c.constraint_id, c.entity_id
2094: ,c.on_operation_action, c.column_name
2095: FROM oe_pc_constraints c
2096: WHERE c.entity_id = P_ENTITY_ID
2097: AND c.constrained_operation = OE_PC_GLOBALS.UPDATE_OP
2098: -- if p_column_name is NULL then check only for constraints with NULL column
2099: -- name
2100: -- if check_all_cols_constraint = 'N', then check for constraint with
2101: -- column_name = p_column_name (do not check for NULL column_name) but

Line 2173: l_validation_result := OE_PC_GLOBALS.NO;

2169: IF l_debug_level > 0 THEN
2170: oe_debug_pub.add( 'ENTER OE_PC_CONSTRAINTS_ADMIN_PVT.IS_OP_CONSTRAINED , COLUMN:' || P_COLUMN_NAME , 1 ) ;
2171: END IF;
2172:
2173: l_validation_result := OE_PC_GLOBALS.NO;
2174:
2175: -- IF OPERATION IS CREATE
2176: IF p_operation = OE_PC_GLOBALS.CREATE_OP THEN
2177:

Line 2176: IF p_operation = OE_PC_GLOBALS.CREATE_OP THEN

2172:
2173: l_validation_result := OE_PC_GLOBALS.NO;
2174:
2175: -- IF OPERATION IS CREATE
2176: IF p_operation = OE_PC_GLOBALS.CREATE_OP THEN
2177:
2178: -- FIRST, check for generic (not column-specific) CREATE constraints
2179:
2180: IF (p_check_all_cols_constraint = 'Y'

Line 2199: OR l_validation_result = OE_PC_GLOBALS.YES) then

2195: ,x_valid_condition_group => l_valid_condition_group
2196: ,x_result => l_validation_result
2197: );
2198: IF (l_condition_count = 0
2199: OR l_validation_result = OE_PC_GLOBALS.YES) then
2200: l_column_name := t_column_names(i);
2201: x_constraint_id := t_constraint_ids(i);
2202: x_on_operation_action := t_on_operation_actions(i);
2203: x_constraining_conditions_grp := l_valid_condition_group;

Line 2245: OR l_validation_result = OE_PC_GLOBALS.YES) then

2241: ,x_valid_condition_group => l_valid_condition_group
2242: ,x_result => l_validation_result
2243: );
2244: IF (l_condition_count = 0
2245: OR l_validation_result = OE_PC_GLOBALS.YES) then
2246: l_column_name := G_Check_On_Insert_Cache(l_index).column_name;
2247: x_constraint_id := G_Check_On_Insert_Cache(l_index).constraint_id;
2248: x_on_operation_action := G_Check_On_Insert_Cache(l_index).on_operation_action;
2249: x_constraining_conditions_grp := l_valid_condition_group;

Line 2260: ELSIF p_operation = OE_PC_GLOBALS.UPDATE_OP THEN

2256:
2257: END LOOP;
2258:
2259: -- IF OPERATION IS UPDATE
2260: ELSIF p_operation = OE_PC_GLOBALS.UPDATE_OP THEN
2261:
2262: OPEN c_update_op;
2263: FETCH c_update_op BULK COLLECT INTO t_constraint_ids,
2264: t_entity_ids,

Line 2278: OR l_validation_result = OE_PC_GLOBALS.YES) then

2274: ,x_valid_condition_group => l_valid_condition_group
2275: ,x_result => l_validation_result
2276: );
2277: IF (l_condition_count = 0
2278: OR l_validation_result = OE_PC_GLOBALS.YES) then
2279: l_column_name := t_column_names(i);
2280: x_constraint_id := t_constraint_ids(i);
2281: x_on_operation_action := t_on_operation_actions(i);
2282: x_constraining_conditions_grp := l_valid_condition_group;

Line 2306: OR l_validation_result = OE_PC_GLOBALS.YES) then

2302: ,x_valid_condition_group => l_valid_condition_group
2303: ,x_result => l_validation_result
2304: );
2305: IF (l_condition_count = 0
2306: OR l_validation_result = OE_PC_GLOBALS.YES) then
2307: l_column_name := t_column_names(i);
2308: x_constraint_id := t_constraint_ids(i);
2309: x_on_operation_action := t_on_operation_actions(i);
2310: x_constraining_conditions_grp := l_valid_condition_group;

Line 2320: IF l_validation_result = OE_PC_GLOBALS.YES THEN

2316:
2317: <>
2318:
2319: -- Add message to the stack if the operation IS constrained!
2320: IF l_validation_result = OE_PC_GLOBALS.YES THEN
2321:
2322: SELECT database_object_name
2323: INTO l_db_object_name
2324: FROM oe_ak_objects_ext

Line 2358: RETURN OE_PC_GLOBALS.ERROR;

2354: ( G_PKG_NAME
2355: , 'Is_Op_Constrained'
2356: );
2357: END IF;
2358: RETURN OE_PC_GLOBALS.ERROR;
2359: END Is_Op_Constrained;
2360:
2361: END Oe_PC_Constraints_Admin_Pvt;