eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBE_SHOP_LIST_WRAPPER_PVT dependencies on JTF_NUMBER_TABLE

Line 561: p_l_shp_list_item_id IN jtf_number_table := NULL,

557: END Construct_SL_Header_Rec;
558:
559:
560: FUNCTION Construct_SL_Line_Tbl(
561: p_l_shp_list_item_id IN jtf_number_table := NULL,
562: p_l_object_version_number IN jtf_number_table := NULL,
563: p_l_creation_date IN jtf_date_table := NULL,
564: p_l_created_by IN jtf_number_table := NULL,
565: p_l_last_updated_by IN jtf_number_table := NULL,

Line 562: p_l_object_version_number IN jtf_number_table := NULL,

558:
559:
560: FUNCTION Construct_SL_Line_Tbl(
561: p_l_shp_list_item_id IN jtf_number_table := NULL,
562: p_l_object_version_number IN jtf_number_table := NULL,
563: p_l_creation_date IN jtf_date_table := NULL,
564: p_l_created_by IN jtf_number_table := NULL,
565: p_l_last_updated_by IN jtf_number_table := NULL,
566: p_l_last_update_date IN jtf_date_table := NULL,

Line 564: p_l_created_by IN jtf_number_table := NULL,

560: FUNCTION Construct_SL_Line_Tbl(
561: p_l_shp_list_item_id IN jtf_number_table := NULL,
562: p_l_object_version_number IN jtf_number_table := NULL,
563: p_l_creation_date IN jtf_date_table := NULL,
564: p_l_created_by IN jtf_number_table := NULL,
565: p_l_last_updated_by IN jtf_number_table := NULL,
566: p_l_last_update_date IN jtf_date_table := NULL,
567: p_l_last_update_login IN jtf_number_table := NULL,
568: p_l_request_id IN jtf_number_table := NULL,

Line 565: p_l_last_updated_by IN jtf_number_table := NULL,

561: p_l_shp_list_item_id IN jtf_number_table := NULL,
562: p_l_object_version_number IN jtf_number_table := NULL,
563: p_l_creation_date IN jtf_date_table := NULL,
564: p_l_created_by IN jtf_number_table := NULL,
565: p_l_last_updated_by IN jtf_number_table := NULL,
566: p_l_last_update_date IN jtf_date_table := NULL,
567: p_l_last_update_login IN jtf_number_table := NULL,
568: p_l_request_id IN jtf_number_table := NULL,
569: p_l_program_id IN jtf_number_table := NULL,

Line 567: p_l_last_update_login IN jtf_number_table := NULL,

563: p_l_creation_date IN jtf_date_table := NULL,
564: p_l_created_by IN jtf_number_table := NULL,
565: p_l_last_updated_by IN jtf_number_table := NULL,
566: p_l_last_update_date IN jtf_date_table := NULL,
567: p_l_last_update_login IN jtf_number_table := NULL,
568: p_l_request_id IN jtf_number_table := NULL,
569: p_l_program_id IN jtf_number_table := NULL,
570: p_l_program_application_id IN jtf_number_table := NULL,
571: p_l_program_update_date IN jtf_date_table := NULL,

Line 568: p_l_request_id IN jtf_number_table := NULL,

564: p_l_created_by IN jtf_number_table := NULL,
565: p_l_last_updated_by IN jtf_number_table := NULL,
566: p_l_last_update_date IN jtf_date_table := NULL,
567: p_l_last_update_login IN jtf_number_table := NULL,
568: p_l_request_id IN jtf_number_table := NULL,
569: p_l_program_id IN jtf_number_table := NULL,
570: p_l_program_application_id IN jtf_number_table := NULL,
571: p_l_program_update_date IN jtf_date_table := NULL,
572: p_l_shp_list_id IN jtf_number_table := NULL,

Line 569: p_l_program_id IN jtf_number_table := NULL,

565: p_l_last_updated_by IN jtf_number_table := NULL,
566: p_l_last_update_date IN jtf_date_table := NULL,
567: p_l_last_update_login IN jtf_number_table := NULL,
568: p_l_request_id IN jtf_number_table := NULL,
569: p_l_program_id IN jtf_number_table := NULL,
570: p_l_program_application_id IN jtf_number_table := 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,

Line 570: p_l_program_application_id IN jtf_number_table := NULL,

566: p_l_last_update_date IN jtf_date_table := NULL,
567: p_l_last_update_login IN jtf_number_table := NULL,
568: p_l_request_id IN jtf_number_table := NULL,
569: p_l_program_id IN jtf_number_table := NULL,
570: p_l_program_application_id IN jtf_number_table := 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,

Line 572: p_l_shp_list_id IN jtf_number_table := NULL,

568: p_l_request_id IN jtf_number_table := NULL,
569: p_l_program_id IN jtf_number_table := NULL,
570: p_l_program_application_id IN jtf_number_table := 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,

Line 573: p_l_inventory_item_id IN jtf_number_table := NULL,

569: p_l_program_id IN jtf_number_table := NULL,
570: p_l_program_application_id IN jtf_number_table := 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,

Line 574: p_l_organization_id IN jtf_number_table := NULL,

570: p_l_program_application_id IN jtf_number_table := 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,

Line 576: p_l_quantity IN jtf_number_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,
580: p_l_valid_configuration_flag IN jtf_varchar2_table_100 := NULL,

Line 577: p_l_config_header_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,
580: p_l_valid_configuration_flag IN jtf_varchar2_table_100 := NULL,
581: p_l_item_type_code IN jtf_varchar2_table_100 := NULL,

Line 578: p_l_config_revision_num 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,
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,

Line 598: p_l_org_id IN jtf_number_table := 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
602: := IBE_Shop_List_PVT.G_MISS_SL_LINE_TBL;

Line 802: p_lr_shlitem_rel_id IN jtf_number_table := NULL,

798: END Construct_SL_Line_Tbl;
799:
800:
801: FUNCTION Construct_SL_Line_Rel_Tbl(
802: p_lr_shlitem_rel_id IN jtf_number_table := NULL,
803: p_lr_request_id IN jtf_number_table := NULL,
804: p_lr_program_application_id IN jtf_number_table := NULL,
805: p_lr_program_id IN jtf_number_table := NULL,
806: p_lr_program_update_date IN jtf_date_table := NULL,

Line 803: p_lr_request_id IN jtf_number_table := NULL,

799:
800:
801: FUNCTION Construct_SL_Line_Rel_Tbl(
802: p_lr_shlitem_rel_id IN jtf_number_table := NULL,
803: p_lr_request_id IN jtf_number_table := NULL,
804: p_lr_program_application_id IN jtf_number_table := NULL,
805: p_lr_program_id IN jtf_number_table := NULL,
806: p_lr_program_update_date IN jtf_date_table := NULL,
807: p_lr_object_version_number IN jtf_number_table := NULL,

Line 804: p_lr_program_application_id IN jtf_number_table := NULL,

800:
801: FUNCTION Construct_SL_Line_Rel_Tbl(
802: p_lr_shlitem_rel_id IN jtf_number_table := NULL,
803: p_lr_request_id IN jtf_number_table := NULL,
804: p_lr_program_application_id IN jtf_number_table := NULL,
805: p_lr_program_id IN jtf_number_table := NULL,
806: p_lr_program_update_date IN jtf_date_table := NULL,
807: p_lr_object_version_number IN jtf_number_table := NULL,
808: p_lr_created_by IN jtf_number_table := NULL,

Line 805: p_lr_program_id IN jtf_number_table := NULL,

801: FUNCTION Construct_SL_Line_Rel_Tbl(
802: p_lr_shlitem_rel_id IN jtf_number_table := NULL,
803: p_lr_request_id IN jtf_number_table := NULL,
804: p_lr_program_application_id IN jtf_number_table := NULL,
805: p_lr_program_id IN jtf_number_table := NULL,
806: p_lr_program_update_date IN jtf_date_table := NULL,
807: p_lr_object_version_number IN jtf_number_table := NULL,
808: p_lr_created_by IN jtf_number_table := NULL,
809: p_lr_creation_date IN jtf_date_table := NULL,

Line 807: p_lr_object_version_number IN jtf_number_table := NULL,

803: p_lr_request_id IN jtf_number_table := NULL,
804: p_lr_program_application_id IN jtf_number_table := NULL,
805: p_lr_program_id IN jtf_number_table := NULL,
806: p_lr_program_update_date IN jtf_date_table := NULL,
807: p_lr_object_version_number IN jtf_number_table := NULL,
808: p_lr_created_by IN jtf_number_table := NULL,
809: p_lr_creation_date IN jtf_date_table := NULL,
810: p_lr_last_updated_by IN jtf_number_table := NULL,
811: p_lr_last_update_date IN jtf_date_table := NULL,

Line 808: p_lr_created_by IN jtf_number_table := NULL,

804: p_lr_program_application_id IN jtf_number_table := NULL,
805: p_lr_program_id IN jtf_number_table := NULL,
806: p_lr_program_update_date IN jtf_date_table := NULL,
807: p_lr_object_version_number IN jtf_number_table := NULL,
808: p_lr_created_by IN jtf_number_table := NULL,
809: p_lr_creation_date IN jtf_date_table := NULL,
810: p_lr_last_updated_by IN jtf_number_table := NULL,
811: p_lr_last_update_date IN jtf_date_table := NULL,
812: p_lr_last_update_login IN jtf_number_table := NULL,

Line 810: p_lr_last_updated_by IN jtf_number_table := NULL,

806: p_lr_program_update_date IN jtf_date_table := NULL,
807: p_lr_object_version_number IN jtf_number_table := NULL,
808: p_lr_created_by IN jtf_number_table := NULL,
809: p_lr_creation_date IN jtf_date_table := NULL,
810: p_lr_last_updated_by IN jtf_number_table := NULL,
811: p_lr_last_update_date IN jtf_date_table := NULL,
812: p_lr_last_update_login IN jtf_number_table := NULL,
813: p_lr_shp_list_item_id IN jtf_number_table := NULL,
814: p_lr_line_index IN jtf_number_table := NULL,

Line 812: p_lr_last_update_login IN jtf_number_table := NULL,

808: p_lr_created_by IN jtf_number_table := NULL,
809: p_lr_creation_date IN jtf_date_table := NULL,
810: p_lr_last_updated_by IN jtf_number_table := NULL,
811: p_lr_last_update_date IN jtf_date_table := NULL,
812: p_lr_last_update_login IN jtf_number_table := 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,

Line 813: p_lr_shp_list_item_id IN jtf_number_table := NULL,

809: p_lr_creation_date IN jtf_date_table := NULL,
810: p_lr_last_updated_by IN jtf_number_table := NULL,
811: p_lr_last_update_date IN jtf_date_table := NULL,
812: p_lr_last_update_login IN jtf_number_table := 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

Line 814: p_lr_line_index IN jtf_number_table := NULL,

810: p_lr_last_updated_by IN jtf_number_table := NULL,
811: p_lr_last_update_date IN jtf_date_table := NULL,
812: p_lr_last_update_login IN jtf_number_table := 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

Line 815: p_lr_related_shp_list_item_id IN jtf_number_table := NULL,

811: p_lr_last_update_date IN jtf_date_table := NULL,
812: p_lr_last_update_login IN jtf_number_table := 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

Line 816: p_lr_related_line_index IN jtf_number_table := NULL,

812: p_lr_last_update_login IN jtf_number_table := 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

Line 982: p_l_shp_list_item_id IN jtf_number_table := NULL ,

978: p_h_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
979: p_h_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
980: p_h_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
981: p_h_org_id IN NUMBER := FND_API.G_MISS_NUM ,
982: p_l_shp_list_item_id IN jtf_number_table := NULL ,
983: p_l_object_version_number IN jtf_number_table := NULL ,
984: p_l_creation_date IN jtf_date_table := NULL ,
985: p_l_created_by IN jtf_number_table := NULL ,
986: p_l_last_updated_by IN jtf_number_table := NULL ,

Line 983: p_l_object_version_number IN jtf_number_table := NULL ,

979: p_h_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
980: p_h_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
981: p_h_org_id IN NUMBER := FND_API.G_MISS_NUM ,
982: p_l_shp_list_item_id IN jtf_number_table := NULL ,
983: p_l_object_version_number IN jtf_number_table := NULL ,
984: p_l_creation_date IN jtf_date_table := NULL ,
985: p_l_created_by IN jtf_number_table := NULL ,
986: p_l_last_updated_by IN jtf_number_table := NULL ,
987: p_l_last_update_date IN jtf_date_table := NULL ,

Line 985: p_l_created_by IN jtf_number_table := NULL ,

981: p_h_org_id IN NUMBER := FND_API.G_MISS_NUM ,
982: p_l_shp_list_item_id IN jtf_number_table := NULL ,
983: p_l_object_version_number IN jtf_number_table := NULL ,
984: p_l_creation_date IN jtf_date_table := NULL ,
985: p_l_created_by IN jtf_number_table := NULL ,
986: p_l_last_updated_by IN jtf_number_table := NULL ,
987: p_l_last_update_date IN jtf_date_table := NULL ,
988: p_l_last_update_login IN jtf_number_table := NULL ,
989: p_l_request_id IN jtf_number_table := NULL ,

Line 986: p_l_last_updated_by IN jtf_number_table := NULL ,

982: p_l_shp_list_item_id IN jtf_number_table := NULL ,
983: p_l_object_version_number IN jtf_number_table := NULL ,
984: p_l_creation_date IN jtf_date_table := NULL ,
985: p_l_created_by IN jtf_number_table := NULL ,
986: p_l_last_updated_by IN jtf_number_table := NULL ,
987: p_l_last_update_date IN jtf_date_table := NULL ,
988: p_l_last_update_login IN jtf_number_table := NULL ,
989: p_l_request_id IN jtf_number_table := NULL ,
990: p_l_program_id IN jtf_number_table := NULL ,

Line 988: p_l_last_update_login IN jtf_number_table := NULL ,

984: p_l_creation_date IN jtf_date_table := NULL ,
985: p_l_created_by IN jtf_number_table := NULL ,
986: p_l_last_updated_by IN jtf_number_table := NULL ,
987: p_l_last_update_date IN jtf_date_table := NULL ,
988: p_l_last_update_login IN jtf_number_table := NULL ,
989: p_l_request_id IN jtf_number_table := NULL ,
990: p_l_program_id IN jtf_number_table := NULL ,
991: p_l_program_application_id IN jtf_number_table := NULL ,
992: p_l_program_update_date IN jtf_date_table := NULL ,

Line 989: p_l_request_id IN jtf_number_table := NULL ,

985: p_l_created_by IN jtf_number_table := NULL ,
986: p_l_last_updated_by IN jtf_number_table := NULL ,
987: p_l_last_update_date IN jtf_date_table := NULL ,
988: p_l_last_update_login IN jtf_number_table := NULL ,
989: p_l_request_id IN jtf_number_table := NULL ,
990: p_l_program_id IN jtf_number_table := NULL ,
991: p_l_program_application_id IN jtf_number_table := NULL ,
992: p_l_program_update_date IN jtf_date_table := NULL ,
993: p_l_shp_list_id IN jtf_number_table := NULL ,

Line 990: p_l_program_id IN jtf_number_table := NULL ,

986: p_l_last_updated_by IN jtf_number_table := NULL ,
987: p_l_last_update_date IN jtf_date_table := NULL ,
988: p_l_last_update_login IN jtf_number_table := NULL ,
989: p_l_request_id IN jtf_number_table := NULL ,
990: p_l_program_id IN jtf_number_table := NULL ,
991: p_l_program_application_id IN jtf_number_table := 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 ,

Line 991: p_l_program_application_id IN jtf_number_table := NULL ,

987: p_l_last_update_date IN jtf_date_table := NULL ,
988: p_l_last_update_login IN jtf_number_table := NULL ,
989: p_l_request_id IN jtf_number_table := NULL ,
990: p_l_program_id IN jtf_number_table := NULL ,
991: p_l_program_application_id IN jtf_number_table := 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 ,

Line 993: p_l_shp_list_id IN jtf_number_table := NULL ,

989: p_l_request_id IN jtf_number_table := NULL ,
990: p_l_program_id IN jtf_number_table := NULL ,
991: p_l_program_application_id IN jtf_number_table := 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 ,

Line 994: p_l_inventory_item_id IN jtf_number_table := NULL ,

990: p_l_program_id IN jtf_number_table := NULL ,
991: p_l_program_application_id IN jtf_number_table := 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 ,

Line 995: p_l_organization_id IN jtf_number_table := NULL ,

991: p_l_program_application_id IN jtf_number_table := 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 ,

Line 997: p_l_quantity IN jtf_number_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 ,
1001: p_l_valid_configuration_flag IN jtf_varchar2_table_100 := NULL ,

Line 998: p_l_config_header_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 ,
1001: p_l_valid_configuration_flag IN jtf_varchar2_table_100 := NULL ,
1002: p_l_item_type_code IN jtf_varchar2_table_100 := NULL ,

Line 999: p_l_config_revision_num 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 ,
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 ,

Line 1019: p_l_org_id IN jtf_number_table := 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 ,
1023: p_lr_program_id IN jtf_number_table := NULL ,

Line 1020: p_lr_shlitem_rel_id IN jtf_number_table := 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 ,
1023: p_lr_program_id IN jtf_number_table := NULL ,
1024: p_lr_program_update_date IN jtf_date_table := NULL ,

Line 1021: p_lr_request_id IN jtf_number_table := 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 ,
1023: p_lr_program_id IN jtf_number_table := NULL ,
1024: p_lr_program_update_date IN jtf_date_table := NULL ,
1025: p_lr_object_version_number IN jtf_number_table := NULL ,

Line 1022: p_lr_program_application_id IN jtf_number_table := 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 ,
1023: p_lr_program_id IN jtf_number_table := NULL ,
1024: p_lr_program_update_date IN jtf_date_table := NULL ,
1025: p_lr_object_version_number IN jtf_number_table := NULL ,
1026: p_lr_created_by IN jtf_number_table := NULL ,

Line 1023: p_lr_program_id IN jtf_number_table := 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 ,
1023: p_lr_program_id IN jtf_number_table := NULL ,
1024: p_lr_program_update_date IN jtf_date_table := NULL ,
1025: p_lr_object_version_number IN jtf_number_table := NULL ,
1026: p_lr_created_by IN jtf_number_table := NULL ,
1027: p_lr_creation_date IN jtf_date_table := NULL ,

Line 1025: p_lr_object_version_number 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 ,
1023: p_lr_program_id IN jtf_number_table := NULL ,
1024: p_lr_program_update_date IN jtf_date_table := NULL ,
1025: p_lr_object_version_number IN jtf_number_table := NULL ,
1026: p_lr_created_by IN jtf_number_table := NULL ,
1027: p_lr_creation_date IN jtf_date_table := NULL ,
1028: p_lr_last_updated_by IN jtf_number_table := NULL ,
1029: p_lr_last_update_date IN jtf_date_table := NULL ,

Line 1026: p_lr_created_by IN jtf_number_table := NULL ,

1022: p_lr_program_application_id IN jtf_number_table := NULL ,
1023: p_lr_program_id IN jtf_number_table := NULL ,
1024: p_lr_program_update_date IN jtf_date_table := NULL ,
1025: p_lr_object_version_number IN jtf_number_table := NULL ,
1026: p_lr_created_by IN jtf_number_table := NULL ,
1027: p_lr_creation_date IN jtf_date_table := NULL ,
1028: p_lr_last_updated_by IN jtf_number_table := NULL ,
1029: p_lr_last_update_date IN jtf_date_table := NULL ,
1030: p_lr_last_update_login IN jtf_number_table := NULL ,

Line 1028: p_lr_last_updated_by IN jtf_number_table := NULL ,

1024: p_lr_program_update_date IN jtf_date_table := NULL ,
1025: p_lr_object_version_number IN jtf_number_table := NULL ,
1026: p_lr_created_by IN jtf_number_table := NULL ,
1027: p_lr_creation_date IN jtf_date_table := NULL ,
1028: p_lr_last_updated_by IN jtf_number_table := NULL ,
1029: p_lr_last_update_date IN jtf_date_table := NULL ,
1030: p_lr_last_update_login IN jtf_number_table := NULL ,
1031: p_lr_shp_list_item_id IN jtf_number_table := NULL ,
1032: p_lr_line_index IN jtf_number_table := NULL ,

Line 1030: p_lr_last_update_login IN jtf_number_table := NULL ,

1026: p_lr_created_by IN jtf_number_table := NULL ,
1027: p_lr_creation_date IN jtf_date_table := NULL ,
1028: p_lr_last_updated_by IN jtf_number_table := NULL ,
1029: p_lr_last_update_date IN jtf_date_table := NULL ,
1030: p_lr_last_update_login IN jtf_number_table := 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 ,

Line 1031: p_lr_shp_list_item_id IN jtf_number_table := NULL ,

1027: p_lr_creation_date IN jtf_date_table := NULL ,
1028: p_lr_last_updated_by IN jtf_number_table := NULL ,
1029: p_lr_last_update_date IN jtf_date_table := NULL ,
1030: p_lr_last_update_login IN jtf_number_table := 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 ,

Line 1032: p_lr_line_index IN jtf_number_table := NULL ,

1028: p_lr_last_updated_by IN jtf_number_table := NULL ,
1029: p_lr_last_update_date IN jtf_date_table := NULL ,
1030: p_lr_last_update_login IN jtf_number_table := 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

Line 1033: p_lr_related_shp_list_item_id IN jtf_number_table := NULL ,

1029: p_lr_last_update_date IN jtf_date_table := NULL ,
1030: p_lr_last_update_login IN jtf_number_table := 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: )

Line 1034: p_lr_related_line_index IN jtf_number_table := NULL ,

1030: p_lr_last_update_login IN jtf_number_table := 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

Line 1158: p_sl_line_ids IN jtf_number_table ,

1154: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
1155: x_return_status OUT NOCOPY VARCHAR2 ,
1156: x_msg_count OUT NOCOPY NUMBER ,
1157: x_msg_data OUT NOCOPY VARCHAR2 ,
1158: p_sl_line_ids IN jtf_number_table ,
1159: p_sl_line_ovns IN jtf_number_table := NULL ,
1160: p_mode IN VARCHAR2 := 'MERGE' ,
1161: p_combine_same_item IN VARCHAR2 := FND_API.G_MISS_CHAR,
1162: p_h_shp_list_id IN NUMBER := FND_API.G_MISS_NUM ,

Line 1159: p_sl_line_ovns IN jtf_number_table := NULL ,

1155: x_return_status OUT NOCOPY VARCHAR2 ,
1156: x_msg_count OUT NOCOPY NUMBER ,
1157: x_msg_data OUT NOCOPY VARCHAR2 ,
1158: p_sl_line_ids IN jtf_number_table ,
1159: p_sl_line_ovns IN jtf_number_table := NULL ,
1160: p_mode IN VARCHAR2 := 'MERGE' ,
1161: p_combine_same_item IN VARCHAR2 := FND_API.G_MISS_CHAR,
1162: p_h_shp_list_id IN NUMBER := FND_API.G_MISS_NUM ,
1163: p_h_request_id IN NUMBER := FND_API.G_MISS_NUM ,

Line 1358: p_sl_line_ids IN jtf_number_table ,

1354: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
1355: x_return_status OUT NOCOPY VARCHAR2 ,
1356: x_msg_count OUT NOCOPY NUMBER ,
1357: x_msg_data OUT NOCOPY VARCHAR2 ,
1358: p_sl_line_ids IN jtf_number_table ,
1359: p_sl_line_ovns IN jtf_number_table := NULL ,
1360: p_quote_retrieval_number IN NUMBER := FND_API.G_MISS_NUM ,
1361: p_recipient_party_id IN NUMBER := FND_API.G_MISS_NUM ,
1362: p_recipient_cust_account_id IN NUMBER := FND_API.G_MISS_NUM ,

Line 1359: p_sl_line_ovns IN jtf_number_table := NULL ,

1355: x_return_status OUT NOCOPY VARCHAR2 ,
1356: x_msg_count OUT NOCOPY NUMBER ,
1357: x_msg_data OUT NOCOPY VARCHAR2 ,
1358: p_sl_line_ids IN jtf_number_table ,
1359: p_sl_line_ovns IN jtf_number_table := NULL ,
1360: p_quote_retrieval_number IN NUMBER := FND_API.G_MISS_NUM ,
1361: p_recipient_party_id IN NUMBER := FND_API.G_MISS_NUM ,
1362: p_recipient_cust_account_id IN NUMBER := FND_API.G_MISS_NUM ,
1363: p_minisite_id IN NUMBER := FND_API.G_MISS_NUM ,