DBA Data[Home] [Help]

APPS.IBC_CV_LABEL_GRP dependencies on JTF_NUMBER_TABLE

Line 607: ,p_content_item_ids IN JTF_NUMBER_TABLE

603: -- Upsert into CV Labels Table
604: --
605: PROCEDURE Upsert_Cv_Labels(
606: p_label_code IN VARCHAR2
607: ,p_content_item_ids IN JTF_NUMBER_TABLE
608: ,p_citem_version_ids IN JTF_NUMBER_TABLE
609: ,p_version_number IN JTF_NUMBER_TABLE
610: ,p_commit IN VARCHAR2
611: ,p_api_version_number IN NUMBER

Line 608: ,p_citem_version_ids IN JTF_NUMBER_TABLE

604: --
605: PROCEDURE Upsert_Cv_Labels(
606: p_label_code IN VARCHAR2
607: ,p_content_item_ids IN JTF_NUMBER_TABLE
608: ,p_citem_version_ids IN JTF_NUMBER_TABLE
609: ,p_version_number IN JTF_NUMBER_TABLE
610: ,p_commit IN VARCHAR2
611: ,p_api_version_number IN NUMBER
612: ,p_init_msg_list IN VARCHAR2 --DEFAULT Fnd_Api.G_FALSE

Line 609: ,p_version_number IN JTF_NUMBER_TABLE

605: PROCEDURE Upsert_Cv_Labels(
606: p_label_code IN VARCHAR2
607: ,p_content_item_ids IN JTF_NUMBER_TABLE
608: ,p_citem_version_ids IN JTF_NUMBER_TABLE
609: ,p_version_number IN JTF_NUMBER_TABLE
610: ,p_commit IN VARCHAR2
611: ,p_api_version_number IN NUMBER
612: ,p_init_msg_list IN VARCHAR2 --DEFAULT Fnd_Api.G_FALSE
613: ,x_return_status OUT NOCOPY VARCHAR2

Line 623: l_ins_content_item_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

619: l_api_name CONSTANT VARCHAR2(30) := 'UPSERT_CV_LABELS';
620: l_api_version_number CONSTANT NUMBER := 1; --G_API_VERSION_DEFAULT;
621:
622: lx_rowid VARCHAR2(240);
623: l_ins_content_item_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
624: l_ins_citem_version_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
625: l_cnt INTEGER := 1;
626: l_temp INTEGER := 1;
627: l_citem_version_ids JTF_NUMBER_TABLE := p_citem_version_ids;

Line 624: l_ins_citem_version_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

620: l_api_version_number CONSTANT NUMBER := 1; --G_API_VERSION_DEFAULT;
621:
622: lx_rowid VARCHAR2(240);
623: l_ins_content_item_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
624: l_ins_citem_version_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
625: l_cnt INTEGER := 1;
626: l_temp INTEGER := 1;
627: l_citem_version_ids JTF_NUMBER_TABLE := p_citem_version_ids;
628:

Line 627: l_citem_version_ids JTF_NUMBER_TABLE := p_citem_version_ids;

623: l_ins_content_item_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
624: l_ins_citem_version_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
625: l_cnt INTEGER := 1;
626: l_temp INTEGER := 1;
627: l_citem_version_ids JTF_NUMBER_TABLE := p_citem_version_ids;
628:
629:
630: BEGIN
631:

Line 839: ,p_content_item_ids IN JTF_NUMBER_TABLE

835: -- Upsert into CV Labels Table
836: --
837: PROCEDURE Upsert_Cv_Labels(
838: p_label_code IN VARCHAR2
839: ,p_content_item_ids IN JTF_NUMBER_TABLE
840: ,p_citem_version_ids IN JTF_NUMBER_TABLE
841: ,p_commit IN VARCHAR2
842: ,p_api_version_number IN NUMBER
843: ,p_init_msg_list IN VARCHAR2 --DEFAULT Fnd_Api.G_FALSE

Line 840: ,p_citem_version_ids IN JTF_NUMBER_TABLE

836: --
837: PROCEDURE Upsert_Cv_Labels(
838: p_label_code IN VARCHAR2
839: ,p_content_item_ids IN JTF_NUMBER_TABLE
840: ,p_citem_version_ids IN JTF_NUMBER_TABLE
841: ,p_commit IN VARCHAR2
842: ,p_api_version_number IN NUMBER
843: ,p_init_msg_list IN VARCHAR2 --DEFAULT Fnd_Api.G_FALSE
844: ,x_return_status OUT NOCOPY VARCHAR2

Line 864: ,p_version_number => JTF_NUMBER_TABLE()

860: Upsert_Cv_Labels(
861: p_label_code => p_label_code
862: ,p_content_item_ids => p_content_item_ids
863: ,p_citem_version_ids => p_citem_version_ids
864: ,p_version_number => JTF_NUMBER_TABLE()
865: ,p_commit => p_commit
866: ,p_api_version_number => p_api_version_number
867: ,p_init_msg_list => p_init_msg_list
868: ,x_return_status => x_return_status

Line 881: ,p_content_item_ids IN JTF_NUMBER_TABLE

877: -- Upsert into CV Labels Table
878: --
879: PROCEDURE Upsert_Cv_Labels(
880: p_label_code IN VARCHAR2
881: ,p_content_item_ids IN JTF_NUMBER_TABLE
882: ,p_version_number IN JTF_NUMBER_TABLE
883: ,p_commit IN VARCHAR2
884: ,p_api_version_number IN NUMBER
885: ,p_init_msg_list IN VARCHAR2 --DEFAULT Fnd_Api.G_FALSE

Line 882: ,p_version_number IN JTF_NUMBER_TABLE

878: --
879: PROCEDURE Upsert_Cv_Labels(
880: p_label_code IN VARCHAR2
881: ,p_content_item_ids IN JTF_NUMBER_TABLE
882: ,p_version_number IN JTF_NUMBER_TABLE
883: ,p_commit IN VARCHAR2
884: ,p_api_version_number IN NUMBER
885: ,p_init_msg_list IN VARCHAR2 --DEFAULT Fnd_Api.G_FALSE
886: ,x_return_status OUT NOCOPY VARCHAR2

Line 892: l_citem_version_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

888: ,x_msg_data OUT NOCOPY VARCHAR2
889: )
890: IS
891:
892: l_citem_version_ids JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
893:
894:
895: BEGIN
896:

Line 906: ,p_citem_version_ids => JTF_NUMBER_TABLE()

902: Upsert_Cv_Labels(
903: p_label_code => p_label_code
904: ,p_content_item_ids => p_content_item_ids
905: ,p_version_number => p_version_number
906: ,p_citem_version_ids => JTF_NUMBER_TABLE()
907: ,p_commit => p_commit
908: ,p_api_version_number => p_api_version_number
909: ,p_init_msg_list => p_init_msg_list
910: ,x_return_status => x_return_status

Line 921: ,p_content_item_ids IN JTF_NUMBER_TABLE

917: -- Delete into CV Labels Table
918: --
919: PROCEDURE Delete_Cv_Labels(
920: p_label_code IN VARCHAR2
921: ,p_content_item_ids IN JTF_NUMBER_TABLE
922: ,p_commit IN VARCHAR2
923: ,p_api_version_number IN NUMBER
924: ,p_init_msg_list IN VARCHAR2 --DEFAULT Fnd_Api.G_FALSE
925: ,x_return_status OUT NOCOPY VARCHAR2