eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_TASK_TEMPLATES_PUB SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 264


            SELECT 1
              FROM jtf_task_templates_b
             WHERE task_template_id = x_task_id;

Line: 763


    PROCEDURE update_task (
        p_api_version             IN       NUMBER,
        p_init_msg_list           IN       VARCHAR2 DEFAULT fnd_api.g_false,
        p_commit                  IN       VARCHAR2 DEFAULT fnd_api.g_false,
        p_object_version_number   IN     OUT NOCOPY NUMBER ,
        p_task_id                 IN       NUMBER DEFAULT fnd_api.g_miss_num,
        p_task_number             IN       VARCHAR2 DEFAULT fnd_api.g_miss_char,
        p_task_group_id           IN       NUMBER DEFAULT fnd_api.g_miss_num,
        p_task_name               IN       VARCHAR2 DEFAULT fnd_api.g_miss_char,
        p_task_type_name          IN       VARCHAR2 DEFAULT fnd_api.g_miss_char,
        p_task_type_id            IN       NUMBER DEFAULT fnd_api.g_miss_num,
        p_description             IN       VARCHAR2 DEFAULT fnd_api.g_miss_char,
        p_task_status_name        IN       VARCHAR2 DEFAULT fnd_api.g_miss_char,
        p_task_status_id          IN       NUMBER DEFAULT fnd_api.g_miss_num,
        p_task_priority_name      IN       VARCHAR2 DEFAULT fnd_api.g_miss_char,
        p_task_priority_id        IN       NUMBER DEFAULT fnd_api.g_miss_num,
        p_duration                IN       NUMBER DEFAULT fnd_api.g_miss_num,
        p_duration_uom            IN       VARCHAR2 DEFAULT fnd_api.g_miss_char,
        p_planned_effort          IN       NUMBER DEFAULT fnd_api.g_miss_num,
        p_planned_effort_uom      IN       VARCHAR2 DEFAULT fnd_api.g_miss_char,
        p_private_flag            IN       VARCHAR2 DEFAULT fnd_api.g_miss_char,
        p_publish_flag            IN       VARCHAR2 DEFAULT fnd_api.g_miss_char,
        p_restrict_closure_flag   IN       VARCHAR2 DEFAULT fnd_api.g_miss_char,
        p_multi_booked_flag       IN       VARCHAR2 DEFAULT fnd_api.g_miss_char,
        p_milestone_flag          IN       VARCHAR2 DEFAULT fnd_api.g_miss_char,
        p_holiday_flag            IN       VARCHAR2 DEFAULT fnd_api.g_miss_char,
        p_billable_flag           IN       VARCHAR2 DEFAULT fnd_api.g_miss_char,
        p_notification_flag       IN       VARCHAR2 DEFAULT fnd_api.g_miss_char,
        p_notification_period     IN       NUMBER DEFAULT fnd_api.g_miss_num,
        p_notification_period_uom IN       VARCHAR2 DEFAULT fnd_api.g_miss_char,
        p_alarm_start             IN       NUMBER DEFAULT fnd_api.g_miss_num,
        p_alarm_start_uom         IN       VARCHAR2 DEFAULT fnd_api.g_miss_char,
        p_alarm_on                IN       VARCHAR2 DEFAULT fnd_api.g_miss_char,
        p_alarm_count             IN       NUMBER DEFAULT fnd_api.g_miss_num,
        p_alarm_interval          IN       NUMBER DEFAULT fnd_api.g_miss_num,
        p_alarm_interval_uom      IN       VARCHAR2 DEFAULT fnd_api.g_miss_char,
        x_return_status           OUT NOCOPY      VARCHAR2,
        x_msg_count               OUT NOCOPY      NUMBER,
        x_msg_data                OUT NOCOPY      VARCHAR2,
        p_attribute1              IN       VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
        p_attribute2              IN       VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
        p_attribute3              IN       VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
        p_attribute4              IN       VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
        p_attribute5              IN       VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
        p_attribute6              IN       VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
        p_attribute7              IN       VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
        p_attribute8              IN       VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
        p_attribute9              IN       VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
        p_attribute10             IN       VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
        p_attribute11             IN       VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
        p_attribute12             IN       VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
        p_attribute13             IN       VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
        p_attribute14             IN       VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
        p_attribute15             IN       VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
        p_attribute_category      IN       VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
        p_task_confirmation_status IN      VARCHAR2
    ) is
        l_api_version       CONSTANT NUMBER                                      := 1.0;

Line: 821


        l_api_name          CONSTANT VARCHAR2(30)                                := 'UPDATE_TASK_TEMPLATE';

Line: 856


        CURSOR c_task_update (
            l_task_id                 IN       NUMBER
        )
        IS
            SELECT DECODE (p_task_id, fnd_api.g_miss_num, task_template_id, p_task_id) task_id,
                   DECODE (p_task_number, fnd_api.g_miss_char, task_number, p_task_number) task_number,
                   DECODE (p_task_name, fnd_api.g_miss_char, task_name, p_task_name) task_name,
                   DECODE (p_task_type_id, fnd_api.g_miss_num, task_type_id, p_task_type_id) task_type_id,
                   DECODE (p_description, fnd_api.g_miss_char, description, p_description) description,
                   DECODE (p_task_status_id, fnd_api.g_miss_num, task_status_id, p_task_status_id) task_status_id,
                   DECODE (p_task_priority_id, fnd_api.g_miss_num, task_priority_id, p_task_priority_id) task_priority_id,
                   DECODE (p_duration, fnd_api.g_miss_num, duration, p_duration) duration,
                   DECODE (p_duration_uom, fnd_api.g_miss_char, duration_uom, p_duration_uom) duration_uom,
                   DECODE (p_planned_effort, fnd_api.g_miss_num, planned_effort, p_planned_effort) planned_effort,
                   DECODE (p_planned_effort_uom, fnd_api.g_miss_char, planned_effort_uom, p_planned_effort_uom) planned_effort_uom,
                   DECODE (p_private_flag, fnd_api.g_miss_char, private_flag, p_private_flag) private_flag,
                   DECODE (p_publish_flag, fnd_api.g_miss_char, publish_flag, p_publish_flag) publish_flag,
                   DECODE (p_restrict_closure_flag, fnd_api.g_miss_char, restrict_closure_flag, p_restrict_closure_flag) restrict_closure_flag,
                   DECODE (p_multi_booked_flag, fnd_api.g_miss_char, multi_booked_flag, p_multi_booked_flag) multi_booked_flag,
                   DECODE (p_milestone_flag, fnd_api.g_miss_char, milestone_flag, p_milestone_flag) milestone_flag,
                   DECODE (p_holiday_flag, fnd_api.g_miss_char, holiday_flag, p_holiday_flag) holiday_flag,
                   DECODE (p_billable_flag, fnd_api.g_miss_char, billable_flag, p_billable_flag) billable_flag,
                   DECODE (p_notification_flag, fnd_api.g_miss_char, notification_flag, p_notification_flag) notification_flag,
                   DECODE (p_notification_period, fnd_api.g_miss_num, notification_period, p_notification_period) notification_period,
                   DECODE (p_notification_period_uom, fnd_api.g_miss_char, notification_period_uom, p_notification_period_uom) notification_period_uom,
                   DECODE (p_alarm_start, fnd_api.g_miss_num, alarm_start, p_alarm_start) alarm_start,
                   DECODE (p_alarm_start_uom, fnd_api.g_miss_char, alarm_start_uom, p_alarm_start_uom) alarm_start_uom,
                   DECODE (p_alarm_on, fnd_api.g_miss_char, alarm_on, p_alarm_on) alarm_on,
                   DECODE (p_alarm_count, fnd_api.g_miss_num, alarm_count, p_alarm_count) alarm_count,
                   DECODE (p_alarm_interval, fnd_api.g_miss_num, alarm_interval, p_alarm_interval) alarm_interval,
                   DECODE (p_alarm_interval_uom, fnd_api.g_miss_char, alarm_interval_uom, p_alarm_interval_uom) alarm_interval_uom,
decode( p_attribute1 , fnd_api.g_miss_char , attribute1 , p_attribute1 )  attribute1  ,
decode( p_attribute2 , fnd_api.g_miss_char , attribute2 , p_attribute2 )  attribute2  ,
decode( p_attribute3 , fnd_api.g_miss_char , attribute3 , p_attribute3 )  attribute3  ,
decode( p_attribute4 , fnd_api.g_miss_char , attribute4 , p_attribute4 )  attribute4  ,
decode( p_attribute5 , fnd_api.g_miss_char , attribute5 , p_attribute5 )  attribute5  ,
decode( p_attribute6 , fnd_api.g_miss_char , attribute6 , p_attribute6 )  attribute6  ,
decode( p_attribute7 , fnd_api.g_miss_char , attribute7 , p_attribute7 )  attribute7  ,
decode( p_attribute8 , fnd_api.g_miss_char , attribute8 , p_attribute8 )  attribute8  ,
decode( p_attribute9 , fnd_api.g_miss_char , attribute9 , p_attribute9 )  attribute9  ,
decode( p_attribute10 , fnd_api.g_miss_char , attribute10 , p_attribute10 )  attribute10  ,
decode( p_attribute11 , fnd_api.g_miss_char , attribute11 , p_attribute11 )  attribute11  ,
decode( p_attribute12 , fnd_api.g_miss_char , attribute12 , p_attribute12 )  attribute12  ,
decode( p_attribute13 , fnd_api.g_miss_char , attribute13 , p_attribute13 )  attribute13  ,
decode( p_attribute14 , fnd_api.g_miss_char , attribute14 , p_attribute14 )  attribute14  ,
decode( p_attribute15 , fnd_api.g_miss_char , attribute15 , p_attribute15 )  attribute15 ,
decode( p_attribute_category,fnd_api.g_miss_char,attribute_category,p_attribute_category) attribute_category,
decode( p_task_confirmation_status,jtf_task_utl.g_miss_char,task_confirmation_status,p_task_confirmation_status)
task_confirmation_status
              FROM jtf_task_templates_vl
             WHERE task_template_id = l_task_id;

Line: 908


        task_rec                     c_task_update%ROWTYPE;

Line: 912


        SAVEPOINT update_task_pub;

Line: 939


            SELECT DECODE (l_task_id, fnd_api.g_miss_num, NULL, l_task_id)
              INTO l_task_id
              FROM dual;

Line: 942


            SELECT DECODE (l_task_number, fnd_api.g_miss_char, NULL, l_task_number)
              INTO l_task_number
              FROM dual;

Line: 985


        OPEN c_task_update (l_task_id);

Line: 986


        FETCH c_task_update INTO task_rec;

Line: 988


        IF c_task_update%NOTFOUND
        THEN
            fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_TEMP');

Line: 1451


      jtf_task_templates_pvt.update_task (
            p_api_version => 1.0,
            p_init_msg_list => fnd_api.g_false,
            p_commit => fnd_api.g_false,
            p_object_version_number => p_object_version_number,
            p_task_id => l_task_id,
            p_task_name => l_task_name,
            p_task_type_id => l_task_type_id,
            p_description => task_rec.description,
            p_task_status_id => l_task_status_id,
            p_task_priority_id => l_task_priority_id,
            p_duration => l_duration,
            p_duration_uom => l_duration_uom,
            p_planned_effort => l_planned_effort,
            p_planned_effort_uom => l_planned_effort_uom,
            p_private_flag => l_private_flag,
            p_publish_flag => l_publish_flag,
            p_restrict_closure_flag => l_restrict_closure_flag,
            p_multi_booked_flag => l_multi_booked_flag,
            p_milestone_flag => l_milestone_flag,
            p_holiday_flag => l_holiday_flag,
            p_billable_flag => l_billable_flag,
            p_notification_flag => l_notification_flag,
            p_notification_period => l_notification_period,
            p_notification_period_uom => l_notification_period_uom,
            p_alarm_start => l_alarm_start,
            p_alarm_start_uom => l_alarm_start_uom,
            p_alarm_on => l_alarm_on,
            p_alarm_count => l_alarm_count,
            p_alarm_interval => l_alarm_interval,
            p_alarm_interval_uom => l_alarm_interval_uom,
            x_return_status => x_return_status,
            x_msg_count => x_msg_count,
            x_msg_data => x_msg_data,
            p_attribute1 => task_rec.attribute1 ,
            p_attribute2 => task_rec.attribute2 ,
            p_attribute3 => task_rec.attribute3 ,
            p_attribute4 => task_rec.attribute4 ,
            p_attribute5 => task_rec.attribute5 ,
            p_attribute6 => task_rec.attribute6 ,
            p_attribute7 => task_rec.attribute7 ,
            p_attribute8 => task_rec.attribute8 ,
            p_attribute9 => task_rec.attribute9 ,
            p_attribute10 => task_rec.attribute10 ,
            p_attribute11 => task_rec.attribute11 ,
            p_attribute12 => task_rec.attribute12 ,
            p_attribute13 => task_rec.attribute13 ,
            p_attribute14 => task_rec.attribute14 ,
            p_attribute15 => task_rec.attribute15 ,
            p_attribute_category => task_rec.attribute_category,
            p_task_confirmation_status => task_rec.task_confirmation_status
        );

Line: 1506


            ROLLBACK TO update_task_pub;

Line: 1510


            ROLLBACK TO update_task_pub;

Line: 1516


            ROLLBACK TO update_task_pub;

Line: 1520


       PROCEDURE update_task (
        p_api_version             IN       NUMBER,
        p_init_msg_list           IN       VARCHAR2 DEFAULT fnd_api.g_false,
        p_commit                  IN       VARCHAR2 DEFAULT fnd_api.g_false,
        p_object_version_number   IN     OUT NOCOPY NUMBER ,
        p_task_id                 IN       NUMBER DEFAULT fnd_api.g_miss_num,
        p_task_number             IN       VARCHAR2 DEFAULT fnd_api.g_miss_char,
        p_task_group_id           IN       NUMBER DEFAULT fnd_api.g_miss_num,
        p_task_name               IN       VARCHAR2 DEFAULT fnd_api.g_miss_char,
        p_task_type_name          IN       VARCHAR2 DEFAULT fnd_api.g_miss_char,
        p_task_type_id            IN       NUMBER DEFAULT fnd_api.g_miss_num,
        p_description             IN       VARCHAR2 DEFAULT fnd_api.g_miss_char,
        p_task_status_name        IN       VARCHAR2 DEFAULT fnd_api.g_miss_char,
        p_task_status_id          IN       NUMBER DEFAULT fnd_api.g_miss_num,
        p_task_priority_name      IN       VARCHAR2 DEFAULT fnd_api.g_miss_char,
        p_task_priority_id        IN       NUMBER DEFAULT fnd_api.g_miss_num,
        p_duration                IN       NUMBER DEFAULT fnd_api.g_miss_num,
        p_duration_uom            IN       VARCHAR2 DEFAULT fnd_api.g_miss_char,
        p_planned_effort          IN       NUMBER DEFAULT fnd_api.g_miss_num,
        p_planned_effort_uom      IN       VARCHAR2 DEFAULT fnd_api.g_miss_char,
        p_private_flag            IN       VARCHAR2 DEFAULT fnd_api.g_miss_char,
        p_publish_flag            IN       VARCHAR2 DEFAULT fnd_api.g_miss_char,
        p_restrict_closure_flag   IN       VARCHAR2 DEFAULT fnd_api.g_miss_char,
        p_multi_booked_flag       IN       VARCHAR2 DEFAULT fnd_api.g_miss_char,
        p_milestone_flag          IN       VARCHAR2 DEFAULT fnd_api.g_miss_char,
        p_holiday_flag            IN       VARCHAR2 DEFAULT fnd_api.g_miss_char,
        p_billable_flag           IN       VARCHAR2 DEFAULT fnd_api.g_miss_char,
        p_notification_flag       IN       VARCHAR2 DEFAULT fnd_api.g_miss_char,
        p_notification_period     IN       NUMBER DEFAULT fnd_api.g_miss_num,
        p_notification_period_uom IN       VARCHAR2 DEFAULT fnd_api.g_miss_char,
        p_alarm_start             IN       NUMBER DEFAULT fnd_api.g_miss_num,
        p_alarm_start_uom         IN       VARCHAR2 DEFAULT fnd_api.g_miss_char,
        p_alarm_on                IN       VARCHAR2 DEFAULT fnd_api.g_miss_char,
        p_alarm_count             IN       NUMBER DEFAULT fnd_api.g_miss_num,
        p_alarm_interval          IN       NUMBER DEFAULT fnd_api.g_miss_num,
        p_alarm_interval_uom      IN       VARCHAR2 DEFAULT fnd_api.g_miss_char,
        x_return_status           OUT NOCOPY      VARCHAR2,
        x_msg_count               OUT NOCOPY      NUMBER,
        x_msg_data                OUT NOCOPY      VARCHAR2,
        p_attribute1              IN       VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
        p_attribute2              IN       VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
        p_attribute3              IN       VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
        p_attribute4              IN       VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
        p_attribute5              IN       VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
        p_attribute6              IN       VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
        p_attribute7              IN       VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
        p_attribute8              IN       VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
        p_attribute9              IN       VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
        p_attribute10             IN       VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
        p_attribute11             IN       VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
        p_attribute12             IN       VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
        p_attribute13             IN       VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
        p_attribute14             IN       VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
        p_attribute15             IN       VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
        p_attribute_category      IN       VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
   )
   IS
        l_api_version    CONSTANT NUMBER                       := 1.0;

Line: 1578


        l_api_name       CONSTANT VARCHAR2(30)                 := 'UPDATE_TASK';

Line: 1580


      SAVEPOINT update_task_pub1;

Line: 1598


      jtf_task_templates_pub.update_task (
	    p_api_version		=> p_api_version,
	    p_init_msg_list		=>  p_init_msg_list,
	    p_commit			=>  p_commit,
	    p_object_version_number	=> p_object_version_number,
	    p_task_id			=> p_task_id,
	    p_task_number 		=> p_task_number,
        p_task_group_id		=> p_task_group_id,
        p_task_name 		=> p_task_name,
        p_task_type_name	=> p_task_type_name,
        p_task_type_id		=> p_task_type_id,
        p_description		=> p_description,
        p_task_status_name	=> p_task_status_name,
	    p_task_status_id		=> p_task_status_id,
        p_task_priority_name	=> p_task_priority_name,
	    p_task_priority_id		=> p_task_priority_id,
        p_duration			=> p_duration,
	    p_duration_uom		=> p_duration_uom,
	    p_planned_effort		=> p_planned_effort,
	    p_planned_effort_uom	=> p_planned_effort_uom,
        p_private_flag		=> p_private_flag,
	    p_publish_flag		=> p_publish_flag,
	    p_restrict_closure_flag	=> p_restrict_closure_flag,
        p_multi_booked_flag 	=> p_multi_booked_flag,
	    p_milestone_flag		=> p_milestone_flag,
	    p_holiday_flag		=> p_holiday_flag,
	    p_billable_flag		=> p_billable_flag,
	    p_notification_flag 	=> p_notification_flag,
	    p_notification_period	=> p_notification_period,
	    p_notification_period_uom	=> p_notification_period_uom,
	    p_alarm_start		=> p_alarm_start,
	    p_alarm_start_uom		=> p_alarm_start_uom,
	    p_alarm_on			=> p_alarm_on,
	    p_alarm_count		=> p_alarm_count,
       --p_alarm_fired_count 	=> p_alarm_fired_count,
	    p_alarm_interval		=> p_alarm_interval,
	    p_alarm_interval_uom	=> p_alarm_interval_uom,
        x_return_status		=> x_return_status,
	    x_msg_count 		=> x_msg_count,
	    x_msg_data			=> x_msg_data,
	    p_attribute1		=> p_attribute1,
	    p_attribute2		=> p_attribute2,
	    p_attribute3		=> p_attribute3,
	    p_attribute4		=> p_attribute4,
	    p_attribute5		=> p_attribute5,
	    p_attribute6		=> p_attribute6,
	    p_attribute7		=> p_attribute7,
	    p_attribute8		=> p_attribute8,
	    p_attribute9		=> p_attribute9,
	    p_attribute10		=> p_attribute10,
	    p_attribute11		=> p_attribute11,
	    p_attribute12		=> p_attribute12,
	    p_attribute13		=> p_attribute13,
	    p_attribute14		=> p_attribute14,
	    p_attribute15		=> p_attribute15,
	    p_attribute_category	=> p_attribute_category,
        p_task_confirmation_status => 'N'
      );

Line: 1672


         ROLLBACK TO update_task_pub1;

Line: 1680


         ROLLBACK TO update_task_pub1;

Line: 1690


    PROCEDURE delete_task (
        p_api_version             IN       NUMBER,
        p_init_msg_list           IN       VARCHAR2 DEFAULT fnd_api.g_false,
        p_commit                  IN       VARCHAR2 DEFAULT fnd_api.g_false,
      p_object_version_number   IN     NUMBER ,

        p_task_id                 IN       NUMBER DEFAULT NULL,
        p_task_number             IN       VARCHAR2 DEFAULT NULL,
        x_return_status           OUT NOCOPY      VARCHAR2,
        x_msg_count               OUT NOCOPY      NUMBER,
        x_msg_data                OUT NOCOPY      VARCHAR2
    )
    is
        l_api_version    CONSTANT NUMBER                       := 1.0;

Line: 1704


        l_api_name       CONSTANT VARCHAR2(30)                 := 'DELETE_TASK';

Line: 1709


        SAVEPOINT delete_task_pub;

Line: 1751


        jtf_task_templates_pvt.delete_task (
            p_api_version => 1.0,
            p_init_msg_list => fnd_api.g_false,
            p_commit => fnd_api.g_false,
            p_object_version_number => p_object_version_number,
            p_task_id => l_task_id,
            x_return_status => x_return_status,
            x_msg_count => x_msg_count,
            x_msg_data => x_msg_data
        );

Line: 1771


            ROLLBACK TO delete_task_pub;

Line: 1778


            ROLLBACK TO delete_task_pub;