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 554: p_l_shp_list_item_id IN jtf_number_table := NULL,

550: END Construct_SL_Header_Rec;
551:
552:
553: FUNCTION Construct_SL_Line_Tbl(
554: p_l_shp_list_item_id IN jtf_number_table := NULL,
555: p_l_object_version_number IN jtf_number_table := NULL,
556: p_l_creation_date IN jtf_date_table := NULL,
557: p_l_created_by IN jtf_number_table := NULL,
558: p_l_last_updated_by IN jtf_number_table := NULL,

Line 555: p_l_object_version_number IN jtf_number_table := NULL,

551:
552:
553: FUNCTION Construct_SL_Line_Tbl(
554: p_l_shp_list_item_id IN jtf_number_table := NULL,
555: p_l_object_version_number IN jtf_number_table := NULL,
556: p_l_creation_date IN jtf_date_table := NULL,
557: p_l_created_by IN jtf_number_table := NULL,
558: p_l_last_updated_by IN jtf_number_table := NULL,
559: p_l_last_update_date IN jtf_date_table := NULL,

Line 557: p_l_created_by IN jtf_number_table := NULL,

553: FUNCTION Construct_SL_Line_Tbl(
554: p_l_shp_list_item_id IN jtf_number_table := NULL,
555: p_l_object_version_number IN jtf_number_table := NULL,
556: p_l_creation_date IN jtf_date_table := NULL,
557: p_l_created_by IN jtf_number_table := NULL,
558: p_l_last_updated_by IN jtf_number_table := NULL,
559: p_l_last_update_date IN jtf_date_table := NULL,
560: p_l_last_update_login IN jtf_number_table := NULL,
561: p_l_request_id IN jtf_number_table := NULL,

Line 558: p_l_last_updated_by IN jtf_number_table := NULL,

554: p_l_shp_list_item_id IN jtf_number_table := NULL,
555: p_l_object_version_number IN jtf_number_table := NULL,
556: p_l_creation_date IN jtf_date_table := NULL,
557: p_l_created_by IN jtf_number_table := NULL,
558: p_l_last_updated_by IN jtf_number_table := NULL,
559: p_l_last_update_date IN jtf_date_table := NULL,
560: p_l_last_update_login IN jtf_number_table := NULL,
561: p_l_request_id IN jtf_number_table := NULL,
562: p_l_program_id IN jtf_number_table := NULL,

Line 560: p_l_last_update_login IN jtf_number_table := NULL,

556: p_l_creation_date IN jtf_date_table := NULL,
557: p_l_created_by IN jtf_number_table := NULL,
558: p_l_last_updated_by IN jtf_number_table := NULL,
559: p_l_last_update_date IN jtf_date_table := NULL,
560: p_l_last_update_login IN jtf_number_table := NULL,
561: p_l_request_id IN jtf_number_table := NULL,
562: p_l_program_id IN jtf_number_table := NULL,
563: p_l_program_application_id IN jtf_number_table := NULL,
564: p_l_program_update_date IN jtf_date_table := NULL,

Line 561: p_l_request_id IN jtf_number_table := NULL,

557: p_l_created_by IN jtf_number_table := NULL,
558: p_l_last_updated_by IN jtf_number_table := NULL,
559: p_l_last_update_date IN jtf_date_table := NULL,
560: p_l_last_update_login IN jtf_number_table := NULL,
561: p_l_request_id IN jtf_number_table := NULL,
562: p_l_program_id IN jtf_number_table := NULL,
563: p_l_program_application_id IN jtf_number_table := NULL,
564: p_l_program_update_date IN jtf_date_table := NULL,
565: p_l_shp_list_id IN jtf_number_table := NULL,

Line 562: p_l_program_id IN jtf_number_table := NULL,

558: p_l_last_updated_by IN jtf_number_table := NULL,
559: p_l_last_update_date IN jtf_date_table := NULL,
560: p_l_last_update_login IN jtf_number_table := NULL,
561: p_l_request_id IN jtf_number_table := NULL,
562: p_l_program_id IN jtf_number_table := NULL,
563: p_l_program_application_id IN jtf_number_table := 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,

Line 563: p_l_program_application_id IN jtf_number_table := NULL,

559: p_l_last_update_date IN jtf_date_table := NULL,
560: p_l_last_update_login IN jtf_number_table := NULL,
561: p_l_request_id IN jtf_number_table := NULL,
562: p_l_program_id IN jtf_number_table := NULL,
563: p_l_program_application_id IN jtf_number_table := 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,

Line 565: p_l_shp_list_id IN jtf_number_table := NULL,

561: p_l_request_id IN jtf_number_table := NULL,
562: p_l_program_id IN jtf_number_table := NULL,
563: p_l_program_application_id IN jtf_number_table := 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,

Line 566: p_l_inventory_item_id IN jtf_number_table := NULL,

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

Line 567: p_l_organization_id IN jtf_number_table := NULL,

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

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

Line 570: p_l_config_header_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,
573: p_l_valid_configuration_flag IN jtf_varchar2_table_100 := NULL,
574: p_l_item_type_code IN jtf_varchar2_table_100 := NULL,

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

Line 591: p_l_org_id IN jtf_number_table := NULL

587: p_l_attribute12 IN jtf_varchar2_table_200 := NULL,
588: p_l_attribute13 IN jtf_varchar2_table_200 := NULL,
589: p_l_attribute14 IN jtf_varchar2_table_200 := NULL,
590: p_l_attribute15 IN jtf_varchar2_table_200 := NULL,
591: p_l_org_id IN jtf_number_table := NULL
592: ) RETURN IBE_Shop_List_PVT.SL_Line_Tbl_Type
593: IS
594: sl_line_tbl IBE_Shop_List_PVT.SL_Line_Tbl_Type
595: := IBE_Shop_List_PVT.G_MISS_SL_LINE_TBL;

Line 795: p_lr_shlitem_rel_id IN jtf_number_table := NULL,

791: END Construct_SL_Line_Tbl;
792:
793:
794: FUNCTION Construct_SL_Line_Rel_Tbl(
795: p_lr_shlitem_rel_id IN jtf_number_table := NULL,
796: p_lr_request_id IN jtf_number_table := NULL,
797: p_lr_program_application_id IN jtf_number_table := NULL,
798: p_lr_program_id IN jtf_number_table := NULL,
799: p_lr_program_update_date IN jtf_date_table := NULL,

Line 796: p_lr_request_id IN jtf_number_table := NULL,

792:
793:
794: FUNCTION Construct_SL_Line_Rel_Tbl(
795: p_lr_shlitem_rel_id IN jtf_number_table := NULL,
796: p_lr_request_id IN jtf_number_table := NULL,
797: p_lr_program_application_id IN jtf_number_table := NULL,
798: p_lr_program_id IN jtf_number_table := NULL,
799: p_lr_program_update_date IN jtf_date_table := NULL,
800: p_lr_object_version_number IN jtf_number_table := NULL,

Line 797: p_lr_program_application_id IN jtf_number_table := NULL,

793:
794: FUNCTION Construct_SL_Line_Rel_Tbl(
795: p_lr_shlitem_rel_id IN jtf_number_table := NULL,
796: p_lr_request_id IN jtf_number_table := NULL,
797: p_lr_program_application_id IN jtf_number_table := NULL,
798: p_lr_program_id IN jtf_number_table := NULL,
799: p_lr_program_update_date IN jtf_date_table := NULL,
800: p_lr_object_version_number IN jtf_number_table := NULL,
801: p_lr_created_by IN jtf_number_table := NULL,

Line 798: p_lr_program_id IN jtf_number_table := NULL,

794: FUNCTION Construct_SL_Line_Rel_Tbl(
795: p_lr_shlitem_rel_id IN jtf_number_table := NULL,
796: p_lr_request_id IN jtf_number_table := NULL,
797: p_lr_program_application_id IN jtf_number_table := NULL,
798: p_lr_program_id IN jtf_number_table := NULL,
799: p_lr_program_update_date IN jtf_date_table := NULL,
800: p_lr_object_version_number IN jtf_number_table := NULL,
801: p_lr_created_by IN jtf_number_table := NULL,
802: p_lr_creation_date IN jtf_date_table := NULL,

Line 800: p_lr_object_version_number IN jtf_number_table := NULL,

796: p_lr_request_id IN jtf_number_table := NULL,
797: p_lr_program_application_id IN jtf_number_table := NULL,
798: p_lr_program_id IN jtf_number_table := NULL,
799: p_lr_program_update_date IN jtf_date_table := NULL,
800: p_lr_object_version_number IN jtf_number_table := NULL,
801: p_lr_created_by IN jtf_number_table := NULL,
802: p_lr_creation_date IN jtf_date_table := NULL,
803: p_lr_last_updated_by IN jtf_number_table := NULL,
804: p_lr_last_update_date IN jtf_date_table := NULL,

Line 801: p_lr_created_by IN jtf_number_table := NULL,

797: p_lr_program_application_id IN jtf_number_table := NULL,
798: p_lr_program_id IN jtf_number_table := NULL,
799: p_lr_program_update_date IN jtf_date_table := NULL,
800: p_lr_object_version_number IN jtf_number_table := NULL,
801: p_lr_created_by IN jtf_number_table := NULL,
802: p_lr_creation_date IN jtf_date_table := NULL,
803: p_lr_last_updated_by IN jtf_number_table := NULL,
804: p_lr_last_update_date IN jtf_date_table := NULL,
805: p_lr_last_update_login IN jtf_number_table := NULL,

Line 803: p_lr_last_updated_by IN jtf_number_table := NULL,

799: p_lr_program_update_date IN jtf_date_table := NULL,
800: p_lr_object_version_number IN jtf_number_table := NULL,
801: p_lr_created_by IN jtf_number_table := NULL,
802: p_lr_creation_date IN jtf_date_table := NULL,
803: p_lr_last_updated_by IN jtf_number_table := NULL,
804: p_lr_last_update_date IN jtf_date_table := NULL,
805: p_lr_last_update_login IN jtf_number_table := NULL,
806: p_lr_shp_list_item_id IN jtf_number_table := NULL,
807: p_lr_line_index IN jtf_number_table := NULL,

Line 805: p_lr_last_update_login IN jtf_number_table := NULL,

801: p_lr_created_by IN jtf_number_table := NULL,
802: p_lr_creation_date IN jtf_date_table := NULL,
803: p_lr_last_updated_by IN jtf_number_table := NULL,
804: p_lr_last_update_date IN jtf_date_table := NULL,
805: p_lr_last_update_login IN jtf_number_table := 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,

Line 806: p_lr_shp_list_item_id IN jtf_number_table := NULL,

802: p_lr_creation_date IN jtf_date_table := NULL,
803: p_lr_last_updated_by IN jtf_number_table := NULL,
804: p_lr_last_update_date IN jtf_date_table := NULL,
805: p_lr_last_update_login IN jtf_number_table := 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

Line 807: p_lr_line_index IN jtf_number_table := NULL,

803: p_lr_last_updated_by IN jtf_number_table := NULL,
804: p_lr_last_update_date IN jtf_date_table := NULL,
805: p_lr_last_update_login IN jtf_number_table := 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

Line 808: p_lr_related_shp_list_item_id IN jtf_number_table := NULL,

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

Line 809: p_lr_related_line_index IN jtf_number_table := NULL,

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

Line 975: p_l_shp_list_item_id IN jtf_number_table := NULL ,

971: p_h_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
972: p_h_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
973: p_h_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
974: p_h_org_id IN NUMBER := FND_API.G_MISS_NUM ,
975: p_l_shp_list_item_id IN jtf_number_table := NULL ,
976: p_l_object_version_number IN jtf_number_table := NULL ,
977: p_l_creation_date IN jtf_date_table := NULL ,
978: p_l_created_by IN jtf_number_table := NULL ,
979: p_l_last_updated_by IN jtf_number_table := NULL ,

Line 976: p_l_object_version_number IN jtf_number_table := NULL ,

972: p_h_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
973: p_h_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
974: p_h_org_id IN NUMBER := FND_API.G_MISS_NUM ,
975: p_l_shp_list_item_id IN jtf_number_table := NULL ,
976: p_l_object_version_number IN jtf_number_table := NULL ,
977: p_l_creation_date IN jtf_date_table := NULL ,
978: p_l_created_by IN jtf_number_table := NULL ,
979: p_l_last_updated_by IN jtf_number_table := NULL ,
980: p_l_last_update_date IN jtf_date_table := NULL ,

Line 978: p_l_created_by IN jtf_number_table := NULL ,

974: p_h_org_id IN NUMBER := FND_API.G_MISS_NUM ,
975: p_l_shp_list_item_id IN jtf_number_table := NULL ,
976: p_l_object_version_number IN jtf_number_table := NULL ,
977: p_l_creation_date IN jtf_date_table := NULL ,
978: p_l_created_by IN jtf_number_table := NULL ,
979: p_l_last_updated_by IN jtf_number_table := NULL ,
980: p_l_last_update_date IN jtf_date_table := NULL ,
981: p_l_last_update_login IN jtf_number_table := NULL ,
982: p_l_request_id IN jtf_number_table := NULL ,

Line 979: p_l_last_updated_by IN jtf_number_table := NULL ,

975: p_l_shp_list_item_id IN jtf_number_table := NULL ,
976: p_l_object_version_number IN jtf_number_table := NULL ,
977: p_l_creation_date IN jtf_date_table := NULL ,
978: p_l_created_by IN jtf_number_table := NULL ,
979: p_l_last_updated_by IN jtf_number_table := NULL ,
980: p_l_last_update_date IN jtf_date_table := NULL ,
981: p_l_last_update_login IN jtf_number_table := NULL ,
982: p_l_request_id IN jtf_number_table := NULL ,
983: p_l_program_id IN jtf_number_table := NULL ,

Line 981: p_l_last_update_login IN jtf_number_table := NULL ,

977: p_l_creation_date IN jtf_date_table := NULL ,
978: p_l_created_by IN jtf_number_table := NULL ,
979: p_l_last_updated_by IN jtf_number_table := NULL ,
980: p_l_last_update_date IN jtf_date_table := NULL ,
981: p_l_last_update_login IN jtf_number_table := NULL ,
982: p_l_request_id IN jtf_number_table := NULL ,
983: p_l_program_id IN jtf_number_table := NULL ,
984: p_l_program_application_id IN jtf_number_table := NULL ,
985: p_l_program_update_date IN jtf_date_table := NULL ,

Line 982: p_l_request_id IN jtf_number_table := NULL ,

978: p_l_created_by IN jtf_number_table := NULL ,
979: p_l_last_updated_by IN jtf_number_table := NULL ,
980: p_l_last_update_date IN jtf_date_table := NULL ,
981: p_l_last_update_login IN jtf_number_table := NULL ,
982: p_l_request_id IN jtf_number_table := NULL ,
983: p_l_program_id IN jtf_number_table := NULL ,
984: p_l_program_application_id IN jtf_number_table := NULL ,
985: p_l_program_update_date IN jtf_date_table := NULL ,
986: p_l_shp_list_id IN jtf_number_table := NULL ,

Line 983: p_l_program_id IN jtf_number_table := NULL ,

979: p_l_last_updated_by IN jtf_number_table := NULL ,
980: p_l_last_update_date IN jtf_date_table := NULL ,
981: p_l_last_update_login IN jtf_number_table := NULL ,
982: p_l_request_id IN jtf_number_table := NULL ,
983: p_l_program_id IN jtf_number_table := NULL ,
984: p_l_program_application_id IN jtf_number_table := 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 ,

Line 984: p_l_program_application_id IN jtf_number_table := NULL ,

980: p_l_last_update_date IN jtf_date_table := NULL ,
981: p_l_last_update_login IN jtf_number_table := NULL ,
982: p_l_request_id IN jtf_number_table := NULL ,
983: p_l_program_id IN jtf_number_table := NULL ,
984: p_l_program_application_id IN jtf_number_table := 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 ,

Line 986: p_l_shp_list_id IN jtf_number_table := NULL ,

982: p_l_request_id IN jtf_number_table := NULL ,
983: p_l_program_id IN jtf_number_table := NULL ,
984: p_l_program_application_id IN jtf_number_table := 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 ,

Line 987: p_l_inventory_item_id IN jtf_number_table := NULL ,

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

Line 988: p_l_organization_id IN jtf_number_table := NULL ,

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

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

Line 991: p_l_config_header_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 ,
994: p_l_valid_configuration_flag IN jtf_varchar2_table_100 := NULL ,
995: p_l_item_type_code IN jtf_varchar2_table_100 := NULL ,

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

Line 1012: p_l_org_id IN jtf_number_table := NULL ,

1008: p_l_attribute12 IN jtf_varchar2_table_200 := NULL ,
1009: p_l_attribute13 IN jtf_varchar2_table_200 := NULL ,
1010: p_l_attribute14 IN jtf_varchar2_table_200 := NULL ,
1011: p_l_attribute15 IN jtf_varchar2_table_200 := NULL ,
1012: p_l_org_id IN jtf_number_table := NULL ,
1013: p_lr_shlitem_rel_id IN jtf_number_table := NULL ,
1014: p_lr_request_id IN jtf_number_table := NULL ,
1015: p_lr_program_application_id IN jtf_number_table := NULL ,
1016: p_lr_program_id IN jtf_number_table := NULL ,

Line 1013: p_lr_shlitem_rel_id IN jtf_number_table := NULL ,

1009: p_l_attribute13 IN jtf_varchar2_table_200 := NULL ,
1010: p_l_attribute14 IN jtf_varchar2_table_200 := NULL ,
1011: p_l_attribute15 IN jtf_varchar2_table_200 := NULL ,
1012: p_l_org_id IN jtf_number_table := NULL ,
1013: p_lr_shlitem_rel_id IN jtf_number_table := NULL ,
1014: p_lr_request_id IN jtf_number_table := NULL ,
1015: p_lr_program_application_id IN jtf_number_table := NULL ,
1016: p_lr_program_id IN jtf_number_table := NULL ,
1017: p_lr_program_update_date IN jtf_date_table := NULL ,

Line 1014: p_lr_request_id IN jtf_number_table := NULL ,

1010: p_l_attribute14 IN jtf_varchar2_table_200 := NULL ,
1011: p_l_attribute15 IN jtf_varchar2_table_200 := NULL ,
1012: p_l_org_id IN jtf_number_table := NULL ,
1013: p_lr_shlitem_rel_id IN jtf_number_table := NULL ,
1014: p_lr_request_id IN jtf_number_table := NULL ,
1015: p_lr_program_application_id IN jtf_number_table := NULL ,
1016: p_lr_program_id IN jtf_number_table := NULL ,
1017: p_lr_program_update_date IN jtf_date_table := NULL ,
1018: p_lr_object_version_number IN jtf_number_table := NULL ,

Line 1015: p_lr_program_application_id IN jtf_number_table := NULL ,

1011: p_l_attribute15 IN jtf_varchar2_table_200 := NULL ,
1012: p_l_org_id IN jtf_number_table := NULL ,
1013: p_lr_shlitem_rel_id IN jtf_number_table := NULL ,
1014: p_lr_request_id IN jtf_number_table := NULL ,
1015: p_lr_program_application_id IN jtf_number_table := NULL ,
1016: p_lr_program_id IN jtf_number_table := NULL ,
1017: p_lr_program_update_date IN jtf_date_table := NULL ,
1018: p_lr_object_version_number IN jtf_number_table := NULL ,
1019: p_lr_created_by IN jtf_number_table := NULL ,

Line 1016: p_lr_program_id IN jtf_number_table := NULL ,

1012: p_l_org_id IN jtf_number_table := NULL ,
1013: p_lr_shlitem_rel_id IN jtf_number_table := NULL ,
1014: p_lr_request_id IN jtf_number_table := NULL ,
1015: p_lr_program_application_id IN jtf_number_table := NULL ,
1016: p_lr_program_id IN jtf_number_table := NULL ,
1017: p_lr_program_update_date IN jtf_date_table := NULL ,
1018: p_lr_object_version_number IN jtf_number_table := NULL ,
1019: p_lr_created_by IN jtf_number_table := NULL ,
1020: p_lr_creation_date IN jtf_date_table := NULL ,

Line 1018: p_lr_object_version_number IN jtf_number_table := NULL ,

1014: p_lr_request_id IN jtf_number_table := NULL ,
1015: p_lr_program_application_id IN jtf_number_table := NULL ,
1016: p_lr_program_id IN jtf_number_table := NULL ,
1017: p_lr_program_update_date IN jtf_date_table := NULL ,
1018: p_lr_object_version_number IN jtf_number_table := NULL ,
1019: p_lr_created_by IN jtf_number_table := NULL ,
1020: p_lr_creation_date IN jtf_date_table := NULL ,
1021: p_lr_last_updated_by IN jtf_number_table := NULL ,
1022: p_lr_last_update_date IN jtf_date_table := NULL ,

Line 1019: p_lr_created_by IN jtf_number_table := NULL ,

1015: p_lr_program_application_id IN jtf_number_table := NULL ,
1016: p_lr_program_id IN jtf_number_table := NULL ,
1017: p_lr_program_update_date IN jtf_date_table := NULL ,
1018: p_lr_object_version_number IN jtf_number_table := NULL ,
1019: p_lr_created_by IN jtf_number_table := NULL ,
1020: p_lr_creation_date IN jtf_date_table := NULL ,
1021: p_lr_last_updated_by IN jtf_number_table := NULL ,
1022: p_lr_last_update_date IN jtf_date_table := NULL ,
1023: p_lr_last_update_login IN jtf_number_table := NULL ,

Line 1021: p_lr_last_updated_by IN jtf_number_table := NULL ,

1017: p_lr_program_update_date IN jtf_date_table := NULL ,
1018: p_lr_object_version_number IN jtf_number_table := NULL ,
1019: p_lr_created_by IN jtf_number_table := NULL ,
1020: p_lr_creation_date IN jtf_date_table := NULL ,
1021: p_lr_last_updated_by IN jtf_number_table := NULL ,
1022: p_lr_last_update_date IN jtf_date_table := NULL ,
1023: p_lr_last_update_login IN jtf_number_table := NULL ,
1024: p_lr_shp_list_item_id IN jtf_number_table := NULL ,
1025: p_lr_line_index IN jtf_number_table := NULL ,

Line 1023: p_lr_last_update_login IN jtf_number_table := NULL ,

1019: p_lr_created_by IN jtf_number_table := NULL ,
1020: p_lr_creation_date IN jtf_date_table := NULL ,
1021: p_lr_last_updated_by IN jtf_number_table := NULL ,
1022: p_lr_last_update_date IN jtf_date_table := NULL ,
1023: p_lr_last_update_login IN jtf_number_table := 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 ,

Line 1024: p_lr_shp_list_item_id IN jtf_number_table := NULL ,

1020: p_lr_creation_date IN jtf_date_table := NULL ,
1021: p_lr_last_updated_by IN jtf_number_table := NULL ,
1022: p_lr_last_update_date IN jtf_date_table := NULL ,
1023: p_lr_last_update_login IN jtf_number_table := 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 ,

Line 1025: p_lr_line_index IN jtf_number_table := NULL ,

1021: p_lr_last_updated_by IN jtf_number_table := NULL ,
1022: p_lr_last_update_date IN jtf_date_table := NULL ,
1023: p_lr_last_update_login IN jtf_number_table := 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

Line 1026: p_lr_related_shp_list_item_id IN jtf_number_table := NULL ,

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

Line 1027: p_lr_related_line_index IN jtf_number_table := NULL ,

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

Line 1151: p_sl_line_ids IN jtf_number_table ,

1147: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
1148: x_return_status OUT NOCOPY VARCHAR2 ,
1149: x_msg_count OUT NOCOPY NUMBER ,
1150: x_msg_data OUT NOCOPY VARCHAR2 ,
1151: p_sl_line_ids IN jtf_number_table ,
1152: p_sl_line_ovns IN jtf_number_table := NULL ,
1153: p_mode IN VARCHAR2 := 'MERGE' ,
1154: p_combine_same_item IN VARCHAR2 := FND_API.G_MISS_CHAR,
1155: p_h_shp_list_id IN NUMBER := FND_API.G_MISS_NUM ,

Line 1152: p_sl_line_ovns IN jtf_number_table := NULL ,

1148: x_return_status OUT NOCOPY VARCHAR2 ,
1149: x_msg_count OUT NOCOPY NUMBER ,
1150: x_msg_data OUT NOCOPY VARCHAR2 ,
1151: p_sl_line_ids IN jtf_number_table ,
1152: p_sl_line_ovns IN jtf_number_table := NULL ,
1153: p_mode IN VARCHAR2 := 'MERGE' ,
1154: p_combine_same_item IN VARCHAR2 := FND_API.G_MISS_CHAR,
1155: p_h_shp_list_id IN NUMBER := FND_API.G_MISS_NUM ,
1156: p_h_request_id IN NUMBER := FND_API.G_MISS_NUM ,

Line 1351: p_sl_line_ids IN jtf_number_table ,

1347: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
1348: x_return_status OUT NOCOPY VARCHAR2 ,
1349: x_msg_count OUT NOCOPY NUMBER ,
1350: x_msg_data OUT NOCOPY VARCHAR2 ,
1351: p_sl_line_ids IN jtf_number_table ,
1352: p_sl_line_ovns IN jtf_number_table := NULL ,
1353: p_quote_retrieval_number IN NUMBER := FND_API.G_MISS_NUM ,
1354: p_recipient_party_id IN NUMBER := FND_API.G_MISS_NUM ,
1355: p_recipient_cust_account_id IN NUMBER := FND_API.G_MISS_NUM ,

Line 1352: p_sl_line_ovns IN jtf_number_table := NULL ,

1348: x_return_status OUT NOCOPY VARCHAR2 ,
1349: x_msg_count OUT NOCOPY NUMBER ,
1350: x_msg_data OUT NOCOPY VARCHAR2 ,
1351: p_sl_line_ids IN jtf_number_table ,
1352: p_sl_line_ovns IN jtf_number_table := NULL ,
1353: p_quote_retrieval_number IN NUMBER := FND_API.G_MISS_NUM ,
1354: p_recipient_party_id IN NUMBER := FND_API.G_MISS_NUM ,
1355: p_recipient_cust_account_id IN NUMBER := FND_API.G_MISS_NUM ,
1356: p_minisite_id IN NUMBER := FND_API.G_MISS_NUM ,