DBA Data[Home] [Help]

APPS.CS_TP_TEMPLATES_PKG dependencies on CS_TP_TEMPLATES_PKG

Line 1: package body CS_TP_TEMPLATES_PKG as

1: package body CS_TP_TEMPLATES_PKG as
2: /* $Header: cstptemb.pls 115.9 2002/12/04 18:52:53 wzli noship $ */
3: /*==========================================================================+
4: | Copyright (c) 1997 Oracle Corporation Redwood Shores, California, USA |
5: | All rights reserved. |

Line 9: | PL/SQL body for package: CS_TP_TEMPLATES_PKG |

5: | All rights reserved. |
6: +==========================================================================+
7: | FILENAME |
8: | DESCRIPTION |
9: | PL/SQL body for package: CS_TP_TEMPLATES_PKG |
10: | |
11: | HISTORY |
12: | 03-11-2002 Adding two new column: UNI_QUESTION_NOTE_FLAG, |
13: | UNI_QUESTION_NOTE_TYPE |

Line 555: CS_TP_TEMPLATES_PKG.Update_Row(

551: l_default_flag := x_default_flag;
552: l_start_date_active := x_start_date_active;
553: l_end_date_active := x_end_date_active;
554:
555: CS_TP_TEMPLATES_PKG.Update_Row(
556: X_TEMPLATE_ID => x_template_id,
557: X_DEFAULT_FLAG => l_default_flag,
558: X_START_DATE_ACTIVE => l_start_date_active ,
559: X_END_DATE_ACTIVE => l_end_date_active,

Line 570: CS_TP_TEMPLATES_PKG.Insert_Row(

566: X_UNI_QUESTION_NOTE_TYPE => X_UNI_QUESTION_NOTE_TYPE );
567:
568: exception
569: when no_data_found then
570: CS_TP_TEMPLATES_PKG.Insert_Row(
571: X_Rowid => l_rowid,
572: X_TEMPLATE_ID => x_template_id,
573: X_DEFAULT_FLAG => l_default_flag,
574: X_START_DATE_ACTIVE => l_start_date_active,

Line 619: end CS_TP_TEMPLATES_PKG;

615: when no_data_found then null;
616:
617: end;
618:
619: end CS_TP_TEMPLATES_PKG;