12:
13: FUNCTION Is_Op_Constrained
14: ( p_operation IN VARCHAR2
15: , p_column_name IN VARCHAR2 DEFAULT NULL
16: , p_record IN OE_AK_HEADER_SCREDITS_V%ROWTYPE
17: , x_on_operation_action OUT NOCOPY NUMBER
18:
19: ) RETURN NUMBER IS
20: l_constraint_id NUMBER;
166: -- Start of fix #1459428 for function definition
167:
168: FUNCTION ATTRIBUTE1
169: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
170: , p_record IN OE_AK_HEADER_SCREDITS_V%ROWTYPE
171: , x_on_operation_action OUT NOCOPY NUMBER
172:
173: ) RETURN NUMBER
174: IS
191:
192:
193: FUNCTION ATTRIBUTE10
194: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
195: , p_record IN OE_AK_HEADER_SCREDITS_V%ROWTYPE
196: , x_on_operation_action OUT NOCOPY NUMBER
197:
198: ) RETURN NUMBER
199: IS
216:
217:
218: FUNCTION ATTRIBUTE11
219: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
220: , p_record IN OE_AK_HEADER_SCREDITS_V%ROWTYPE
221: , x_on_operation_action OUT NOCOPY NUMBER
222:
223: ) RETURN NUMBER
224: IS
241:
242:
243: FUNCTION ATTRIBUTE12
244: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
245: , p_record IN OE_AK_HEADER_SCREDITS_V%ROWTYPE
246: , x_on_operation_action OUT NOCOPY NUMBER
247:
248: ) RETURN NUMBER
249: IS
266:
267:
268: FUNCTION ATTRIBUTE13
269: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
270: , p_record IN OE_AK_HEADER_SCREDITS_V%ROWTYPE
271: , x_on_operation_action OUT NOCOPY NUMBER
272:
273: ) RETURN NUMBER
274: IS
291:
292:
293: FUNCTION ATTRIBUTE14
294: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
295: , p_record IN OE_AK_HEADER_SCREDITS_V%ROWTYPE
296: , x_on_operation_action OUT NOCOPY NUMBER
297:
298: ) RETURN NUMBER
299: IS
316:
317:
318: FUNCTION ATTRIBUTE15
319: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
320: , p_record IN OE_AK_HEADER_SCREDITS_V%ROWTYPE
321: , x_on_operation_action OUT NOCOPY NUMBER
322:
323: ) RETURN NUMBER
324: IS
341:
342:
343: FUNCTION ATTRIBUTE2
344: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
345: , p_record IN OE_AK_HEADER_SCREDITS_V%ROWTYPE
346: , x_on_operation_action OUT NOCOPY NUMBER
347:
348: ) RETURN NUMBER
349: IS
366:
367:
368: FUNCTION ATTRIBUTE3
369: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
370: , p_record IN OE_AK_HEADER_SCREDITS_V%ROWTYPE
371: , x_on_operation_action OUT NOCOPY NUMBER
372:
373: ) RETURN NUMBER
374: IS
391:
392:
393: FUNCTION ATTRIBUTE4
394: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
395: , p_record IN OE_AK_HEADER_SCREDITS_V%ROWTYPE
396: , x_on_operation_action OUT NOCOPY NUMBER
397:
398: ) RETURN NUMBER
399: IS
416:
417:
418: FUNCTION ATTRIBUTE5
419: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
420: , p_record IN OE_AK_HEADER_SCREDITS_V%ROWTYPE
421: , x_on_operation_action OUT NOCOPY NUMBER
422:
423: ) RETURN NUMBER
424: IS
441:
442:
443: FUNCTION ATTRIBUTE6
444: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
445: , p_record IN OE_AK_HEADER_SCREDITS_V%ROWTYPE
446: , x_on_operation_action OUT NOCOPY NUMBER
447:
448: ) RETURN NUMBER
449: IS
466:
467:
468: FUNCTION ATTRIBUTE7
469: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
470: , p_record IN OE_AK_HEADER_SCREDITS_V%ROWTYPE
471: , x_on_operation_action OUT NOCOPY NUMBER
472:
473: ) RETURN NUMBER
474: IS
491:
492:
493: FUNCTION ATTRIBUTE8
494: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
495: , p_record IN OE_AK_HEADER_SCREDITS_V%ROWTYPE
496: , x_on_operation_action OUT NOCOPY NUMBER
497:
498: ) RETURN NUMBER
499: IS
516:
517:
518: FUNCTION ATTRIBUTE9
519: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
520: , p_record IN OE_AK_HEADER_SCREDITS_V%ROWTYPE
521: , x_on_operation_action OUT NOCOPY NUMBER
522:
523: ) RETURN NUMBER
524: IS
541:
542:
543: FUNCTION CONTEXT
544: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
545: , p_record IN OE_AK_HEADER_SCREDITS_V%ROWTYPE
546: , x_on_operation_action OUT NOCOPY NUMBER
547:
548: ) RETURN NUMBER
549: IS
567: -- End of fix #1459428 for function definition
568:
569: FUNCTION CREATED_BY
570: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
571: , p_record IN OE_AK_HEADER_SCREDITS_V%ROWTYPE
572: , x_on_operation_action OUT NOCOPY NUMBER
573:
574: ) RETURN NUMBER
575: IS
592:
593:
594: FUNCTION DW_UPDATE_ADVICE
595: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
596: , p_record IN OE_AK_HEADER_SCREDITS_V%ROWTYPE
597: , x_on_operation_action OUT NOCOPY NUMBER
598:
599: ) RETURN NUMBER
600: IS
617:
618:
619: FUNCTION PERCENT
620: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
621: , p_record IN OE_AK_HEADER_SCREDITS_V%ROWTYPE
622: , x_on_operation_action OUT NOCOPY NUMBER
623:
624: ) RETURN NUMBER
625: IS
643:
644:
645: FUNCTION SALESREP
646: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
647: , p_record IN OE_AK_HEADER_SCREDITS_V%ROWTYPE
648: , x_on_operation_action OUT NOCOPY NUMBER
649:
650: ) RETURN NUMBER
651: IS
667: END SALESREP;
668:
669: FUNCTION sales_credit_type
670: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
671: , p_record IN OE_AK_HEADER_SCREDITS_V%ROWTYPE
672: , x_on_operation_action OUT NOCOPY NUMBER
673:
674: ) RETURN NUMBER
675: IS
691: END sales_credit_type;
692:
693: FUNCTION WH_UPDATE_DATE
694: ( p_operation IN VARCHAR2 DEFAULT OE_PC_GLOBALS.UPDATE_OP
695: , p_record IN OE_AK_HEADER_SCREDITS_V%ROWTYPE
696: , x_on_operation_action OUT NOCOPY NUMBER
697:
698: ) RETURN NUMBER
699: IS
723:
724: ) IS
725: l_operation VARCHAR2(1);
726: l_on_operation_action NUMBER;
727: l_rowtype_rec OE_AK_HEADER_SCREDITS_V%ROWTYPE;
728: --
729: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
730: --
731: BEGIN
790: ) IS
791: l_operation VARCHAR2(1);
792: l_on_operation_action NUMBER;
793: l_result NUMBER;
794: l_rowtype_rec OE_AK_HEADER_SCREDITS_V%ROWTYPE;
795: l_column_name VARCHAR2(30);
796: l_check_all_cols_constraint VARCHAR2(1);
797: --
798: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;