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,
587: p_l_attribute5 IN jtf_varchar2_table_200 := 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,
587: p_l_attribute5 IN jtf_varchar2_table_200 := NULL,
588: p_l_attribute6 IN jtf_varchar2_table_200 := 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,
587: p_l_attribute5 IN jtf_varchar2_table_200 := NULL,
588: p_l_attribute6 IN jtf_varchar2_table_200 := NULL,
589: p_l_attribute7 IN jtf_varchar2_table_200 := 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,
587: p_l_attribute5 IN jtf_varchar2_table_200 := NULL,
588: p_l_attribute6 IN jtf_varchar2_table_200 := NULL,
589: p_l_attribute7 IN jtf_varchar2_table_200 := NULL,
590: p_l_attribute8 IN jtf_varchar2_table_200 := 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,
587: p_l_attribute5 IN jtf_varchar2_table_200 := NULL,
588: p_l_attribute6 IN jtf_varchar2_table_200 := NULL,
589: p_l_attribute7 IN jtf_varchar2_table_200 := NULL,
590: p_l_attribute8 IN jtf_varchar2_table_200 := NULL,
591: p_l_attribute9 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,
587: p_l_attribute5 IN jtf_varchar2_table_200 := NULL,
588: p_l_attribute6 IN jtf_varchar2_table_200 := NULL,
589: p_l_attribute7 IN jtf_varchar2_table_200 := NULL,
590: p_l_attribute8 IN jtf_varchar2_table_200 := NULL,
591: p_l_attribute9 IN jtf_varchar2_table_200 := NULL,
592: p_l_attribute10 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,
587: p_l_attribute5 IN jtf_varchar2_table_200 := NULL,
588: p_l_attribute6 IN jtf_varchar2_table_200 := NULL,
589: p_l_attribute7 IN jtf_varchar2_table_200 := NULL,
590: p_l_attribute8 IN jtf_varchar2_table_200 := NULL,
591: p_l_attribute9 IN jtf_varchar2_table_200 := NULL,
592: p_l_attribute10 IN jtf_varchar2_table_200 := NULL,
593: p_l_attribute11 IN jtf_varchar2_table_200 := NULL,
586: p_l_attribute4 IN jtf_varchar2_table_200 := NULL,
587: p_l_attribute5 IN jtf_varchar2_table_200 := NULL,
588: p_l_attribute6 IN jtf_varchar2_table_200 := NULL,
589: p_l_attribute7 IN jtf_varchar2_table_200 := NULL,
590: p_l_attribute8 IN jtf_varchar2_table_200 := NULL,
591: p_l_attribute9 IN jtf_varchar2_table_200 := NULL,
592: p_l_attribute10 IN jtf_varchar2_table_200 := NULL,
593: p_l_attribute11 IN jtf_varchar2_table_200 := NULL,
594: p_l_attribute12 IN jtf_varchar2_table_200 := NULL,
587: p_l_attribute5 IN jtf_varchar2_table_200 := NULL,
588: p_l_attribute6 IN jtf_varchar2_table_200 := NULL,
589: p_l_attribute7 IN jtf_varchar2_table_200 := NULL,
590: p_l_attribute8 IN jtf_varchar2_table_200 := NULL,
591: p_l_attribute9 IN jtf_varchar2_table_200 := NULL,
592: p_l_attribute10 IN jtf_varchar2_table_200 := NULL,
593: p_l_attribute11 IN jtf_varchar2_table_200 := NULL,
594: p_l_attribute12 IN jtf_varchar2_table_200 := NULL,
595: p_l_attribute13 IN jtf_varchar2_table_200 := NULL,
588: p_l_attribute6 IN jtf_varchar2_table_200 := NULL,
589: p_l_attribute7 IN jtf_varchar2_table_200 := NULL,
590: p_l_attribute8 IN jtf_varchar2_table_200 := NULL,
591: p_l_attribute9 IN jtf_varchar2_table_200 := NULL,
592: p_l_attribute10 IN jtf_varchar2_table_200 := NULL,
593: p_l_attribute11 IN jtf_varchar2_table_200 := NULL,
594: p_l_attribute12 IN jtf_varchar2_table_200 := NULL,
595: p_l_attribute13 IN jtf_varchar2_table_200 := NULL,
596: p_l_attribute14 IN jtf_varchar2_table_200 := NULL,
589: p_l_attribute7 IN jtf_varchar2_table_200 := NULL,
590: p_l_attribute8 IN jtf_varchar2_table_200 := NULL,
591: p_l_attribute9 IN jtf_varchar2_table_200 := NULL,
592: p_l_attribute10 IN jtf_varchar2_table_200 := NULL,
593: p_l_attribute11 IN jtf_varchar2_table_200 := NULL,
594: p_l_attribute12 IN jtf_varchar2_table_200 := NULL,
595: p_l_attribute13 IN jtf_varchar2_table_200 := NULL,
596: p_l_attribute14 IN jtf_varchar2_table_200 := NULL,
597: p_l_attribute15 IN jtf_varchar2_table_200 := NULL,
590: p_l_attribute8 IN jtf_varchar2_table_200 := NULL,
591: p_l_attribute9 IN jtf_varchar2_table_200 := NULL,
592: p_l_attribute10 IN jtf_varchar2_table_200 := NULL,
593: p_l_attribute11 IN jtf_varchar2_table_200 := NULL,
594: p_l_attribute12 IN jtf_varchar2_table_200 := NULL,
595: p_l_attribute13 IN jtf_varchar2_table_200 := NULL,
596: p_l_attribute14 IN jtf_varchar2_table_200 := NULL,
597: p_l_attribute15 IN jtf_varchar2_table_200 := NULL,
598: p_l_org_id IN jtf_number_table := NULL
591: p_l_attribute9 IN jtf_varchar2_table_200 := NULL,
592: p_l_attribute10 IN jtf_varchar2_table_200 := NULL,
593: p_l_attribute11 IN jtf_varchar2_table_200 := NULL,
594: p_l_attribute12 IN jtf_varchar2_table_200 := NULL,
595: p_l_attribute13 IN jtf_varchar2_table_200 := NULL,
596: p_l_attribute14 IN jtf_varchar2_table_200 := NULL,
597: p_l_attribute15 IN jtf_varchar2_table_200 := NULL,
598: p_l_org_id IN jtf_number_table := NULL
599: ) RETURN IBE_Shop_List_PVT.SL_Line_Tbl_Type
592: p_l_attribute10 IN jtf_varchar2_table_200 := NULL,
593: p_l_attribute11 IN jtf_varchar2_table_200 := NULL,
594: p_l_attribute12 IN jtf_varchar2_table_200 := NULL,
595: p_l_attribute13 IN jtf_varchar2_table_200 := NULL,
596: p_l_attribute14 IN jtf_varchar2_table_200 := NULL,
597: p_l_attribute15 IN jtf_varchar2_table_200 := NULL,
598: p_l_org_id IN jtf_number_table := NULL
599: ) RETURN IBE_Shop_List_PVT.SL_Line_Tbl_Type
600: IS
593: p_l_attribute11 IN jtf_varchar2_table_200 := NULL,
594: p_l_attribute12 IN jtf_varchar2_table_200 := NULL,
595: p_l_attribute13 IN jtf_varchar2_table_200 := NULL,
596: p_l_attribute14 IN jtf_varchar2_table_200 := NULL,
597: p_l_attribute15 IN jtf_varchar2_table_200 := NULL,
598: p_l_org_id IN jtf_number_table := NULL
599: ) RETURN IBE_Shop_List_PVT.SL_Line_Tbl_Type
600: IS
601: sl_line_tbl IBE_Shop_List_PVT.SL_Line_Tbl_Type
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 ,
1008: p_l_attribute5 IN jtf_varchar2_table_200 := 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 ,
1008: p_l_attribute5 IN jtf_varchar2_table_200 := NULL ,
1009: p_l_attribute6 IN jtf_varchar2_table_200 := 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 ,
1008: p_l_attribute5 IN jtf_varchar2_table_200 := NULL ,
1009: p_l_attribute6 IN jtf_varchar2_table_200 := NULL ,
1010: p_l_attribute7 IN jtf_varchar2_table_200 := 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 ,
1008: p_l_attribute5 IN jtf_varchar2_table_200 := NULL ,
1009: p_l_attribute6 IN jtf_varchar2_table_200 := NULL ,
1010: p_l_attribute7 IN jtf_varchar2_table_200 := NULL ,
1011: p_l_attribute8 IN jtf_varchar2_table_200 := 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 ,
1008: p_l_attribute5 IN jtf_varchar2_table_200 := NULL ,
1009: p_l_attribute6 IN jtf_varchar2_table_200 := NULL ,
1010: p_l_attribute7 IN jtf_varchar2_table_200 := NULL ,
1011: p_l_attribute8 IN jtf_varchar2_table_200 := NULL ,
1012: p_l_attribute9 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 ,
1008: p_l_attribute5 IN jtf_varchar2_table_200 := NULL ,
1009: p_l_attribute6 IN jtf_varchar2_table_200 := NULL ,
1010: p_l_attribute7 IN jtf_varchar2_table_200 := NULL ,
1011: p_l_attribute8 IN jtf_varchar2_table_200 := NULL ,
1012: p_l_attribute9 IN jtf_varchar2_table_200 := NULL ,
1013: p_l_attribute10 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 ,
1008: p_l_attribute5 IN jtf_varchar2_table_200 := NULL ,
1009: p_l_attribute6 IN jtf_varchar2_table_200 := NULL ,
1010: p_l_attribute7 IN jtf_varchar2_table_200 := NULL ,
1011: p_l_attribute8 IN jtf_varchar2_table_200 := NULL ,
1012: p_l_attribute9 IN jtf_varchar2_table_200 := NULL ,
1013: p_l_attribute10 IN jtf_varchar2_table_200 := NULL ,
1014: p_l_attribute11 IN jtf_varchar2_table_200 := NULL ,
1007: p_l_attribute4 IN jtf_varchar2_table_200 := NULL ,
1008: p_l_attribute5 IN jtf_varchar2_table_200 := NULL ,
1009: p_l_attribute6 IN jtf_varchar2_table_200 := NULL ,
1010: p_l_attribute7 IN jtf_varchar2_table_200 := NULL ,
1011: p_l_attribute8 IN jtf_varchar2_table_200 := NULL ,
1012: p_l_attribute9 IN jtf_varchar2_table_200 := NULL ,
1013: p_l_attribute10 IN jtf_varchar2_table_200 := NULL ,
1014: p_l_attribute11 IN jtf_varchar2_table_200 := NULL ,
1015: p_l_attribute12 IN jtf_varchar2_table_200 := NULL ,
1008: p_l_attribute5 IN jtf_varchar2_table_200 := NULL ,
1009: p_l_attribute6 IN jtf_varchar2_table_200 := NULL ,
1010: p_l_attribute7 IN jtf_varchar2_table_200 := NULL ,
1011: p_l_attribute8 IN jtf_varchar2_table_200 := NULL ,
1012: p_l_attribute9 IN jtf_varchar2_table_200 := NULL ,
1013: p_l_attribute10 IN jtf_varchar2_table_200 := NULL ,
1014: p_l_attribute11 IN jtf_varchar2_table_200 := NULL ,
1015: p_l_attribute12 IN jtf_varchar2_table_200 := NULL ,
1016: p_l_attribute13 IN jtf_varchar2_table_200 := NULL ,
1009: p_l_attribute6 IN jtf_varchar2_table_200 := NULL ,
1010: p_l_attribute7 IN jtf_varchar2_table_200 := NULL ,
1011: p_l_attribute8 IN jtf_varchar2_table_200 := NULL ,
1012: p_l_attribute9 IN jtf_varchar2_table_200 := NULL ,
1013: p_l_attribute10 IN jtf_varchar2_table_200 := NULL ,
1014: p_l_attribute11 IN jtf_varchar2_table_200 := NULL ,
1015: p_l_attribute12 IN jtf_varchar2_table_200 := NULL ,
1016: p_l_attribute13 IN jtf_varchar2_table_200 := NULL ,
1017: p_l_attribute14 IN jtf_varchar2_table_200 := NULL ,
1010: p_l_attribute7 IN jtf_varchar2_table_200 := NULL ,
1011: p_l_attribute8 IN jtf_varchar2_table_200 := NULL ,
1012: p_l_attribute9 IN jtf_varchar2_table_200 := NULL ,
1013: p_l_attribute10 IN jtf_varchar2_table_200 := NULL ,
1014: p_l_attribute11 IN jtf_varchar2_table_200 := NULL ,
1015: p_l_attribute12 IN jtf_varchar2_table_200 := NULL ,
1016: p_l_attribute13 IN jtf_varchar2_table_200 := NULL ,
1017: p_l_attribute14 IN jtf_varchar2_table_200 := NULL ,
1018: p_l_attribute15 IN jtf_varchar2_table_200 := NULL ,
1011: p_l_attribute8 IN jtf_varchar2_table_200 := NULL ,
1012: p_l_attribute9 IN jtf_varchar2_table_200 := NULL ,
1013: p_l_attribute10 IN jtf_varchar2_table_200 := NULL ,
1014: p_l_attribute11 IN jtf_varchar2_table_200 := NULL ,
1015: p_l_attribute12 IN jtf_varchar2_table_200 := NULL ,
1016: p_l_attribute13 IN jtf_varchar2_table_200 := NULL ,
1017: p_l_attribute14 IN jtf_varchar2_table_200 := NULL ,
1018: p_l_attribute15 IN jtf_varchar2_table_200 := NULL ,
1019: p_l_org_id IN jtf_number_table := NULL ,
1012: p_l_attribute9 IN jtf_varchar2_table_200 := NULL ,
1013: p_l_attribute10 IN jtf_varchar2_table_200 := NULL ,
1014: p_l_attribute11 IN jtf_varchar2_table_200 := NULL ,
1015: p_l_attribute12 IN jtf_varchar2_table_200 := NULL ,
1016: p_l_attribute13 IN jtf_varchar2_table_200 := NULL ,
1017: p_l_attribute14 IN jtf_varchar2_table_200 := NULL ,
1018: p_l_attribute15 IN jtf_varchar2_table_200 := NULL ,
1019: p_l_org_id IN jtf_number_table := NULL ,
1020: p_lr_shlitem_rel_id IN jtf_number_table := NULL ,
1013: p_l_attribute10 IN jtf_varchar2_table_200 := NULL ,
1014: p_l_attribute11 IN jtf_varchar2_table_200 := NULL ,
1015: p_l_attribute12 IN jtf_varchar2_table_200 := NULL ,
1016: p_l_attribute13 IN jtf_varchar2_table_200 := NULL ,
1017: p_l_attribute14 IN jtf_varchar2_table_200 := NULL ,
1018: p_l_attribute15 IN jtf_varchar2_table_200 := NULL ,
1019: p_l_org_id IN jtf_number_table := NULL ,
1020: p_lr_shlitem_rel_id IN jtf_number_table := NULL ,
1021: p_lr_request_id IN jtf_number_table := NULL ,
1014: p_l_attribute11 IN jtf_varchar2_table_200 := NULL ,
1015: p_l_attribute12 IN jtf_varchar2_table_200 := NULL ,
1016: p_l_attribute13 IN jtf_varchar2_table_200 := NULL ,
1017: p_l_attribute14 IN jtf_varchar2_table_200 := NULL ,
1018: p_l_attribute15 IN jtf_varchar2_table_200 := NULL ,
1019: p_l_org_id IN jtf_number_table := NULL ,
1020: p_lr_shlitem_rel_id IN jtf_number_table := NULL ,
1021: p_lr_request_id IN jtf_number_table := NULL ,
1022: p_lr_program_application_id IN jtf_number_table := NULL ,
1470: p_h_order_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
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