DBA Data[Home] [Help]

APPS.IBE_MSITE_INFORMATION_MGR_PVT dependencies on JTF_VARCHAR2_TABLE_100

Line 20: p_operation_flags IN JTF_VARCHAR2_TABLE_100,

16: p_api_version IN NUMBER,
17: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
18: p_commit IN VARCHAR2 := FND_API.G_FALSE,
19: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
20: p_operation_flags IN JTF_VARCHAR2_TABLE_100,
21: p_msite_information_ids IN JTF_NUMBER_TABLE,
22: p_object_version_numbers IN JTF_NUMBER_TABLE,
23: p_msite_ids IN JTF_NUMBER_TABLE,
24: p_msite_information_contexts IN JTF_VARCHAR2_TABLE_100,

Line 24: p_msite_information_contexts IN JTF_VARCHAR2_TABLE_100,

20: p_operation_flags IN JTF_VARCHAR2_TABLE_100,
21: p_msite_information_ids IN JTF_NUMBER_TABLE,
22: p_object_version_numbers IN JTF_NUMBER_TABLE,
23: p_msite_ids IN JTF_NUMBER_TABLE,
24: p_msite_information_contexts IN JTF_VARCHAR2_TABLE_100,
25: p_msite_informations1 IN JTF_VARCHAR2_TABLE_300,
26: p_msite_informations2 IN JTF_VARCHAR2_TABLE_300,
27: p_msite_informations3 IN JTF_VARCHAR2_TABLE_300,
28: p_msite_informations4 IN JTF_VARCHAR2_TABLE_300,

Line 45: p_attribute_categorys IN JTF_VARCHAR2_TABLE_100,

41: p_msite_informations17 IN JTF_VARCHAR2_TABLE_300,
42: p_msite_informations18 IN JTF_VARCHAR2_TABLE_300,
43: p_msite_informations19 IN JTF_VARCHAR2_TABLE_300,
44: p_msite_informations20 IN JTF_VARCHAR2_TABLE_300,
45: p_attribute_categorys IN JTF_VARCHAR2_TABLE_100,
46: p_attributes1 IN JTF_VARCHAR2_TABLE_300,
47: p_attributes2 IN JTF_VARCHAR2_TABLE_300,
48: p_attributes3 IN JTF_VARCHAR2_TABLE_300,
49: p_attributes4 IN JTF_VARCHAR2_TABLE_300,

Line 62: x_msite_info_return_statuses OUT NOCOPY JTF_VARCHAR2_TABLE_100,

58: p_attributes13 IN JTF_VARCHAR2_TABLE_300,
59: p_attributes14 IN JTF_VARCHAR2_TABLE_300,
60: p_attributes15 IN JTF_VARCHAR2_TABLE_300,
61: x_msite_information_ids OUT NOCOPY JTF_NUMBER_TABLE,
62: x_msite_info_return_statuses OUT NOCOPY JTF_VARCHAR2_TABLE_100,
63: x_return_status OUT NOCOPY VARCHAR2,
64: x_msg_count OUT NOCOPY NUMBER,
65: x_msg_data OUT NOCOPY VARCHAR2
66: )

Line 95: x_msite_info_return_statuses := JTF_VARCHAR2_TABLE_100();

91:
92: -- Initialize API return status to success
93: x_return_status := FND_API.G_RET_STS_SUCCESS;
94:
95: x_msite_info_return_statuses := JTF_VARCHAR2_TABLE_100();
96: x_msite_information_ids := JTF_NUMBER_TABLE();
97:
98: FOR i IN 1..p_operation_flags.COUNT LOOP
99:

Line 419: l_operation_flags JTF_VARCHAR2_TABLE_100;

415: l_debug VARCHAR2(1);
416: l_i NUMBER;
417: -- For minisite information, such as payment type, credit card
418: -- and shipping method
419: l_operation_flags JTF_VARCHAR2_TABLE_100;
420: l_msite_information_ids JTF_NUMBER_TABLE;
421: l_object_version_numbers JTF_NUMBER_TABLE;
422: l_msite_ids JTF_NUMBER_TABLE;
423: x_msite_information_ids JTF_NUMBER_TABLE;

Line 424: x_msite_info_return_statuses JTF_VARCHAR2_TABLE_100;

420: l_msite_information_ids JTF_NUMBER_TABLE;
421: l_object_version_numbers JTF_NUMBER_TABLE;
422: l_msite_ids JTF_NUMBER_TABLE;
423: x_msite_information_ids JTF_NUMBER_TABLE;
424: x_msite_info_return_statuses JTF_VARCHAR2_TABLE_100;
425: l_msite_information_context VARCHAR2(40);
426: l_msite_information1 VARCHAR2(150);
427: l_msite_information2 VARCHAR2(150);
428: l_msite_information3 VARCHAR2(150);

Line 462: l_msite_information_contexts JTF_VARCHAR2_TABLE_100;

458: l_attribute12 VARCHAR2(150);
459: l_attribute13 VARCHAR2(150);
460: l_attribute14 VARCHAR2(150);
461: l_attribute15 VARCHAR2(150);
462: l_msite_information_contexts JTF_VARCHAR2_TABLE_100;
463: l_msite_informations1 JTF_VARCHAR2_TABLE_300;
464: l_msite_informations2 JTF_VARCHAR2_TABLE_300;
465: l_msite_informations3 JTF_VARCHAR2_TABLE_300;
466: l_msite_informations4 JTF_VARCHAR2_TABLE_300;

Line 483: l_attribute_categorys JTF_VARCHAR2_TABLE_100;

479: l_msite_informations17 JTF_VARCHAR2_TABLE_300;
480: l_msite_informations18 JTF_VARCHAR2_TABLE_300;
481: l_msite_informations19 JTF_VARCHAR2_TABLE_300;
482: l_msite_informations20 JTF_VARCHAR2_TABLE_300;
483: l_attribute_categorys JTF_VARCHAR2_TABLE_100;
484: l_attributes1 JTF_VARCHAR2_TABLE_300;
485: l_attributes2 JTF_VARCHAR2_TABLE_300;
486: l_attributes3 JTF_VARCHAR2_TABLE_300;
487: l_attributes4 JTF_VARCHAR2_TABLE_300;

Line 538: l_operation_flags := JTF_VARCHAR2_TABLE_100();

534: -- Initialize API return status to SUCCESS
535: x_return_status := FND_API.G_RET_STS_SUCCESS;
536:
537: -- For Payment Types, Shipping Methods, and Credit Card
538: l_operation_flags := JTF_VARCHAR2_TABLE_100();
539: l_msite_ids := JTF_NUMBER_TABLE();
540: l_msite_information_ids := JTF_NUMBER_TABLE();
541: l_object_version_numbers := JTF_NUMBER_TABLE();
542: l_msite_information_contexts := JTF_VARCHAR2_TABLE_100();

Line 542: l_msite_information_contexts := JTF_VARCHAR2_TABLE_100();

538: l_operation_flags := JTF_VARCHAR2_TABLE_100();
539: l_msite_ids := JTF_NUMBER_TABLE();
540: l_msite_information_ids := JTF_NUMBER_TABLE();
541: l_object_version_numbers := JTF_NUMBER_TABLE();
542: l_msite_information_contexts := JTF_VARCHAR2_TABLE_100();
543: l_msite_informations1 := JTF_VARCHAR2_TABLE_300();
544: l_msite_informations2 := JTF_VARCHAR2_TABLE_300();
545: l_msite_informations3 := JTF_VARCHAR2_TABLE_300();
546: l_msite_informations4 := JTF_VARCHAR2_TABLE_300();

Line 563: l_attribute_categorys := JTF_VARCHAR2_TABLE_100();

559: l_msite_informations17 := JTF_VARCHAR2_TABLE_300();
560: l_msite_informations18 := JTF_VARCHAR2_TABLE_300();
561: l_msite_informations19 := JTF_VARCHAR2_TABLE_300();
562: l_msite_informations20 := JTF_VARCHAR2_TABLE_300();
563: l_attribute_categorys := JTF_VARCHAR2_TABLE_100();
564: l_attributes1 := JTF_VARCHAR2_TABLE_300();
565: l_attributes2 := JTF_VARCHAR2_TABLE_300();
566: l_attributes3 := JTF_VARCHAR2_TABLE_300();
567: l_attributes4 := JTF_VARCHAR2_TABLE_300();