DBA Data[Home] [Help]

APPS.IBE_SHOP_LIST_WRAPPER_PVT dependencies on JTF_VARCHAR2_TABLE_100

Line 575: p_l_uom_code IN jtf_varchar2_table_100 := NULL,

571: p_l_program_update_date IN jtf_date_table := NULL,
572: p_l_shp_list_id IN jtf_number_table := NULL,
573: p_l_inventory_item_id IN jtf_number_table := NULL,
574: p_l_organization_id IN jtf_number_table := NULL,
575: p_l_uom_code IN jtf_varchar2_table_100 := NULL,
576: p_l_quantity IN jtf_number_table := NULL,
577: p_l_config_header_id IN jtf_number_table := NULL,
578: p_l_config_revision_num IN jtf_number_table := NULL,
579: p_l_complete_config_flag IN jtf_varchar2_table_100 := NULL,

Line 579: p_l_complete_config_flag IN jtf_varchar2_table_100 := NULL,

575: p_l_uom_code IN jtf_varchar2_table_100 := NULL,
576: p_l_quantity IN jtf_number_table := NULL,
577: p_l_config_header_id IN jtf_number_table := NULL,
578: p_l_config_revision_num IN jtf_number_table := NULL,
579: p_l_complete_config_flag IN jtf_varchar2_table_100 := NULL,
580: p_l_valid_configuration_flag IN jtf_varchar2_table_100 := NULL,
581: p_l_item_type_code IN jtf_varchar2_table_100 := NULL,
582: p_l_attribute_category IN jtf_varchar2_table_100 := NULL,
583: p_l_attribute1 IN jtf_varchar2_table_200 := NULL,

Line 580: p_l_valid_configuration_flag IN jtf_varchar2_table_100 := NULL,

576: p_l_quantity IN jtf_number_table := NULL,
577: p_l_config_header_id IN jtf_number_table := NULL,
578: p_l_config_revision_num IN jtf_number_table := NULL,
579: p_l_complete_config_flag IN jtf_varchar2_table_100 := NULL,
580: p_l_valid_configuration_flag IN jtf_varchar2_table_100 := NULL,
581: p_l_item_type_code IN jtf_varchar2_table_100 := NULL,
582: p_l_attribute_category IN jtf_varchar2_table_100 := NULL,
583: p_l_attribute1 IN jtf_varchar2_table_200 := NULL,
584: p_l_attribute2 IN jtf_varchar2_table_200 := NULL,

Line 581: p_l_item_type_code IN jtf_varchar2_table_100 := NULL,

577: p_l_config_header_id IN jtf_number_table := NULL,
578: p_l_config_revision_num IN jtf_number_table := NULL,
579: p_l_complete_config_flag IN jtf_varchar2_table_100 := NULL,
580: p_l_valid_configuration_flag IN jtf_varchar2_table_100 := NULL,
581: p_l_item_type_code IN jtf_varchar2_table_100 := NULL,
582: p_l_attribute_category IN jtf_varchar2_table_100 := NULL,
583: p_l_attribute1 IN jtf_varchar2_table_200 := NULL,
584: p_l_attribute2 IN jtf_varchar2_table_200 := NULL,
585: p_l_attribute3 IN jtf_varchar2_table_200 := NULL,

Line 582: p_l_attribute_category IN jtf_varchar2_table_100 := NULL,

578: p_l_config_revision_num IN jtf_number_table := NULL,
579: p_l_complete_config_flag IN jtf_varchar2_table_100 := NULL,
580: p_l_valid_configuration_flag IN jtf_varchar2_table_100 := NULL,
581: p_l_item_type_code IN jtf_varchar2_table_100 := NULL,
582: p_l_attribute_category IN jtf_varchar2_table_100 := NULL,
583: p_l_attribute1 IN jtf_varchar2_table_200 := NULL,
584: p_l_attribute2 IN jtf_varchar2_table_200 := NULL,
585: p_l_attribute3 IN jtf_varchar2_table_200 := NULL,
586: p_l_attribute4 IN jtf_varchar2_table_200 := NULL,

Line 817: p_lr_relationship_type_code IN jtf_varchar2_table_100 := NULL

813: p_lr_shp_list_item_id IN jtf_number_table := NULL,
814: p_lr_line_index IN jtf_number_table := NULL,
815: p_lr_related_shp_list_item_id IN jtf_number_table := NULL,
816: p_lr_related_line_index IN jtf_number_table := NULL,
817: p_lr_relationship_type_code IN jtf_varchar2_table_100 := NULL
818: ) RETURN IBE_Shop_List_PVT.SL_Line_Rel_Tbl_Type
819: IS
820: sl_line_rel_tbl IBE_Shop_List_PVT.SL_Line_Rel_Tbl_Type
821: := IBE_Shop_List_PVT.G_MISS_SL_LINE_REL_TBL;

Line 996: p_l_uom_code IN jtf_varchar2_table_100 := NULL ,

992: p_l_program_update_date IN jtf_date_table := NULL ,
993: p_l_shp_list_id IN jtf_number_table := NULL ,
994: p_l_inventory_item_id IN jtf_number_table := NULL ,
995: p_l_organization_id IN jtf_number_table := NULL ,
996: p_l_uom_code IN jtf_varchar2_table_100 := NULL ,
997: p_l_quantity IN jtf_number_table := NULL ,
998: p_l_config_header_id IN jtf_number_table := NULL ,
999: p_l_config_revision_num IN jtf_number_table := NULL ,
1000: p_l_complete_config_flag IN jtf_varchar2_table_100 := NULL ,

Line 1000: p_l_complete_config_flag IN jtf_varchar2_table_100 := NULL ,

996: p_l_uom_code IN jtf_varchar2_table_100 := NULL ,
997: p_l_quantity IN jtf_number_table := NULL ,
998: p_l_config_header_id IN jtf_number_table := NULL ,
999: p_l_config_revision_num IN jtf_number_table := NULL ,
1000: p_l_complete_config_flag IN jtf_varchar2_table_100 := NULL ,
1001: p_l_valid_configuration_flag IN jtf_varchar2_table_100 := NULL ,
1002: p_l_item_type_code IN jtf_varchar2_table_100 := NULL ,
1003: p_l_attribute_category IN jtf_varchar2_table_100 := NULL ,
1004: p_l_attribute1 IN jtf_varchar2_table_200 := NULL ,

Line 1001: p_l_valid_configuration_flag IN jtf_varchar2_table_100 := NULL ,

997: p_l_quantity IN jtf_number_table := NULL ,
998: p_l_config_header_id IN jtf_number_table := NULL ,
999: p_l_config_revision_num IN jtf_number_table := NULL ,
1000: p_l_complete_config_flag IN jtf_varchar2_table_100 := NULL ,
1001: p_l_valid_configuration_flag IN jtf_varchar2_table_100 := NULL ,
1002: p_l_item_type_code IN jtf_varchar2_table_100 := NULL ,
1003: p_l_attribute_category IN jtf_varchar2_table_100 := NULL ,
1004: p_l_attribute1 IN jtf_varchar2_table_200 := NULL ,
1005: p_l_attribute2 IN jtf_varchar2_table_200 := NULL ,

Line 1002: p_l_item_type_code IN jtf_varchar2_table_100 := NULL ,

998: p_l_config_header_id IN jtf_number_table := NULL ,
999: p_l_config_revision_num IN jtf_number_table := NULL ,
1000: p_l_complete_config_flag IN jtf_varchar2_table_100 := NULL ,
1001: p_l_valid_configuration_flag IN jtf_varchar2_table_100 := NULL ,
1002: p_l_item_type_code IN jtf_varchar2_table_100 := NULL ,
1003: p_l_attribute_category IN jtf_varchar2_table_100 := NULL ,
1004: p_l_attribute1 IN jtf_varchar2_table_200 := NULL ,
1005: p_l_attribute2 IN jtf_varchar2_table_200 := NULL ,
1006: p_l_attribute3 IN jtf_varchar2_table_200 := NULL ,

Line 1003: p_l_attribute_category IN jtf_varchar2_table_100 := NULL ,

999: p_l_config_revision_num IN jtf_number_table := NULL ,
1000: p_l_complete_config_flag IN jtf_varchar2_table_100 := NULL ,
1001: p_l_valid_configuration_flag IN jtf_varchar2_table_100 := NULL ,
1002: p_l_item_type_code IN jtf_varchar2_table_100 := NULL ,
1003: p_l_attribute_category IN jtf_varchar2_table_100 := NULL ,
1004: p_l_attribute1 IN jtf_varchar2_table_200 := NULL ,
1005: p_l_attribute2 IN jtf_varchar2_table_200 := NULL ,
1006: p_l_attribute3 IN jtf_varchar2_table_200 := NULL ,
1007: p_l_attribute4 IN jtf_varchar2_table_200 := NULL ,

Line 1035: p_lr_relationship_type_code IN jtf_varchar2_table_100 := NULL ,

1031: p_lr_shp_list_item_id IN jtf_number_table := NULL ,
1032: p_lr_line_index IN jtf_number_table := NULL ,
1033: p_lr_related_shp_list_item_id IN jtf_number_table := NULL ,
1034: p_lr_related_line_index IN jtf_number_table := NULL ,
1035: p_lr_relationship_type_code IN jtf_varchar2_table_100 := NULL ,
1036: x_sl_header_id OUT NOCOPY NUMBER
1037: )
1038: IS
1039: l_sl_header_rec IBE_Shop_List_PVT.SL_Header_Rec_Type;

Line 1475: p_privilege_type IN jtf_varchar2_table_100 := NULL,

1471: p_h_ordered_date IN DATE := FND_API.G_MISS_DATE,
1472: p_h_resource_id IN NUMBER := FND_API.G_MISS_NUM ,
1473: p_password IN VARCHAR2 := FND_API.G_MISS_CHAR,
1474: p_email_address IN jtf_varchar2_table_2000 := NULL,
1475: p_privilege_type IN jtf_varchar2_table_100 := NULL,
1476: p_url IN VARCHAR2 := FND_API.G_MISS_CHAR,
1477: p_comments IN VARCHAR2 := FND_API.G_MISS_CHAR,
1478: p_promocode IN VARCHAR2 := FND_API.G_MISS_CHAR, --added for R12
1479: x_q_header_id OUT NOCOPY NUMBER