DBA Data[Home] [Help]

APPS.IBE_SHOP_LIST_WRAPPER_PVT dependencies on JTF_VARCHAR2_TABLE_100

Line 568: p_l_uom_code IN jtf_varchar2_table_100 := NULL,

564: p_l_program_update_date IN jtf_date_table := NULL,
565: p_l_shp_list_id IN jtf_number_table := NULL,
566: p_l_inventory_item_id IN jtf_number_table := NULL,
567: p_l_organization_id IN jtf_number_table := NULL,
568: p_l_uom_code IN jtf_varchar2_table_100 := NULL,
569: p_l_quantity IN jtf_number_table := NULL,
570: p_l_config_header_id IN jtf_number_table := NULL,
571: p_l_config_revision_num IN jtf_number_table := NULL,
572: p_l_complete_config_flag IN jtf_varchar2_table_100 := NULL,

Line 572: p_l_complete_config_flag IN jtf_varchar2_table_100 := NULL,

568: p_l_uom_code IN jtf_varchar2_table_100 := NULL,
569: p_l_quantity IN jtf_number_table := NULL,
570: p_l_config_header_id IN jtf_number_table := NULL,
571: p_l_config_revision_num IN jtf_number_table := NULL,
572: p_l_complete_config_flag IN jtf_varchar2_table_100 := NULL,
573: p_l_valid_configuration_flag IN jtf_varchar2_table_100 := NULL,
574: p_l_item_type_code IN jtf_varchar2_table_100 := NULL,
575: p_l_attribute_category IN jtf_varchar2_table_100 := NULL,
576: p_l_attribute1 IN jtf_varchar2_table_200 := NULL,

Line 573: p_l_valid_configuration_flag IN jtf_varchar2_table_100 := NULL,

569: p_l_quantity IN jtf_number_table := NULL,
570: p_l_config_header_id IN jtf_number_table := NULL,
571: p_l_config_revision_num IN jtf_number_table := NULL,
572: p_l_complete_config_flag IN jtf_varchar2_table_100 := NULL,
573: p_l_valid_configuration_flag IN jtf_varchar2_table_100 := NULL,
574: p_l_item_type_code IN jtf_varchar2_table_100 := NULL,
575: p_l_attribute_category IN jtf_varchar2_table_100 := NULL,
576: p_l_attribute1 IN jtf_varchar2_table_200 := NULL,
577: p_l_attribute2 IN jtf_varchar2_table_200 := NULL,

Line 574: p_l_item_type_code IN jtf_varchar2_table_100 := NULL,

570: p_l_config_header_id IN jtf_number_table := NULL,
571: p_l_config_revision_num IN jtf_number_table := NULL,
572: p_l_complete_config_flag IN jtf_varchar2_table_100 := NULL,
573: p_l_valid_configuration_flag IN jtf_varchar2_table_100 := NULL,
574: p_l_item_type_code IN jtf_varchar2_table_100 := NULL,
575: p_l_attribute_category IN jtf_varchar2_table_100 := NULL,
576: p_l_attribute1 IN jtf_varchar2_table_200 := NULL,
577: p_l_attribute2 IN jtf_varchar2_table_200 := NULL,
578: p_l_attribute3 IN jtf_varchar2_table_200 := NULL,

Line 575: p_l_attribute_category IN jtf_varchar2_table_100 := NULL,

571: p_l_config_revision_num IN jtf_number_table := NULL,
572: p_l_complete_config_flag IN jtf_varchar2_table_100 := NULL,
573: p_l_valid_configuration_flag IN jtf_varchar2_table_100 := NULL,
574: p_l_item_type_code IN jtf_varchar2_table_100 := NULL,
575: p_l_attribute_category IN jtf_varchar2_table_100 := NULL,
576: p_l_attribute1 IN jtf_varchar2_table_200 := NULL,
577: p_l_attribute2 IN jtf_varchar2_table_200 := NULL,
578: p_l_attribute3 IN jtf_varchar2_table_200 := NULL,
579: p_l_attribute4 IN jtf_varchar2_table_200 := NULL,

Line 810: p_lr_relationship_type_code IN jtf_varchar2_table_100 := NULL

806: p_lr_shp_list_item_id IN jtf_number_table := NULL,
807: p_lr_line_index IN jtf_number_table := NULL,
808: p_lr_related_shp_list_item_id IN jtf_number_table := NULL,
809: p_lr_related_line_index IN jtf_number_table := NULL,
810: p_lr_relationship_type_code IN jtf_varchar2_table_100 := NULL
811: ) RETURN IBE_Shop_List_PVT.SL_Line_Rel_Tbl_Type
812: IS
813: sl_line_rel_tbl IBE_Shop_List_PVT.SL_Line_Rel_Tbl_Type
814: := IBE_Shop_List_PVT.G_MISS_SL_LINE_REL_TBL;

Line 989: p_l_uom_code IN jtf_varchar2_table_100 := NULL ,

985: p_l_program_update_date IN jtf_date_table := NULL ,
986: p_l_shp_list_id IN jtf_number_table := NULL ,
987: p_l_inventory_item_id IN jtf_number_table := NULL ,
988: p_l_organization_id IN jtf_number_table := NULL ,
989: p_l_uom_code IN jtf_varchar2_table_100 := NULL ,
990: p_l_quantity IN jtf_number_table := NULL ,
991: p_l_config_header_id IN jtf_number_table := NULL ,
992: p_l_config_revision_num IN jtf_number_table := NULL ,
993: p_l_complete_config_flag IN jtf_varchar2_table_100 := NULL ,

Line 993: p_l_complete_config_flag IN jtf_varchar2_table_100 := NULL ,

989: p_l_uom_code IN jtf_varchar2_table_100 := NULL ,
990: p_l_quantity IN jtf_number_table := NULL ,
991: p_l_config_header_id IN jtf_number_table := NULL ,
992: p_l_config_revision_num IN jtf_number_table := NULL ,
993: p_l_complete_config_flag IN jtf_varchar2_table_100 := NULL ,
994: p_l_valid_configuration_flag IN jtf_varchar2_table_100 := NULL ,
995: p_l_item_type_code IN jtf_varchar2_table_100 := NULL ,
996: p_l_attribute_category IN jtf_varchar2_table_100 := NULL ,
997: p_l_attribute1 IN jtf_varchar2_table_200 := NULL ,

Line 994: p_l_valid_configuration_flag IN jtf_varchar2_table_100 := NULL ,

990: p_l_quantity IN jtf_number_table := NULL ,
991: p_l_config_header_id IN jtf_number_table := NULL ,
992: p_l_config_revision_num IN jtf_number_table := NULL ,
993: p_l_complete_config_flag IN jtf_varchar2_table_100 := NULL ,
994: p_l_valid_configuration_flag IN jtf_varchar2_table_100 := NULL ,
995: p_l_item_type_code IN jtf_varchar2_table_100 := NULL ,
996: p_l_attribute_category IN jtf_varchar2_table_100 := NULL ,
997: p_l_attribute1 IN jtf_varchar2_table_200 := NULL ,
998: p_l_attribute2 IN jtf_varchar2_table_200 := NULL ,

Line 995: p_l_item_type_code IN jtf_varchar2_table_100 := NULL ,

991: p_l_config_header_id IN jtf_number_table := NULL ,
992: p_l_config_revision_num IN jtf_number_table := NULL ,
993: p_l_complete_config_flag IN jtf_varchar2_table_100 := NULL ,
994: p_l_valid_configuration_flag IN jtf_varchar2_table_100 := NULL ,
995: p_l_item_type_code IN jtf_varchar2_table_100 := NULL ,
996: p_l_attribute_category IN jtf_varchar2_table_100 := NULL ,
997: p_l_attribute1 IN jtf_varchar2_table_200 := NULL ,
998: p_l_attribute2 IN jtf_varchar2_table_200 := NULL ,
999: p_l_attribute3 IN jtf_varchar2_table_200 := NULL ,

Line 996: p_l_attribute_category IN jtf_varchar2_table_100 := NULL ,

992: p_l_config_revision_num IN jtf_number_table := NULL ,
993: p_l_complete_config_flag IN jtf_varchar2_table_100 := NULL ,
994: p_l_valid_configuration_flag IN jtf_varchar2_table_100 := NULL ,
995: p_l_item_type_code IN jtf_varchar2_table_100 := NULL ,
996: p_l_attribute_category IN jtf_varchar2_table_100 := NULL ,
997: p_l_attribute1 IN jtf_varchar2_table_200 := NULL ,
998: p_l_attribute2 IN jtf_varchar2_table_200 := NULL ,
999: p_l_attribute3 IN jtf_varchar2_table_200 := NULL ,
1000: p_l_attribute4 IN jtf_varchar2_table_200 := NULL ,

Line 1028: p_lr_relationship_type_code IN jtf_varchar2_table_100 := NULL ,

1024: p_lr_shp_list_item_id IN jtf_number_table := NULL ,
1025: p_lr_line_index IN jtf_number_table := NULL ,
1026: p_lr_related_shp_list_item_id IN jtf_number_table := NULL ,
1027: p_lr_related_line_index IN jtf_number_table := NULL ,
1028: p_lr_relationship_type_code IN jtf_varchar2_table_100 := NULL ,
1029: x_sl_header_id OUT NOCOPY NUMBER
1030: )
1031: IS
1032: l_sl_header_rec IBE_Shop_List_PVT.SL_Header_Rec_Type;

Line 1465: p_privilege_type IN jtf_varchar2_table_100 := NULL,

1461: p_h_ordered_date IN DATE := FND_API.G_MISS_DATE,
1462: p_h_resource_id IN NUMBER := FND_API.G_MISS_NUM ,
1463: p_password IN VARCHAR2 := FND_API.G_MISS_CHAR,
1464: p_email_address IN jtf_varchar2_table_2000 := NULL,
1465: p_privilege_type IN jtf_varchar2_table_100 := NULL,
1466: p_url IN VARCHAR2 := FND_API.G_MISS_CHAR,
1467: p_comments IN VARCHAR2 := FND_API.G_MISS_CHAR,
1468: p_promocode IN VARCHAR2 := FND_API.G_MISS_CHAR, --added for R12
1469: x_q_header_id OUT NOCOPY NUMBER