DBA Data[Home] [Help]

APPS.IBE_WF_NOTIF_SETUP_PVT dependencies on JTF_VARCHAR2_TABLE_100

Line 697: x_return_status OUT NOCOPY JTF_VARCHAR2_TABLE_100,

693: end if;
694: END Delete_wf_notif_setup;
695:
696: procedure Update_Wf_notif_setup(
697: x_return_status OUT NOCOPY JTF_VARCHAR2_TABLE_100,
698: x_msg_count OUT NOCOPY NUMBER,
699: x_msg_data OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
700: p_notif_name_tbl IN JTF_VARCHAR2_TABLE_100,
701: p_enabled_flag_tbl IN JTF_VARCHAR2_TABLE_100)

Line 700: p_notif_name_tbl IN JTF_VARCHAR2_TABLE_100,

696: procedure Update_Wf_notif_setup(
697: x_return_status OUT NOCOPY JTF_VARCHAR2_TABLE_100,
698: x_msg_count OUT NOCOPY NUMBER,
699: x_msg_data OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
700: p_notif_name_tbl IN JTF_VARCHAR2_TABLE_100,
701: p_enabled_flag_tbl IN JTF_VARCHAR2_TABLE_100)
702: IS
703: l_notif_name_tbl JTF_VARCHAR2_TABLE_100;
704: l_msite_flag VARCHAR2(1);

Line 701: p_enabled_flag_tbl IN JTF_VARCHAR2_TABLE_100)

697: x_return_status OUT NOCOPY JTF_VARCHAR2_TABLE_100,
698: x_msg_count OUT NOCOPY NUMBER,
699: x_msg_data OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
700: p_notif_name_tbl IN JTF_VARCHAR2_TABLE_100,
701: p_enabled_flag_tbl IN JTF_VARCHAR2_TABLE_100)
702: IS
703: l_notif_name_tbl JTF_VARCHAR2_TABLE_100;
704: l_msite_flag VARCHAR2(1);
705: l_org_flag VARCHAR2(1);

Line 703: l_notif_name_tbl JTF_VARCHAR2_TABLE_100;

699: x_msg_data OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
700: p_notif_name_tbl IN JTF_VARCHAR2_TABLE_100,
701: p_enabled_flag_tbl IN JTF_VARCHAR2_TABLE_100)
702: IS
703: l_notif_name_tbl JTF_VARCHAR2_TABLE_100;
704: l_msite_flag VARCHAR2(1);
705: l_org_flag VARCHAR2(1);
706: l_user_type_flag VARCHAR2(1);
707: l_default_message_name VARCHAR2(30);

Line 717: x_return_status := JTF_VARCHAR2_TABLE_100();

713: l_msg_count NUMBER;
714: l_object_version_number NUMBER;
715: BEGIN
716: --null;
717: x_return_status := JTF_VARCHAR2_TABLE_100();
718: x_msg_data := JTF_VARCHAR2_TABLE_2000();
719: if( p_notif_name_tbl IS NULL ) THEN
720: x_return_status.extend(1);
721: x_return_status(1) := FND_API.G_RET_STS_ERROR;